Method for simplifying databinding in application programs

• US 20040107183A1
• Filed: 12/03/2002
• Published: 06/03/2004
• 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
• Granted Patent: US 7,149,752 B2
• Time in Patent Office: Days
• US Class Current: 707/2
• 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. The developer can therefore concentrate on implementing a complex business object model. And, changes to the business object models have no direct impact on the underlying persistence model. Automatic code generation reduces a developer'"'"'s coding time by up to 90%. Moreover, coding errors are virtually eliminated since the generated code is not prone to manual coding errors. Thus, testing time is reduced as well.

Claims

1. A method of communicating between an application and a database comprising the steps of:

providing a database;

providing an application;

providing a databinding framework;

generating databinding files to bind the database data to the application program; and

providing a run-time component to integrate the generated databinding files into the application when the application is run.

2. The method of claim 1 wherein providing the database comprises providing a relational database.

3. The method of claim 1 wherein providing the database comprises providing a relational Sybase database.

4. The method of claim 1 wherein providing the database comprises providing a relational Microsoft SQL Server database.

5. The method of claim 1 wherein providing the database comprises providing a relational Oracle database.

6. The method of claim 1 wherein providing the application comprises providing an application written in an object oriented language.

7. The method of claim 1 wherein providing the application comprises providing an application written in Java.

8. The method of claim 1 wherein providing the application comprises providing an application written in C++.

9. A method of databinding a relational database to an application comprising the steps of:

providing a relational database residing on a tangible computer readable medium;

providing an application written in an object oriented computer language residing on the tangible computer medium;

providing a databinding framework;

identifying tables to persist data in the database;

generating a table of metadata from the identified tables;

generating stored procedures from the metadata;

generating Value Objects (VO) from the metadata;

generating an XML binding definition from the metadata;

providing Data Access Objects (DAO); and

running the application with a run-time component that integrates the stored procedures, VOs, XML binding definitions and DAOs.

10. The method of claim 9 wherein generating the Value Objects comprises generating JavaBeans.

11. The method of claim 9 wherein providing the relational database comprises providing a relational Sybase database.

12. The method of claim 9 wherein providing the relational database comprises providing a relational Microsoft SQL server database.

13. The method of claim 9 wherein providing the relational database comprises providing a relational Oracle database.

14. The method of claim 9 wherein providing the application written in an object oriented computer language comprises providing an application written in Java.

15. The method of claim 9 wherein providing the application written in an object oriented computer language comprises providing an application written in C++.

16. The method of claim 9 wherein providing the databinding framework comprises providing an SPBinder framework.

17. The method of claim 9 wherein running the application with a run-time component comprises running the application with a run-time component comprising the subcomponents of SPBinder Manager, SPConnection, SPCaller, and SPCacheManager.