Indexing to efficiently manage versioned data in a database system
US7047250B1 · kind B1 · utility
Assignee
Inventors
Key dates
| Filing date | Sep 27, 2002 |
| Grant date | May 16, 2006 |
| Priority date | — |
| Expiry date | Nov 16, 2023 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99952
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method and apparatus for accessing information using indexes on versioned tables is described that exploits the power of partitioned indexing to index versioned data. In partitioned indexing, an index is divided in sub-indexes, referred to as index partitions. An index may be, for example, partitioned according to a particular version identified by a version id, that is, each index partition indexes the rows in a versioned table that belong to the version identified by a particular version id. Partitioned indexes can be more efficient to use to access versioned data. The utility of partitioned indexes extends beyond indexing versioned data.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.