Tracking modifications to values of various fields in a database server
US8224808B2 · kind B2 · utility
0Cited by
1References
14Claims
0Family size
Assignee
Inventor
Key dates
| Filing date | Dec 12, 2005 |
| Grant date | Jul 17, 2012 |
| Priority date | — |
| Expiry date | May 6, 2028 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/2358
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Storing historical/previous values of a field of a relational database in the same table. The previous values can be conveniently used to revert back to any of such previously stored values. Thus, for each update/modify operation, the present value is stored as a previous value. In one embodiment, the previous values are stored in a VARRAY associated with each field. The indexed entries of the VARRAY store the present as well as previous values of the field.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.