Federation
In a federated database, a query can access data in a data source that is different from the one to which the query was submitted.
- Supported data sources
- In a federated database, a query can access data that is stored on any of the data sources that comprise the federated database.
- Federated systems
-
A federated system is a special type of distributed database management system (DBMS) that consists of a database instance that operates as a federated server, a database that acts as the federated database, one or more data sources, and clients (users and applications) that access the database and data sources.
- Configuring federation and data sources
- To configure federated systems and data sources, you configure the federated database and server, configure access to data sources, and tune for performance.
- Configuring data sources
- You can configure the federated server to access relational and nonrelational data sources.
- Administering federation
- Administration tasks include modifying configuration settings, working with federated DDL, DML, stored procedures, nicknames, and more.
- Developing for federation
- You have many resources available to help you develop various kinds of federated applications. You can also create your own custom wrappers.
- Performance for federation
- You can improve the performance of a federated system by analyzing system statistics to identify opportunities for improving performance, tuning queries for more efficient processing, and caching data and queries locally where the system can access it quickly.
- Security for federation
- You can increase the security of federated systems and reduce the maintenance.
- Troubleshooting
- To help you understand, isolate, and resolve problems with your IBM® software, the troubleshooting and support information contains instructions for using the problem-determination resources that are provided with your IBM products and by IBM Support.
- Reference
- Reference information includes syntax, examples, and detailed technical information to help you with your tasks.