Fast refresh of snapshots
US5963959A · kind A · utility
Assignee
Inventors
Key dates
| Filing date | May 30, 1997 |
| Grant date | Oct 5, 1999 |
| Priority date | — |
| Expiry date | May 30, 2017 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99952
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method and apparatus employs primary key values stored in a master table to drive a fast refresh mechanism for a snapshot defined on the master table. A primary key is a set of columns in the master table having a combined value that uniquely identifies each row in the master table. When rows of the master table are modified, the primary key values of the modified rows are recorded in a master log. In response to a fresh command, differences between the master table and snapshot are reconciled based on primary key values stored in the master table, the master log, and the snapshot.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.