Boots – shoes – and leggings
Patent
1982-06-30
1985-02-05
Springborn, Harvey E.
Boots, shoes, and leggings
G06F 700, G06F 1100
Patent
active
044981457
ABSTRACT:
A method for assuring atomicity of user requested multi-row update operations to tables such as in a relational database, guarantees that for any update operation that succeeds all stated effects will have occurred and that for any update operation that fails the system state as perceived by the user remains unchanged. This is accomplished by establishing, in response to a multi-row update operation request, an execution module of a program containing sets of machine language code instructions implementing the update operation request with a savepoint request at the beginning of the execution module of the program. For each set of machine language code instructions in or called by the execution module which modified the user perceived system state, information is logged to a soft log. Upon completing the execution module of the program, the savepoint is dropped, causing all soft log information recorded since the savepoint to be deleted and releasing all resources held to guarantee restoration of the user perceived system state at the time of the savepoint request. Responsive to the detection of an error during execution of the execution module of the program, the soft logged information is used to restore the user perceived state to that existing at the time of the savepoint request.
REFERENCES:
patent: 4042912 (1977-08-01), Bachman et al.
patent: 4130867 (1978-12-01), Bachman et al.
patent: 4159517 (1979-06-01), Paradine et al.
Blasgen, et al., "System R: An Architectural Overview", IBM Systems Journal, vol. 20, No. 1, 1981, pp. 41-62.
Astrahan, et al., "System R: A Relational Approach to Data Base Management", IBM Research Publication, Computer Science, RJ 1738, (#25356), Feb. 27, 1976.
Grey, et al., "The Recovery Manager of a Data Management System", IBM Research Publication, Computer Science, RJ 2623, (#33801), Aug. 15, 1979, (See, also, ACM Computing Surveys, vol. 13, No. 2, Jun. 1981, pp. 223-242.).
Chamberlin, et al., "Sequel 2: A Unified Approach to Data Definition, Manipulation, and Control", IBM Journal Research Development, Nov. 1976, pp. 560-575.
IBM, "SQL/Data System Planning and Administration", IBM Publication SH24-5014-0, Program No. 5748-XXJ, First Edition, Aug. 1981, pp. 9-1 to 9-19, Recovery Considerations.
Baker Jerry W.
Crus Richard A.
Haderle Donald J.
Beckstrand Shelley M.
Brodie R. Bruce
International Business Machines - Corporation
Springborn Harvey E.
LandOfFree
Method for assuring atomicity of multi-row update operations in 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 assuring atomicity of multi-row update operations in , we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method for assuring atomicity of multi-row update operations in will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2085344