System and method for transparent persistence management

• US 7,653,651 B1
• Filed: 04/29/2004
• Issued: 01/26/2010
• Est. Priority Date: 04/29/2004
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Pavlov, Vladimir K.
• Primary Examiner(s): Breene; John E
• Assistant Examiner(s): MYINT, DENNIS Y
• Application Number:
  US10/836,159
• Time in Patent Office: 2,098 Days
• Field of Search: 714/13, 707/102, 707/100, 707/200, 707/104.1, 707/103.R, 707/103.Y
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2343 Locking methods, e.g. distributed locking or locking implementation details
• CPC Class Codes: G06F 16/289 Object oriented databases
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure

Abstract

One embodiment of the invention employs “transparent object persistence” techniques in which persistent data objects (i.e., the objects that represent persistent data from a database) are separated from business processing objects (i.e., the objects that handle the requests, process specific business operations, manipulate the persistent data and respond to clients). Within a Java 2 Enterprise Edition (“J2EE”) environment, the business processing objects are entity beans managed by an Enterprise Java Bean (“EJB”) container. A persistence manager manages the persistent data objects, which provide an in-memory representation of a set of database data. The entity beans manipulate the persistent data by invoking get/set accessor methods on the persistent data objects. In one embodiment, the persistence manager associates a state with each of the persistent data objects which indicates an operation to be performed within tables of a relational database when the modifications to the persistent data objects are committed to the relational database.

Claims

1. A cluster server system comprising:

a plurality of instances, each instance including;

a dispatcher to distribute a plurality of service requests to one or more server nodes, wherein each server node includes;

a lock manager to manage locks on one or more of a plurality of database data as requested by a locking service on a central services instance;

a cluster manager to communicate with a messaging service on the central services instance;

a configuration manager to communicate with a relational database on a permanent storage medium, the relational database to store the plurality of database data within a plurality of database tables; and

a persistence manager to map a plurality of persistent data objects to the plurality of database data and modify the persistent data objects responsive to receiving one of the plurality of service requests, the persistence manager further to associate a state property with each of the persistent data objects indicating an operation to be performed within the plurality of database tables of the relational database when the modifications to the persistent data objects are committed to the relational database,

wherein the persistence manager comprises state transition logic defining a plurality of values for the state property associated with each of the plurality of persistent data objects, wherein each of the plurality of values corresponds to a modification performed on the persistent data object with which the state property is associated.

2. The system of claim 1 wherein the plurality of values for the state property include a “

default”

value identifying persistent data objects which represent unmodified data from the database.

3. The system of claim 1 wherein the plurality of values for the state property comprise:

a “

created”

value representing a create operation for creating new data;

a “

removed”

value representing a remove operation for removing data; and

an “

updated”

value representing an update operation for updating existing data.

4. The system of claim 3 wherein, in response to performing a “

remove”

operation on a persistent data object having a state property with the “

created”

value, the value of the state property transitions to “

virtually removed”

, indicating that no operation is required when data is committed to the relational database.

5. The system of claim 1 wherein the relational database comprises a plurality of database tables and wherein each persistent data object represents data from a row of a particular database table.

6. The system of claim 5 wherein each persistent data object has a primary key associated therewith, the primary key uniquely identifying each persistent data object and each associated row of the database table.

7. The system of claim 1 wherein each persistent data object is associated with one of a plurality of business processing objects, each business processing object having business logic to perform in response to receiving one of the plurality of service requests.

8. A method comprising:

storing a set of database data within a plurality of database tables;

generating a plurality of persistent data objects representing the set of database data in a volatile memory;

mapping the plurality of persistent data objects to the set of database data;

modifying the plurality of persistent data objects responsive to receiving service requests from a dispatcher module; and

modifying a value of a state property associated with each of the plurality of persistent data objects in response to modifying the plurality of persistent data objects, wherein the value of the state property represents an operation to be performed within the plurality of database tables of a relational database when the modifications to the persistent data objects are committed to the relational database.

9. The method as in claim 8 wherein the value for the state property includes a “

default”

value identifying persistent data objects which represent unmodified data from the database.

10. The method as in claim 8 wherein the value of the state property is one of:

a “

created”

value representing a create operation for creating new data;

a “

removed”

value representing a remove operation for removing data; and

an “

updated”

value representing an update operation for updating existing data.

11. The method as in claim 10 wherein, in response to performing a “

remove”

operation on a persistent data object with a state property having a “

created”

value, the value of the state property transitions to a “

virtually removed”

value, indicating that no operation is required when data is committed to the relational database.

12. The method as in claim 8 wherein the relational database comprises the plurality of database tables and wherein each persistent data object represents data from a row of a particular database table.

13. The method as in claim 12 wherein each persistent data object has a primary key associated therewith, the primary key uniquely identifying each persistent data object and each associated row of the database table.

14. A machine readable medium having instructions therein that when executed by the machine cause the machine to:

distribute a plurality of service requests from a dispatcher to one or more server nodes, wherein each server node includes;

a lock manager to manage locks on one or more of a plurality of database data as requested by a locking service on a central services instance;

a cluster manager to communicate with a messaging service on the central services instance;

a configuration manager to communicate with a relational database on a permanent storage medium, the relational database to store the plurality of database data within a plurality of database tables; and

a persistence manager to map a plurality of persistent data objects to the plurality of database data and modify the persistent data objects responsive to receiving one of the plurality of service requests, the persistence manager further to associate a state property with each of the persistent data objects indicating an operation to be performed within the plurality of database tables of the relational database when the modifications to the persistent data objects are committed to the relational database,

wherein the persistence manager comprises state transition logic defining a plurality of values for the state property associated with each of the plurality of persistent data objects, wherein each of the plurality of values corresponds to a modification performed on the persistent data object with which the state property is associated.

15. The machine readable medium of claim 14 wherein the value of the state property includes a “

default”

value identifying persistent data objects which represent unmodified data from the database.

16. The machine readable medium of claim 14 wherein the plurality of values for the state property comprise:

a “

created”

value representing a create operation for creating new data;

a “

removed”

value representing a remove operation for removing data; and

an “

updated”

value representing an update operation for updating existing data.

17. The machine readable medium of claim 16 wherein in response to performing a “

remove”

operation on a persistent data object having a state property with the “

created”

value, the value of the state property transitions to “

virtually removed”

, indicating that no operation is required when data is committed to the relational database.

18. The machine readable medium of claim 14 wherein the relational database comprises a plurality of database tables and wherein each persistent data object represents data from a row of a particular database table.

19. The machine readable medium of claim 18 wherein each persistent data object has a primary key associated therewith, the primary key uniquely identifying each persistent data object and each associated row of the database table.