| CPC G06F 12/0253 (2013.01) [G06F 16/2272 (2019.01); G06F 2212/702 (2013.01)] | 20 Claims |
|
1. A computer-implemented method comprising:
receiving a request to create an index based on a portion of a database, the portion of the database comprising one or more entries that correspond to one or more ongoing transactions;
responsive to the request to create the index:
generating the index based on the portion of the database, and
auto-committing to disk a subset of entries that correspond to one or more ongoing transactions in the database prior to a completion of the one or more ongoing transactions;
determining that the database comprises a plurality of parallel transactions to which the index is accessible;
detecting, after the auto-committing, a command to rollback the request to create the index;
scheduling the index for asynchronous garbage collection, wherein the asynchronous garbage collection removes information associated with the index from both a memory and the disk based upon a completion of the plurality of parallel transactions; and
removing the information associated with the index from both the memory and the disk in accordance with the asynchronous garbage collection.
|