Fast refresh of snapshots

Details Fast refresh of snapshots Fast refresh of snapshots

1997-05-30

1999-10-05

Fetting, Anton

Data processing: database and file management or data structures

Database design

Data structure types

707201, 707100, 707102, 707103, 707104, 707 2, G06F 1730

Patent

active

059639598

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.

REFERENCES:
patent: 4631673 (1986-12-01), Haas et al.
patent: 5175849 (1992-12-01), Schneider
patent: 5287496 (1994-02-01), Chen et al.
patent: 5701480 (1997-12-01), Raz
patent: 5806074 (1998-09-01), Souder et al.
patent: 5806075 (1998-09-01), Jain et al.

Affiliated with

Also associated with

Rating

Fast refresh of snapshots does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Fast refresh of snapshots, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Fast refresh of snapshots will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-1183670