Hardware transactional memory (htm) assisted database transactions

A method of utilizing a Hardware Transactional Memory (HTM) for an in-memory database accessed by a plurality of threads, comprising:

• splitting each of a plurality of database transactions held concurrently into a shared in-memory database to a plurality of HTM transactions, wherein each of the plurality of HTM transactions is executed atomically to access one of a plurality of rows of a database, and
• for each of the plurality of HTM transactions performing the following operations:
• access a certain one of the plurality of rows, for a read HTM transaction fetch a previous version of the certain row in case of a detection of another write HTM transaction concurrently writing to the certain row, and for a write HTM transaction abort the write HTM transaction at initiation in case of the detection, and
• validate and commit the each HTM transaction through an additional HTM transaction.

A computer readable storage medium, comprising computer readable program instructions thereon for causing a processor to carry out the operations of:

• splitting each of a plurality of database transactions held concurrently to a shared in-memory database into a plurality of HTM transactions, wherein each of the plurality of HTM transactions is executed atomically to access one of a plurality of rows of a database, and
• for each of the plurality of HTM transactions performing the following operations:
• access a certain one of the plurality of rows, for a read HTM transaction fetch a previous version of the certain row in case of a detection of another write HTM transaction concurrently writing to the certain row, and for a write HTM transaction abort the write HTM transaction at initiation in case of the detection, and
• validate and commit the each HTM transaction through an additional HTM transaction.