Abstract
Transient versioning methods, where prior versions are maintained temporarily, are proposed to execute long-running queries without affecting concurrent transactions. However, transactions in these methods do not exploit the prior versions. This paper presents a transientversioning method, called Dynamic Versioning, which uses the transient versions to not only support queries but also increase concurrency among transactions. Data conflicts due to incompatible requests are resolved by dynamically creating dependence orders among the requesting transactions and queries. These orders help precisely identify the prior versions that have to be kept for the queries. Since only the required versions are stored, the storage overhead for the transient versions is reduced to the minimum possible. We present the results of simulation experiments that show that our method provides high transaction concurrency and supports queries almost as efficiently as the other transient-versioning methods, while incurring only a fraction of the storage overhead.
Preview
Unable to display preview. Download preview PDF.
References
Agrawal, R., Carey, M., Livny, M.: Concurrency Control Performance Modeling: Alternatives and Implications. ACM Transactions on Database Systems, December 1987.
Agrawal, R., Carey, M., McVoy, L.: The Performance of Alternative Strategies for Dealing with Deadlocks in Database Management Systems. IEEE Transactions on Software Engineering, December 1987.
Agrawal, D., Sengupta, S.: Modular Synchronization in Multiversion Databases: Version Control and Concurrency Control. ACM SIGMOD International Conference on Management of Data, May 1989.
Bayer, R., Heller, H., Reiser, A.: Parallelism and Recovery in Database Systems. ACM Transactions on Database Systems, June 1980.
Bernstein, P.A., Hadzilacos, V., Goodman, N.: Concurrency Control and Recovery in Database Systems. Addison-Wesley Pub. Co., 1987.
Bober, P., Carey, M.: On Mixing Queries and Transactions via Multiversion Locking. Proc. 8th International Conference on Data Engineering, February 1992.
Bober, P., Carey, M.: Multiversion query locking. Proc. 18th International Conference on Very Large Data Bases, August 1992.
Chan, A., et al.: The Implementation of an Integrated Concurrency Control and Recovery Scheme. ACM SIGMOD International Conference on Management of Data, June 1982.
DeWitt, D., Gray, J.: Parallel Database Systems: The Future of High Performance Database Systems. Communications of the ACM, June 1992.
Gray, J., Reuter, A.: Transaction Processing: Concepts and Techniques. Morgan Kaufmann Publishers, 1993.
Gray, J., Lorie, R., Putzolu, F., Traiger, I.: Granularity of Locks and Degrees of Consistency in a Shared Data Base. Modeling in Data Base Systems, North Holland Publishing, 1976.
Hadzilacos, T.: Serialization graph algorithms for multiversion concurrency control. ACM SIGMOD International Conference on Management of Data, March 1988.
Mohan, C., Pirahesh, H., Lorie, R.: Efficient and Flexible Methods for Transient Versioning of Records to Avoid Locking by Read-Only Transactions. ACM SIGMOD International Conference on Management of Data, June 1992.
Pirahesh, H., Mohan, C., Cheng, J., Liu, T.S., Selinger, P.: Parallelism in Relational Database Systems: Architectural Issues and Design Approaches. IEEE 2nd Int'l Symp. on Databases in Parallel and Distributed Systems, July 1990.
Reed, D.: Naming and Synchronization in a Decentralized Computer System. PhD Thesis, Technical Report MIT/LCS/TR-205, MIT, September 1978.
Schwetman, H.: CSIM Users Guide. March 1990.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1995 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Gukal, S., Omiecinski, E., Ramachandran, U. (1995). An efficient transient versioning method. In: Goble, C., Keane, J. (eds) Advances in Databases. BNCOD 1995. Lecture Notes in Computer Science, vol 940. Springer, Berlin, Heidelberg. https://doi.org/10.1007/BFb0000546
Download citation
DOI: https://doi.org/10.1007/BFb0000546
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-60100-5
Online ISBN: 978-3-540-49427-0
eBook Packages: Springer Book Archive