Patent · US Active

Asynchronous database index maintenance

US8140495B2 · kind B2 · utility

13Cited by

2References

20Claims

0Family size

Assignee

Microsoft Corporation · US

Inventors

Peter A. Carlin · Seattle, US
Per-Ake Larson · Redmond, US
Jingren Zhou · Bellevue, US

Key dates

Filing date	May 4, 2009
Grant date	Mar 20, 2012
Priority date	—
Expiry date	Apr 16, 2030

Classification

Technology area (CPC G)Physics
CPC primaryG06F16/22
WIPO fieldComputer technology
WIPO sectorElectrical engineering

Abstract

This disclosure provides techniques for asynchronously maintaining database indexes or sub-indexes. For example, a database management server may receive a data manipulation statement to modify particular data stored in a database and determine whether an index associated with executing the statement is maintained asynchronously. When the index is maintained asynchronously, maintenance of the index to reflect changes made to the particular data by executing the data manipulation statement may be delayed until an index maintenance event. The index maintenance may be based on an isolation level of a transaction including a query that triggered the index maintenance.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.