Interaction Between Concurrent Transactions in the Design of Distributed Databases

Uday Kulkarni, Hemant K. Jain

Research output: Contribution to journalArticle

4 Citations (Scopus)

Abstract

A distributed database system allows concurrent execution of transactions from multiple users at multiple locations. This paper presents a general scheme of including the effect of interaction between such transactions in the design process of distributed databases. This scheme allows the decision maker to choose the most appropriate design for a distributed database. The interaction effect is a consequence of concurrency control procedures and contention for system resources. Prior research has not included all components of the interaction effect in the design process. A separate module, called an interaction module, was built to measure the interaction effect using a comprehensive simulation model of a general purpose relational distributed database management system (DBMS). The interaction module can be interfaced with any distributed database design system as an add‐on module so that the interaction effect can be included in the design process. A detailed example demonstrates the use of the interaction module in the decision‐making process. Experiments conducted using the module show that the interaction effect can be significant and that it can affect the choice of the design. Experiments were also conducted to measure the sensitivity of design choices under changing input conditions.

Original languageEnglish (US)
Pages (from-to)253-278
Number of pages26
JournalDecision Sciences
Volume24
Issue number2
DOIs
StatePublished - 1993

Fingerprint

Distributed database systems
Concurrency control
Distributed databases
Module
Interaction
Interaction effects
Experiments
Design process
Experiment
Concurrency
Decision maker
Database management systems
Decision-making process
Resources
Database design
Simulation model

Keywords

  • Decision Support Systems
  • Information Management
  • Simulation

ASJC Scopus subject areas

  • Business, Management and Accounting(all)
  • Strategy and Management
  • Information Systems and Management
  • Management of Technology and Innovation

Cite this

Interaction Between Concurrent Transactions in the Design of Distributed Databases. / Kulkarni, Uday; Jain, Hemant K.

In: Decision Sciences, Vol. 24, No. 2, 1993, p. 253-278.

Research output: Contribution to journalArticle

@article{7929225db3ed427a9f7587077fe3436a,
title = "Interaction Between Concurrent Transactions in the Design of Distributed Databases",
abstract = "A distributed database system allows concurrent execution of transactions from multiple users at multiple locations. This paper presents a general scheme of including the effect of interaction between such transactions in the design process of distributed databases. This scheme allows the decision maker to choose the most appropriate design for a distributed database. The interaction effect is a consequence of concurrency control procedures and contention for system resources. Prior research has not included all components of the interaction effect in the design process. A separate module, called an interaction module, was built to measure the interaction effect using a comprehensive simulation model of a general purpose relational distributed database management system (DBMS). The interaction module can be interfaced with any distributed database design system as an add‐on module so that the interaction effect can be included in the design process. A detailed example demonstrates the use of the interaction module in the decision‐making process. Experiments conducted using the module show that the interaction effect can be significant and that it can affect the choice of the design. Experiments were also conducted to measure the sensitivity of design choices under changing input conditions.",
keywords = "Decision Support Systems, Information Management, Simulation",
author = "Uday Kulkarni and Jain, {Hemant K.}",
year = "1993",
doi = "10.1111/j.1540-5915.1993.tb00474.x",
language = "English (US)",
volume = "24",
pages = "253--278",
journal = "Decision Sciences",
issn = "0011-7315",
publisher = "Wiley-Blackwell",
number = "2",

}

TY - JOUR

T1 - Interaction Between Concurrent Transactions in the Design of Distributed Databases

AU - Kulkarni, Uday

AU - Jain, Hemant K.

PY - 1993

Y1 - 1993

N2 - A distributed database system allows concurrent execution of transactions from multiple users at multiple locations. This paper presents a general scheme of including the effect of interaction between such transactions in the design process of distributed databases. This scheme allows the decision maker to choose the most appropriate design for a distributed database. The interaction effect is a consequence of concurrency control procedures and contention for system resources. Prior research has not included all components of the interaction effect in the design process. A separate module, called an interaction module, was built to measure the interaction effect using a comprehensive simulation model of a general purpose relational distributed database management system (DBMS). The interaction module can be interfaced with any distributed database design system as an add‐on module so that the interaction effect can be included in the design process. A detailed example demonstrates the use of the interaction module in the decision‐making process. Experiments conducted using the module show that the interaction effect can be significant and that it can affect the choice of the design. Experiments were also conducted to measure the sensitivity of design choices under changing input conditions.

AB - A distributed database system allows concurrent execution of transactions from multiple users at multiple locations. This paper presents a general scheme of including the effect of interaction between such transactions in the design process of distributed databases. This scheme allows the decision maker to choose the most appropriate design for a distributed database. The interaction effect is a consequence of concurrency control procedures and contention for system resources. Prior research has not included all components of the interaction effect in the design process. A separate module, called an interaction module, was built to measure the interaction effect using a comprehensive simulation model of a general purpose relational distributed database management system (DBMS). The interaction module can be interfaced with any distributed database design system as an add‐on module so that the interaction effect can be included in the design process. A detailed example demonstrates the use of the interaction module in the decision‐making process. Experiments conducted using the module show that the interaction effect can be significant and that it can affect the choice of the design. Experiments were also conducted to measure the sensitivity of design choices under changing input conditions.

KW - Decision Support Systems

KW - Information Management

KW - Simulation

UR - http://www.scopus.com/inward/record.url?scp=84990578216&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=84990578216&partnerID=8YFLogxK

U2 - 10.1111/j.1540-5915.1993.tb00474.x

DO - 10.1111/j.1540-5915.1993.tb00474.x

M3 - Article

VL - 24

SP - 253

EP - 278

JO - Decision Sciences

JF - Decision Sciences

SN - 0011-7315

IS - 2

ER -