Granted Patent B2

US 7,020,648 · App. 10/319,941 · Granted Mar 28, 2006

Abstract

Claims (33)

1. A method for identifying and utilizing at least one secondary index in order to efficiently access a hierarchical database in response to a relational application program request utilizing a database management system that is not provided with an internal catalog of online metadata, comprising:

receiving the relational application program request from an application program;

parsing the relational application program request to determine at least one column name and at least one table name;

utilizing an external online application catalog comprising metadata to translate the at least one column name and the at least one table name to a segment name that is associated with the at least one secondary index;

determining at least an associated secondary index name utilizing the external online application catalog;

building a database request comprising the segment name, the field name, and the associated secondary index name;

sending the database request to the database management system, wherein the database management system uses the at least one secondary index to prepare a response to the database request;

wherein the application program is a JAVA application; and

wherein receiving the relational application program request comprises receiving the relational application program request through a JDBC application program interface.

2. The method of claim 1 , wherein the relational application program request comprises an SQL query.

3. The method of claim 1 , wherein the hierarchical database is an information management system hierarchical database.

4. A computer program product having instruction codes that are stored on a computer-readable medium, for identifying and utilizing at least one secondary index in order to efficiently access a hierarchical database in response to a relational application program request utilizing a database management system that is not provided with an internal catalog of online metadata, comprising:

a first set of instruction codes for receiving the relational application program request from an application program;

a second set of instruction codes for parsing the relational application program request to determine at least one column name and at least one table name;

a third set of instruction codes for translating the at least one column name and the at least one table name to a segment name that is associated with the at least one secondary index, utilizing an external online application catalog comprising metadata;

a fourth set of instruction codes for determining at least an associated secondary index name utilizing the external online application catalog;

a fifth set of instruction codes for building a database request comprising the segment name, the field name, and the associated secondary index name;

the fifth set of instruction codes sending the database request to the database management system, wherein the database management system uses the at least one secondary index to prepare a response to the database request;

wherein the application program is a JAVA application; and

wherein the first set of instruction codes receives the relational application program request through a JDBC application program interface.

5. The computer program product of claim 4 , wherein the relational application program request comprises an SQL query.

6. The computer program product of claim 4 , wherein the hierarchical database is an information management system hierarchical database.

7. A system that identifies and utilizes at least one secondary index in order to efficiently access a hierarchical database in response to a relational application program request utilizing a database management system that is not provided with an internal catalog of online metadata, comprising:

means for receiving the relational application program request from an application program;

means for parsing the relational application program request to determine at least one column name and at least one table name;

means for translating the at least one column name and the at least one table name to a segment name that is associated with the at least one secondary index, utilizing an external online application catalog comprising metadata;

means for determining at least an associated secondary index name utilizing the external online application catalog;

means for building a database request comprising the segment name, the field name, and the associated secondary index name;

means for sending the database request to the database management system, wherein the database management system uses the at least one secondary index to prepare a response to the database request;

wherein the application program is a JAVA application; and

wherein the relational application program request is received through a JDBC application program interface.

8. The system of claim 7 , wherein the relational application program request comprises an SQL query.

9. The system of claim 7 , wherein the hierarchical database is an information management system hierarchical database.

Assignments (7)