Techniques for reducing the number of snapshots of a database

Details Techniques for reducing the number of snapshots of a database Techniques for reducing the number of snapshots of a database

1997-04-23

1999-09-21

Lintz, Paul R.

Data processing: database and file management or data structures

Database design

Data structure types

707201, 707203, G06F 1730

Patent

active

059567139

ABSTRACT:
A method and apparatus for reducing the number of snapshots in use within a database is provided. A transaction that accesses one or more data items in a database is assigned to a snapshot of the database when the transaction completes execution. At that time, it is determined whether a first snapshot includes any transactions that updated the one or more data items. If the first snapshot includes any transactions that updated the one or more data items, then the transaction is assigned to a different snapshot that includes the first snapshot. If the first snapshot does not include any transactions that updated the one or more data items, then the transaction is assigned to the first snapshot. This technique allows multiple transactions to the same snapshot, consequently reducing the actual number of snapshots of the database.

REFERENCES:
patent: 5280612 (1994-01-01), Lorie et al.
patent: 5317731 (1994-05-01), Dias et al.
patent: 5440735 (1995-08-01), Goldring

Affiliated with

Also associated with

Rating

Techniques for reducing the number of snapshots of a database does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Techniques for reducing the number of snapshots of a database, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Techniques for reducing the number of snapshots of a database will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-91727