Automatically generated client application source code using database table definitions

• US 20030233632A1
• Filed: 06/12/2002
• Published: 12/18/2003
• Est. Priority Date: 06/12/2002
• Status: Abandoned Application

• Current Assignee: Lockheed Martin Corporation (Martin Marietta Corporation)
• Original Assignee: Lockheed Martin Corporation (Martin Marietta Corporation)
• Inventors: Shkarlet, Yekaterina Y., Aigen, Michael L.
• Application Number:
  US10/170,836
• Publication Number:
  US 20030233632A1
• Time in Patent Office: Days
• US Class Current: 717/106
• CPC Class Codes: G06F 8/30 Creation or generation of source code

Abstract

A computer product for generating application source code on a client computer for querying database tables on a server computer includes a portion for obtaining database structure information for the database tables from database table definition files on the server computer. The computer product also includes a portion operative to construct database queries using the database structure information. The database queries are constructed in a database query language required to query information from the database tables on the server computer. The computer product further includes a portion for constructing application source code commands for executing the database queries. The application source code commands are constructed in a programming language of the client application.

Claims

1. A computer product for generating application source code on a client computer for querying database tables on a server computer, said computer product comprising:

a portion for obtaining database structure information for the database tables from database table definition files on the server computer;

a portion operative to construct database queries using said database structure information, said database queries being constructed in a database query language required to query information from the database tables on the server computer; and

a portion for constructing application source code commands for executing said database queries, said application source code commands being constructed in a programming language of the client application.

2. The computer product recited in claim 1, wherein said database query language is Structured Query Language and said programming language of the client application is a Java language.

3. The computer product recited in claim 1, wherein said portion for constructing application source code commands comprises a portion for generating Java classes for executing Structured Query Language database queries.

4. The computer product recited in claim 3, wherein said Java classes comprise classes for encapsulating a single row of the database table.

5. The computer product recited in claim 3, wherein said Java classes comprise classes for encapsulating the entire database table.

6. The computer product recited in claim 1, wherein said portion for reading database table definition files is operative to access the database table definition files via a network connecting the client computer to the server computer.

7. The computer product recited in claim 1, further comprising a client-based portion for gathering a batch comprising a plurality of said application source code commands and sending said batch to the server computer;

and

a server-based portion for receiving said batch from said client-based portion and executing said application source code commands of said batch on the database table.

8. The computer product recited in claim 7, wherein said server-based portion is further operative receive results of said database queries of said application source code commands and provide said results to said client-based portion, said client-based portion being further operative to receive said results.

9. The computer product recited in claim 8, wherein said client-based portion is further operative to provide said results to client-based applications on the client computer.

10. A computer implemented method for generating application source code on a client computer for querying database tables on a server computer, said method comprising the steps of:

obtaining database structure information for the database tables from database table definition files on the server computer;

constructing database queries using said database structure information, said database queries being constructed in a database query language required to query information from the database tables on the server computer; and

constructing application source code commands for executing said database queries, said application source code commands being constructed in a programming language of the client application.

11. The method recited in claim 10, wherein said database query language is Structured Query Language and said programming language of the client application is a Java language.

12. The method recited in claim 10, wherein said step of constructing application source code commands comprises the step of generating Java classes for executing Structured Query Language database queries.

13. The method recited in claim 12, wherein said Java classes comprise classes for encapsulating a single row of the database table.

14. The method recited in claim 12, wherein said Java classes comprise classes for encapsulating the entire database table.

15. The method recited in claim 10, wherein said step of reading database table definition files comprises the step of accessing the database table definition files via a network connecting the client computer to the server computer.

16. The method recited in claim 10, further comprising the steps of:

gathering a batch comprising a plurality of database queries;

sending said batch to the server computer;

receiving said batch from said client-based portion; and

executing said database queries of said batch on the database table.

17. The method recited in claim 16, further comprising the steps of:

receiving results of said database queries of said application source code commands on the server computer;

providing said results to the client computer; and

receiving said results on the client computer.

18. The method recited in claim 17, further comprising the step of providing said results to client-based applications on the client computer.

19. A computer product implementable on a system including a client computer and a server computer operatively connected to each other by a network, said computer product comprising comprising:

a client-based portion resident to the client computer, said client-based portion being operative to gather a batch comprising a plurality of database queries and send said batch to the server computer via the network; and

a server-based portion resident to the server computer, said server-based portion being operative to receive said batch from said client-based portion and execute said database queries in said batch on a database resident to the server computer.

20. The computer product recited in claim 19, wherein said server-based portion is further operative receive results of said database queries and provide said results to the client computer via the network, said client-based portion being further operative to receive said results and provide said results to client-based applications on the client computer.