DATABASE SYSTEM TRANSACTION MANAGEMENT

• US 20130262424A1
• Filed: 03/30/2012
• Published: 10/03/2013
• Est. Priority Date: 03/30/2012
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Cain, Harold Wade III, Dillenberger, Donna N., Hack, Michel H.T., Min, Hong, Su, Gong, Teng, James Zu-Chia
• Granted Patent: US 9,870,384 B2
• Time in Patent Office: Days
• US Class Current: 707/703
• CPC Class Codes: G06F 16/2315 Optimistic concurrency control

Abstract

Systems, methods, and products for database system transaction management are provided herein. One aspect provides for annotating via a computing device at least one data object residing on the computing device utilizing at least one transaction tag, the at least one transaction tag being configured to indicate a status of an associated data object; processing at least one database transaction utilizing a transactional memory process, wherein access to the at least one data object is determined based on the status of the at least one data object; and updating the status of the at least one data object responsive to an attempted access of the at least one data object by the at least one database transaction. Other embodiments and aspects are also described herein.

Claims

1. A system comprising:

at least one processor; and

a memory device operatively connected to the at least one processor;

wherein, responsive to execution of program instructions accessible to the at least one processor, the at least one processor is configured to;

annotate at least one data object utilizing at least one transaction tag, the at least one transaction tag being configured to indicate a status of an associated data object;

process at least one database transaction utilizing a transactional memory process, wherein access to the at least one data object is determined based on the status of the at least one data object; and

update the status of the at least one data object responsive to an attempted access of the at least one data object by the at least one database transaction.

2. The system according to claim 1, wherein the at least one processor is further configured to define at least one application programming interface configured to enable a transaction declaration on data annotated with a transaction tag.

3. The system according to claim 1, wherein the status of the at least one data object is updated via hardware transaction management.

4. The system according to claim 3, wherein hardware transaction management handles updating optimistically lock-free.

5. The system according to claim 1, wherein the at least one transaction tag comprises an active read counter and an active write counter.

6. The system according to claim 1, wherein the at least one transaction tag is transparent to applications invoking database transactions.

7. The system according to claim 1, wherein the update of the status of the at least one data object is undone responsive to completion of access to the at least one data object.

8. The system according to claim 1, wherein access to a plurality of data objects may be grouped.

9. The system according to claim 1, wherein access to a grouped plurality of data objects is granted on an all-or-nothing basis.

10. The system according to claim 1, wherein the at least one data object is defined within a database comprising table, page, and row elements.

11. A method comprising:

annotating via a computing device at least one data object residing on the computing device utilizing at least one transaction tag, the at least one transaction tag being configured to indicate a status of an associated data object;

processing at least one database transaction utilizing a transactional memory process, wherein access to the at least one data object is determined based on the status of the at least one data object; and

updating the status of the at least one data object responsive to an attempted access of the at least one data object by the at least one database transaction.

12. The method according to claim 11, further comprising defining at least one application programming interface configured to enable a transaction declaration on data annotated with a transaction tag.

13. The method according to claim 11, wherein the status of the at least one data object is updated via hardware transaction management.

14. The method according to claim 13, wherein hardware transaction management handles updating optimistically lock-free.

15. The method according to claim 11, wherein the at least one transaction tag comprises an active read counter and an active write counter.

16. The method according to claim 11, wherein the at least one transaction tag is transparent to applications invoking database transactions.

17. The method according to claim 11, wherein the update of the status of the at least one data object is undone responsive to completion of access to the at least one data object.

18. The method according to claim 11, wherein access to a plurality of data objects may be grouped.

19. The method according to claim 11, wherein access to a grouped plurality of data objects is granted on an all-or-nothing basis.

20. A computer program product comprising:

a computer readable storage medium having computer readable program code embodied therewith, the computer readable program code comprising;

computer readable program code configured to annotate at least one data object utilizing at least one transaction tag, the at least one transaction tag being configured to indicate a status of an associated data object;

computer readable program code configured to process at least one database transaction utilizing a transactional memory process, wherein access to the at least one data object is determined based on the status of the at least one data object; and

computer readable program code configured to update the status of the at least one data object responsive to an attempted access of the at least one data object by the at least one database transaction.