Common interface to access catalog information from...

Data processing: database and file management or data structures – Database design – Data structure types

Reexamination Certificate

Rate now

  [ 0.00 ] – not rated yet Voters 0   Comments 0

Details

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.

LandOfFree

Say what you really think

Search LandOfFree.com for the USA inventors and patents. Rate them and share your experience with other people.

Rating

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.

Rate now

     

Profile ID: LFUS-PAI-O-4036083

  Search
All data on this website is collected from public sources. Our data reflects the most accurate information available at the time of publication.