Invention Grant
- Patent Title: Common interface to access catalog information from heterogeneous databases
- Patent Title (中): 从异构数据库访问目录信息的公共接口
-
Application No.: US12249957Application Date: 2008-10-12
-
Publication No.: US08051094B2Publication Date: 2011-11-01
- Inventor: Geetika Agrawal , Mary Ann Roth , Peter Martin Schwarz
- Applicant: Geetika Agrawal , Mary Ann Roth , Peter Martin Schwarz
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agent Janet M. Skafar; Elissa Y. Wang
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/30

Abstract:
Various embodiments of a system and computer program product to access metadata from a plurality of data servers from a federated database management system are provided. In one embodiment, a request for metadata, from a client application, is received by the federated database management system. Data servers which are accessible from the federated database management system are identified. For each data server, metadata describing data of a data source of that data server is retrieved in accordance with the application request. The retrieved metadata from each of the data servers is aggregated to produce an aggregated result in a uniform format. The aggregated result is provided. In another embodiment, for each data server, a source metadata request for metadata of that data server is generated in accordance with the application request and a source metadata application programming interface. A view is created based on the source metadata request for metadata for each data server.
Public/Granted literature
- US20090037391A1 Common Interface to Access Catalog Information from Heterogeneous Databases Public/Granted day:2009-02-05
Information query