US 10,885,015 B2Granted

Database system transaction management

AssigneeInternational Business Machines Corporation

InventorsHarold Wade Cain, III, Donna N. Dillenberger, Michel H. T. Hack, Hong Min, Gong Su, James Zu-Chia Teng

Life of this patent

Estimating the term…

Loading patent…

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.

Claims20

Dependent claims

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 by augmenting the at least one data object with at least one transaction tag, the at least one transaction tag being configured to indicate an access intent and access status of an associated data object;
process a plurality of database transactions utilizing a transactional memory process, wherein access to each of the plurality of data objects is determined based on the status of each of the plurality of data objects as identified by the at least one transaction tag corresponding to the data object, wherein the plurality of data objects comprise tagged and untagged data objects, wherein to process comprises transforming the at least one database transaction into an operation by:
updating, utilizing hardware transactional memory, the access status of the at least one transaction tag of each of the plurality of data objects having at least one transaction tag to an accessible state to reserve access privilege of each of the plurality of data objects, wherein the access privilege comprises a right to attempt access and operation of the at least one data object;
accessing, utilizing an application thread provided reserved access to the plurality of data objects from the hardware transactional memory, the data structure content of the plurality of data objects having the access status of an accessible state and modifying the transaction tag of the plurality of data objects by marking the plurality of data objects as accessed, wherein the accessing is performed lock-free based upon the application thread having reserved access to the plurality of data objects;
blocking access to the plurality of data objects to an application thread not having reserved access to the plurality of data objects;
and
updating, utilizing the hardware transaction memory, the access status of the at least one transaction tag of each of the plurality of data objects having at least one transaction tag to a state previous to the accessible state of the at least one transaction tag;
and
update the status of the at least one data object responsive to the processing.

10 more elements

A method comprising:

annotating via a computing device at least one data object residing on the computing device by augmenting the at least one data object with at least one transaction tag, the at least one transaction tag being configured to indicate an access intent and access status of an associated data object;
processing a plurality of database transactions utilizing a transactional memory process, wherein access to each of the plurality of data objects is determined based on the status of each of the plurality of data objects as identified by the at least one transaction tag corresponding to the data object, wherein the plurality of data object comprise tagged and untagged data objects, wherein to process comprises transforming the at least one database transaction into an operation by:
updating, utilizing hardware transactional memory, the access status of the at least one transaction tag of each of the plurality of data objects having at least one transaction tag to an accessible state to reserve access privilege of each of the plurality of data objects, wherein the access privilege comprises a right to attempt access and operation of the at least one data object;
accessing, utilizing an application thread provided reserved access to the plurality of data objects from the hardware transactional memory, the data structure content of the plurality of data objects having the access status of an accessible state and modifying the transaction tag of the plurality of data objects by marking the plurality of data objects as accessed, wherein the accessing is performed lock-free based upon the application thread having reserved access to the plurality of data objects;
blocking access to the plurality of data objects to an application thread not having reserved access to the plurality of data objects;
and
updating, utilizing the hardware transaction memory, the access status of the at least one transaction tag of each of the plurality of data objects having at least one transaction tag to a state previous to the accessible state of the at least one transaction tag;
and
updating the status of the at least one data object responsive to the processing.

6 more elements

A computer program product comprising:

a non-transitory 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 by augmenting the at least one data object with at least one transaction tag, the at least one transaction tag being configured to indicate an access intent and access status of an associated data object;
computer readable program code configured to process a plurality of database transactions utilizing a transactional memory process, wherein access to each of the plurality of data objects is determined based on the status of each of the plurality of data objects as identified by the at least one transaction tag corresponding to the data object, wherein the plurality of data object comprise tagged and untagged data objects, wherein to process comprises transforming the at least one database transaction into an operation by:
updating, utilizing hardware transactional memory, the access status of the at least one transaction tag of each of the plurality of data objects having at least one transaction tag to an accessible state to reserve access privilege of each of the plurality of data objects, wherein the access privilege comprises a right to attempt access and operation of the at least one data object;
accessing, utilizing an application thread provided reserved access to the plurality of data objects from the hardware transactional memory, the data structure content of the plurality of data objects having the access status of an accessible state and modifying the transaction tag of the plurality of data objects by marking the plurality of data objects as accessed, wherein the accessing is performed lock-free based upon the application thread having reserved access to the plurality of data objects;
blocking access to the plurality of data objects to an application thread not having reserved access to the plurality of data objects;
and
updating, utilizing the hardware transaction memory, the access status of the at least one transaction tag of each of the plurality of data objects having at least one transaction tag to a state previous to the accessible state of the at least one transaction tag;
and
computer readable program code configured to update the status of the at least one data object responsive to the processing.

7 more elements

Dependencies are inferred from the claim text.