Transaction identifier locking with data row locks

A computing device is provided, including non-volatile memory storing a database including a table having a plurality of rows. The computing device may further include a processor configured to receive a request to perform a first transaction on a row. The processor may assign a first transaction id...

Full description

Saved in:
Bibliographic Details
Main Authors Chen, Wei, Mittur Venkataramanappa, Girish, Ravella, Chaitanya Sreenivas, Purnananda, Prashanth, Byrne, Peter, Radu, Adrian-Leonard, Freedman, Craig Steven, Antonopoulos, Panagiotis, Thallam Kodandaramaih, Raghavendra, Kodavalla, Hanumantha Rao
Format Patent
LanguageEnglish
Published 12.09.2023
Subjects
CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
Online AccessGet full text

Cover

More Information
Summary:A computing device is provided, including non-volatile memory storing a database including a table having a plurality of rows. The computing device may further include a processor configured to receive a request to perform a first transaction on a row. The processor may assign a first transaction identifier (TID) of the first transaction to the row. The processor may impose a first exclusive TID lock on the first TID of the row and may impose a first exclusive data lock associated with the first transaction on the row. The processor may perform the first transaction on the row. Performing the first transaction may include modifying the table as stored in the memory. In response to completing the first transaction, the processor may release the first exclusive data lock on the row and release the first exclusive TID lock on the first TID of the row.
Bibliography:Application Number: US202117358773