Invention Grant
- Patent Title: Database concurrency control through hash-bucket latching
-
Application No.: US15420377Application Date: 2017-01-31
-
Publication No.: US11386065B2Publication Date: 2022-07-12
- Inventor: Thomas Fanghaenel , Patrick James Helland , James E. Mace
- Applicant: salesforce.com, inc.
- Applicant Address: US CA San Francisco
- Assignee: salesforce.com, inc.
- Current Assignee: salesforce.com, inc.
- Current Assignee Address: US CA San Francisco
- Agency: Kowert, Hood, Munyon, Rankin & Goetzel, P.C.
- Agent Paul T. Seegers; Dean M. Munyon
- Main IPC: G06F16/23
- IPC: G06F16/23 ; G06F16/22

Abstract:
Techniques are disclosed relating to efficiently processing of concurrent database transactions. In one embodiment, a database system receives a first key-value pair for a database transaction and stores the key-value pair in a data structure for active database transactions. The storing may include indexing into a hash table of the data structure with a key of the key-value pair to identify a hash bucket of the hash table corresponding to the key, acquiring a latch associated with the identified hash bucket, and, based on a state of the acquired latch, appending, to the hash bucket, a record specifying the key-value pair. The database system may cause the key-value pair from the data structure to be committed to persistent storage in response to the database transaction being committed.
Public/Granted literature
- US20180218023A1 DATABASE CONCURRENCY CONTROL THROUGH HASH-BUCKET LATCHING Public/Granted day:2018-08-02
Information query