| US 7,469,248 B2 | ||
| Common interface to access catalog information from heterogeneous databases | ||
| Geetika Agrawal, San Jose, Calif. (US); Mary Ann Roth, San Jose, Calif. (US); and Peter Martin Schwarz, San Jose, Calif. (US) | ||
| Assigned to International Business Machines Corporation, Armonk, N.Y. (US) | ||
| Filed on May 17, 2005, as Appl. No. 11/131,792. | ||
| Prior Publication US 2006/0265385 A1, Nov. 23, 2006 | ||
| Int. Cl. G06F 7/00 (2006.01); G06F 17/00 (2006.01) | ||
| U.S. Cl. 707—10 [707/100; 707/2; 707/103 Y; 709/203] | 15 Claims |
| 1. A computer-implemented method of accessing metadata from a plurality of data servers accessible from a federated database
management system, comprising:
receiving, from a client application, an a first application request for metadata by said federated database management system,
wherein said first application request for metadata requests at least one table name of at least one database table accessible
from said federated database management system;
identifying a plurality of data servers accessible from said federated database management system, said plurality of data
servers comprising a first data server and a second data server, said first data server being a first relational database
management system, said second data server being a second relational database management system, said first relational database
management system comprising at least one first database table, said second relational database management system comprising
at least one second database table;
for said each data server of said plurality of data servers, retrieving first metadata in accordance with said first application
request to produce retrieved first metadata, said retrieved first metadata for said first data server comprising at least
one first table name of said at least one first database table, respectively, of said first relational database management
system, and said retrieved first metadata for said second data server comprising at least one second table name of said at
least one second database table, respectively, of said second relational database management system, wherein a metadata adapter
for said each data server generates a source metadata request to retrieve said first metadata based on a first application
request and a source metadata application programming interface associated with said each data server, and said metadata adapter
for each data server invokes said source metadata request;
aggregating said retrieved first metadata from said each data server to produce a first an aggregated result, said first aggregated
result comprising said at least one first table name and a name of said first data server, and also comprising said at least
one second table name and a name of said second data server in a first uniform format; and
providing said first aggregated result.
|