Method for assuring atomicity of multi-row update operations in a database system

作者: Richard A. Crus , Donald J. Haderle , Jerry W. Baker

DOI:

关键词:

摘要: A method for assuring atomicity of user requested multi-row update operations to tables such as in a relational database, guarantees that any operation succeeds all stated effects will have occurred and fails the system state perceived by remains unchanged. This is accomplished establishing, response request, an execution module program containing sets machine language code instructions implementing request with savepoint at beginning program. For each set or called which modified state, information logged soft log. Upon completing program, dropped, causing log recorded since be deleted releasing resources held guarantee restoration time request. Responsive detection error during used restore existing

参考文章(6)
Benjamin S. Franklin, Charles W. Bachman, Database set condition test instruction ,(1975)
Christopher Paradine, Geoffrey W. Robinson, Journal back-up storage control for a data processing system ,(1977)
Benjamin S. Franklin, Charles W. Bachman, Database instruction apparatus for determining a database record type ,(1975)
P. R. McJones, I. L. Traiger, P. P. Griffiths, K. P. Eswaran, G. R. Putzolu, D. D. Chamberlin, B. W. Wade, J. N. Gray, J. W. Mehl, R. A. Lorie, M. M. Astrahan, V. Watson, W. F. King, M. W. Blasgen, System R: a relational approach to database management berkeley workshop. pp. 16- 36 ,(1988)
D. D. Chamberlin, M. M. Astrahan, K. P. Eswaran, P. P. Griffiths, R. A. Lorie, J. W. Mehl, P. Reisner, B. W. Wade, SEQUEL 2: a unified approach to data definition, manipulation, and control Ibm Journal of Research and Development. ,vol. 20, pp. 560- 575 ,(1976) , 10.1147/RD.206.0560
M. W. Blasgen, M. M. Astrahan, D. D. Chamberlin, J. N. Gray, W. F. King, B. G. Lindsay, R. A. Lorie, J. W. Mehl, T. G. Price, G. R. Putzolu, M. Schkolnick, P. G. Selinger, D. R. Slutz, H. R. Strong, I. L. Traiger, B. W. Wade, R. A. Yost, System R: an architectural overview Ibm Systems Journal. ,vol. 38, pp. 375- 396 ,(1999) , 10.1147/SJ.382.0375