Method and system for generating computer programs for queries formed by manipulating object-oriented diagrams

• US 5,555,367 A
• Filed: 09/30/1994
• Issued: 09/10/1996
• Est. Priority Date: 09/30/1994
• Status: Expired due to Fees

• Current Assignee: General Electric Company
• Original Assignee: General Electric Company
• Inventors: Rumbaugh, James E., Salemme, Robert M., Premerlani, William J., Blaha, Michael R.
• Primary Examiner(s): Powell, Mark R.
• Assistant Examiner(s): HO, RUAY L
• Application Number:
  US08/315,514
• Time in Patent Office: 711 Days
• Field of Search: 395/161, 395/500, 395/600, 395/650, 395/700, 395/800, 364/401
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2423 Interactive query statement specification based on a database schema
• CPC Class Codes: G06F 16/289 Object oriented databases
• CPC Class Codes: G06F 8/34 Graphical or visual programming
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99935 Query augmenting and refining, e.g. inexact access
• CPC Class Codes: Y10S 715/967 Visual or iconic programming
• CPC Class Codes: Y10S 715/968 interface for database querying and retrieval

Abstract

A method and system for generating computer programs for queries by manipulating an object-oriented diagram. In the present invention, a query is specified for the object diagram. A series of transformations are performed on the object classes within the object diagram in accordance with the query. A revised object diagram representative of the query is then produced. Computer code is then automatically generated for the query from the revised object diagram. The code is used to prototype programs that query and/or update data stored in a database.

Claims

1. A computer-implemented method for generating a computer program that specifies a query for extracting data from a database, the method comprising the steps of:

creating an object-oriented diagram describing data structures within the database as object classes and providing a representation of relationships between each of the object classes;

interpreting the object-oriented diagram as specifying a subset of all object instances of the object classes that satisfy constraints implied by the relationships in the object-oriented diagram;

performing a series of transformations on the object classes within the object-oriented diagram to further specify conditions of the query;

producing a revised object-oriented diagram representative of the query; and

automatically generating a code for the query from the revised object-oriented diagram.

2. A method according to claim 1, wherein the step of performing a series of transformation includes operations such as retain, duplicate, merge, constrain, and restrict.

3. A method according to claim 2, wherein the retain operation retains classes and associations that are to be included in the specification of the query.

4. A method according to claim 2, wherein the duplicate operation includes duplicating classes and associations that specify the query.

5. A method according to claim 2, wherein the merge operation includes combining copies of the same classes, when two or more copies of the same class specify the query.

6. A method according to claim 2, wherein the constrain operation includes expressing a constraint between instances of two specified classes from the query.

7. A method according to claim 2, wherein the restrict operation includes expressing a condition that an attribute of class will satisfy.

8. A method according to claim 1, further comprising the step of prototyping the generated code for accessing and updating data stored in a database.

9. A computer-implemented method for generating a computer program that specifies a query for extracting data from a database, the method comprising the steps of:

creating an object-oriented diagram describing data structures within the database as object classes and providing a representation of relationships between each of the object classes;

interpreting the object-oriented diagram as specifying a subset of all object instances of the object classes that satisfy constraints implied by the relationships in the object-oriented diagram;

performing a series of transformations on the object classes within the object-oriented diagram to further specify conditions of the query;

producing a revised object-oriented diagram representative of the query;

automatically generating a code for the query from the revised object-oriented diagram; and

prototyping the generated code for accessing and updating data stored in the database.

10. A system for generating a computer program that specifies a query for extracting data from a database, the system comprising:

a computer processor;

a database coupled to the computer processor for storing data;

interface means coupled to the computer processor for inputting, retrieving, and manipulating data in the database; and

tooling means responsive to the interface means for producing the object-oriented diagram describing data structures within the database as object classes and providing a representation of relationships between each of the object classes, the tooling means further comprising means for interpreting the object-oriented diagram as specifying a subset of all object instances of the object classes that satisfy constraints implied by the relationships in the object-oriented diagram;

means for performing a series of transformations on the object classes within the object-oriented diagram to further specify conditions of the query;

means for producing a revised object-oriented diagram representative of the query; and

means for automatically generating a code for the query from the revised object-oriented diagram.

11. A system according to claim 10, wherein the a series of transformation performed in the performing means includes operations such as retain, duplicate, merge, constrain, and restrict.

12. A system according to claim 11, wherein the retain operation retains classes and associations that are to be included in the specification of the query.

13. A system according to claim 11, wherein the duplicate operation includes duplicating classes and associations that specify the query.

14. A system according to claim 11, wherein the merge operation includes combining copies of the same classes, when two or more copies of the same class specify the query.

15. A system according to claim 11, wherein the constrain operation includes expressing a constraint between instances of two specified classes from the query.

16. A system according to claim 11, wherein the restrict operation includes expressing a condition that an attribute of class will satisfy.

17. A system according to claim 11, further comprising means for prototyping the generated code for accessing and updating data stored in a database.

18. A system for generating a computer program that specifies a query for extracting data from a database, the system comprising:

a computer processor;

a database coupled to the computer processor for storing data;

interface means coupled to the computer processor for inputting, retrieving, and manipulating data in the database; and

tooling means responsive to the interface means for producing the object-oriented diagram describing data structures within the database as object classes and providing a representation of relationships between each of the object classes, the tooling means further comprising means for interpreting the object-oriented diagram as specifying a subset of all object instances of the object classes that satisfy constraints implied by the relationships in the object-oriented diagram;

means for performing a series of transformations on the object classes within the object-oriented diagram to further specify conditions of the query;

means for producing a revised object-oriented diagram representative of the query;

means for automatically generating a code for the query from the revised object-oriented diagram; and

means for prototyping the generated code for accessing and updating data stored in the database.