Issue No. 12 - December (1987 vol. 13)
K.H. Pun , Centre of Computer Studies, University of Hong Kong
Many database systems guarantee the consistency of the database for concurrent transaction processing by a standard locking protocol called two phase locking. The performance of such systems is dependent on various factors, among which are the choices of locking granularity (the amount of data controlled by a single lock) and degree of multiprogramming (the maximum number of transactions allowed to run concurrently in the system). Previous simulation and experimental studies on such systems suggest that the choices are dependent on the properties of the application.
two-phase locking, Degree of multiprogramming, granularity, performance mance study, queueing networks, simulation, single-site database systems
K. Pun and G. Belford, "Perfornance Study of Two Phase Locking in Single-Site Database Systems," in IEEE Transactions on Software Engineering, vol. 13, no. , pp. 1311-1328, 1987.