This Article 
 Bibliographic References 
 Add to: 
A Queueing Network Model for a Distributed Database Testbed System
July 1988 (vol. 14 no. 7)
pp. 908-921

A queuing network model for analyzing the performance of a distributed database testbed system with a transaction workload is developed. The model includes the effects of the concurrency control protocol (two-phase locking with distributed deadlock detection), the transaction recovery protocol (write-ahead logging of before-images), and the commit protocol (centralized two-phase commit) used in the testbed system. The queuing model differs from previous analytical models in three major aspects. First, it is a model for a distributed transaction processing system. Second, it is more general and integrated than previous analytical models. Finally, it reflects a functioning distributed database testbed system and is validated against performance measurements.

[1] G. Almes and E. Lazowska, "The behavior of Ethernet-like computer communication network," inProc. 7th Symp. Operating System Principles, 1979.
[2] R. Agrawal, M. J. Carey, and M. Livny, "Models for studying concurrency control performance: Alternatives and implications,"ACM SIGMOD Int. Conf. Management of Data, 1985, pp. 108-121.
[3] R. Agrawal and D. J. DeWitt, "Integrated concurrency control and recovery mechanisms: Design and performance evaluation,"ACM Trans. Database Syst., vol. 10, pp. 529-564, Dec. 1985.
[4] F. Baskett, K. M. Chandy, R. R. Muntz, and F. G. Palacios, "Open, closed, and mixed networks of queues with different classes of customers,"J. ACM, vol. 22, no. 2, pp. 248-260, 1975.
[5] P.A. Bernstein and N. Goodman, "A Sophisticate's Introduction to Distributed Database Concurrency Control,"Proc. Eighth Very Large Database Conf., Morgan Kaufmann, Palo Alto, Calif., 1982, pp. 62-76.
[6] M. Carey and M. Stonebraker, "The performance of concurrency control algorithms for database management systems," inProc. VLDB, 1984, pp. 107-118.
[7] S. Ceri and G. Pelagatti,Distributed Databases: Principles and Systems, McGraw-Hill, New York, 1984.
[8] K. M. Chandy and C. H. Sauer, "Computational methods for product form queueing networks,"Commun. ACM, vol. 23, pp. 573-583, 1980.
[9] K. M. Chandy, J. Misra, and L. M. Haas, "Distributed deadlock detection,"ACM Trans. Comput. Syst., vol. 1, no. 2, pp. 144-156, May 1983.
[10] A. Chesnais, E. Gelenbe, and I. Mitrani, "On the modeling of parallel access to shared data,"Commum. ACM, vol. 26, no. 3., pp. 196-202, Mar. 1983.
[11] D. W. Cornell, D. M. Dias, and P. S. Yu, "On multisystem coupling through function request shipping,"IEEE Trans. Software Eng., vol. SE-12, no. 10, pp. 1006-1017, Oct. 1986.
[12] P. Franaszek and J. T. Robinson, "Limitations on concurrency in transaction processing,"ACM Trans. Database Systems, vol. 10, Mar. 1985.
[13] B. I. Galler, "Concurrency control performance issues," Ph.D. thesis, Comput. Sci. Dept., Univ. Toronto, Sept. 1982.
[14] H. Garcia-Molina, "Performance of update algorithms for replicated data in a distributed database," Ph. D. dissertation, Computer Science Dept., Stanford Univ., June 1979.
[15] J. Gray, "Notes on database operation systems," inOperating Systems: An Advanced Course(Lecture Notes in Computer Science, vol. 60) Berlin: Springer-Verlag, 1978.
[16] J. N. Gray, P. Homan, R. Obermack, and H. Korth, "A straw man analysis of probability of waiting and deadlock," IBM Res. Rep. RJ 3066, 1981.
[17] K. B. Irani and H. L. Lin, "Queueing network models for concurrent transaction processing in a database system," inProc. ACM-SIGMOD Int. Conf. Management of Data, Boston, MA, Jan. 1979, pp. 134-142.
[18] P. A. Jacobson and E. D. Lazowska, "A reduction technique for evaluating queueing networks with serialization delays," inProc. Performance '83, 1983, pp. 45-59
[19] B. P. Jenq, "Performance measurement, modelling, and evaluation of integrated concurrency control and recovery algorithms in distributed database systems," Ph.D. dissertation, Dep. Elect. Comput. Eng., Univ. Massachusetts, Amherst, Feb. 1986.
[20] L. Kleinrock,Queueing Systems--Volume I. New York: Wiley, 1975.
[21] W. H. Kohler and B. P. Jenq, "Performance evaluation of integrated concurrency control and recovery algorithms using a distributed transaction processing testbed," inProc. Sixth Int. Conf. Distributed Computing Systems, Cambridge, MA, May 1986, pp. 130-139.
[22] W. H. Kohler and B. P. Jenq, "CARAT: A testbed for the performance evaluation of distributed database systems," inProc. 1986 Fall Joint Computer Conf., Nov. 1986, to be published.
[23] N. P. Kronenberg, H. M. Levy, and W. D. Strecker, "VAXcluster: A closely-coupled distributed system,"ACM Trans. Comput. Syst., vol. 4., no. 2, pp. 130-146, May 1986.
[24] H. T. Kung and J. T. Robinson, "On optimistic methods for concurrency control,"ACM Trans. Database Syst., vol. 6, pp. 213-226, June 1981.
[25] D. Menasce and T. Nakanishi, "Optimistic versus pessimistic concurrency control mechanisms in database management systems,"Inform. Syst., vol. 7, no. 1, 1982.
[26] T. Nakanishi and D. Menasce, "Performance evaluation of a two-phase commit based protocol for DDBs,"ACM Principles of Data-base Syst., Mar. 1982.
[27] D. Potier and P. Leblanc, "Analysis of locking policies in database management systems,"Commun. ACM, vol. 23, no. 10, pp. 584- 593, Oct. 1980.
[28] D. Ries, "Effects of locking granularity in a database management system,"ACM Trans. Database Syst., Sept. 1977.
[29] D. Ries, "The effects of concurrency on the performance of a distributed data management system," inProc. 4th Berkeley Workshop Distributed Data Management and Computer Networks, 1979.
[30] D. R. Ries and M. R. Stonebraker, "Locking granularity revisited,"ACM Trans. Database Syst., June 1979.
[31] M. Stonebrakeret al., "Performance analysis of distributed data base systems," inProc. Third Symp. Reliability in Distributed Software and Database Systems, Oct. 1983, pp. 135-138.
[32] Y.C. Tay, N. Goodman, and R. Suri, "Locking performance in centralized databases,"ACM Trans. Database Syst., vol. 10, no. 4, pp. 415-462, Dec. 1985.
[33] A. Thomasian, "An iterative solution to the queueing network model of a DBMS with dynamic locking," inProc. 13th Computer Measurement Group Conf., Dec. 1982, pp. 252-261.
[34] A. Thomasian, "Performance evaluation of centralized databases with static locking,"IEEE Trans. Software Eng., vol. SE-11, no. 4, Apr. 1985.
[35] S. B. Yao, "Approximating block accesses in database organizations,"Commun. ACM, vol. 20, pp. 260-261, Apr. 1977.
[36] P. S. Yu, D. M. Dias, J. T. Robinson, B. R. Iyer, and D. Cornell, "Modeling of centralized concurrency control in multi-system environment,"Perform. Eval. Rev., (Proc. 1985 ACM SIGMETRICS), vol. 13, no. 2, pp. 183-191.

Index Terms:
queueing network model; distributed database testbed system; transaction workload; concurrency control protocol; two-phase locking; distributed deadlock detection; transaction recovery protocol; write-ahead logging; commit protocol; centralized two-phase commit; distributed databases; program testing; protocols; queueing theory; system recovery
B.-C. Jenq, W.H. Kohler, D. Towsley, "A Queueing Network Model for a Distributed Database Testbed System," IEEE Transactions on Software Engineering, vol. 14, no. 7, pp. 908-921, July 1988, doi:10.1109/32.42734
Usage of this product signifies your acceptance of the Terms of Use.