This Article 
 Bibliographic References 
 Add to: 
On Coupling Multiple Systems With A Global Buffer
April 1996 (vol. 8 no. 2)
pp. 339-344

Abstract—In this paper, we conduct a performance study of coupling multiple systems with a global buffer, and present several results obtained from a multiple-system simulator. This simulator has been run against three workloads, and the coupled system behavior with these three different inputs is studied. Several statistics, including those on local and global buffer hits, page writes to the global buffer, cross-invalidations, and castouts are reported. Their relationship to the degree of data skew is explored. Moreover, in addition to the update-caching approach, a design alternative for the use of a global buffer, namely read-caching, is explored. In read-caching, not only updated pages but also pages read by each node are kept in the global buffer, thereby facilitating other nodes' access to the same pages at the cost of a higher global buffer usage. Also investigated is the case of no-caching, i.e., without using a global buffer. Several simulation results are presented and analyzed.

[1] M. Carey, M. Franklin, M. Livny, and E. Shekita, "Data Caching Tradeoffs in Client-Server DBMS Architecture," Proc. ACM-SIGMOD Conf. Management of Data,Denver, Colo., May 1991.
[2] IBM Corp., "Sysplex Overview: Introducing Data Sharing and Parallelism in a Sysplex," Technical Report GC28-1208-00, Apr. 1994.
[3] A. Dan, P.S. Yu, and D.M. Dias, "Performance Modelling and Comparison of Global Shared Buffer Management Polocies in A Cluster Environment," IEEE Trans Computers, vol. 43, no. 11, pp. 1,281-1,297, 1994.
[4] D.J. Haderle, R.D. Jackson, "IBM Database 2 Overview," IBM Systems J., vol. 23, no. 2, pp. 112-125, 1984.
[5] C. Mohan, D. Haderle, B. Lindsay, H. Pirahesh, and P. Schwarz, ARIES: A Transaction Recovery Method Supporting Fine-Granularity Locking and Partial Rollbacks Using Write-Ahead Logging ACM Trans. Database Systems, vol. 17, no. 1, pp. 94-162, Mar. 1992.
[6] E. Rahm, "Evaluation of Closely Coupled Systems for High Performance Database Processing," Proc. 13th Int'l Conf. Distributed Computing Systems, pp. 301-310, May 1993.
[7] E. Rahm, "Empirical Performance Evaluation of Concurrency and Coherency Control Protocols for Database Sharing Systems," ACM Trans. Database Systems, vol. 18, no. 2, pp. 333-377, June 1993.
[8] R.R. Daniel and M. Stonebraker,"Locking granularity revised," ACM Trans. Database Systems, vol. 4, no. 2, pp. 210-227, June 1979.
[9] Y. Wang and L. Rowe, "Cache Consistency and Concurrency Control in a Client/Server DBMS Architecture," Proc. 1991 ACM SIGMOD Int'l Conf.,Denver, Colo., May 1991.
[10] P.S. Yu, D.M. Dias, J.T. Robinson, B.R. Iyer, and D.W. Cornell, "On Coupling Multi-Systems Through Data Sharing," Proc. IEEE, vol. 75, no. 5, pp. 573-587, May 1987.

Index Terms:
Data sharing approach, global buffer, temporal locality, read-caching.
Ming-Syan Chen, Philip S. Yu, Tao-Heng Yang, "On Coupling Multiple Systems With A Global Buffer," IEEE Transactions on Knowledge and Data Engineering, vol. 8, no. 2, pp. 339-344, April 1996, doi:10.1109/69.494171
Usage of this product signifies your acceptance of the Terms of Use.