Implementing versioning support for data using a two-table approach that maximizes database efficiency
US8010887B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Sep 21, 2001 |
| Grant date | Aug 30, 2011 |
| Priority date | — |
| Expiry date | Jul 24, 2026 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/219
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method, system, and storage medium for providing versioning of data by associating a version number having a value with a data item, establishing a table for storing a most recent version of the data item, establishing a second table for storing all versions of the data item other than the most recent version, storing the current version of the data item in the first table, storing all other versions of the data item in the second table, and determining the version of said database data item based on the version number and storage location of the database data item.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.