Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2005-05-17
2008-12-23
Alam, Hosain T (Department: 2166)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C707S793000, C709S203000
Reexamination Certificate
active
07469248
ABSTRACT:
Various embodiments of a method 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.
REFERENCES:
patent: 5596744 (1997-01-01), Dao et al.
patent: 5721911 (1998-02-01), Ha et al.
patent: 6240416 (2001-05-01), Immon et al.
patent: 6275820 (2001-08-01), Navin-Chandra et al.
patent: 6360225 (2002-03-01), Kleewein et al.
patent: 7136851 (2006-11-01), Ma et al.
patent: 7249135 (2007-07-01), Ma et al.
patent: 2002/0198869 (2002-12-01), Barnett
patent: 2003/0100999 (2003-05-01), Markowitz
patent: 2003/0158767 (2003-08-01), Nwafor et al.
patent: 2004/0148270 (2004-07-01), McKay et al.
patent: 02/35395 (2002-05-01), None
Written Opinion Of The International Searching Authority, International application No. PCT/EP2006/062310, Date of mailing of the Written Opinion Aug. 1, 2006 <7 pages>.
International Preliminary Report On Patentability, International application No. PCT/EP2006/062310, Date of mailing of the International Preliminary Report On Patentability Apr. 23, 2007 <10 pages>.
“IBM VisualAge, DataAtlas Multiplatform, Dictionary User's Guide, Version 2,” First Edition, Apr. 1997, pp. 1-6, 49-56, SC26-9039-00.
“Ascential, Meta Data Management, The Meta Data Glue,” © 2004 Ascential Software Corporation, All information is as of Feb. 2004, pp. 1-4.
“Ascential Software, DataStage® Product Family, Architectural Overview,” Jan. 2002, WP-3002-0102.
“Java.sql, Interface DatabaseMetaData, Java™ 2 Platform Std. Ed. v1.4.2,” [online] Copyright 2003 Sun Microsystems, Inc.[retrieved on Jan. 25, 2005] Retrieved from the Internet: <URL: http://java.sun.com/j2se/1.4.2/docs/api/java/sql/DatabaseMetaData.html>.
“OBDC API Reference (Microsoft Open Database Connectivity (ODBC)),” [online] © 1998-2004 Microsoft Corporation, [retrieved on Jan. 25, 2005]. Retrieved from the Internet: <URL: http://msdn.microsoft.com/library/en-us/odbc/htm/odbcodbc—api—reference.asp?frame=true>.
“IBM Software—DB2 Warehouse Manager for Linux, UNIX and Windows—Features and Benefits,” [online] [retrieved on Jan. 25, 2005]. Retrieved from the Internet: <URL: http://www-306.ibm.com/software/data/db2/datawarehouse/about.html>.
“DB2 Warehouse Manager—Data Warehousing Overview,” [online] [retrieved on Jan. 25, 2005]. Retrieved from the Internet: <URL: http://www-306.ibm.com/software/data/db2/datawarehouse/overview.html>.
IBM DB2 Warehouse Manager Standard Edition, Information Catalog Center Administration Guide, Version 8.2, [online] Copyright 1994, 2004 [retrieved on Jan. 25, 2005]. Retrieved from the Internet: <URL: ftp://ftp.software.ibm.com/ps/products/db2/info/vr82/pdf/en—US/db2die81.pdf>, SC-27-1125-01.
Saracco, C.M. et al, “Enabling distributed enterprise integration with WebSphere and DB2 Information Integrator”, IBM Systems Journal, vol. 43, No. 2, 2004, pp. 255-269.
Haas, L.M. et al, “Data integration through database federation”, IBM Systems Journal, vol. 41, No. 4, 2002, pp. 578-596.
Josifovski, V. et al, “Garlic: A New Flavor of Federated Query Processing for DB2”, ACM SIGMOD '2002 Conference Proceedings, Jun. 4, 2002-Jun. 6, 2002, USA, pp. 524-532.
“IBM WebSphere Information Integrator: Accessing and integrating diverse data for the on demand business”, IBM White Paper, Jan. 2005, USA, pp. 1-28.
Barbancon F. et al, “Implementing federated database systems by compiling SchemaSQL”, Database Engineering and Applications Symposium, 2002, Proceedings. International Jul. 17-19, 2002, Piscataway, New Jersey, USA, IEEE, Jul. 17, 2002, pp. 192-201.
Roth, M.T. et al, “Don't Scrap It Wrap It, A Wrapper Architecture for Legacy Data Sources”, Proceedings of the International Conference on Very Large Data Bases, Aug. 26, 1997, pp. 266-275.
Kozankiewicz, H. et al, “Implementation of Federated Databases Through Updatable Views”, Advances in Grid Computing—EGC 2005, European Grid Conference, Springer Verlag, LNCS, vol. 3470, Feb. 14-16, 2005, pp. 610-619, Germany.
International Search Report, International application No. PCT/EP2006/062310, Date of mailing of the international search report Aug. 1, 2006.
Agrawal Geetika
Roth Mary Ann
Schwarz Peter Martin
Alam Hosain T
International Business Machines - Corporation
Lefeve Douglas H.
Ngo Van H
Skafar Janet M.
LandOfFree
Common interface to access catalog information from... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Common interface to access catalog information from..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Common interface to access catalog information from... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4036083