Federated Database System

A federated database system is a type of meta-database management system (DBMS), which transparently maps multiple autonomous database systems into a single federated database. The constituent databases are interconnected via a computer network and may be geographically decentralized. Since the constituent database systems remain autonomous, a federated database system is a contrastable alternative to the (sometimes daunting) task of merging several disparate databases. A federated database, or virtual database, is a composite of all constituent databases in a federated database system. There is no actual data integration in the constituent disparate databases as a result of data federation.

McLeod and Heimbigner were among the first to define a federated database system, as one which "define the architecture and interconnect databases that minimize central authority yet support partial sharing and coordination among database systems".

Through data abstraction, federated database systems can provide a uniform user interface, enabling users and clients to store and retrieve data in multiple noncontiguous databases with a single query -- even if the constituent databases are heterogeneous. To this end, a federated database system must be able to decompose the query into subqueries for submission to the relevant constituent DBMS's, after which the system must composite the result sets of the subqueries. Because various database management systems employ different query languages, federated database systems can apply wrappers to the subqueries to translate them into the appropriate query languages.

  • Note: this description of federated databases does not accurately reflect the McLeod/Heimbigner definition of a federated database. Rather, this description fits what McLeod/Heimbinger called a composite database. McLeod/Heimbigner's federated database is a collection of autonomous components that make their data available to other members of the federation through the publication of an export schema and access operations; there is no unified, central schema that encompasses the information available from the members of the federation.

Among other surveys, defines a Federated Database as a collection of cooperating component systems which are autonomous and are possibly heterogeneous. The three important components of an FDBS as pointed out in are autonomy, heterogeneity and distribution. Another dimension which has also been considered is the Networking Environment Computer Network, e.g., many DBSs over a LAN or many DBSs over a WAN update related functions of participating DBSs (e.g., no updates, nonatomic transitions, atomic updates).

Read more about Federated Database System:  FDBS Architecture, Five Level Schema Architecture For FDBSs

Other articles related to "database, databases":

Open ERP - Architecture - Database
... OpenERP uses PostgreSQL as database management system. ...
Implementation: Database Management Systems - DBMS Support For The Development and Maintenance of A Database and Its Application
... maintain an application built around its respective database type ... Examples for tools relate to database design, application programming, application program maintenance, database performance analysis and monitoring, database configuration ...
Lantibiotics - Database
... BACTIBASE is an open-access database for bacteriocins including lantibiotics. ...
IBATIS
... framework which automates the mapping between SQL databases and objects in Java.NET, and Ruby on Rails ... code that a developer needs to access a relational database using lower level APIs like JDBC and ODBC ... say) by the user, and create and maintain the relational database automatically ...
UK Statute Law Database - Current Limitations
... While the database reflects amendments to primary legislation, it is not up to date ... Also the database does not currently include Pre-1991 repealed legislation Most pre-1991 local Acts and revisions to post-1991 local Acts Secondary legislation pre-dati ... There are no plans to extend the database to include the above material ...

Famous quotes containing the words system and/or federated:

    We find ourselves under the government of a system of political institutions, conducing more essentially to the ends of civil and religious liberty, than any of which the history of former times tells us.
    Abraham Lincoln (1809–1865)

    The Federated Republic of Europe—the United States of Europe—that is what must be. National autonomy no longer suffices. Economic evolution demands the abolition of national frontiers. If Europe is to remain split into national groups, then Imperialism will recommence its work. Only a Federated Republic of Europe can give peace to the world.
    Leon Trotsky (1879–1940)