Cached persistent data management through state tracking

• US 7,469,256 B1
• Filed: 04/29/2004
• Issued: 12/23/2008
• Est. Priority Date: 04/29/2004
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Simeonov, Ivo V., Manolov, Svetoslav H.
• Primary Examiner(s): Le; Uyen
• Application Number:
  US10/835,751
• Time in Patent Office: 1,699 Days
• Field of Search: 707/102, 707/204, 711/100, 718/101, 718/102, 719/330
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: G06F 16/2379 Updates performed during online database operations; commit processing
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

A method is described in which, during execution of a distributed transaction, a representation of persistent data stored at an entry in a database is placed into a cache. Then, in response to an application'"'"'s decision that the entry should be removed from the database, the representation is kept in the cache and marked as corresponding to an entry that is to be removed from the database. Then, during execution of the distributed transaction'"'"'s two-phase commit protocol, the database is informed that the entry is to be removed from the database if the representation was marked as corresponding to an entry that is to be removed from the database when the application completed its execution for the distributed transaction.

Claims

1. A method, comprising:

during execution of a distributed transaction;

a) placing into a cache a representation of persistent data stored at an entry in a database;

b) in response to an application'"'"'s decision that said entry should be removed from said database, keeping said representation in said cache and marking said representation as corresponding to an entry that is to be removed from said database, and, updating a list with the identity of said representation, said list listing cached entries of persistent data, each one of said cached entries marked during said distributed transaction as a database entry that is to be removed from its respective database; and

,

c) during execution of said distributed transaction'"'"'s two-phase commit protocol, referring to said list to identify each one of those cached representations of persistent data that is marked as corresponding to an entry that is to be removed from its respective database when said application'"'"'s execution for said distributed transaction is complete, and, informing each said respective database that it is to remove its corresponding entry identified from said list.

2. The method of claim 1 wherein said representation is an object.

3. The method of claim 2 wherein said object is an entity bean.

4. The method of claim 1 wherein said reading and said informing is performed with the assistance of a resource manager.

5. The method of claim 4 wherein said resource manager is a JDBC resource manager.

6. The method of claim 4 wherein said resource manager is an ODBC resource manager.

7. The method of claim 1 wherein said

“

placing into a cache a representation of persistent data stored at an entry in a database”

in a)

is performed by;

placing into a cache a representation of persistent data stored at an entry in a database, said representation marked as being in a default state.

8. The method of claim 7 further comprising changing said default state to a remove state as a consequence of said application'"'"'s decision, said marking being said changing.

9. The method of claim 7 further comprising, between a) and b), changing said representation to represent a new value for said data and changing said default state to an update state, and, adding the identity of said representation to a second list, said second list listing cached representations of persistent data that are marked as being updated.

10. The method of claim 9 further comprising changing said update state to a remove state as a consequence of said application'"'"'s decision, said marking being said changing of said update state to said remove state.

11. The method of claim 9 wherein said representations comprise objects.

12. The method of claim 11 wherein said objects are entity beans.

13. The method of claim 11 wherein said list is kept within a transaction context.

14. The method of claim 11 further comprising

during execution of said distributed transaction'"'"'s two-phase commit protocol, referring to said second list to identify each one of those cached representations of Persistent data that is marked as corresponding to an entry that is to be updated within its respective database when said application'"'"'s execution for said distributed transaction is complete, and, informing each said respective database of the update it needs to make its corresponding entry identified from said second list.

15. The method of claim 14 further comprising

during execution of said distributed transaction'"'"'s two-phase commit protocol, referring to a third list to identify each one of those cached representations of persistent data that is marked as corresponding to an entry that is to be newly created within a respective database when said application'"'"'s execution for said distributed transaction is complete, and, informing each said respective database of the new entry it needs to make for its corresponding representation identified from said third list.

16. An article of manufacture including program code which, when processed by a machine, causes the machine to perform a method, the method comprising:

during execution of a distributed transaction;

a) placing into a cache a representation of persistent data stored at an entry in a database;

b) in response to an application'"'"'s decision that said entry should be removed from said database, keeping said representation in said cache and marking said representation as corresponding to an entry that is to be removed from said database, and, updating a list with the identity of said representation, said list listing cached entries of persistent data, each one of said cached entries marked during said distributed transaction as a database entry that is to be removed from its respective database; and

,

c) during execution of said distributed transaction'"'"'s two-phase commit protocol, referring to said list to identify each one of those cached representations of persistent data that is marked as corresponding to an entry that is to be removed from its respective database when said application'"'"'s execution for said distributed transaction is complete, and, informing each said respective database that it is to remove its corresponding entry identified from said list.

17. The article of manufacture of claim 16 wherein said representation is an object.

18. The article of manufacture of claim 17 wherein said object is an entity bean.

19. The article of manufacture of claim 16 wherein said reading and said informing is performed with the assistance of a resource manager.

20. The article of manufacture of claim 19 wherein said resource manager is a JDBC resource manager.

