Microsoft Technology Licensing, LLC

Prashanth Purnananda

Hanumantha Rao Kodavalla

Craig Steven Freedman

Panagiotis Antonopoulos

Girish Mittur Venkataramanappa

Peter Byrne

Raghavendra Thallam Kodandaramaih

Wei Ting Chen

Adrian-Leonard Radu

Vasileios Papadimos

Chaitanya Sreenivas Ravella

Example aspects include techniques for anomaly detection via sparse judgmental samples. These techniques may include generating a qualified timestamp corresponding to execution of a first operation of a first transaction over a database and determining, based on the qualified timestamp, that a row of a table is not locked by a second operation of a second transaction over the database. In addition, the techniques may include determining that the row meets a condition of the first operation. Further, the techniques may include updating, based on the qualified timestamp, the row in response to the row meeting the condition, the updating including acquiring a lock on the row of the table.

Method and system for lock after qualification for update queries

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.

Transaction identifier locking with data row locks

Growing community of inventors

Bellevue, WA, United States of America

Prashanth Purnananda