Abstract
In recent years, the demand for on-line transaction processing systems has grown rapidly with ever stringent performance requirements. In this paper, we examine several issues encountered in designing transaction processing systems and report some of the recent advancements in analytical performance modelling methodology on analyzing alternative design trade-offs. First of all, the Concurrency Control (CC) scheme employed can profoundly affect the performance of transaction processing systems. A general analytic modelling approach is presented that can be applied to analyze the various CC schemes under a unified framework, including locking, various optimistic schemes, and hybrid schemes. The analysis can capture the effect of skewed data access, different lock modes, variable length transactions and the buffer retention effect on rerun transactions. Next we consider the analysis of buffer hit probability. In a multi-node environment, whether in a cluster or client server environment, buffer coherency needs to be addressed. The cross invalidation phenomenon can have an adverse effect on the buffer hit probability. A general methodology to analyze various coherency control schemes is examined to predict the buffer hit probability. A hierarchical approach is used to decompose the modelling of transaction processing systems into three components: hardware resource, concurrency control and buffer models. The interaction among the components is then captured through a fixed point iteration.
Chapter PDF
Keywords
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.
References
Bernstein, P.A., Hadzilacos, V., and Goodman, N., “Concurrency Control and Recovery in Database Systems”, Addison Wesley, 1987.
Bayer, R., et al., “Dynamic Timestamp Allocation for Transactions in Database Systems”, In H.-J. Schneider, editor, Proc. of 2nd Intl. Symp. on Distributed Data Bases, pp. 9–21, North Holland, 1982.
Boksenbaum, C., et al., “Concurrent Certifications by Intervals of Timestamps in Distributed Database Systems”, IEEE Transactions on Software Engineering, Vol. SE-13, No. 4, April 1987, pp. 409–419.
Carey, M.J., et al., “Data Caching Tradeoffs in Client-Server DBMS Architectures”, ACM SIGMOD, Denver, CO, May 1991, pp. 357–366.
Cellary, W., Gelenbe, E., and Tadeusz, M., “Concurrency Control in Distributed Database Systems”, North-Holland, 1988.
Chesnais, A., Gelenbe, E., and Mitrani, I., “On the Modeling of Parallel Access to Shared Data”, Comm. ACM, Vol. 26, No. 3, Mar. 1983, pp. 196–202.
Ciciani, B., Dias, D.M., and Yu, P.S. “Analysis of Replication in Distributed Database Systems”, IEEE Transactions on Knowledge and Data Engineering, Vol. 2, No. 2, June 1990, pp. 247–261.
Ciciani, B., Dias, D.M., Iyer, B.R., and Yu, P.S., “A Hybrid Distributed Centralized System Structure for Transaction Processing”, IEEE Transactions on Software Engineering, Vol. 16, No. 8, Aug. 1990, pp. 791–806.
Ciciani, B., Dias, D.M., and Yu, P.S. ”Analysis of Concurrency-Coherency Control Protocols for Distributed Transaction Processing with Regional Locality”, IEEE Transactions on Software Engineering, Vol. 18, No. 10, Oct. 1992, pp. 899–914.
Cornell, D.W., Dias, D.M. and Yu, P.S., “On Multisystem Coupling Through Function Request Shipping”, IEEE Transactions on Software Engineering, Vol. SE-12, No.10, October 1986, pp. 1006–1017.
Date, C.J., “An Introduction to Database Systems”, Vol. 2, Addison Wesley, Reading, MA, 1983.
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”, Proc. 4th Intl. Conf. on Data Engineering, Los Angeles, CA, Feb. 1988, pp. 418–425.
Dan, A., and Towsley, D., “An Approximate Analysis of the LRU and FIFO Buffer Replacement Schemes”, ACM SIGMETRICS, Denver, CO, (Performance Evaluation Review, Vol. 18, No. 1), May 1990, pp. 143–152.
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”, Proc. 16th Intl. Conf. on Very Large Databases, Brisbane, Australia, Aug. 1990, pp. 419–431.
Dan, A., Dias, D.M., and Yu, P.S., “Analytic Modelling of a Hierarchical Buffer for a Data Sharing Environment”, Proc. 1991 ACM SIGMETRICS Conference, San Diego, CA, May 1991, pp. 156–167.
Dan, A., and Yu, P.S., “Performance analysis of coherency control policies through lock retention”, Proc. of the ACM SIGMOD Intl. Conf. on Management of Data, San Diego, CA, June 1992, pp. 114–123.
Dan, A., Yu, P.S. and Jhingran, A. “Recovery Analysis of Data Sharing Systems under Deferred Dirty Page Propagation Policies”, IBM research Report RC 18553, Yorktown Heights, 1992.
Dan, A. and Yu, P.S., “Analytic Modeling and Comparison of Buffer Coherency Policies based on Lock Retention”, IBM research Report RC 18664, Yorktown Heights, 1993.
Dan, A., and Yu, P.S., “Performance Analysis of Buffer Coherency Policies in a Multi-System Data Sharing Environment,” IEEE Transactions on Parallel and Distributed Systems, Vol. 4, No. 3, March 1993.
Dan, A., Yu, P.S., and Chung, J-Y., “Database Access Characterization for Buffer Hit Prediction”, Proc. 9th Intl. Conf. on Data Engineering, Vienna, Austria, April 1993.
Dias, D. M., Iyer, B. R. and Yu, P. S., “Trade-offs Between Coupling Small and Large Processors for Transaction Processing”, IEEE Transactions on Computers, Vol. 37, No. 3, March 1988, pp. 310–320.
Deux, O., et al., “The Story of O 2”, IEEE Transactions on Knowledge and Data Engineering, Vol. 2, No. 1, March, 1990, pp. 91–108.
Franaszek, P.A. and Robinson, J.T., “Limitations of Concurrency in Transaction Processing”, ACM Transactions on Database Systems, Vol. 10, No. 1, March 1985, pp. 1–28.
Franaszek, P.A., Robinson, J.T. and Thomasian, A., “Concurrency Control for High Contention Environments”, ACM Transactions on Database Systems, Vol. 17, No. 2, June 1992, pp. 304–345.
Franklin, M.J., and Carey, M.J. and Livny, M., “Global Memory Management in Client Server DBMS Architectures”, Proc. 18th Intl. Conf. on Very Large Databases, Vancouver, Canada, Aug. 1992, pp. 596–609.
Gray, J., Homan, P., Obermarck, R. and Korth, H., “A Straw Man Analysis of Probability of Waiting and Deadlock”, IBM Research Report RJ 3066, San Jose, CA, 1981.
Gray, J.N., “An Approach to Decentralized Computer Systems”, IEEE Transactions on Software Engineering, Vol SE-12, No. 6, June 1986, pp. 684–692.
Hartzman, C. S., “The Delay Due to Dynamic Two-Phase Locking”, IEEE Transactions on Software Engineering, Vol. 15, No. 1, Jan. 1989, pp. 72–82.
Hornick, M., and Zdonik, S., “A Shared, Segmented Memory System for an Object-Oriented Database”, ACM Transactions on Information Systems, Vol. 5, No. 1, Jan, 1987.
Hsu, M., and Shang, B., “Modeling Performance Impact of Hotspots”, Technical Report TR-08-88, Aiken Computation Lab., Harvard University, April 1988.
Hsu, M., and Zhang, B., “Performance Evaluation of Cautious Waiting”, ACM Transactions on Database Systems, Vol. 17, No. 3, Sept. 1992. pp. 477–512.
Kim, W., et al., “The Architecture of the ORION Next Generation Database System”, IEEE Transactions on Knowledge and Data Engineering, Vol. 2, No. 1, March 1990, pp. 109–124.
Kronenberg, N., Levy, H., and Strecker, W.D., “VAXcluster: a Closely-Coupled Distributed System”, ACM Transactions on Computer Systems, Vol. 4, No. 2, May 1986, pp. 130–146.
Kung, H.T. and Robinson, J.T., “On Optimistic Methods for Concurrency Control”, ACM Transactions on Database Systems, Vol. 6, No. 2, June 1981, pp. 213–226.
Lavenberg, S.S. (Ed.), “Computer Performance Modeling Handbook”, Academic Press, 1983.
Leff, A., Yu, P.S., and Wolf, J.L, “Policies for Efficient Memory Utilization in a Remote Caching Architecture”, Proc. 1st Intl. Conf. on Parallel and Distributed Information Systems, Miami Beach, Florida, Dec. 1992, pp. 198–205.
Li, K., and Hudak, P., “Memory Coherence in Shared Virtual Memory Systems,” ACM Transactions on Computer System, Vol. 7, Nov. 1989, pp. 321–359.
Mohan, C., and Narang, I., “Recovery and Coherency Control Protocols for Fast Intersystem Page Transfer and Fine Granularity Locking in a Shared Disks Transaction Environment”, Proc. 17th Intl. Conf. on Very Large Databases, Barcelona, Spain, Sept. 1991, pp. 193–207.
Morris, R.J.T., Wong, W.S., “Performance Analysis of Locking and Optimistic Concurrency Control Algorithms”, Performance Evaluation, Vol. 5, 1985, pp. 105–118.
Rahm, E., “Primary Copy Synchronization for DB-Sharing”, Information Systems, Vol. 11, No. 4, 1986, pp. 275–286.
Rahm, E., “Emprical Performance Evaluation of Concurrency and Coherency Control Protocols for Data Sharing”, IBM Research Report RC 14325, 1988.
Ramachandran, U., Ahamad, M. and Khalidi, M.Y.A., “Coherence of Distributed Shared Memory: Unifying Synchronization and Data Transfer”, Proc. 18th Intl. Conf. on Parallel Processing, St. Charles, Ill, Aug. 1989, pp. II-160–II-169.
Ryu, I. K. and Thomasian, A., “Performance Analysis of Centralized Databases with Optimistic Concurrency Control”, Performance Evaluation, Vol. 7, 1987, pp. 195–211.
Rosenkrantz, D.J., Stearns, R.E., and Lewis, P.M., II. “System Level Concurrency Control for Distributed Database Systems”, ACM Transactions on Database Systems, Vol. 3, No. 2, June 1978, pp. 178–198.
Sevcik, K. C., “Comparison of Concurrency Control Methods Using Analytic Models”, Information Processing 83, R.E.A. Mason (ed.), North Holland, 1983, pp. 847–858.
Singhal, M. and Yesha, Y., “A Polynomial Algorithm for Computation of the Probability of Conflicts in a Database under Arbitrary Data Access Distribution”, Information Processing Letters, Vol. 27, No., 2, Feb. 1988, pp. 69–74.
Singhal, M., “Analysis of the Probability of Transaction Abort and Throughput of Two Timestamp Ordering Algorithms for Database Systems”, IEEE Transaction on Knowledge and Data Engineering, Vo. 3, No. 2, June 1991, pp. 261–266.
Tay, Y.C., “A Mean Value Performance Model for Locking in Databases”, Ph.D. Dissertation, Harvard University, Cambridge, MA, Feb. 1984.
Tay, Y.C., Suri, R. and Goodman, N., “A Mean Value Performance Model for Locking in Databases: The No-Waiting Case”, Journal of the ACM, Vol. 32, No. 3, July 1985, pp. 618–651.
Tay, Y.C., Goodman, N., and Suri, R., “Locking Performance in Centralized Databases”, ACM Transactions on Database Systems, Vol. 10, No. 4, Dec. 1985, pp. 415–462.
Tay, Y.C., “Issues in Modelling Locking Performance”, in “Stochastic Analysis of Computer and Communication Systems, H. Takagi (Ed.), North-Holland, 1990, pp. 631–655.
Thomasian, A. and Ryu, I.K., “Analysis of Some Optimistic Concurrency Control Schemes Based on Certification”, Performance Eval. Review, 13, 2 (Proc. of 1985 ACM SIGMETRICS), pp. 192–203.
Thomasian, A. and Ryu, I.K., “Performance Analysis of Two-Phase Locking”, IEEE Transactions on Software Engineering, Vol. 17, No. 5, May 1991, pp. 386–401.
Wilkinson, K., and Neimat, M.A., “Maintaining Consistency of Client-Cached Data” Proc. 16th Very Large Database Conf., Brisbane, Australia, August 1990, pp. 122–133.
Yu, P.S., Dias, D.M., Robinson, J.T., Iyer, B.R. and Cornell, D.W., “Modelling of Centralized Concurrency Control in Multi-System Environment”, Performance Eval. Review, 13, 2 (Proc. of 1985 ACM SIGMETRICS), pp.183–191.
Yu, P.S., et al., “On Coupling Multi-Systems Through Data Sharing”, Proceedings of the IEEE, Vol. 75, No. 5, May 1987, pp. 573–587.
Yu, P.S. and Dias, D.M., “Concurrency Control Using Locking with Deferred Blocking”, Proc. 6th Intl. Conf. on Data Engineering, Los Angeles, CA, 1990, pp.30–36.
Yu, P.S., Heiss, H. and Dias, D.M., “Modelling and Analysis of a Time-Stamp History Based Certification Protocol for Concurrency Control”, IEEE Transactions on Knowledge and Data Engineering, Vo. 3, No. 4, Dec. 1991, pp. 525–537.
Yu, P.S. and Dias, D.M., “Analysis of Hybrid Concurrency Control Schemes for a High Data Contention Environment”, IEEE Transactions on Software Engineering, Vol. 18, No. 2, Feb. 1992, pp. 118–129.
Yu, P.S. and Dan, A., “Effect of System Dynamics on Coupling Architectures for Transaction Processing”, Proc. 8th Intl. Conf. on Data Engineering, Tempe, AZ, Feb. 1992, pp. 458–469.
Yu, P.S., and Dan, A., “Impact of Workload Partitionability on the Performance of Coupling Architectures for Transaction Processing”, Proc. 4th IEEE Symposium on Parallel and Distributed Processing, Dec. 1992, pp. 40–49.
Yu, P.S., Dias, D., and Lavenberg, S.S., “On the Analytical Modeling of Database Concurrency Control”, Journal of the ACM, Sept. 1993.
Yu, P.S., K.L. Wu, K.J. Lin, and S.H. Son, “On Real-time Databases: Concurrency Control and Scheduling”, (to appear) Proceedings of the IEEE, Jan. 1994.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1993 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Yu, P.S. (1993). Modeling and analysis of transaction processing systems. In: Donatiello, L., Nelson, R. (eds) Performance Evaluation of Computer and Communication Systems. Performance SIGMETRICS 1993 1993. Lecture Notes in Computer Science, vol 729. Springer, Berlin, Heidelberg. https://doi.org/10.1007/BFb0013872
Download citation
DOI: https://doi.org/10.1007/BFb0013872
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-57297-8
Online ISBN: 978-3-540-48044-0
eBook Packages: Springer Book Archive