A closed queueing network model to evaluate the impact of recovery operations on the performance of database servers

Paulo B Goes, Ushio Sumita

Research output: Contribution to journalArticle

Abstract

As database servers proliferate in modern information systems architectures in organizations, the issue of protecting and recovering the databases becomes of utmost importance. By developing an analytical model based on a closed network of queues, this paper analyses how different database recovery mechanisms impact on the normal transaction processing. Such a model enables one to capture intricate effects that are peculiar to complex, tightly coupled, multi-component systems, such as database recovery systems, and can be used to facilitate the design and the tuning of database recovery managers. The proposed model provides important performance measures in terms of average transaction processing time and overall systems throughput. Numerical experiments using actual recovery methods demonstrate the effectiveness of the modelling approach.

Original languageEnglish (US)
Pages (from-to)122-135
Number of pages14
JournalJournal of the Operational Research Society
Volume47
Issue number1
Publication statusPublished - Jan 1996
Externally publishedYes

    Fingerprint

Keywords

  • Computers
  • Database systems
  • Information systems
  • Queueing

ASJC Scopus subject areas

  • Management of Technology and Innovation
  • Strategy and Management
  • Management Science and Operations Research

Cite this