Data processing: database and file management or data structures – Database design – Data structure types
Patent
1997-04-23
1999-09-21
Kulik, Paul V.
Data processing: database and file management or data structures
Database design
Data structure types
707200, 707202, 707 1, 707 8, 39518213, 3952006, G06F 1730
Patent
active
059567317
ABSTRACT:
A method and apparatus for supplying data from a database to a group of transactions is provided. A value is maintained for the group of transactions. The value indicates a target snapshot of the database. When a transaction within the group of transactions accesses a data item, it is determined whether the transaction can use the target snapshot. If the transaction can use the target snapshot, then the transaction is supplied a version of the data item that belongs to the target snapshot. If the transaction cannot use the target snapshot, then the transaction is supplied a version of the data item other than the version of the data item that belongs to the target snapshot. Trying to supply data from the same snapshot to all of the transactions in the group increases the likelihood that the transactions will be able to use the same version of any given data item. Consequently, fewer reconstruction operations will have to be performed, and dynamic memory is less likely to become filled with different versions of the same data items.
REFERENCES:
patent: 5280612 (1994-01-01), Lorie et al.
patent: 5317731 (1994-05-01), Dias et al.
patent: 5452445 (1995-09-01), Hallmark et al.
patent: 5553279 (1996-09-01), Goldring
patent: 5613113 (1997-03-01), Goldring
patent: 5758149 (1998-05-01), Bierma et al.
patent: 5870758 (1999-02-01), Bamford et al.
patent: 5873098 (1999-02-01), Bamford et al.
Paul Ammann et al., "A Two Snapshot Algorithm for Concurrency Control In Multi-Level Secure Databases", IEEE online, pp. 204-215, Jan. 1992.
Bamford Roger
Klots Boris
Swart Garret
Kulik Paul V.
Oracle Corporation
Robinson Greta L.
LandOfFree
Sharing snapshots for consistent reads does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Sharing snapshots for consistent reads, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Sharing snapshots for consistent reads will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-91949