Adjustable database runtime kernel

• US 7,251,641 B2
• Filed: 08/02/2002
• Issued: 07/31/2007
• Est. Priority Date: 08/01/2001
• Status: Expired due to Fees

• Current Assignee: It Liberator As
• Original Assignee: It Liberator As
• Inventors: Sjogren, Bjorn-Harald, Bjornemyr, Jan-Thore
• Primary Examiner(s): Wong, Don
• Assistant Examiner(s): Dang, Thanh-Ha
• Application Number:
  US10/209,917
• Publication Number:
  US 20030140028A1
• Time in Patent Office: 1,824 Days
• Field of Search: 707/100, 707/1, 707/103
• US Class Current: 1/1
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: Y10S 707/99931 Database or file accessing

Abstract

The present invention relates generally to a computer system for providing access to a database upon a request from an application computer program 250. The computer system includes a data model 260 represented in a data dictionary 230, an application program interface, a data storage 220, and a database kernel 210, 215 providing access from the application program interface to the data storage 220. The database kernel 210, 215 comprises a runtime module 210 for providing access from the application program interface to the database kernel and a storage engine module 215 for providing access from the runtime module 210 to the data storage 220. The runtime module 210 is dynamically changeable, dependent on the data model 260 represented in the data dictionary 230, while the storage engine module 215 is invariable and independent of the data model. An automatic code generator 240 is arranged to generate an executable program code for the runtime module 210, based upon the data model 260 represented in the data dictionary 230.

Claims

1. A computer system for providing access to a database upon a request from an application computer program, comprising:

a data model represented in a data dictionary;

an application program interface;

a data storage;

a database kernel, providing access from the application program interface to the data storage;

wherein said database kernel includes a database runtime module for providing access from the application program interface to the database kernel, said runtime module being dynamically changeable, dependent on the data model represented in the data dictionary, and

wherein said database kernel further includes a storage engine module for providing access from the runtime module to the data storage, said storage engine module being invariable and independent of said data model;

an automatic code generator, said code generator being adapted to generate an executable program code, irrespective of which format or programming language the code is generated, for the runtime module based upon the data model represented in the data dictionary; and

wherein said system executes the generated program code based on the data model represented in said data dictionary.

2. The computer system according to claim 1, wherein the program code for the runtime module is generated by the code generator subsequent to any amendments in the data model.

3. The computer system according to claim 1, wherein said storage engine is adapted to offer the runtime module platform-independent access to the data stored in the data storage.

4. The computer system according to claim 3, wherein said storage engine is adapted to store and retrieve data elements of a first data structure (BASE), including an unordered set of data, and data elements of a second data structure (INDEX), including an ordered set of data.

5. The computer system according to claim 4, wherein said storage engine is adapted to provide an identifier (Rowid) in each data elements (BASE) of said first data structure, and to provide data elements (INDEX) of said second structure wherein each entry has a set of such associated identifiers (Rowid).

6. The computer system according to claim 1, wherein said code generating module is adapted to generate descriptive code or procedural code, dependent on the syntactical data provided from the template.

7. A computer system for providing access to a database upon a request from an application computer program, comprising:

a data model represented in a data dictionary;

an application program interface;

a data storage;

a database kernel, providing access from the application program interface to the data storage;

wherein said database kernel includes a database runtime module for providing access from the application program interface to the database kernel, said runtime module being dynamically changeable, dependent on the data model represented in the data dictionary, and

wherein said database kernel further includes a storage engine module for providing access from the runtime module to the data storage, said storage engine module being invariable and independent of said data model;

an automatic code generator, said code generator being adapted to generate an executable program code, irrespective of which format or programming language the code is generated, for the runtime module based upon the data model represented in the data dictionary, wherein said code generator comprises a source code generating module and a compiler module, said code generating module, in operation, generates a source code to be processed by the compiler module, thus generating said executable program code; and

wherein said system executes the generated program code based on the data model represented in said data dictionary.

8. The computer system according to claim 7, wherein said code generating module is adapted for receiving structural data provided from the data dictionary;

receiving syntactical data provided from a template; and

processing said structural data in accordance with rules defined by the syntactical data, thus producing source code adapted for input to the compiler module.

9. The computer system according to claim 8, wherein said code generating module is adapted to generate descriptive code or procedural code, dependent on the syntactical data provided from the template.

