The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Mar. 28, 2006
Filed:
Dec. 14, 2002
Kiran Challapalli, San Jose, CA (US);
Kyle Jeffrey Charlet, Morgan Hill, CA (US);
Douglas Michael Frederick Hembry, Los Gatos, CA (US);
Christopher M. Holtz, San Jose, CA (US);
Robert Daniel Love, Morgan Hill, CA (US);
Kiran Challapalli, San Jose, CA (US);
Kyle Jeffrey Charlet, Morgan Hill, CA (US);
Douglas Michael Frederick Hembry, Los Gatos, CA (US);
Christopher M. Holtz, San Jose, CA (US);
Robert Daniel Love, Morgan Hill, CA (US);
International Business Machines Corporation, Armonk, NY (US);
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.