Microsoft Technology Licensing, LLC

Chaitanya Sreenivas Ravella

Hanumantha Rao Kodavalla

Peter Byrne

Adrian-Leonard Radu

Prashanth Purnananda

Craig Steven Freedman

Panagiotis Antonopoulos

Girish Mittur Venkataramanappa

Raghavendra Thallam Kodandaramaih

Wei Ting Chen

Rahul Mittal

Srikanth Sampath

Srinag Rao Sadananda

Gururama Jithendra Gandikota

Systems, methods, apparatuses, and program products are disclosed for granular tracking of locking queries. Upon receiving a data manipulation command associated with a row of a page, a flag associated with the page is checked to determine whether a row locking query (RLQ) may be associated with the page. If no RLQ is associated with the page, the data manipulation command is executed without acquiring a lock. If an RLQ may be associated with the page, it is determined whether an active lock is associated with the page. If no active lock is associated with the page, the flag is updated to indicate that no RLQ is associated with the page and the data manipulation command is executed without acquiring a lock. If an active lock is associated with the page, page-level and row-level locks are acquired on the page and the row, respectively, before executing the data manipulation command.

Granular tracking of locking queries to reduce locking

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

Snoqualmie, WA, United States of America

Chaitanya Sreenivas Ravella