O-R gateway: a system for connecting object-oriented application programs and relational databases

• US 5,504,885 A
• Filed: 06/29/1993
• Issued: 04/02/1996
• Est. Priority Date: 06/29/1993
• Status: Expired due to Term

• Current Assignee: Texas Instruments, Inc.
• Original Assignee: Texas Instruments, Inc.
• Inventors: Alashqur, Abdallah M.
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): Loomis, John C.
• Application Number:
  US08/084,841
• Time in Patent Office: 1,008 Days
• Field of Search: 395/600, 395/700
• US Class Current: 717/141
• CPC Class Codes: G06F 16/2438 Embedded query languages
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation

Abstract

This is a method and system of extending the capability of a relational database management system'"'"'s precompiler to object-oriented languages comprising: embedding SQL statement in an object-oriented program; compiling the object-oriented program with a precompiler from the database management system into a temporary file; compiling the temporary file with an object-oriented precompiler into a file acceptable to an object-oriented compiler; and compiling the file with the object-oriented compiler into an executable file.

Claims

1. A method of extending the capability of a database management system'"'"'s precompiler to object-oriented languages comprising:

embedding SQL statements in an object-oriented program;

compiling said object-oriented program with a precompiler from said database management system into a temporary file;

compiling said temporary file with an object-oriented precompiler into a file acceptable to an object-oriented compiler; and

compiling said file with said object-oriented compiler into an executable file.

2. The method of claim 1, wherein said object-oriented program utilizes C++.

3. The method of claim 1, wherein said database management system is a relational database management system.

4. The method of claim 1, wherein said database management system utilizes Oracle.

5. A method of enabling object queries in an object-oriented program using a database management system which is not object-oriented comprising:

creating a program with object query language statements and object-oriented language statements;

converting said object query language statements of the program into structured query language statements to generated a converted object-oriented program;

compiling said converted object-oriented program with a precompiler from said database management system into a temporary file;

compiling said temporary file with an object-oriented precompiler into a file acceptable to an object-oriented compiler; and

compiling said file with said object-oriented compiler into an executable file.

6. The method of claim 5, wherein said database management system is a relational database management system.

7. The method of claim 6, wherein said converting step includes converting an object-oriented schema into a relational schema for the conversion of the queries.

8. The method of claim 7, wherein said converting the object query language portion of the program further includes converting queries from an object-oriented database query to a relational database query.

9. The method of claim 7, wherein said converting of said object-oriented schema includes extracting relational schema information from a relational dictionary in the relational database system.

10. The method of claim 9, wherein said converting of said object-oriented schema further includes generating library files containing class definitions representing said relational schema.

11. The method of claim 10, wherein said converting of said object-oriented schema further includes creating and maintaining mapping rules for class definitions representing said relational schema.

12. The method of claim 7, wherein said converting queries includes parsing program to identify object-oriented database queries.

13. The method of claim 12, wherein said converting queries further includes translating said object-oriented queries into SQL queries utilizing said mapping rules.

14. A method of extending the capability of a relational database management system'"'"'s precompiler to object-oriented languages comprising:

embedding SQL statements in an object-oriented program;

compiling said object-oriented program with a precompiler from said database management system into a temporary file;

compiling said temporary file with an object-oriented precompiler into a file acceptable to a object-oriented compiler; and

compiling said file with said object-oriented compiler into an executable file;

wherein said object-oriented program utilizes C++; and

wherein said database management system utilizes Oracle.