Management of updates in a database system

摘要

A method, system, and computer program product to efficiently maintain a database is disclosed. The method, system, and computer program product may include structuring the database to have a table, an index associated with the table, and a log associated with the index. The method, system, and computer program product may include receiving a maintenance request related to the index. The method, system, and computer program product may include accounting for the maintenance request when the index is being searched. The method, system, and computer program product may include adding the maintenance request to the log when the index is not being searched.

主权项

1. A computer-implemented method of managing a database contained in a storage facility, comprising:
structuring, with a database management system (DBMS), the database to have a table, an index associated with the table, and a log associated with the index; ordering entries of the log, based on a key; receiving, using a parser, a maintenance request related to the index; determining, with the DBMS, that the index is not being searched including determining that a pipeline is either closed or open and inactive between an application and the index, the pipeline being open and inactive including the pipeline being open, but not actively in use by a search request associated with the application and the index; adding, using a batch process, the maintenance request to the log in response to determining that the index is not being searched, wherein the maintenance request is a change to the index and the maintenance request is used to determine delays in maintenance of the index; determining, with the DBMS, that the index is being searched; and accounting for the maintenance request in response to determining that the index is being searched, wherein accounting for the maintenance request includes updating the index with the maintenance request and resume searching.