Abstract
This paper describes a technique for use when multiple instances of a data base management system (DBMS), each with its own cache (buffer pool), can directly read and modify any data stored on a set of shared disks. Global locking and coherency control protocols are necessary in this context for assuring transaction consistency and for maintaining coherency of the data cached in the multiple caches. The coordination amongst the systems is performed by a set of local lock managers (LLMs) and a global lock manager (GLM). This typically involves sending messages. We describe a technique, called LP locking, which saves locking calls when the granularity of locking by transactions is the same as the granularity of caching by the cache manager. The savings are gained by making the LLMs hide from the GLM the distinction between a transaction lock, called the L lock, and a cache-ownership lock, called the P lock, for the same object. The L and P locks for an object, though distinct at an LLM, are known as a single lock at the GLM. An LLM can grant an L or P lock request on an object locally if the combined lock mode of the L and P locks already held on that object by that LLM is equal to or higher than the requested mode. Such optimizations save messages between the LLMs and the GLM. Our ideas apply also to the client-server environment which has become very popular in the OODBMS area and to the distributed shared memory environment.
Preview
Unable to display preview. Download preview PDF.
References
Carey, M., Franklin, M., Livny, M., Shekita, E. Data Caching Tradeoffs in Client-Server DBMS Architectures, Proc. ACM SIGMOD International Conference on Management of Data, Denver, May 1991.
Cheng, J., Haderle, D., Hedges, R., Iyer, B., Messinger, T., Mohan, C., Wang, Y. An Efficient Hybrid Join Algorithm: a DB2 Prototype, Proc. 7th International Conference on Data Engineering, Kobe, April 1991. Also available as IBM Research Report RJ7884, IBM Almaden Research Center, December 1990.
Delis, A., Roussopoulos, N. Performance Comparison of Three Modern DBMS Architectures, Technical Report CS-TR-2679, University of Maryland, May 1991.
Dias, D., Iyer, B., Robinson, J., Yu, P. Integrated Concurrency-Coherency Controls for Multisystem Data Sharing, IEEE Transactions on Software Engineering, Vol. 15, No. 4, April 1989.
DeWitt, D., Maier, D., Futtersack, P., Velez, F. A Study of Three Alternative Workstation-Server Architectures for Object Oriented Database Systems, Proc. 16th International Conference on Very Large Data Bases, Brisbane, August 1990.
Gray, J., Lorie, R., Putzolu, F., Traiger, I. Granularity of Locks and Degrees of Consistency in a Shared Data Base, Proc. IFIP Working Conference on Modelling of Database Management Systems, Freudenstadt, January 1976. Also Available as IBM Research Report RJ1654, IBM San Jose Research Laboratory.
Haerder, T. Handling Hot Spot Data in DB-Sharing Systems, Information Systems, Vol. 13, No. 2, p155–166, 1988.
Haderle, D., Jackson, R. IBM Database 2 Overview, IBM Systems Journal, Vol. 23, No. 2, 1984.
Haerder, T., Reuter, A. Principles of Transaction Oriented Database Recovery — A Taxonomy, Computing Surveys, Vol. 15, No. 4, December 1983.
Joshi, A. Adaptive Locking Strategies in a Multi-Node Shared Data Model Environment, Proc. 17th International Conference on Very Large Data Bases, Barcelona, September 1991.
Kronenberg, N., Levy, H., Strecker, W. VAXclusters: A Closely-Coupled Distributed System, ACM Transactions on Computer Systems.Vol. 4, No. 2, May 1986.
Koch, B., Schunke, T., Dearle, A., Vaughan, F., Marlin, C., Fazakerley, R., Barter, C. Cache Coherency and Storage Management in a Persistent Object System, Proc. 4th International Workshop on Persistent Object Systems, Martha's Vineyard, September 1990, Morgan Kaufmann Publishers, Inc.
Mohan, C., Haderle. D., Wang, Y., Cheng, J. Single Table Access Using Multiple Indexes: Optimization, Execution and Concurrency Control Techniques, Proc. International Conference on Extending Data Base Technology, Venice, March 1990. An expanded version of this paper is available as IBM Research Report RJ7341, IBM Almaden Research Center, March 1990.
Mohan, C., Narang, I. Recovery and Coherency Control Protocols for Fast Intersystem Page Transfer and Fine-Granularity Locking in Shared Dtsks Transaction Environment, Proc. 17th International Conference on Very Large Data Bases, Barcelona, September 1991. A longer version of this paper is available as IBM Research Report RJ8017, IBM Almaden Research Center, March, 1991.
Mohan, C., Narang, I. Data Base Recovery in Shared Dtsks and Client-Server Architectures, IBM Research Report, IBM Almaden Research Center, November 1991.
Mohan, C., Narang, I., Palmer, J. A Case Study of Problems in Migrating to Distributed Computing: Page Recovery Using Multiple Logs in the Shared Disks Environment, IBM Research Report RJ7343, IBM Almaden Research Center, March 1990.
Mohan, C., Narang, I., Silen, S. Solutions to Hot Spot Problems in a Shared Disks Transaction Environment, Proc. 4th International Workshop on High Performance Transaction Systems, Asilomar, September 1991. Also available as IBM Research Report RJ8281, IBM Almaden Research Center, August 1991.
Nitzberg, B., Lo, V. Distributed Shared Memory: A Survey of Issues and Algorithms, Computer, August 1991.
Peterson, R.J., Strickland, J.P. Log Write-Ahead Protocols and IMS/VS Logging, Proc. 2nd ACM SIGACT-SIGMOD Symposium on Principles of Database Systems, Atlanta, March 1983.
Rahm, E. Primary Copy Synchronization for DB-Sharing, Information Systems, Vol. 11, No. 4, 1986.
Rahm, E. Recovery Concepts for Data Sharing Systems, Proc. 21st International Symposium on Fault-Tolerant Computing, Montreal, June 1991.
Rengarajan, T.K., Spiro, P., Wright. W. High Availability Mechanisms of VAX DBMS Software, Digital Technical Journal, No. 8, February 1989.
Reuter, A. Load Control and Load Balancing in a Shared Database Management System, Proc. International Conference on Data Engineering, February 1986.
Roussopoulos, N., Delis, A. Modern Client-Server DBMS Architectures, Technical Report CS-TR-2719. University of Maryland, June 1991.
Scrutchin, T. TPF: Performance, Capacity, Availability, Proc. IEEE Compcon Spring '87, San Francisco, February 1987.
Shoens, K. Data Sharing vs. Partitioning for Capacity and Availability, Database Engineering, Vol. 9. No. 1, March 1986.
Shoens, K., Treiber, K. Method for Lock Management, Page Coherency, and Asynchronous Writing of Changed Pages to Shared External Store in a Distributed Computing System, U.S. Patent 4,965,719, IBM. October 1990.
Shoens, K., Narang, I., Obermarck, R., Palmer, J., Silen, S., Traiger, I., Treiber, K. Amoeba Project, Proc. IEEE Compcon Spring '85, San Francisco, February 1985.
Strickland, J., Uhrowczik, P., Watts, V. IMS/VS: An Evolving System, IBM Systems Journal, Vol. 21, No. 4, 1982.
Teng, J., Gumaer, R. Managing IBM Database 2 Buffers to Maximize Performance, IBM Systems Journal, Vol. 23, No. 2, 1984.
Wang, Y., Rowe, L., Cache Consistency and Concurrency Control in a Client/Server DBMS Architecture, Proc. ACM-SIGMOD International Conference on Management of Data, Denver, May 1991.
Wilkinson, K., Neimat, M.-A. Maintaining Consistency of Client-Cached Data, Proc. 16th International Conference on Very Large Data Bases, Brisbane, August 1990.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1992 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Mohan, C., Narang, I. (1992). Efficient locking and caching of data in the multisystem shared disks transaction environment. In: Pirotte, A., Delobel, C., Gottlob, G. (eds) Advances in Database Technology — EDBT '92. EDBT 1992. Lecture Notes in Computer Science, vol 580. Springer, Berlin, Heidelberg. https://doi.org/10.1007/BFb0032448
Download citation
DOI: https://doi.org/10.1007/BFb0032448
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-55270-3
Online ISBN: 978-3-540-47003-8
eBook Packages: Springer Book Archive