System and method for communicating between an application and a database

• US 8,321,467 B2
• Filed: 12/11/2006
• Issued: 11/27/2012
• Est. Priority Date: 12/03/2002
• Status: Active Grant

• Current Assignee: JP Morgan Chase Bank, N.A. (JP Morgan Chase & Co)
• Original Assignee: JP Morgan Chase Bank, N.A. (JP Morgan Chase & Co)
• Inventors: Mangan, John Patrick
• Primary Examiner(s): Leroux, Etienne
• Assistant Examiner(s): RAHMAN, MOHAMMAD N
• Application Number:
  US11/609,172
• Publication Number:
  US 20070143337A1
• Time in Patent Office: 2,178 Days
• Field of Search: 707 2- 4, 707/999.2, 707/802
• US Class Current: 707/802
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure

Abstract

A method for communicating between an application and a database by using a lightweight stored procedure data-binding framework for applications written in object oriented programming languages such as JAVA, significantly reduces the coding effort required to communicate with a relational database. Once the developer specifies the needed tabular data, the inventive framework generates all needed data objects and stored procedures to accomplish the interaction with that database data. The automatically generated code is then used by the application via a run-time component. This means the developer need only make simple calls in a few lines of code for database interaction. The encapsulated data model deals only with persistence and retrieval issues and is therefore de-coupled from the business model.

Claims

1. A computer readable medium having stored thereon a plurality of instructions, the plurality of instructions including instructions which, when executed by a computer, cause the computer to perform steps of a method for enabling a databinding framework for communicating between an application and a database, said method comprising the steps of:

generating a code of databinding files to bind data of the database to a program of the application wherein said code identifies tables to persist the data in the database, wherein said code generates a table of metadata from the identified tables, wherein said code generates stored procedures from the metadata table, generates value objects (VO) from the metadata table and generates at least one XML binding definition from the metadata table; and

integrating the generated code of the stored procedures to the VOs via the XML binding definitions into the application when the application is run.

4. The computer readable medium of claim 1 wherein said database include relational database and application program Written in an object oriented language.

5. The computer readable medium of claim 1 wherein said integrating comprising mapping the stored procedures to the VOs using the XML binding functions.

2. The computer readable medium of claim l further comprising generating a second code of Data Access Objects (DAOs).

3. The computer readable medium of claim 2 wherein said run-time component integrates the DAOs into the application when the application is run.

6. A computer-implemented system for communicating between an application and a database, the system comprising:

a code generator to generate a code of databinding files to bind data of the database to a program of the application wherein said code identifies tables to persist the data in the database, wherein said code generates a table of metadata from the identified tables,

wherein said code generates stored procedures from the metadata table, generates value objects (VO) from the metadata table and generates at least one XML binding definition from the metadata table; and

at least one run-time component coupled to the code generator to integrate the generated code of the stored procedures to the VOs via the XML binding definitions into the application when the application is run.

7. The system of claim 6 wherein said run-time component functions to integrate a second code of Data Access Objects (DAO) from the metadata into the application when the application is run.

8. The system of claim 6 wherein said data is in a tabular format.

9. The system of claim 6 wherein the database comprises a relational database.

10. The system of claim 6 wherein the database comprises a relational SYBASE database.

11. The system of claim 6 wherein the database comprises a relational SQL SERVER database.

12. The system of claim 6 wherein the database comprises a relational ORACLE database.

13. The system of claim 6 wherein the application comprises an application written in an object oriented language.

14. The system of claim 6 wherein the application comprises an application written in JAVA programming language.

15. The system of claim 6 wherein the application comprises an application written in C++ programming language.

16. The system of claim 6 wherein the run-time component comprises subcomponents of SPBinder Manager, SPConnection, SPCaller, and SPCacheManager.

17. The system of claim 6 wherein said run-time component further comprising a binding manager for mapping the stored procedures to the VOs using the XML binding functions.