Recovery Issues in Databases Using Redundant Disk Arrays

Abstract

Redundant disk arrays provide a way for achieving rapid recovery from media failures with a relatively low storage cost for large scale database systems requiring high availability. In this paper we propose a method for using redundant disk arrays to support rapid recovery from system crashes and transaction aborts in addition to their role in providing media failure recovery. A twin page scheme is used to store the parity information in the array so that the time for transaction commit processing is not degraded. Using an analytical model and simulation results, we show that the proposed method achieves a significant increase in the throughput of database systems using redundant disk arrays by reducing the number of recovery operations needed to maintain the consistency of the database.

Open PDF

Document Details

Document Type
Technical Report
Publication Date
Jun 22, 1992
Accession Number
ADA259256

Entities

People

  • Antoine N. Mourad
  • Daniel G. Saab
  • W. Kent Fuchs

Organizations

  • University of Illinois Urbana–Champaign

Tags

Communities of Interest

  • Materials and Manufacturing Processes

DTIC Thesaurus Topics

  • Algorithms
  • Availability
  • Computers
  • Data Storage Systems
  • Databases
  • Environment
  • Equations
  • Failure Mode And Effect Analysis
  • Frequency
  • Intervals
  • Network Protocols
  • Probability
  • Random Variables
  • Recovery
  • Simulations
  • Test And Evaluation
  • Throughput

Fields of Study

  • Computer science
  • Engineering

Readers

  • Parallel and Distributed Computing.