Abstract
We examine the problem of concurrency control when the database management system supports multiple versions of the data. We characterize the limit of the parallelism achievable by the multiversion approach and demonstrate the resulting space-parallelism trade-off.
- 1 BAYER, R., HELLER, H., AND REISER, A. Parallelism and recovery in database systems. ACM Trans. Database Syst. 5, 2 (June 1980), 139-156. Google ScholarDigital Library
- 2 BERNSTEIN, P.A., AND GOODMAN, N. Concurrency control in distributed database systems. ACM Comput. Surv. 13, 2 (June 1981), 185-222. Google ScholarDigital Library
- 3 ESWARAN, K.P., GRAY, J.N., LORIE, R.A., AND TRAIGER, I.L. The notions of consistency and predicate locks in a database system. Commun. ACM 19, 11 (Nov, 1976), 624-633. Google ScholarDigital Library
- 4 GAREY, M.R., AND JOHNSON, D.S. Computers and Intractability: A Guide to the Theory o/NP- Completeness. Freeman, San Francisco, 1978. Google ScholarDigital Library
- 5 GRAY, J.N. Notes on database operating systems. In Operating Systems~An Advanced Course. R. Bayer, R.M. Graham, B.G. Seegmuller, Eds., Springer-Verlag, 1978. Google ScholarDigital Library
- 6 Honeywell File Management Supervisor. Order No. DB54, Honeywell Information Systems Inc., 1973.Google Scholar
- 7 KUNG, H.T., AND PAPADIMITRIOU, C.H. An optimality theory of database concurrency control. In Proc. ACM-SIGMOD (1979), ACM, New York, pp. 116-126. Google ScholarDigital Library
- 8 LAUSEN, G. Serializabillty problems of interleaved database transactions. Manuscript, 1981.Google Scholar
- 9 LAUSEN, G. On database transaction schedulers with high degree of parallelism. Manuscript, 1981.Google Scholar
- 10 MURO, S., MINOURA, T., AND KAMEDA, T. Multiversion concurrency control for a database system. Manuscript, 1981.Google Scholar
- 11 PAPADIMITRIOU, C.H. Serializability of concurrent database updates. J. ACM 26, 4 (Oct. 1979), 631-653. Google ScholarDigital Library
- 12 PAPADIMITRIOU, C.H. On the power of locking. In Proc. ACM-SIGMOD, (1981), ACM, New York, pp. 148-154. Google ScholarDigital Library
- 13 REED, D.P. Naming and synchronization in a decentralized computer system. PhD dissertation, MIT, Dept. of EECS, Sept. 1978.Google Scholar
- 14 STEARNS, R.E., LEWIS, P.M., AND ROSENKRANTZ, D.J. Concurrency control for database systems. In Proc. 16th IEEE-FOCS, {1976), pp. 19-32.Google Scholar
- 15 STEARNS, R.E., AND ROSENKRANTZ, D.J. Distributed database concurrency control using before-values. In Proc. ACM-SIGMOD, (1981), ACM, New York, pp. 74-83. Google ScholarDigital Library
- 16 YANNAKAKIS, M., PAPADIMITRIOU, C.H., AND KUNG, H.T. Locking policies: safety and freedom from deadlock. In Proc. 20th IEEE-FOCS, (1979), pp. 283-287.Google ScholarDigital Library
- 17 YANNAKAKIS, M. The various notions of correctness in database concurrency control. In preparation.Google Scholar
Index Terms
- On Concurrency Control by Multiple Versions
Recommendations
Semantics-based concurrency control: beyond commutativity
The concurrency of transactions executing on atomic data types can be enhanced through the use of semantic information about operations defined on these types. Hitherto, commutativity of operations has been exploited to provide enchanced concurrency ...
On concurrency control by multiple versions
PODS '82: Proceedings of the 1st ACM SIGACT-SIGMOD symposium on Principles of database systemsWe examine the problem of concurrency control when the database management system supports multiple versions of the data. We characterize the limit of the parallelism achievable by the multiversion approach and demonstrate the resulting space-...
Rethinking serializable multiversion concurrency control
Multi-versioned database systems have the potential to significantly increase the amount of concurrency in transaction processing because they can avoid read-write conflicts. Unfortunately, the increase in concurrency usually comes at the cost of ...
Comments