Data processing: database and file management or data structures – Database and file access – Record – file – and data search and comparisons
Reexamination Certificate
2008-10-12
2011-11-01
Pham, Khanh (Department: 2166)
Data processing: database and file management or data structures
Database and file access
Record, file, and data search and comparisons
C709S203000
Reexamination Certificate
active
08051094
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.
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: 7469248 (2008-12-01), Agrawal 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
“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>. <4 pages>.
“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>. <3 pages>.
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, 2005-Feb. 16, 2005, pp. 610-619, Germany.
International Search Report, International application No. PCT/EP2006/062310, Applicant's file reference SVL040086, Date of mailing of the international search report Aug. 1, 2006.
Written Opinion of the International Searching Authority, International application No. PCT/EP2006/062310, Applicant's file reference SVL040086, Date of mailing of the Written Opinion Aug. 1, 2006 <7 pages>.
International Preliminary Report on Patentability, International application No. PCT/EP2006/062310, Applicant's file reference SVL040086, Date of mailing of the International Preliminary Report on Patentability Apr. 23, 2007 <10 pages>.
Non-Final Office Action for U.S. Appl. No. 11/131,792 mailed on Aug. 21, 2007 <12 pages>.
Final Office Action for U.S. Appl. No. 11/131,792 mailed on Feb. 5, 2008 <19 pages>.
Notice of Allowance for U.S. Appl. No. 11/131,792 mailed on Jul. 31, 2008 <11 pages>.
Agrawal Geetika
Roth Mary Ann
Schwarz Peter Martin
International Business Machines - Corporation
Oberly Van
Pham Khanh
Skafar Janet M.
Wang Elissa Y.
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-4262000