Software framework that facilitates design and implementation of database applications

• US 7,412,455 B2
• Filed: 04/30/2004
• Issued: 08/12/2008
• Est. Priority Date: 04/30/2003
• Status: Expired due to Fees

• Current Assignee: RPX Corporation
• Original Assignee: Dillon Software Services LLC
• Inventors: Dillon, David M.
• Primary Examiner(s): Wong, Don
• Assistant Examiner(s): Brown, Sheree N
• Application Number:
  US10/836,580
• Publication Number:
  US 20040220956A1
• Time in Patent Office: 1,565 Days
• Field of Search: 707/2, 707/102
• US Class Current: 1/1
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• 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

Abstract

An intelligent framework is provided that is disposed between a high-level language environment and a database system environment. According to one embodiment, the framework programmatically receives information regarding definitions of data structures of objects participating in a software application and information regarding relationships among the objects. Based upon the particular request from the high-level language environment and upon the definitions and relationships, the framework programmatically and dynamically generates appropriate statements associated with the database system environment that accomplish the request. For example, the framework may issue statements to define the structure of a database, access information from the database, and/or manipulate information within the database.

Claims

1. A method of creating a structure of a data store within a storage system comprising:

automatically and programmatically receiving from a software application by an intelligent framework coupled between a high-level language environment and the storage system (a) information regarding definitions of a plurality of data structures associated with a plurality of objects participating in the software application, and (b) information regarding relationships among the plurality of data structures, each object of the plurality of objects generated as a result of compilation of the software application by a compiler and representing an instance of a data structure of the plurality of data structures, wherein said programmatically receiving includes interrogating the plurality of objects;

based upon the information regarding definitions of the plurality of data structures and the information regarding relationships among the plurality of data structures, programmatically and dynamically generating a data definition expression (DDE) comprising one or more statements to define the structure of the data store inferred by the relationships; and

in response to receipt of a request from the software application, the intelligent framework causing the storage system to create the structure of the data store by directing the storage system based on the one or more statements.

2. The method of claim 1, wherein the one or more statements comprise language statements associated with the storage system.

3. The method of claim 1, wherein the information regarding definitions of a plurality of data structures comprises definitions of a plurality of classes that are specified by semantics of a high-level, object-oriented programming language and generated by the compiler.

4. The method of claim 3, wherein the information regarding relationships is implemented as one or more properties of those of the plurality of classes that embody the relationships.

5. The method of claim 3, wherein complex relationships between classes of the plurality of classes are supported, and include one or more of child, parent, peer, children, recursive peer, recursive parent, foreign parent, foreign child, and constant.

6. The method of claim 4, wherein the storage system comprises a relational database management system.

7. The method of claim 2, wherein the language statements comprise Structured Query Language (SQL) data definition language statements.

8. The method of claim 6, wherein within the relational database management system, tables are used to represent the objects participating in the software application.

9. The method of claim 8, wherein each table has a primary key.

10. The method of claim 1, wherein the storage system comprises an extensible markup language (XML) database system.

11. The method of claim 1, wherein the storage system comprises an object-oriented database system.

37. The method of claim 1, wherein said interrogating the plurality of objects comprises use of language reflection.

42. An article of manufacture comprising a computer-readable medium having stored thereon instructions, which when executed by one or more processors cause the method of claim 1 to be performed.

12. A method of accessing a data store within a storage system comprising:

automatically and programmatically receiving from a software application by an intelligent framework coupled between a high-level language environment and the storage system (a) information regarding definitions of a plurality of data structures associated with a plurality of objects participating in the software application, and (b) information regarding relationships among the plurality of data structures, each object of a plurality of objects generated as a result of compilation of the software application by a compiler and representing an instance of a data structure of the plurality of data structures, wherein said programmatically receiving includes interrogating the plurality of objects;

in response to receipt of a request from the software application to read an object of the plurality of objects from the data store, programmatically and dynamically generating a data query expression (DQE) comprising one or more statements based at least in part upon the object'"'"'s relationship with one or more other objects of the plurality of objects; and

responsive to the request, the intelligent framework causing the storage system to retrieve information associated with the object from the data store by querying the storage system based on the one or more statements.

13. The method of claim 12, wherein the one or more statements comprise language statements associated with the storage system.

14. The method of claim 12, wherein the information regarding definitions of a plurality of data structures comprises definitions of a plurality of classes that are specified by semantics of a high-level, object-oriented programming language and generated by the compiler.

15. The method of claim 14, wherein the information regarding relationships is implemented as one or more properties of those of the plurality of classes that embody the relationships.

16. The method of claim 14, wherein complex relationships between classes of the plurality of classes are supported, and include one or more of child, parent, peer, children, recursive peer, recursive parent, foreign parent, foreign child, and constant.

17. The method of claim 15, wherein the storage system comprises a relational database management system.

18. The method of claim 13, wherein the language statements comprise Structured Query Language (SQL) data query language statements.

19. The method of claim 17, wherein within the relational database management system, tables are used to represent the objects participating in the software application.

20. The method of claim 19, wherein each table has a primary key.

21. The method of claim 12, wherein the storage system comprises an extensible markup language (XML) database system.

22. The method of claim 12, wherein the storage system comprises an object-oriented database system.

