Database Federation

Pragya Sapkota
2 min readFeb 25, 2023

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

I hope this article was helpful to you.

Please remember to applaud this article and follow me!!!

Any kind of feedback or comment is welcome!!!

You can also subscribe to my stories via email to get notified whenever I bring out an article on a new subject.

Thank you for your time and support!!!!

Keep Reading!! Keep Learning!!!