On the Analytical Modeling of Database Concurrency Control

Journal of the ACM (JACM)

Volumn 40, Issue 4, 1993, Pages 831-872

  Yu, Philip S ^a   Dias, Daniel M ^a   Lavenberg, Stephen S ^a  

^a IBM T J WATSON RESEARCH CENTER   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

COMPUTER SYSTEM RECOVERY; CONTROL THEORY; DATA HANDLING; DATA STRUCTURES; ITERATIVE METHODS; MATHEMATICAL MODELS; OPTIMIZATION; PERFORMANCE; SYSTEMS ANALYSIS;

CONCURRENCY CONTROL; DATA CONTENTION; RESOURCE CONTENTION;

DISTRIBUTED DATABASE SYSTEMS;

EID: 0027668408     PISSN: 00045411     EISSN: 1557735X     Source Type: Journal    
DOI: 10.1145/153724.153733     Document Type: Article

References (47)

1. BARBARA, D., AND GARCIA-MOLINA, H., HOW expensive is data replication? An example. In Proceedings of the 2nd International Conference on Distributed Computing Systems (Feb.) IEEE Computer Society Press, Los Alamitos, Calif., 1982, pp. 263-268
2. BERNSTEIN, P. A., HADZILACOS, V., AND GOODMAN, N. Concurrency Control and Recovery in Database Systems. Addison-Wesley, Reading, Mass., 1987
3. BOKSENBAUM, C., CART. M., FERRIE, J., AND PONS, J.-F. Concurrent certifications by intervals of timestamps in distributed database systems. IEEE Trans. Softw. Eng. SE-13, 4 (Apr. 1987), 409-419.
4. CAREY, M. J. AND LIVNY, M. Distributed concurrency control performance: A study of algorithms, distribution, and replication. In Proceedings of the 14th Annual Conference on Very Large Data Bases. Morgan Kaufmann, San Mateo, Calif., 1988. pp 13-25.
5. CELLARY, W., GELENBE, E., AND TADEUSZ, M. Concurrency Control in Distributed Database Systems. North-Holland, Amsterdam, The Netherlands, 1988.
6. CHESNAIS, A., GELENBE, E., AND MITRANI, I. On the modeling of parallel access to shared data. Commun. ACM 26, 3 (Mar. 1983), 196-202.
7. CICIANI, B., DIAS, D. M., IYER, B. R., AND YU, P. S. A hybrid distributed centralized system structure for transaction processing. IEEE Trans. Softw. Eng. SE-16, 8 (1990), 791-806.
8. CICIANI, B., DIAS, D. M., AND YU, P. S. Analysis of concurrency-coherency control protocols for distributed transaction processing systems with regional locality. IEEE Trans. Softw. Eng. SE-18, 10 (Oct. 1992), 889-914.
9. CICIANI, B., DIAS, D. M., AND YU, P. S. Analysis of replication in distributed database systems. IEEE Trans. Knowledge Data Eng. 2, 2 (June 1990), 247-261.
10. CORNELL, D. W., DIAS, D. M., AND YU, P. S. On multisystem coupling through function request shipping. IEEE Trans. Softw. Eng. SE-12, 10 (Oct. 1986), 1006-1017.
11. DAN, A., DIAS, D. M., AND YU, P. S. The effect of skewed data access on buffer hits and data contention in a data sharing environment. In Proceedings of the 16th International Conference on Very Large Databases (Brisbane, Australia, Aug.). Morgan Kaufmann, San Mateo, Calif, 1990, pp. 419-431.
12. DAN, A., TOWSLEY, D. F., AND KOHLER, W. H. Modeling the effects of data and resource contention on the performance of optimistic concurrency control protocols. In Proceedings of the 4th International Conference on Data Engineering (Los Angeles. Calif., Feb.). IEEE Computer Society Press, Los Alamitos, Calif., 1988, pp. 418-425.
13. DATE, C. J. An Introduction to Database Systems. Vol. 2. Addison-Wesley, Reading, Mass 1983.
14. DIAS, D. M., IYER, B. R., AND YU, P. S. Trade-offs between coupling small and large processors for transaction processing. IEEE Trans. Comput. 37. 3 (Mar. 1988), 310-320.
15. DIAS, D. M., YU, P. S. AND BENNETT, B. T. On centralized versus geographically distributed database systems. In Proceedings of the 7th International Conference on Distributed Computing Systems (Berlin, West Germany, Sept.). IEEE Computer Society Press, Los Alamitos Calif 1987, pp. 64-71.
16. FRANASZEK. P. A., AND ROBINSON, J. T Limitations of concurrency in transactions processing. ACM Trans. Datab. Syst. 10, 1 (Mar. 1985), 1-28.
17. FRANASZEK, P. A., ROBINSON, J. T., AND THOMASIAN, A. Access invariance and its use in high contention environments. In Proceedings of the 6th International Conference on Data Engineering (Los Angeles, Calif.). IEEE Computer Society Press, Los Alamitos, Calif., 1990, pp. 47-55.
18. FRANASZEK, P. A., ROBINSON, J. T., AND THOMASIAN, A. Wait depth limited concurrency control. In Proceedings of the 7th International Conference on Data Engineering (Kobe, Japan). IEEE Computer Society Press, Los Alamitos, Calif., 1991, pp. 92-101.
19. GARCIA-MOUNA, H. Performance of update algorithms for replicated data in a distributed database. Ph.D. dissertation. Computer Science Dept., Stanford Univ., Stanford, Calif., June 1979.
20. GRAY, J. N. An approach to decentralized computer systems. IEEE Trans. Softw. Eng. SE-12, 6 (June 1986), 684-692.
21. GRAY, J., HOMAN, P., OBERMARCK, R., AND KORTH, H. A straw man analysis of probability of waiting and deadlock. IBM Res. Rep. RJ 3066. IBM, Yorktown Heights, N.Y., 1981.
22. HARTZMAN, C. S. The delay due to dynamic two-phase locking. IEEE Trans. Soft. Eng. 15, 1 (Jan. 1989), 72-82.
23. Hsu, M., AND SHANG, B. Modeling performance impact of hotspots. Tech. Rep. TR-08-88. Aiken Computation Laboratory, Harvard University, Cambridge, Mass., Apr. 1988.
24. IYER, B. R. Limits in transaction throughput-Why big is better. IBM Res. Rep. RJ 6584. IBM, Yorktown Heights, N.Y., Nov. 1988.
25. KUNG, S. T., AND ROBINSON, J. T. On optimistic methods for concurrency control. ACM Trans. Datab. Syst. 6, 2 (June 1981), 213-226.
26. LAVENBERG, S. S. (ED.) Computer Performance Modeling Handbook. Academic Press, Orlando, Fla., 1983.
27. MENASCE, D. A., AND NAKANISHI, T. Performance evaluation of a two-phase commit based protocol for DDBs. In Proceedings of the ACM Symposium on Principles of Database Systems (Los Angeles, Calif., Mar. 29-31). ACM, New York, 1982, pp. 247-255.
28. MORRIS, R. J. T., AND WONG, W. S. Performance analysis of locking and optimistic concurrency control algorithms. Perf. Eval. 5 (1985), 105-118.
29. ROSENKRANTZ, D. J., STEARNS, R. E., AND LEWIS. P. S., II System level concurrency control for distributed database systems. ACM Trans. Datab. Syst. 3, 2 (June 1978), 178-198.
30. RYU, I. K., AND THOMASIAN, A. Performance analysis of centralized databases with optimistic concurrency control. Perf. Eval. 7 (1987), 195-211.
31. SEVCIK, K. C. Comparison of concurrency control methods using analytic models. In Information Processing 83, R. E. A. Mason, ed. North-Holland, Amsterdam, The Netherlands, 1983, pp. 847-858.
32. SINGHAL, M., AND YESHA, Y. A polynomial algorithm for computation of the probability of conflicts in a database under arbitrary data access distribution. Inf. Proc. Lett. 27, 2 (Feb. 1988), 69-74.
33. TAY, Y. C. A mean value performance model for locking in databases. Ph.D. dissertation. Harvard University, Cambridge, Mass., Feb. 1984.
34. TAY, Y. C. Issues in modelling locking performance. In Stochastic Analysis of Computer and Communication Systems, H. Takagi, ed. North-Holland, Amsterdam, The Netherlands, 1990, pp. 631-655.
35. TAY, Y. C., GOODMAN, N., AND SURI, R. Locking performance in centralized databases. ACM Trans. Datab. Syst. 10, 4 (Dec. 1985), 415-462.
36. TAY, Y. C., SURI, R., AND GOODMAN, N. A mean value performance model for locking in databases: The no-waiting case. J. ACM 32, 3 (July 1985), 618-651.
37. THANOS, C., BERTINO, C., AND CARLESI, C. The effects of two-phase locking on the performance of a distributed database management system. Perf. Eval. 8 (1988), 129-157.
38. THOMASIAN, A. An iterative solution to the queueing network model of a DBMS with dynamic locking. In Proceedings of the 13th CMG Conference. Computer Measurement Group, Alexandria, Va., 1982, pp. 252-261.
39. THOMASIAN, A., AND RYU, I. K. Analysis of some optimistic concurrency control schemes based on certification. Perf. Eval. Rev. 13, 2 (Proceedings of 1985 ACM SIGMETRICS), pp. 192-203.
40. THOMASIAN, A., AND RYU, I. K. Performance analysis of two-phase locking. IEEE Trans. Softw. Eng. 17, 5 (May 1991), 386-401.
41. YU, P. S., AND DIAS, D. M. Performance analysis of optimistic concurrency control schemes for systems with large memory. IBM Res. Rep. RC 13976. IBM, Yorktown Heights, N.Y., Mar. 1988.
42. Yu, P. S., AND DIAS, D. M. Concurrency control using locking with deferred blocking. In Proceedings of the 6th International Conference on Data Engineering (Los Angeles, Calif.). IEEE Computer Society Press, Los Alamitos, Calif. 1990, pp. 30-36.
43. Yu, P. S., AND DIAS, D. M. Analysis of hybrid concurrency control schemes for a high data contention environment. IEEE Trans. Softw. Eng. 18, 2 (Feb. 1992), 118-129.
44. Yu, P. S., DIAS, D. M., CORNELL, D. W., AND IYER, B. R. Analysis of affinity based routing in multi-system data sharing. Perf. Eval. 7, 2 (June 1987), 87-109.
45. Yu, P. S., DIAS, D. M., ROBINSON, J. T., IYER, B. R., AND CORNELL, D. W. Modelling of centralized concurrency control in a multi-system environment. Perf. Eval. Rev. 13, 2 (Proceedings of 1985 ACM SIGMETRICS). 183-191.
46. Yu, P. S., DIAS, D. M., ROBINSON, J. T., IYER, B. R., AND CORNELL, D. W. On coupling multi-systems through data sharing. Proc. IEEE 75, 5 (May 1987), 573-587
47. Yu, P. S. HEISS, H., AND DIAS, D. M. Modelling and analysis of a time-stamp history based certification protocol for concurrency control. IEEE Trans. Knowl. Data Eng. 3, 4 (Dec. 1991), 525-537.