This Article 
 Bibliographic References 
 Add to: 
Locking Performance in a Shared Nothing Parallel Database Machine
December 1989 (vol. 1 no. 4)
pp. 530-543

A quantitative performance study of two-phase locking in a parallel database machine using a simulation-based methodology is described. The DBSIM simulation methodology uses models at two levels: a Petri net model at the higher level and a queuing network model at the lower level. The Petri net model captures the characteristics of parallelism and synchronization at the workload level, while the queuing network model captures queuing aspects of the system at the physical resource level. Transactions in a workload are specified using a performance-oriented specification language based on the transaction component graph, a data flow graph with database operators. The transaction specifications are translated into Petri net representations to derive the simulation experiments. The workload is a transaction taken from an order-entry application. A shared-nothing parallel machine architecture is assumed. Results of analysis of a two-phase locking strategy with machine sizes ranging from 4 to 256 processors are presented.

[1] D. DeWittet al., "GAMMA: A high performance dataflow database machine," Univ. Wisconsin-Madison, Tech. Rep. 635, Mar. 1986.
[2] D. Hsiao,Advanced Database Machine Architecture. Englewood Cliffs, NJ: Prentice-Hall, 1983.
[3] Measurement Concepts Corp., "C3I teradata study," Rome Air Development Center, Rome, NY, Tech. Rep. RADC-TR-85-273, Mar. 1986.
[4] K. P. Eswaran, J. N. Gray, R. A. Lorie, and I. L. Traiger, "The notions of consistency and predicate locks in a database system,"Commun. ACM, vol. 19, no. 11, pp. 624-633, Nov. 1976.
[5] D.J. Rosenkrantz, R.E. Stearns, and P.M. Lewis, II, "System level concurrency control for distributed database systems,"ACM Trans. Database Syst., vol. 3, pp. 178-198, June 1978.
[6] 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.
[7] M. Stonebraker, "The case for shared nothing,"IEEE Database Eng., vol. 9, Mar. 1986.
[8] D. Ries, "Effects of locking granularity in a database management system,"ACM Trans. Database Syst., Sept. 1977.
[9] 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.
[10] P. Franaszek and J. T. Robinson, "Limitations on concurrency in transaction processing,"ACM Trans. Database Systems, vol. 10, Mar. 1985.
[11] R. Agrawal, M. J. Carey, and M. Linvy, "Concurrency control performance modelling: Alternatives and implications,"ACM Trans. Database Syst., vol. 12, pp. 609-654, Dec. 1987.
[12] 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.
[13] B. Jenq, W. Kohler, and D. Towsley, "A queueing network model for a distributed database testbed system,"IEEE Trans. Software Eng., vol. 14, July 1988.
[14] J. Grayet al., "A straw man analysis of probability of waiting and deadlock," IBM Res. RJ 3066, Feb. 1981.
[15] 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.
[16] D. Ries, "Effects of concurrency control on the performance of a distributed management system," inProc. 4th Berkeley Workshop Distributed Data Management Computer Networks, Aug. 1979.
[17] W. Kohler and B. Jenq, "Performance evaluation of integrated concurrency control and recovery algorithms using a distributed transaction processing testbed," inProc. 6th Int. Conf. Distributed Comput. Syst., June 1986.
[18] M. J. Carey and M. Livny, "Distributed concurrency control performance: A study of algorithms, distribution, and replication," inProc. 14th Int. Conf. Very Large Data Bases, 1988.
[19] J. L. Peterson,Petri Net Theory and the Modeling of Systems. Englewood Cliffs, NJ: Prentice-Hall, 1981.
[20] M. Ajmone Marsan, G. Balbo, and G. Conte, "A class of generalized stochastic Petri nets for the performance evaluation of multiprocessor systems,"ACM Trans. Comput. Syst., vol. 2, pp. 93-122, May 1984.
[21] M. Ajmone Marsan, G. Balbo, G. Chiola, and G. Conte, "Modeling the software architecture of a prototype parallel machine," inProc. 1987 SIGMETRICS Conf., Alberta, Canada, May 1987.
[22] M. A. Holliday and M. K. Vernon, "Exact performance estimates for muitiprocessor memory and bus interference,"IEEE Trans. Comput., vol. C-36, pp. 76-85, Jan. 1987.
[23] E. Lazowska, J. Zahorjan, and K. Sevick, "Computer system performance evaluation using queueing network models,"Ann. Rev. Comput. Sci., 1986.
[24] W. Alexander and G. Copeland, "Process and dataflow control in distributed data-intensive systems," inProc. ACM SIGMOD Conf., Chicago, IL, June 1988.
[25] H.D. Schwetman, "CSIM: A C-Based, Process-Oriented Simulation Language,"Proc. 1986 Winter Simulation Conf., American Statistical Assoc., Washington, DC, 1986.
[26] Anon,et al., "A measure of transaction processing power,"Datamation, vol. 31, no. 7, pp. 112-118, 1985.
[27] A. Cardenas, "Analysis and performance of inverted data-base structures,"Commun. ACM, vol. 18, no. 5, pp. 253-263, 1975.
[28] G. Copeland, W. Alexander, E. Boughter, and T. Keller, "Data placement in bubba," inProc. ACM SIGMOD, Chicago, IL, June 1-3, 1988, pp. 99-109.

Index Terms:
shared nothing parallel database machine; quantitative performance study; two-phase locking; simulation-based methodology; DBSIM simulation methodology; Petri net model; queuing network model; parallelism; synchronization; queuing network model; physical resource level; performance-oriented specification language; transaction component graph; data flow graph; database operators; order-entry application; distributed databases; parallel machines; performance evaluation; queueing theory; special purpose computers; transaction processing
B.-C. Jenq, B.C. Twichell, T.W. Keller, "Locking Performance in a Shared Nothing Parallel Database Machine," IEEE Transactions on Knowledge and Data Engineering, vol. 1, no. 4, pp. 530-543, Dec. 1989, doi:10.1109/69.43427
Usage of this product signifies your acceptance of the Terms of Use.