One could also use «create table as select» type operations to create meta tables on the DB2 instance containing selected rows / columns from
the federated databases.
Scott Lurndal (13:35:16): Now, with
a federated database such as DB2, a view (a pseudo table represented by a query) can be created combining columns from each of the aforementioned databases, That is just an implementation detail.
Now, with
a federated database such as DB2, a view (a pseudo table represented by a query) can be created combining columns from each of the aforementioned databases, or queries can be generated combining all the data without having to first replicate all the tables in the top level database.
Not exact matches
The building blocks of the GDS» promised «government as a platform» approach have appeared: Verify, a
federated identity system that doesn't rely on ID cards or centralised identity
databases, Govpay, which makes it easier to make payments to the government, and Notify, which allows government agencies to keep citizens informed of progress on services.
MME was created to establish a
federated network connecting
databases of genomic and phenotypic data using a common application programming interface (API).
Since joining the firm in 2006, James» responsibilities have grown to cover multiple global systems including the firm's central
database of deal and credentials information, on - going development of its
federated legal knowledge search solution, and management of a distributed team that supports content creation and quality across these systems.
For example, the big commercial providers like Westlaw and Lexis do not allow
federated search tools into their
databases and some providers have not yet developed the code to allow the
federated search tools to connect to them.
As well, the increased convenience may come at a cost: many of the advanced search features and limit options offered by individual
databases are not available in
federated searching.
It can support the development of
federated citation
databases that help connect legal professionals to resources.
WorldWideScience is a cooperative venture among 44 countries under the auspices of the U.S. Department of Energy's Office of Scientific and Technical Information (sigh: I wish I didn't wish it was run out of Denmark or Korea or Chile) that offers a
federated search of the various countries»
databases.
Illinois has a
federated data system plan, in which agencies maintain their own
databases and all are linked through a Central Demographic Dataset Administrator (under a contract with Northern Illinois University).