10. The computer system according to claim 7, wherein the program code for the runtime module is generated by the code generator subsequent to any amendments in the data model.

11. The computer system according to claim 7, wherein said code generating module is adapted for receiving structural data provided from the data dictionary;

receiving syntactical data provided from a template; and

processing said structural data in accordance with rules defined by the syntactical data;

thus producing source code adapted for input to the compiler module.

12. The computer system according to claim 7, wherein said storage engine is adapted to offer the runtime module a platform independent access to the data stored in the data storage.

13. The computer system according to claim 7, wherein said storage engine is adapted to store and retrieve data elements of a first data structure (BASE), including an unordered set of data, and data elements of a second data structure (INDEX), including an ordered set of data.

14. The computer system according to claim 7, wherein said storage engine is adapted to provide an identifier (Rowid) in each data elements (BASE) of said first data structure, and to provide data elements (INDEX) of said second structure wherein each entry has a set of such associated identifiers (Rowid).

15. A method for providing access to a database upon a request from an application computer program, comprising:

representing a data model in a data dictionary;

providing an application program interface and a data storage;

providing access from the application program interface to the data storage by a database kernel;

providing access from the application program interface to the database kernel by a database runtime module embedded in the database kernel, said runtime module being dynamically changeable, dependent on the data model represented in the data dictionary, and

providing access from the runtime module to the data storage by a storage engine module embedded in the database kernel, said storage engine module being invariable and independent of said data model;

generating an executable program code by an automatic code generator embedded in the database kernel, irrespective of which format or programming language the code is generated, for the runtime module based upon the data model represented in the data dictionary; and

executing the generated program code based on the data model represented in said data dictionary.

16. The method according to claim 15, further comprising:

generating the program code for the runtime module by the code generator subsequent to any amendments in the data model.

17. The method according to claim 15, wherein said storage engine is adapted to offer the runtime module platform-independent access to the data stored in the data storage.

18. A The method according to claim 17, further comprising:

storing and retrieving data elements of a first data structure (BASE), including an unordered set of data, and data elements of a second data structure (INDEX), including an ordered set of data.

19. The method according to claim 18, further comprising:

providing an identifier (Rowid) in each data elements (BASE) of said first data structure, and to provide data elements (INDEX) of said second structure wherein each entry has a set of such associated identifiers (Rowid).

20. The method according to claim 15, wherein said code generating module is adapted to generate descriptive code or procedural code, dependent on the syntactical data provided from the template.

21. A method for providing access to a database upon a request from an application computer program, comprising:

representing a data model in a data dictionary;

providing an application program interface and a data storage;

providing access from the application program interface to the data storage by a database kernel;

providing access from the application program interface to the database kernel by a database runtime module embedded in the database kernel, said runtime module being dynamically changeable, dependent on the data model represented in the data dictionary, and

providing access from the runtime module to the data storage by a storage engine module embedded in the database kernel, said storage engine module being invariable and independent of said data model;

generating an executable program code by an automatic code generator embedded in the database kernel, irrespective of which format or programming language the code is generated, for the runtime module based upon the data model represented in the data dictionary, wherein said code generator comprises a source code generating module and a compiler module, said code generating module being adapted to generate a source code to be processed by the compiler module, thus generating said executable program code; and

executing the generated program code based on the data model represented in said data dictionary.

22. The method according to claim 21, further comprising:

receiving structural data provided from the data dictionary;

receiving syntactical data provided from a template; and

processing said structural data in accordance with rules defined by the syntactical data, thus producing source code adapted for input to the compiler module.

23. The method according to claim 22, further comprising:

generating descriptive code or procedural code, dependent on the syntactical data provided from the template.

24. The method according to claim 22, wherein said storage engine is adapted to provide an identifier (Rowid) in each data elements (BASE) of said first data structure, and to provide data elements (INDEX) of said second structure wherein each entry has a set of such associated identifiers (Rowid).

25. The method according to claim 21, further comprising:

generating the program code for the runtime module generated by the code generator subsequent to any amendments in the data model.

26. The method according to claim 21, wherein said storage engine is adapted to offer the runtime module a platform independent access to the data stored in the data storage.

27. The method according to claim 21, wherein said storage engine is adapted to store and retrieve data elements of a first data structure (BASE), including an unordered set of data, and data elements of a second data structure (INDEX), including an ordered set of data.