Design and Analysis of Integrated Concurrency-Coherence Controls.

Daniel M. Dias, Balakrishna R. Iyer, John T. Robinson, Philip S. Yu: Design and Analysis of Integrated Concurrency-Coherence Controls. VLDB 1987: 463-471
  author    = {Daniel M. Dias and
               Balakrishna R. Iyer and
               John T. Robinson and
               Philip S. Yu},
  editor    = {Peter M. Stocker and
               William Kent and
               Peter Hammersley},
  title     = {Design and Analysis of Integrated Concurrency-Coherence Controls},
  booktitle = {VLDB'87, Proceedings of 13th International Conference on Very
               Large Data Bases, September 1-4, 1987, Brighton, England},
  publisher = {Morgan Kaufmann},
  year      = {1987},
  isbn      = {0-934613-46-X},
  pages     = {463-471},
  ee        = {db/conf/vldb/DiasIRY87.html},
  crossref  = {DBLP:conf/vldb/87},
  bibsource = {DBLP,}


In a multi-system data sharing complex, the systems have direct access to all data, with sharing typically at the disk level. This necessitates global concurrency control and coherency control of local buffers in each system. We propose an integrated controller for handling both global concurrency and coherency control, and show that this leads to a significant performance gain. The multi-system performance can be enhanced by use of an intermediate shared semiconductor memory. This gives rise to additional read-write synchronization and disk write serialization problems. We show these can be handled efficiently by the integrated controller, while allowing for early transaction commit. Significant transaction speedup and reduction in lock contention among transactions are obtained. The decrease in lock contention allows the multiple systems to sustain a higher transaction throughput. A queueing model is used to quantify the performance improvement. Although intermediate memory can be employed as a buffering device our analysis shows that substantial performance gains can be realized when combined with the integrated concurrency-coherency control.

Copyright © 1987 by the VLDB Endowment. Permission to copy without fee all or part of this material is granted provided that the copies are not made or distributed for direct commercial advantage, the VLDB copyright notice and the title of the publication and its date appear, and notice is given that copying is by the permission of the Very Large Data Base Endowment. To copy otherwise, or to republish, requires a fee and/or special permission from the Endowment.

Online Paper

ACM SIGMOD Anthology

CDROM Version: Load the CDROM "Volume 1 Issue 4, VLDB '75-'88" and ... DVD Version: Load ACM SIGMOD Anthology DVD 1" and ... BibTeX

Printed Edition

Peter M. Stocker, William Kent, Peter Hammersley (Eds.): VLDB'87, Proceedings of 13th International Conference on Very Large Data Bases, September 1-4, 1987, Brighton, England. Morgan Kaufmann 1987, ISBN 0-934613-46-X
Contents BibTeX


Douglas W. Cornell, Daniel M. Dias, Philip S. Yu: On Multisystem Coupling Through Function Request Shipping. IEEE Trans. Software Eng. 12(10): 1006-1017(1986) BibTeX
Jim Gray, Pete Homan, Henry F. Korth, Ron Obermarck: A Straw Man Analysis of the Probability of Waiting and Deadlock in a Database System. Berkeley Workshop 1981: 125 BibTeX
Stephen S. Lavenberg: A Simple Analysis of Exclusive and Shared Lock Contention in a Database System. SIGMETRICS 1984: 143-148 BibTeX
Alan Jay Smith: Disk Cache-Miss Ratio Analysis and Design Considerations. ACM Trans. Comput. Syst. 3(3): 161-203(1985) BibTeX
Philip S. Yu, Daniel M. Dias, John T. Robinson, Balakrishna R. Iyer, Douglas W. Cornell: Modelling of Centralized Concurrency Control in a Multi-System Environment. SIGMETRICS 1985: 183-191 BibTeX
Philip S. Yu, Douglas W. Cornell, Daniel M. Dias, Alexander Thomasian: On Coupling Partitioned Database Systems. ICDCS 1986: 148-157 BibTeX

Referenced by

  1. Michael J. Franklin, Michael J. Carey, Miron Livny: Transactional Client-Server Cache Consistency: Alternatives and Performance. ACM Trans. Database Syst. 22(3): 315-363(1997)
  2. Mukesh Singhal: Analysis of the Probability of Transaction Abort and Throughput of Two Timestamp Ordering Algorithms for Database Systems. IEEE Trans. Knowl. Data Eng. 3(2): 261-266(1991)
  3. Joel L. Wolf, Daniel M. Dias, Balakrishna R. Iyer, Philip S. Yu: A Hybrid Data Sharing - Data Partitioning Architecture for Transaction Processing. ICDE 1988: 520-527
ACM SIGMOD Anthology - DBLP: [Home | Search: Author, Title | Conferences | Journals]
VLDB Proceedings: Copyright © by VLDB Endowment,
ACM SIGMOD Anthology: Copyright © by ACM (, Corrections:
DBLP: Copyright © by Michael Ley (, last change: Sat May 16 23:45:36 2009