Invention Grant
- Patent Title: Database index repair
-
Application No.: US16565401Application Date: 2019-09-09
-
Publication No.: US11321294B2Publication Date: 2022-05-03
- Inventor: Rohit Agrawal , Thomas Fanghaenel
- 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.
- Main IPC: G06F16/22
- IPC: G06F16/22 ; G06F16/2453 ; G06F16/21 ; G06F16/23

Abstract:
A computing system may repair a database index for a database table by placing a first structural lock on the database table to prevent modifications to the structure of the table. The computing system may scan the database table to determine a plurality of database records. The system may probe the database index for the database records to identify records with missing entries in the index. Based on the probing, the system may place a first data lock on a record of the database table corresponding to a missing index entry to prevent modification of data in the record. In response to placing the first record lock, the system adds an index entry for the locked database record to the database index. During repair of the index, one or more processes may use the database index to locate one of the plurality of database records included in the database table.
Public/Granted literature
- US20210073195A1 DATABASE INDEX REPAIR Public/Granted day:2021-03-11
Information query