
This Article  
 
Share  
Bibliographic References  
Add to:  
Digg Furl Spurl Blink Simpy Del.icio.us Y!MyWeb  
Search  
 
ASCII Text  x  
M. Singhal, "Analysis of the Probability of Transaction Abort and Throughput of Two Timestamp Ordering Algorithms for Database Systems," IEEE Transactions on Knowledge and Data Engineering, vol. 3, no. 2, pp. 261266, June, 1991.  
BibTex  x  
@article{ 10.1109/69.88007, author = {M. Singhal}, title = {Analysis of the Probability of Transaction Abort and Throughput of Two Timestamp Ordering Algorithms for Database Systems}, journal ={IEEE Transactions on Knowledge and Data Engineering}, volume = {3}, number = {2}, issn = {10414347}, year = {1991}, pages = {261266}, doi = {http://doi.ieeecomputersociety.org/10.1109/69.88007}, publisher = {IEEE Computer Society}, address = {Los Alamitos, CA, USA}, }  
RefWorks Procite/RefMan/Endnote  x  
TY  JOUR JO  IEEE Transactions on Knowledge and Data Engineering TI  Analysis of the Probability of Transaction Abort and Throughput of Two Timestamp Ordering Algorithms for Database Systems IS  2 SN  10414347 SP261 EP266 EPD  261266 A1  M. Singhal, PY  1991 KW  transaction abort; timestamp ordering algorithms; database systems; timestamp ordering concurrency control algorithms; multiversion algorithm; basic timestamp ordering algorithm; performance enhancement; storage overhead; multiversion algorithm; exact performance model; closedform solution; conflict/abort; concurrency control; distributed databases; transaction processing VL  3 JA  IEEE Transactions on Knowledge and Data Engineering ER   
The author analyzes and compares the performance of two timestamp ordering concurrency control algorithms, namely, the basic and multiversion, for database systems. The multiversion algorithm improves the performance of the basic timestamp ordering algorithm by keeping multiple versions of data objects. The author discusses the performance enhancement in the multiversion algorithm over the basic algorithm. The author also discusses the storage overhead due to multiple versions of data objects in the multiversion algorithm. The exact performance model of these algorithms is so complex that it is impossible to find a closedform solution. The author reduces the complexity of the analysis by analyzing a single transaction in isolation and reflects the presence of other transactions on the isolated transaction by the probability of conflict/abort. The analysis provides useful insight into the performance of these algorithms.
[1] P. Bernstein and N. Goodman, "Timestamp based algorithms for concurrency control in distributed database systems," inProc. 6th Int. Conf. Very Large Database, Oct. 1980, pp. 285300.
[2] P. Bernstein and N. Goodman, "Concurrency Control in Distributed Database Systems,"ACM Computing Surveys, Vol. 13, No. 2, June 1981, pp. 185221.
[3] K. M. Chandy, U. Herzog, and L. Wu, "Parametric analysis of queueing networks,"IBM J. Res. Develop., pp. 3642, Jan. 1975.
[4] A. Chesnais, E. Gelenbe, and I. Mitrani, "On the modeling of parallel access to shared data,"Commum. ACM, vol. 26, no. 3., pp. 196202, Mar. 1983.
[5] D. M. Dias, B. R. Iyer, J. T. Robinson, and P. S. Yu, "Design and analysis of integrated concurrencycoherency controls," inProc. 13th Int. Conf. Very Large Data Bases, Brighton, UK, Sept. 1987, pp. 463471.
[6] B. I. Galler, "Concurrency control performance issues," Ph.D. thesis, Comput. Sci. Dept., Univ. Toronto, Sept. 1982.
[7] H. GarciaMolina, "Performance of update algorithms for replicated data in a distributed database," Ph. D. dissertation, Computer Science Dept., Stanford Univ., June 1979.
[8] F. Kamoun, L. Kleinrock, and R. Muntz, "Queueing analysis of the ordering issues in a distributed database concurrency control mechanism," inProc. Second Int. Conf. Distributed Comput. Syst., 1981, pp. 1323.
[9] L. Kleinrock,Queueing Systems, Vol. 1: Theory. New York: Wiley 1975.
[10] S. Lavenberg, "A simple analysis of exclusive and shared lock contention in a database system,"Perform. Eval. Rev., (Proc. 1984 ACM SIGMETRICS Conf., vol. 12, no. 3, pp. 143148.
[11] V. O. K. Li, "Performance models of timestampordering concurrency control algorithms in distributed database,"IEEE Trans. Comput., pp. 10411051, Sept. 1987.
[12] D.A. Menasce and T. Nakanishi, "Optimistic versus pessimistic concurrency control mechanisms in database management systems,"Inform. Syst.vol. 7, no. 1, pp. 1327, 1982.
[13] K. H. Pun and G. G. Belford, "Performance study of twophase locking in singlesite database systems,"IEEE Trans. Software Eng., SE13, pp. 13111328, Dec. 1987.
[14] M. Singhal, and A. K. Agrawala, "Performance analysis of an algorithm for concurrency control in replicated database systems,"Perform. Eval. Rev., vol. 14, no. 1, May 1986.
[15] M. Singhal "Performace analysis of the basic timestamp ordering algorithm via Markov modeling," Ohio State Univ. Tech. Rep. CISRC 8/8TR28, Aug. 1988.
[16] M. Singhal, "Performance analysis of an optimistic concurrency algorithm in replicated database systems," inProc. 17th Int. Conf. Parallel Processing, Chicago, IL, Aug. 1988, pp. 186189.
[17] Y. C. Tay, "A mean value performance model for locking in databases," Ph.D. dissertation, Harvard Univ., Cambridge, MA, Feb. 1984.
[18] Y.C. Tay, N. Goodman, and R. Suri, "Locking performance in centralized databases,"ACM Trans. Database Syst., vol. 10, no. 4, pp. 415462, Dec. 1985.
[19] A. Thomasian and I. K. Ryu, "A decomposition solution of the queueing network model the centralized DBMS with static locking," inProc. 1983 ACM SIGMETRICS Conf. Computer Performance Modeling, Measurement and Evaluation, Minneapolis, MN, Aug. 1983, pp. 8292.
[20] A. Thomasian, "Performance evaluation of centralized databases with static locking,"IEEE Trans. Software Eng., vol. SE11, no. 4, Apr. 1985.
[21] A. Thomasian and I. K. Ryu, "Analysis of some optimistic concurrency control schemes based on certification,"Perform. Eval. Rev., vol. 13, no. 2, pp. 192203, 1985.
[22] R. J. T. Wong and W.S. Morris, "Performance analysis of locking and optimistic concurrency control algorithms,"Perform. Eval., 5, pp. 105118, NorthHolland, 1985.