Loading an index with minimal effect on availability of applications using the corresponding table
US8380702B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Mar 10, 2009 |
| Grant date | Feb 19, 2013 |
| Priority date | — |
| Expiry date | Nov 14, 2029 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/81
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A database server provides a partitioned table with a corresponding locally partitioned index. When a request is made to load data into the table by an application, a table partition, along with a corresponding index partition, is created for the application. The corresponding index partition in marked as asynchronously maintained, allowing other index partitions to be used by the query optimizer in formulating query plans for other table partitions. Once the loading of data is complete, a synchronization operation is called with the result of conforming the data in the asynchronously maintained index partition with its corresponding table in which the data was loaded. Once the data in the corresponding table partition and the data in the asynchronously maintained index partition are synchronized, the asynchronously maintained index partition is marked as synchronously maintained.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.