Patent · US Expired

Fast refresh of snapshots

US5963959A · kind A · utility

70Cited by
6References
40Claims
0Family size

Assignee

Inventors

Key dates

Filing dateMay 30, 1997
Grant dateOct 5, 1999
Priority date
Expiry dateMay 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.