Methods and apparatus for generating dynamic program files based on input queries that facilitate use of persistent query services

• US 8,032,544 B2
• Filed: 09/24/2008
• Issued: 10/04/2011
• Est. Priority Date: 09/24/2008
• Status: Active Grant

• Current Assignee: The Boeing Co.
• Original Assignee: The Boeing Co.
• Inventors: Jing, Yi, Bremer, John F. Jr., Mohammad, Alimuddin
• Primary Examiner(s): Fleurantin; Jean B
• Application Number:
  US12/236,640
• Publication Number:
  US 20100082656A1
• Time in Patent Office: 1,105 Days
• Field of Search: 707600-831
• US Class Current: 707/760
• CPC Class Codes: G06F 16/2455 Query execution
• CPC Class Codes: G06F 16/24552 Database cache management

Abstract

A method includes receiving a request for information from a relational database, translating the received request to at least one of an object and a relational persistent query, parsing the query to determine one or more of table names, attributes and attribute types, and generating at least one set of related files. The parsing results are used to update at least one configuration file to accept the related files for use by at least one of the object and the relational persistent query service, and execute at least one of the persistent query services based on the translated queries, wherein the persistent query services are programmed to receive the translated query. Based on the execution of the translated query, the results are either fetched from at least one of the object cache or retrieved from at least one of the database, stored, and the results are transmitted to the user.

Claims

1. A computer-implemented method, for automating the process of querying a relational database using at least one of an object and a relational persistent query service on a processor, the method comprising:

receiving a request from a user for information from the relational database;

translating the received request to at least one of an object and a relational persistent query;

determining if a class associated with a table name already exists in a directory, wherein upon determining the class associated with the table name does not already exist in a directory comprises;

performing a pre-fetch for one or more table columns on the relational database; and

creating classes and other related files for the query using the table names and the table columns;

parsing the query to determine one or more of table names, attributes and attribute types;

generating at least one set of related files, based on the parsing of the query;

updating at least one object and relational persistent configuration file to accept the newly generated at least one set of related files for use by at least one of the object and the relational persistent query service; and

executing at least one of the object and the relational persistent query service based on the at least one of the object and the relational persistent query, wherein the at least one of the object and the relational persistent query service is programmed to;

receive the translated query;

retrieve at least one result stored in at least one of an object cache and the relational database based on at least one of the translated query and the generated at least one set of related files; and

transmit the results to the user.

2. The method of claim 1 wherein generating at least one set of related files, based on the parsing of the query comprises generating at least one object class file and at least one object mapping file.

3. The method of claim 1 wherein translating the received request to at least one of an object and a relational persistent query further comprises:

determining that classes and other files have been correctly created.

4. The method of claim 1 wherein upon determining the class associated with the table name does not already exist in a directory, said method further comprises:

generating class variables and functions;

generating at least one mapping file that includes information consistent with information related to the mapping files, including identification numbers and tables with class properties;

generating a cache configuration file that includes information consistent with the configuration of the object cache, the information including a default cache size, a store location, a life span, and an idle time; and

adding one or more default properties into the updated at least one object and relational persistent configuration file and mapped out classes.

5. The method of claim 4 further comprising:

determining if the classes and other related files have been created correctly; and

returning an error message to a client computer via a network if either the classes or any of the other related files have been incorrectly created.

6. The method of claim 1 further comprising at least one of:

determining and creating at least one object class file based on the requested query;

determining and creating at least one object mapping file based on at least one object;

determining at least one table name associated with the relational database based on the requested query; and

determining an object mapping file based on the translated query.

7. The method of claim 1 further comprising:

determining a result based on the translated data is not stored in the object cache;

querying the relational database based on the translated query; and

storing a result from the query of the relational database in the object cache.

8. A system for automating a process of querying a relational database using at least one of an object and a relational persistent query service, the system comprising:

a partition;

a cache area;

a processor;

a network accessible by at least one user, wherein the network is coupled to the partition; and

a relational database, the relational database being coupled to the partition, the partition and the cache area being coupled to the processor, the processor being programmed to;

receive a request from a user via the partition for information from the relational database;

translate the received request to at least one of an object and a relational persistent query;

determine if a class associated with a table name already exists in a directory and perform a pre-fetch for one or more table columns on the relational database and create classes and other related files for the query using the table names and the table columns upon determining the class associated with the table name does not already exist in a directory;

parse the query to determine table names, attributes and attribute types;

generate at least one set of related files based on the parsed query;

update at least one configuration file for use by at least one of an object and a relational persistent query service; and

execute at least one of an object and a relational persistent query service based on the at least one of an object and a relational persistent query, wherein the at least one of an object and a relational persistent query service is operable to receive the translated query, retrieve at least one result stored in at least one of the cache area or the relational database based on at least one of the translated query and the generated at least one set of related files, and transmit the results to the user.

9. The system according to claim 8 wherein the processor is programmed to:

determine at least one object based on the requested query; and

determine at least one object mapping file based on the at least one object.

10. The system according to claim 8 wherein the at least one set of related files comprises an object class file and an object mapping file.

11. The system according to claim 8 wherein to translate the received request to at least one of an object and a relational persistent query, the processor further programmed to:

determine that classes and other files have been correctly created.

12. The system according to claim 8 wherein upon determining the class associated with the table name does not already exist in a directory, the processor further programmed to:

generate class variables and functions;

generate at least one mapping file that includes information consistent with information related to the mapping files, including identification numbers and tables with class properties;

generate a cache configuration file that includes information consistent with the configuration of the cache, including a default cache size, store location, life span, and idle time; and

add one or more default properties into the at least one updated configuration file and mapped out classes.

13. The system according to claim 12 wherein the processor is further programmed to:

determine if the classes and other related files have been created correctly; and

return an error message to a client computer via the network if either the classes or any of the other related files have been incorrectly created.

14. The system according to claim 8 wherein the processor is programmed to:

determine and create at least one object class file based on the requested query;

determine and create at least one object mapping file based on at least one object;

determine at least one table name associated with the relational database based on the requested query; and

determine an object mapping file based on the translated query.

15. The system according to claim 8 wherein the processor is programmed to:

determine a result based on the translated data is not stored in the cache area;

query the relational database based on the translated query; and

store a result from the query of the relational database in the cache area.

16. An apparatus, comprising:

a partition comprising a network interface, the partition being operable to receive requests from a user and to query a relational database external to the apparatus;

an object cache communicatively coupled to said partition;

a processor communicatively coupled to the partition and comprising at least one of an object and a relational persistent query service running thereon, the apparatus being configured to;

receive a request for information from the relational database from a user via said partition;

translate the received request to at least one of an object and a relational persistent query;

determine if a class associated with a table name already exists in a directory and perform a pre-fetch for one or more table columns on the relational database and create classes and other related files for the query using the table names and the table columns upon determining the class associated with the table name does not already exist in a directory;

generate at least one set of related files based on the at least one of an object and a relational persistent query;

execute the at least one of an object and a relational persistent query utilizing said at least one of an object and a relational persistent query service, said at least one of an object and a relational persistent query service operable to retrieve at least one result stored in at least one of said object cache or said relational database based on at least one of the query and the generated at least one set of related files, said apparatus operable to transmit the results to the user through the partition.

17. The apparatus of claim 16, wherein said processor is programmed to determine at least one object mapping file based on at least one object within the object cache.

18. The apparatus of claim 16, wherein the processor is programmed to determine at least one table name associated with the relational database based on the requested query.