Method for controlling query and update processing in a database

Details Method for controlling query and update processing in a database Method for controlling query and update processing in a database

1985-03-06

1987-03-03

Zache, Raulfe B.

Boots, shoes, and leggings

G06F 1540

Patent

active

046480366

ABSTRACT:
A method of performing update transactions in a database system to perserve consistent logical data states at all times. Each changeable data entry in the database is associated with an individual code field. When no update transaction is in progress, every code field is set to a first value. An update transaction is begun by changing a system state parameter from a NON-UPDATE to an UPDATE state. During the UPDATE state, the code fields of data entries to be added are marked with a second value and then inserted into the database. Code fields of entries to be deleted are marked with a third value. When this is complete, the system state parameter is set to a POST-UPDATE state. All code fields are then returned to the first value at which time the system is returned to the NON-UPDATE state. During the UPDATE state, all queries are given access to entries with first and third code field value. Conversely during the POST-UPDATE state, queries are allowed access only to entries with first and second code field values.

REFERENCES:
patent: 4506326 (1985-03-01), Shaw et al.
IEEE--1979--"Locking Policies: Safety and Freedom from Deadlock"--pp. 286-297--Yannakakis-Papadimitriou-Kung.
IEEE--1981--"Transaction Monitoring in Encompass [TM]: Reliable Distribute Transaction Processing"--pp. 155-165--Borr.
IEEE--1983--"A Case for Non-Two Phase Locking Protocols that Ensure Atomicity"--pp. 535-538.

Affiliated with

Also associated with

Rating

Method for controlling query and update processing in 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 Method for controlling query and update processing in a database, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method for controlling query and update processing in a database will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-1021009