In a database, when it needs to be split up by functions, we use federation architecture. In common words, we can call the federation functional partitioning as well. There are multiple physical databases in the architecture which are presented as a logical database to the end-users. This is because the components here are bound together by federal schemas. The latter has common data throughout the federation that can be used to specify the information to share among the components for a common basis of communication for them. In addition, there are cohesive, unified views of data from multiple data sources in the database federation architecture. There are both structured and unstructured data in the database of these sources.
Why use database federation?
Below is the reason why you should choose database federation.
- Data Sharing is flexible
- Database components have autonomy among themselves
- Heterogenous data can be accessed in a unified way
- Legal databases have loosely coupled applications
Characteristics of database federation
- The users have no idea where the data is stored. The differences and the implementation of underlying data sources are masked.
- The database system can easily add new sources if required.
- A federated database can have multiple hardware, network protocols, data models, etc.
- The existing database and the interface are not changed.
- The data integration is supported in the federation architecture.
Are there any demerits?
The database federation also comes with some demerits.
- More hardware is required
- The operations are more complex since joining the data from two databases is hard.
- We are overly dependent on autonomous data sources.
- Query performance
- Scalability
pragyaasapkota / System-Design-Concepts
Though the concepts of system design might be tricky, let's see them individually to their core concepts and have a better understanding.
System Design
Systems design is the process of defining elements of a system like modules, architecture, components and their interfaces and data for a system based on the specified requirements.
This is a index for the concepts of system.
If you wish to open these in a new tab, Press CTRL+click
S.N. | Table of Content |
---|---|
1. | Caching |
2. | Network Protocols |
3. | Storage: The Underrated Topic |
4. | Latency and Throughput |
5. | System Availability |
6. | Leader Election |
7. | Proxies |
8. | Load Balancing |
9. | Endpoint Protection |
10. | HTTPS: Is it better than HTTP? |
11. | Polling and Streaming |
12. | Long Polling |
13. | Hashing |
14. | CAP Theorem |
15. | PACELC Theorem |
16. | Messaging and Pub-Sub |
17. | Database |
18. | Logging, Monitoring, and Alerting |
19. | Distributed System |
20. | Scaling |
21. | Event Driven Architecture (EDA) |
22. | CQRS |
23. | Message Queue |
24. | Architectural Patterns |
25. | Enterprise Service Bus (ESB) |
I hope this article was helpful to you.
Please don’t forget to follow me!!!
Any kind of feedback or comment is welcome!!!
Thank you for your time and support!!!!
Keep Reading!! Keep Learning!!!
Top comments (0)