21. The article of manufacture of claim 19 wherein said resource manager is an ODBC resource manager.

22. The article of manufacture of claim 16 wherein said

“

placing into a cache a representation of persistent data stored at an entry in a database”

in a)

is performed by;

placing into a cache a representation of persistent data stored at an entry in a database, said representation marked as being in a default state.

23. The article of manufacture of claim 22 wherein said method further comprises changing said default state to a remove state as a consequence of said application'"'"'s decision, said marking being said changing.

24. The article of manufacture of claim 22 wherein said method further comprises, between a) and b), changing said representation to represent a new value for said data and changing said default state to an update state, and, adding the identity of said representation to a second list, said second list listing cached representations of persistent data that are marked as being updated.

25. The article of manufacture of claim 24 wherein said method further comprises changing said update state to a remove state as a consequence of said application'"'"'s decision, said marking being said changing of said update state to said remove state.

26. The article of manufacture of claim 24 wherein said representations comprise objects.

27. The article of manufacture of claim 26 wherein said objects are entity beans.

28. The article of manufacture of claim 26 wherein said list is kept within a transaction context.

29. The article of manufacture of claim 26 wherein said method further comprises

during execution of said distributed transaction'"'"'s two-phase commit protocol, referring to said second list to identify each one of those cached representations of persistent data that is marked as corresponding to an entry that is to be updated within its respective database when said application'"'"'s execution for said distributed transaction is complete, and, informing each said respective database of the update it needs to make its corresponding entry identified from said second list.

30. The article of manufacture of claim 29 wherein said method further comprises

during execution of said distributed transaction'"'"'s two-phase commit protocol, referring to a third list to identify each one of those cached representations of persistent data that is marked as corresponding to an entry that is to be newly created within a respective database when said application'"'"'s execution for said distributed transaction is complete, and, informing each said respective database of the new entry it needs to make for its corresponding representation identified from said third list.

31. A computing system comprising program code disposed on a computer readable medium, said program code capable of being processed by a machine within said computing system to perform a method, said method comprising:

during execution of a distributed transaction;

a) placing into a cache a representation of persistent data stored at an entry in a database;

b) in response to an application'"'"'s decision that said entry should be removed from said database keeping said representation in said cache and marking said representation as corresponding to an entry that is to be removed from said database, and, updating a list with the identity of said representation, said list listing cached entries of persistent data, each one of said cached entries marked during said distributed transaction as a database entry that is to be removed from its respective database; and

,

c) during execution of said distributed transaction'"'"'s two-phase commit protocol, referring to said list to identify each one of those cached representations of persistent data that is marked as corresponding to an entry that is to be removed from its respective database when said application'"'"'s execution for said distributed transaction is complete, and, informing each said respective database that it is to remove its corresponding entry identified from said list.

32. The computing system of claim 31 wherein said representation is an object.

33. The computing system of claim 32 wherein said object is an entity bean.

34. The computing system of claim 31 wherein said reading and said informing is performed with the assistance of a resource manager.

35. The computing system of claim 34 wherein said resource manager is a JDBC resource manager.

36. The computing system of claim 34 wherein said resource manager is an ODBC resource manager.

37. The computing system of claim 31 wherein said

“

placing into a cache a representation of persistent data stored at an entry in a database”

in a)

is performed by;

placing into a cache a representation of persistent data stored at an entry in a database, said representation marked as being in a default state.

38. The computing system of claim 37 wherein said method further comprises changing said default state to a remove state as a consequence of said application'"'"'s decision, said marking being said changing.

39. The computing system of claim 37 wherein said method further comprises, between a) and b), changing said representation to represent a new value for said data and changing said default state to an update state, and, adding the identity of said representation to a second list, said second list listing cached representations of persistent data that are marked as being updated.

40. The computing system of claim 39 wherein said method further comprises changing said update state to a remove state as a consequence of said application'"'"'s decision, said marking being said changing of said update state to said remove state.

41. The computing system of claim 39 wherein said representations comprise objects.

42. The computing system of claim 41 wherein said objects are entity beans.

43. The computing system of claim 41 wherein said list is kept within a transaction context.

44. The computing system of claim 41 wherein said method further comprises

during execution of said distributed transaction'"'"'s two-phase commit protocol, referring to said second list to identify each one of those cached representations of persistent data that is marked as corresponding to an entry that is to be updated within its respective database when said application'"'"'s execution for said distributed transaction is complete, and, informing each said respective database of the update it needs to make its corresponding entry identified from said second list.

45. The computing system of claim 44 wherein said method further comprises

during execution of said distributed transaction'"'"'s two-phase commit protocol, referring to a third list to identify each one of those cached representations of persistent data that is marked as corresponding to an entry that is to be newly created within a respective database when said application'"'"'s execution for said distributed transaction is complete, and, informing each said respective database of the new entry it needs to make for its corresponding representation identified from said third list.