Two-stage transaction processing in client-server DBMSs

V. Kanitkar, A. Delis

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Abstract

Shows that there is scope for replication in data-shipping client-server DBMSs, offering opportunities for improved transaction response times. To support this replication, we describe a two-stage protocol for transaction processing (2STP). We extend the conventional client-server data-shipping mechanism by allowing clients to update and query cached objects that have replicas in multiple sites. We use the concept of acceptance criteria to provide a means for the flexible handling of client updates. The effectiveness of the two-stage transaction processing mechanism is supported by means of queuing analysis and detailed simulation experiments comparing 2STP with a global lock-based data-shipping protocol. This improvement in transaction processing efficiency is achieved at the cost of longer downtimes for crash recovery.

Original languageEnglish (US)
Title of host publicationProceedings - 7th International Symposium on High Performance Distributed Computing, HPDC 1998
PublisherInstitute of Electrical and Electronics Engineers Inc.
Pages1-8
Number of pages8
ISBN (Electronic)0818685794, 9780818685798
DOIs
StatePublished - 1998
Event7th IEEE International Symposium on High Performance Distributed Computing, HPDC 1998 - Chicago, United States
Duration: Jul 31 1998 → …

Publication series

NameProceedings - 7th International Symposium on High Performance Distributed Computing, HPDC 1998
Volume1998-July

Conference

Conference7th IEEE International Symposium on High Performance Distributed Computing, HPDC 1998
Country/TerritoryUnited States
CityChicago
Period7/31/98 → …

ASJC Scopus subject areas

  • Software
  • Computer Networks and Communications
  • Hardware and Architecture

Fingerprint

Dive into the research topics of 'Two-stage transaction processing in client-server DBMSs'. Together they form a unique fingerprint.

Cite this