Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2006-03-28
2006-03-28
Pham, Khanh (Department: 2166)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C707S793000, C707S793000
Reexamination Certificate
active
07020648
ABSTRACT:
A system for identifying and utilizing a secondary index to access a database using a management system without an internal catalogue of online metadata. The system receives an application request to access a database from the application program, and parses the application request to determine at least one column name and at least one table name. The system utilizes an online catalogue containing metadata to translate the column name to a field name and the table name to a segment name, wherein the segment name has an associated secondary index. The system utilizes the online catalogue to determine an associated secondary index name, and builds a database request that includes the segment name, the field name, and the associated secondary index name. The system then sends the database request to the database management system, so that the associated secondary index can be used by the database management system in response to the database request.
REFERENCES:
patent: 5884304 (1999-03-01), Davis, III et al.
patent: 6128619 (2000-10-01), Fogarasi et al.
patent: 6202069 (2001-03-01), Blackman et al.
patent: 6253200 (2001-06-01), Smedley et al.
patent: 6304867 (2001-10-01), Schmidt
patent: 6370537 (2002-04-01), Gilbert et al.
patent: 6418443 (2002-07-01), Martin, Jr.
patent: 6708164 (2004-03-01), Cseri et al.
patent: 6845376 (2005-01-01), Johnson
patent: 6853997 (2005-02-01), Wotring et al.
patent: 6879986 (2005-04-01), Fisher
Meng et al., “Processing hierarchical queries in heterogeneous environment”, Data Engineering, 1992. Proceedings. Eighth International Conference on Publication Date: Feb. 2-3, 1992, On page(s): 394-401.
Ching et al., “A relational query language interface to a hierarchical database management system”, Data and Knowledge Systems for Manufacturing and Engineering, 1989., Second International Conference on Oct. 16-18, 1989 Page(s): 105-112.
Meier et al., “Hierarchical to relational database migration”, Software, IEEE Publication Date: May 1994 □□vol.: 11 , Issue: 3, On page(s): 21-27.
Chung et al., “Access to indexed hierarchical databases using a relational query language” Knowledge and Data Engineering, IEEE Transactions on, vol. 5, Issue 1, Feb. 1993 Page(s):155-161.
Challapalli Kiran
Charlet Kyle Jeffrey
Hembry Douglas Michael Frederick
Holtz Christopher M.
Love Robert Daniel
International Business Machines - Corporation
Kassatly Samuel A.
Pham Khanh
LandOfFree
System and method for identifying and utilizing a secondary... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with System and method for identifying and utilizing a secondary..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method for identifying and utilizing a secondary... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3579316