Abstract
An abstract model of concurrency control algorithms is presented. The model facilitates implementation-independent descriptions of various algorithms, allowing them to be specified in terms of the information that they require, the conditions under which blocking or restarts are called for, and the manner in which requests are processed. The model also facilitates comparisons of the relative storage and CPU overheads of various algorithms based on their descriptions. Results are given for single-site versions of two-phase locking, basic timestamp ordering, and serial validation. Extensions which will allow comparisons of multiple version and distributed algorithms are discussed as well.
- {Bada79} Badal, D., "Correctness of Concurrency Control and Implications in Distributed Databases", Proceedings of the COMPSAC '79 Conference, Chicago, Illinois, November 1979.]]Google Scholar
- {Bada81} Badal, D., "Concurrency Control Overhead or Closer Look at Blocking vs. Nonblocking Concurrency Control Mechanisms", Proceedings of the Fifth Berkeley Workshop on Distributed Data Management and Computer Networks, Emeryville, CA, February 1981.]]Google Scholar
- {Baye80} Bayer, R., Heller, H., and Reiser, A., "Parallelism and Recovery in Database Systems", ACM Transactions on Database Systems 5(2), June 1980.]] Google ScholarDigital Library
- {Bern80} Bernstein, P., and Goodman, N., "Fundamental Algorithms for Concurrency Control in Distributed Database Systems", Technical Report, Computer Corporation of America, 1980.]]Google ScholarCross Ref
- {Bern81} Bernstein, P., and Goodman, N., "Concurrency Control in Distributed Database Systems", ACM Computing Surveys 13(2), June 1981.]] Google ScholarDigital Library
- {Bern82a} Bernstein, P., and Goodman, N., "A Sophisticate's Introduction to Distributed Database Concurrency Control", Proceedings of the Eighth International Conference on Very Large Data Bases, September 1982.]] Google ScholarDigital Library
- {Bern82b} Bernstein, P., and Goodman, N., "Multiversion Concurrency Control Theory and Algorithms", Technical Report No. TR-20-82, Aiken Computation Laboratory, Harvard University, June 1982.]]Google Scholar
- {Care83} Carey, M., "Modeling and Evaluation of Database Concurrency Control Algorithms", Ph.D. Thesis, Computer Science Division, EECS Department, University of California, Berkeley, (in preparation).]] Google ScholarDigital Library
- {Casa79} Casanova, M., "The Concurrency Control Problem for Database Systems", Ph.D. Thesis, Computer Science Department, Harvard University, 1979.]]Google Scholar
- {Ceri82} Ceri, S., and Owicki, S., "On the Use of Optimistic Methods for Concurrency Control in Distributed Databases", Proceedings of the Sixth Berkeley Workshop on Distributed Data Management and Computer Networks, February, 1982.]]Google Scholar
- {Chan82} Chan, A., Fox, S., Lin, W., Nori, A., and Ries, D., "The Implementation of An Integrated Concurrency Control and Recovery Scheme", Proceedings of the ACM-SIGMOD International Conference on Management of Data, March 1982.]] Google ScholarDigital Library
- {Date82} Date, C., "An Introduction to Database Systems (Volume II)", Addison-Wesley Publishing Company, 1982.]] Google ScholarDigital Library
- {Elli77} Ellis, C., "A Robust Algorithm for Updating Duplicate Databases", Proceedings of the 2nd Berkeley Workshop on Distributed Databases and Computer Networks, May 1977.]]Google Scholar
- {Gall82} Galler, B., "Concurrency Control Performance Issues" Ph.D. Thesis, Computer Science Department, University of Toronto, September, 1982.]] Google ScholarDigital Library
- {Garc79} Garcia-Molina, H., "Performance of Update Algorithms for Replicated Data in a Distributed Database", Ph.D. Thesis, Computer Science Department, Stanford University, June 1979.]] Google ScholarDigital Library
- {Gray79} Gray, J., "Notes On Database Operating Systems", in "Operating Systems: An Advanced Course", Springer-Verlag, 1979.]] Google ScholarDigital Library
- {Gray81} Gray, J., Homan, P., Korth, H., and Obermarck, R., "A Straw Man Analysis of the Probability of Waiting and Deadlock in a Database System", Report No. RJ3066, IBM San Jose Research Laboratory, February 1981.]]Google Scholar
- {Iran79} Irani, K., and Lin, H., "Queueing Network Models for Concurrent Transaction Processing in a Database System, Proceedings of the ACM-SIGMOD International Symposium on Management of Data, 1979.]] Google ScholarDigital Library
- {Kung81} Kung, H., and Robinson, J., "On Optimistic Methods for Concurrency Control", ACM Transactions on Database Systems 6(2), June 1981.]] Google ScholarDigital Library
- {Lin82} Lin, W., and Nolte, J., "Distributed Database Control and Allocation: Semi-Annual Report", Technical Report, Computer Corporation of America, Cambridge, Massachusetts, January 1982.]]Google Scholar
- {Lind79} Lindsay, B., Selinger, P., Galtieri, C., Gray, J., Lorie, R., Price, T., Putzolu, F., Traiger, I., and Wade, B., "Notes on Distributed Databases", Research Report, IBM San Jose Research Center, 1979.]]Google Scholar
- {Mena78} Menasce, D., and Muntz, R., "Locking and Deadlock Detection in Distributed Databases", Proceedings of the Third Berkeley Workshop on Distributed Data Management and Computer Networks, August 1978.]]Google Scholar
- {Papa79} Papadimitriou, C., "Serializability of Concurrent Updates", Journal of the ACM 26(4), October 1979.]] Google ScholarDigital Library
- {Poti80} Potier, D., and LeBlanc, P., "Analysis of Locking Policies in Database Management Systems", Proceedings of the Performance '80 Conference, 7th IFIP W.G.7.3 International Symposium on Computer Performance Modeling, Measurement, and Evaluation, Toronto, May 1980.]] Google ScholarDigital Library
- {Reed78} Reed, D., "Naming and Synchronization in a Decentralized Computer System", PhD Thesis, Department of Electrical Engineering and Computer Science, Massachusetts Institute of Technology, 1978.]]Google Scholar
- {Ries77} Ries, D., and Stonebraker, M., "Effects of Locking Granularity on Database Management System Performance", ACM Transactions on Database Systems 2(3), September 1977.]] Google ScholarDigital Library
- {Ries79a} Ries, D., "The Effects of Concurrency Control on Database Management System Performance", PhD Thesis, Department of Electrical Engineering and Computer Science, University of California at Berkeley, 1979.]] Google ScholarDigital Library
- {Ries79b} Ries, D., and Stonebraker, M., "Locking Granularity Revisited", ACM Transactions on Database Systems 4(2), June 1979.]] Google ScholarDigital Library
- {Rose78} Rosenkrantz, D., Stearns, R., and Lewis, P., "System Level Concurrency Control for Distributed Database Systems", ACM Transactions on Database Systems 3(2), June 1978.]] Google ScholarDigital Library
- {Stea81} Stearns, R., and Rosenkrantz, D., "Distributed Database Concurrency Controls Using Before-Values", Technical Report, SUNY Albany, February 1981.]]Google ScholarDigital Library
- {Ston76} Stonebraker, M., Wong, E., Kreps, P. and Held, G., "The Design and Implementation of INGRES", ACM Transactions on Database Systems 1(3), September 1976.]] Google ScholarDigital Library
- {Ston79} Stonebraker, M., "Concurrency Control and Consistency of Multiple Copies of Data in Distributed INGRES", IEEE Transactions on Software Engineering 5(3), May 1979.]]Google ScholarDigital Library
- {Thom79} Thomas, R., "A Majority Consensus Approach to Concurrency Control for Multiple Copy Databases", ACM Transactions on Database Systems 4(2), June 1979.]] Google ScholarDigital Library
Index Terms
- An abstract model of database concurrency control algorithms
Recommendations
An abstract model of database concurrency control algorithms
SIGMOD '83: Proceedings of the 1983 ACM SIGMOD international conference on Management of dataAn abstract model of concurrency control algorithms is presented. The model facilitates implementation-independent descriptions of various algorithms, allowing them to be specified in terms of the information that they require, the conditions under ...
Comments