TRANSACTION IDENTIFIER LOCKING WITH DATA ROW LOCKS

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...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: BYRNE, Peter, ANTONOPOULOS, Panagiotis, RAVELLA, Chaitanya Sreenivas, PURNANANDA, Prashanth, MITTUR VENKATARAMANAPPA, Girish, KODAVALLA, Hanumantha Rao, RADU, Adrian-Leonard, THALLAM KODANDARAMAIH, Raghavendra, FREEDMAN, Craig Steven, CHEN, Wei
Format: Patent
Sprache:eng ; fre ; ger
Schlagworte:
CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung: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.