Database schema independence

• US 5,974,418 A
• Filed: 10/16/1996
• Issued: 10/26/1999
• Est. Priority Date: 10/16/1996
• Status: Expired due to Term

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Blinn, Arnold, Cohen, Michael Ari, Lorton, Michael, Stein, Gregory J.
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): Alam, Hosain T.
• Application Number:
  US08/732,013
• Time in Patent Office: 1,105 Days
• Field of Search: 707/10, 707/100-102, 707/1-3, 707/4, 705/26
• US Class Current: 707/741
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: G06F 16/972 Access to data in other repository systems, e.g. legacy data or dynamic Web page generation
• CPC Class Codes: G06Q 30/02 Marketing; Price estimation or determination; Fundraising
• CPC Class Codes: G06Q 30/0601 Electronic shopping [e-shopping]
• CPC Class Codes: Y10S 707/955 Object-oriented
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

An application, such as an online merchant system, provides a name for a query stored in a database. The database accesses the query using the name provided by the application. The database next executes the query to produce an access object having the query results. The application then processes the access object to obtain a selected result. Storing queries in the database provides a level of indirection and flexibility enabling applications to access databases without prior knowledge of their schemas. Thus, applications can access data in a wide variety of existing databases having different schemas and data sublanguages. Modification of the database schema does not require corresponding modification or recompilation of the application accessing the database.

Claims

1. In an online shopping system that obtains product information from a legacy database having a predefined schema, a method of accessing desired product data from the legacy database, the method comprising:

associating a plurality of database queries with corresponding query names in a cross-reference;

obtaining a particular database query from the cross-reference that corresponds to a particular one of the query names;

submitting the particular database query to the legacy database from the online shopping system, wherein the legacy database returns a data table having one or more information records relating to different products;

wherein the database queries are formulated to return data tables that are formatted as required by the online shopping system rather than being formatted in accordance with the predefined schema of the legacy database;

processing the returned data table in the online shopping system to obtain the desired product data.

2. A method as recited in claim 1, wherein the cross-reference is stored in the legacy database.

3. A method as recited in claim 1, wherein the database queries are written in the SQL data sublanguage.

4. A method as recited in claim 1, wherein the processing step comprises indexing the returned data table with row and column identifiers.

5. A computer-readable storage medium containing instructions that implement an online shopping system, wherein the online shopping system obtains product information from a legacy database having a predefined schema, the instructions being executable by a computer to perform steps comprising:

associating a plurality of database queries with corresponding query names in a cross-reference;

obtaining a particular database query from the cross-reference that corresponds to a particular one of the query names;

submitting the particular database query to the legacy database from the online shopping system, wherein the legacy database returns an access object having a plurality of information records relating to different products;

wherein the database queries are formulated to return access objects whose information records are formatted as required by the online shopping system rather than being formatted in accordance with the predefined schema of the legacy database;

processing the returned access object in the online shopping system to obtain the desired product data.

6. A computer-readable storage medium as recited in claim 5, wherein the cross-reference is stored in the legacy database.

7. A computer-readable storage medium as recited in claim 5, wherein the database queries are written in the SQL data sublanguage.

8. A computer-readable storage medium as recited in claim 5, wherein each information record contains one or more fields, and wherein the processing step comprises indexing the returned access object with record and field identifiers.

9. An online shopping system comprising:

a server computer;

a legacy database accessible to the server computer, the legacy database having a predefined schema;

a cross-reference that associates a plurality of database queries with corresponding query names;

an application program that executes on the server computer to implement the online shopping system and to perform steps comprising;

obtaining a particular database query from the cross-reference that corresponds to a particular one of the query names;

submitting the particular database query to the legacy database from the online shopping system, wherein the legacy database returns a data table having one or more information records relating to different products;

wherein the database queries are formulated to data tables that are formatted as required by the online shopping system rather than being formatted in accordance with the predefined schema of the legacy database;

processing the returned data table in the online shopping system to obtain the desired product data.

10. An online shopping system as recited in claim 9, wherein the cross-reference is stored in the legacy database.

11. An online shopping system as recited in claim 9, wherein the database queries are written in the SQL data sublanguage.

12. An online shopping system as recited in claim 9, wherein the processing step comprises indexing the returned data table with row and column identifiers.

13. In an online shopping system that obtains product information from a legacy database having a predefined schema, a method of accessing desired product data from the legacy database, the method comprising:

submitting a database query to the legacy database from the online shopping system, wherein the legacy database returns an access object having one or more information records relating to different products;

wherein the database query is formulated to return an access object that is formatted as required by the online shopping system rather than being formatted in accordance with the predefined schema of the legacy database, the access object having records and fields;

processing the access object in the online shopping system to obtain the desired product data;

wherein the processing step comprises indexing the access object with record and field identifiers.

14. A method as recited in claim 13, wherein the database query is written in the SQL data sublanguage.

15. A method as recited in claim 13, wherein the access object comprises a table, and wherein the record and field identifiers comprise row and column identifiers.

16. A computer-readable storage medium containing instructions that implement an online shopping system, wherein the online shopping system obtains product information from a legacy database having a predefined schema, the instructions being executable by a computer to perform steps comprising:

submitting a database query to the legacy database from the online shopping system, wherein the legacy database returns an access object having one or more information records relating to different products;

wherein the database query is formulated to return an access object that is formatted as required by the online shopping system rather than being formatted in accordance with the predefined schema of the legacy database the access object having records and fields;

processing the access object in the online shopping system to obtain the desired product data;

wherein the processing step comprises indexing the access object with record and field identifiers.

17. A computer-readable storage medium as recited in claim 16, wherein the database query is written in the SQL data sublanguage.

18. A computer-readable storage medium as recited in claim 16, wherein the access object comprises a table, and wherein the record and field identifiers comprise row and column identifiers.

19. An online shopping system comprising:

a server computer;

a legacy database accessible to the server computer, the legacy database having a predefined schema;

an application program that executes on the server computer to implement the online shopping system and to perform steps comprising;

submitting a database query to the legacy database from the online shopping system, wherein the legacy database returns an access object having one or more information records relating to different products;

wherein the database query is formulated to return an access object that is formatted as required by the online shopping system rather than being formatted in accordance with the predefined schema of the legacy database, the access object having records and fields;

processing the access object in the online shopping system to obtain the desired product data;

wherein the processing step comprises indexing the access object with record and field identifiers.

20. An online shopping system as recited in claim 19, wherein the database query is written in the SQL data sublanguage.

21. An online shopping system as recited in claim 19, wherein the access object comprises a table, and wherein the record and field identifiers comprise row and column identifiers.