Mapping Enterprise Java Bean attributes to database schema

• US 20060031243A1
• Filed: 08/05/2004
• Published: 02/09/2006
• Est. Priority Date: 08/05/2004
• Status: Active Grant

• Current Assignee: Google LLC (Alphabet Inc.)
• Original Assignee: International Business Machines Corporation
• Inventors: Sudarsan, Sridhar, Chupa, Kenneth A., Boyle, Alan Iain
• Granted Patent: US 7,313,570 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

Mapping Enterprise Java Bean (“EJB”) attributes to database schema including providing a first metamap including one or more abstracted variable characteristics of a first database schema and creating from the first metamap a second metamap for a second database schema including varying one or more of the abstracted variable characteristics to conform to the second database schema. Typical embodiments also include synchronizing, in response to methods invoked on the EJB and in dependence upon the second metamap, the state of the EJB with a persistent data store having the second database schema. In typical embodiments, synchronizing the state of the EJB with a persistent data store having the second database schema also includes creating records, updating records, and deleting records in the persistent data store.

Claims

1. A method for mapping Enterprise Java Bean (“

EJB”

) attributes to database schema, the method comprising;

providing a first metamap including one or more abstracted variable characteristics of a first database schema; and

creating from the first metamap a second metamap for a second database schema including varying one or more of the abstracted variable characteristics to conform to the second database schema.

2. The method of claim 1 further comprising synchronizing, in response to methods invoked on the EJB and in dependence upon the second metamap, the state of the EJB with a persistent data store having the second database schema.

3. The method of claim 2 wherein synchronizing the state of the EJB with a persistent data store having the second database schema further comprises creating records, updating records, and deleting records in the persistent data store.

4. The method of claim 1 wherein providing a first metamap further comprises abstracting, from a mapping of EJB attributes to columns of the first database schema, one or more variable characteristics of the first database schema.

5. The method of claim 4 wherein variable characteristics of the first database schema comprise schema name, database name, table name, and column name.

6. The method of claim 4 wherein abstracting variable characteristics of the first database schema further comprises inserting in the first metamap an element representing each abstracted variable characteristic.

7. The method of claim 4 wherein abstracting variable characteristics of the first database schema further comprises:

moving table and column descriptions from the mapping into a table file linked to the first metamap with a table identifier, including names of the abstracted variable characteristics;

deleting from the table file the names of the abstracted variable characteristics;

moving mapping descriptions from the mapping into a field mapping file linked to the first metamap with a mapping identifier, including names of the abstracted variable characteristics; and

deleting from the field mapping file the names of the abstracted variable characteristics.

8. A system for mapping Enterprise Java Bean (“

EJB”

) attributes to database schema, the system comprising;

means for providing a first metamap including one or more abstracted variable characteristics of a first database schema; and

means for creating from the first metamap a second metamap for a second database schema including means for varying one or more of the abstracted variable characteristics to conform to the second database schema.

9. The system of claim 8 further comprising means for synchronizing, in response to systems invoked on the EJB and in dependence upon the second metamap, the state of the EJB with a persistent data store having the second database schema.

10. The system of claim 9 wherein means for synchronizing the state of the EJB with a persistent data store having the second database schema further comprises means for creating records, means for updating records, and means for deleting records in the persistent data store.

11. The system of claim 8 wherein means for providing a first metamap further comprises means for abstracting, from a mapping of EJB attributes to columns of the first database schema, one or more variable characteristics of the first database schema.

12. The system of claim 11 wherein means for abstracting variable characteristics of the first database schema further comprises means for inserting in the first metamap an element representing each abstracted variable characteristic.

13. The system of claim 11 wherein means for abstracting variable characteristics of the first database schema further comprises:

means for moving table and column descriptions from the mapping into a table file linked to the first metamap with a table identifier, including names of the abstracted variable characteristics;

means for deleting from the table file the names of the abstracted variable characteristics;

means for moving mapping descriptions from the mapping into a field mapping file linked to the first metamap with a mapping identifier, including names of the abstracted variable characteristics; and

means for deleting from the field mapping file the names of the abstracted variable characteristics.

14. A computer program product for mapping Enterprise Java Bean (“

EJB”

) attributes to database schema, the computer program product comprising;

a recording medium;

means, recorded on the recording medium, for providing a first metamap including one or more abstracted variable characteristics of a first database schema; and

means, recorded on the recording medium, for creating from the first metamap a second metamap for a second database schema including means, recorded on the recording medium, for varying one or more of the abstracted variable characteristics to conform to the second database schema.

15. The computer program product of claim 14 further comprising means, recorded on the recording medium, for synchronizing, in response to computer program products invoked on the EJB and in dependence upon the second metamap, the state of the EJB with a persistent data store having the second database schema.

16. The computer program product of claim 14 wherein means, recorded on the recording medium, for synchronizing the state of the EJB with a persistent data store having the second database schema further comprises means, recorded on the recording medium, for creating records, means, recorded on the recording medium, for updating records, and means, recorded on the recording medium, for deleting records in the persistent data store.

17. The computer program product of claim 14 wherein means, recorded on the recording medium, for providing a first metamap further comprises means, recorded on the recording medium, for abstracting, from a mapping of EJB attributes to columns of the first database schema, one or more variable characteristics of the first database schema.

18. The computer program product of claim 17 wherein variable characteristics of the first database schema comprise schema name, database name, table name, and column name.

19. The computer program product of claim 17 wherein means, recorded on the recording medium, for abstracting variable characteristics of the first database schema further comprises means, recorded on the recording medium, for inserting in the first metamap an element representing each abstracted variable characteristic.

20. The computer program product of claim 17 wherein means, recorded on the recording medium, for abstracting variable characteristics of the first database schema further comprises:

means, recorded on the recording medium, for moving table and column descriptions from the mapping into a table file linked to the first metamap with a table identifier, including names of the abstracted variable characteristics;

means, recorded on the recording medium, for deleting from the table file the names of the abstracted variable characteristics;

means, recorded on the recording medium, for moving mapping descriptions from the mapping into a field mapping file linked to the first metamap with a mapping identifier, including names of the abstracted variable characteristics; and

means, recorded on the recording medium, for deleting from the field mapping file the names of the abstracted variable characteristics.