System and method for identifying and utilizing a secondary index to access a database using a management system without an internal catalogue of online metadata
US7020648B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Dec 14, 2002 |
| Grant date | Mar 28, 2006 |
| Priority date | — |
| Expiry date | Mar 11, 2024 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99942
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
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.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.