38. The method of claim 12, wherein said interrogating the plurality of objects comprises use of language reflection.

43. An article of manufacture comprising a computer-readable medium having stored thereon instructions, which when executed by one or more processors cause the method of claim 12 to be performed.

23. A method of manipulating a data store within a storage system comprising:

automatically and programmatically receiving from a software application by an intelligent framework coupled between a high-level language environment and the storage system (a) information regarding definitions of a plurality of data structures associated with a plurality of objects participating in the software application, and (b) information regarding relationships among the plurality of data structures, each object of a plurality of objects generated as a result of compilation of the software application by a compiler and representing an instance of a data structure of the plurality of data structures, wherein said programmatically receiving includes interrogating the plurality of objects;

in response to receipt of a request from the software application to manipulate an object of the plurality of objects, programmatically and dynamically generating a data manipulation expression (DME) comprising one or more statements based at least in part upon the object'"'"'s relationship with one or more other objects of the plurality of objects; and

responsive to the request, the intelligent framework causing the storage system to manipulate the data store by directing the storage system based on the one or more statements.

24. The method of claim 23, wherein the one or more statements comprise language statements associated with the storage system.

25. The method of claim 23, wherein the information regarding definitions of a plurality of data structures comprises definitions of a plurality of classes that are specified by semantics of a high-level, object-oriented programming language and generated by the compiler.

26. The method of claim 25, wherein the information regarding relationships is implemented as one or more properties of those of the plurality of classes that embody the relationships.

27. The method of claim 25, wherein complex relationships between classes of the plurality of classes are supported, and include one or more of child, parent, peer, children, recursive peer, recursive parent, foreign parent, foreign child, and constant.

28. The method of claim 26, wherein the storage system comprises a relational database management system.

29. The method of claim 24, wherein the language statements comprise Structured Query Language (SQL) data manipulation language statements.

30. The method of claim 28, wherein within the relational database management system, tables are used to represent the objects participating in the software application.

31. The method of claim 30, wherein each table has a primary key.

32. The method of claim 28, wherein the request to manipulate the object of the plurality of objects comprises one of (i) a request to insert the object into the data store;

(ii) a request to update the object in the data store;

or (iii) a request to delete the object from the data store.

33. The method of claim 23, wherein the storage system comprises an extensible markup language (XML) database system.

34. The method of claim 23, wherein the storage system comprises an object-oriented database system.

39. The method of claim 23, wherein said interrogating the plurality of objects comprises use of language reflection.

44. An article of manufacture comprising a computer-readable medium having stored thereon instructions, which when executed by one or more processors cause the method of claim 23 to be performed.

35. A method comprising:

automatically and programmatically receiving by an intelligent framework coupled between a high-level language environment and a relational database management system information regarding definitions of a plurality of classes associated with a plurality of objects participating in a software application, each class of the plurality of classes containing information regarding its relationships with one or more other classes of the plurality of classes, each object of the plurality of objects generated as a result of compilation of the software application by a compiler and representing an instance of a class of the plurality of classes, wherein said programmatically receiving includes interrogating the plurality of objects;

based upon the definitions of the plurality of classes, programmatically and dynamically generating one or more Structured Query Language (SQL) statements associated with the relational database management system, the one or more SQL statements defining the structure of a relational database inferred by the relationships;

causing the storage system to create the structure of the relational database by directing the relational database management system based on the one or more SQL statements;

in response to receipt of a request to read an object of the plurality of objects from the relational database;

programmatically and dynamically generating one or more SQL statements associated with the relational database management system based at least in part upon relationships of the object with one or more other objects of the plurality of objects; and

causing the relational database management system to retrieve information associated with the object by querying the relational database management system based on the one or more SQL statements; and

in response to receipt of a request to manipulate an object of the plurality of objects;

programmatically and dynamically generating one or more SQL statements associated with the relational database management system based at least in part upon relationships of the object with one or more other objects of the plurality of objects; and

causing the relational database management system to manipulate the relational database by directing the relational database management system based on the one or more SQL statements.

40. The method of claim 35, wherein said interrogating the plurality of objects comprises use of language reflection.

45. An article of manufacture comprising a computer-readable medium having stored thereon instructions, which when executed by one or more processors cause the method of claim 35 to be performed.

36. A method of accessing a database within a relational database management system comprising:

automatically and programmatically receiving by an intelligent framework coupled between a high-level language environment and the relational database management system (a) information regarding definitions of a plurality of classes specified by semantics of a high-level, object-oriented programming language and generated by a compiler that are associated with a plurality of objects participating in a software application, and (b) information regarding relationships among the plurality of classes, wherein said programmatically receiving includes interrogating the plurality of objects;

in response to receipt of a request from the software application to read one or more objects of the plurality of objects from the database, the intelligent framework programmatically and dynamically generating one or more Structured Query Language (SQL) data query language statements based at least in part upon a relationship of an object template associated with the one or more objects with one or more other objects of the plurality of objects and a state of the object template; and

the intelligent framework causing the relational database management system to retrieve information associated with the one or more objects by querying the relational database management system based on the one or more SQL data query language statements.

41. The method of claim 36, wherein said interrogating the plurality of objects comprises use of language reflection.