Data Federation Features and Functions

• Single virtual catalog across sources


• Dynamic federated-query processing


• Virtual views as new data models


• Optimized, distributed query execution


• Standard access via SQL and XML


• OLTP ability to add, remove, or update


• Data administrator can monitor, maintain, and implement security for virtual federated databased


• Tools to move or copy data from multiple source data sources to a target aggregated-data repository


• Tools to access data from multiple data sources and then combine it temporarily for specific purposes, such as cross-database queries


• Data views are aggregated across applications in the XML database for improved query and update performance across the applications


• Data source data replication