System Design Fundamentals
Vote

0% completed

​

Database Federation

Database federation, also called a federated database system, is an approach where multiple independent databases are virtually integrated to appear as one single database to the end user.

Each underlying database, often called a component database or data source, stays autonomous. It keeps its own data, its own schema and its own database engine. The federation layer coordinates: when an application issues a query, it does not need to know which database holds the data, because the federated system routes the request to the right sources and combines the results.

.....

.....

.....

Like the course? Get enrolled and start learning!
Oleksandr Zdanevych

Oleksandr Zdanevych

· 2 years ago

Can you please share examples of Database Federation implementation or publicly known use-cases from real companies?

Sivaram K

Sivaram K

· 3 months ago

Potentially Lower Latency Than ETL: Direct queries to each source can yield near real-time results, though this depends on network and query complexity.

What does "real-time results" exactly mean in this context, and what is the actual advantage?