Skip to main content

An efficient transient versioning method

  • Conference paper
  • First Online:
Advances in Databases (BNCOD 1995)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 940))

Included in the following conference series:

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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Agrawal, R., Carey, M., Livny, M.: Concurrency Control Performance Modeling: Alternatives and Implications. ACM Transactions on Database Systems, December 1987.

    Google Scholar 

  2. 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.

    Google Scholar 

  3. Agrawal, D., Sengupta, S.: Modular Synchronization in Multiversion Databases: Version Control and Concurrency Control. ACM SIGMOD International Conference on Management of Data, May 1989.

    Google Scholar 

  4. Bayer, R., Heller, H., Reiser, A.: Parallelism and Recovery in Database Systems. ACM Transactions on Database Systems, June 1980.

    Google Scholar 

  5. Bernstein, P.A., Hadzilacos, V., Goodman, N.: Concurrency Control and Recovery in Database Systems. Addison-Wesley Pub. Co., 1987.

    Google Scholar 

  6. Bober, P., Carey, M.: On Mixing Queries and Transactions via Multiversion Locking. Proc. 8th International Conference on Data Engineering, February 1992.

    Google Scholar 

  7. Bober, P., Carey, M.: Multiversion query locking. Proc. 18th International Conference on Very Large Data Bases, August 1992.

    Google Scholar 

  8. Chan, A., et al.: The Implementation of an Integrated Concurrency Control and Recovery Scheme. ACM SIGMOD International Conference on Management of Data, June 1982.

    Google Scholar 

  9. DeWitt, D., Gray, J.: Parallel Database Systems: The Future of High Performance Database Systems. Communications of the ACM, June 1992.

    Google Scholar 

  10. Gray, J., Reuter, A.: Transaction Processing: Concepts and Techniques. Morgan Kaufmann Publishers, 1993.

    Google Scholar 

  11. 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.

    Google Scholar 

  12. Hadzilacos, T.: Serialization graph algorithms for multiversion concurrency control. ACM SIGMOD International Conference on Management of Data, March 1988.

    Google Scholar 

  13. 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.

    Google Scholar 

  14. 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.

    Google Scholar 

  15. Reed, D.: Naming and Synchronization in a Decentralized Computer System. PhD Thesis, Technical Report MIT/LCS/TR-205, MIT, September 1978.

    Google Scholar 

  16. Schwetman, H.: CSIM Users Guide. March 1990.

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Carole Goble John Keane

Rights and permissions

Reprints 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

Publish with us

Policies and ethics