Export engine which builds relational database directly from object model

• US 20030126152A1
• Filed: 12/28/2001
• Published: 07/03/2003
• Est. Priority Date: 12/28/2001
• Status: Active Grant

• Current Assignee: CGI Technologies and Solutions Incorporated (CGI Group)
• Original Assignee: CGI Technologies and Solutions Incorporated (CGI Group)
• Inventors: Rajak, Surendra Kumar
• Granted Patent: US 7,096,231 B2
• Time in Patent Office: Days
• US Class Current: 707/101
• CPC Class Codes: G06F 16/289 Object oriented databases
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure

Abstract

A computer-implemented export engine automatically extracts selected data directly from an object model via an object query language, automatically builds relational database tables for the extracted data and automatically inserts the extracted data into the tables. The tables with the inserted data are then loaded into a relational database.

Claims

1. A method comprising:

automatically extracting data directly from an object model; and

automatically translating the extracted data to a non-object format.

2. A method comprising:

automatically extracting data directly from an object model; and

automatically building a non-object database from the extracted data.

3. A method as in claim 2, wherein the non-object database is a relational database.

4. A method as in claim 2, wherein said automatically extracting extracts the data from the object model using an object query language corresponding to the object model.

5. A method as in claim 4, wherein said automatically building builds the non-object database using a query language corresponding to the non-object database and which is different from the object query language corresponding to the object model.

6. A method as in claim 5, wherein the non-object database is a relational database.

7. A method as in claim 5, wherein the non-object database is a relational database and the query language corresponding to the non-object database is SQL.

8. A method comprising:

selecting object-oriented data in an object model by a user;

automatically extracting the selected data directly from the object model using an object query language corresponding to the object model;

automatically building tables for the extracted data in accordance with metadata for the extracted data, the tables being tables for a target relational database; and

automatically inserting the extracted data into the tables using a query language corresponding to the tables and which is different from the object query language.

9. A method as in claim 8, further comprising:

automatically loading the tables with the inserted data into the target relational database.

10. A method as in claim 8, further comprising:

automatically generating queries in the object query language corresponding to the object model, for extracting the selected data.

11. A method comprising:

selecting object-oriented data in an object model by a human user via a graphical user interface (GUI);

automatically constructing commands in an object query language corresponding to the object model to extract the selected data from the object model;

automatically extracting the selected data directly from the object model using the constructed commands;

automatically building tables for the extracted data in accordance with metadata for the extracted data, the tables being tables for a target relational database; and

automatically inserting the extracted data into the tables using a query language corresponding to the tables and which is different from the object query language.

12. A method as in claim 11, further comprising:

automatically loading the tables with the inserted data into the target relational database.

13. A method comprising:

selecting object-oriented data in an object model by a human user;

extracting the selected data directly from the object model by a computer using an object query language corresponding to the object model;

building tables for the extracted data by a computer in accordance with metadata for the extracted data, the tables being tables for a target relational database; and

inserting the extracted data into the tables by a computer using a query language corresponding to the tables and which is different from the object query language.

14. A method as in claim 13, further comprising:

loading the tables with the inserted data into the target relational database by a computer.

15. A method as in claim 13, further comprising:

automatically generating queries in the object query language corresponding to the object model, for extracting the selected data.

16. A method comprising:

selecting object-oriented data in an object model by a human user via a graphical user interface (GUI);

constructing commands by a computer in an object query language corresponding to the object model to extract the selected data from the object model;

extracting the selected data by a computer directly from the object model using the constructed commands;

building tables for the extracted data by a computer in accordance with metadata for the extracted data, the tables being tables for a target relational database; and

inserting the extracted data into the tables by a computer using a query language corresponding to the tables and which is different from the object query language.

17. An apparatus comprising:

an object model;

a relational database;

a selection device in which a human user selects data to be extracted from the object model;

a computer-implemented engine automatically extracting the selected data directly from the object model via an object query language, automatically building relational database tables for the extracted data and automatically inserting the extracted data into the tables; and

a database management system loading the tables with the inserted data into the relational database.

18. An apparatus as in claim 17, wherein the selection device is one of the group consisting of a graphical user interface and a control table.

19. A method comprising:

selecting a respective object model from a plurality of object models;

automatically exacting data directly from the selected object model; and

automatically building a non-object database from the extracted data.

20. A method comprising:

automatically extracting a first set of data directly from an object model;

automatically building a first non-object database from the extracted first set of data;

automatically extracting a second set of data directly from the object model; and

automatically building a second non-object database from the extracted second set of data.

21. A method comprising:

selecting a respective object model from a plurality of object models;

automatically extracting a first set of data directly from the selected object model;

automatically building a first non-object database from the extracted first set of data;

automatically extracting a second set of data directly from the selected object model; and

automatically building a second non-object database from the extracted second set of data.