Update constraints in transactions which may abort

Details Update constraints in transactions which may abort Update constraints in transactions which may abort

1994-05-27

1996-04-30

Black, Thomas G.

Boots, shoes, and leggings

39518901, 395650, 395700, 39518213, 364DIG1, 364DIG2, 36422282, 3649621, G06F 1540, G06F 700

Patent

active

055133509

ABSTRACT:
A technique which may be used in a transaction which updates a data set when the data set is subject to constraints and includes operations which may abort. The technique produces an update constraint which may be tested before the data set is altered to determine whether the constraints will be satisfied if the data set is altered. The update constraint of the technique indicates whether the constraints would be satisfied if the transaction could not abort. The update constraint is checked at the application level, while the constraints which cause an operation to abort are checked at the system level. An application of the update constraint to a relational data base embedded in a telephone switch is disclosed.

REFERENCES:
patent: 4933848 (1990-06-01), Haderle et al.
patent: 4947320 (1990-08-01), Crus et al.
patent: 5133068 (1992-07-01), Crus et al.
patent: 5267346 (1993-11-01), Maruyama et al.
patent: 5355474 (1994-10-01), Thuraisngham et al.
patent: 5386557 (1995-01-01), Boykin et al.
patent: 5408657 (1995-04-01), Bigelow et al.
Marie Collins et al, "Security Constraint processing during the update operation in multijewel secure databare management system", IEEE, 1991, pp. 23-32.
Sang Ho Lee et al, "Enforcement of integrity comstraints against transactions with transaction Axions," IEEE, 1992, pp. 162-167.
Stephen Clarke et al, "Software fault trees and weakest preconditions: a comparasion and analysis", IEEE, 1993, pp. 225-236.
M. Samg Gamal-Eldino et al; "Local and Global Constraints in Database Entegration" IEEE, 1989, pp. 604-611.
Xiao Quan, "An Effective Method for Integrity Constraint Simplification" IEEE, 1988, pp. 338-345.
P. W. P. J. Grefen, "Combining Theory and Practice in Integrity Control: A Declarative Approach to the Specification of a Transaction Modification Subsystem", Proceedings of the 19th VLDB Conference, Dublin, Ireland, 1993, pp. 581-589.
M. Lawley, R. Topor, M. Wallace, "Using Weakest Preconditions to Simplify Integrity Constraint Checking", Proceedings of the 4th Australian Database Conference, Brisbane, Feb. 1-2, 1993, pp. 161-170.
P. W. P. J. Grefen, Integrity Control in Relational Database Systems-An Overview-, Nov. 1991, Chapters 1, 2 and 3.
X. Qian, et al., "Integrity Constraint Reformulation for Efficient Validation", Proceedings of the 13th VLDB Conf., Brighton 1987, pp. 417-425.
Anonymous, "Distributed Optimistic Concurrency control Based on Time-Stamp History Certification", IBM Technical Bulletin, Apr. 1991, vol. 33, No. 11, pp. 178-181.

Affiliated with

Also associated with

Rating

Update constraints in transactions which may abort does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Update constraints in transactions which may abort, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Update constraints in transactions which may abort will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-636925