A Cost-Effective Method for Providing Improved Data Availability During DBMS Restart Recovery After a Failure.
C. Mohan:
A Cost-Effective Method for Providing Improved Data Availability During DBMS Restart Recovery After a Failure.
VLDB 1993: 368-379@inproceedings{DBLP:conf/vldb/Mohan93,
author = {C. Mohan},
editor = {Rakesh Agrawal and
Se{\'a}n Baker and
David A. Bell},
title = {A Cost-Effective Method for Providing Improved Data Availability
During DBMS Restart Recovery After a Failure},
booktitle = {19th International Conference on Very Large Data Bases, August
24-27, 1993, Dublin, Ireland, Proceedings},
publisher = {Morgan Kaufmann},
year = {1993},
isbn = {1-55860-152-X},
pages = {368-379},
ee = {db/conf/vldb/Mohan93.html},
crossref = {DBLP:conf/vldb/93},
bibsource = {DBLP, http://dblp.uni-trier.de}
}
Abstract
We present a cost-effective method for improving data availability during restart recovery of a data base management system (DBMS) after a failure.
The method achieves its objective by enabling the processing of new transactions to begin even before restart recovery is completed by exploiting the Commit_LSN concept.
It supports fine- granularity (e.g., record) locking with semantically- rich lock modes and operation logging, partial roll- backs, write-ahead logging, and the steal and no-force buffer management policies.
The overhead imposed by this method during normal transaction processing is insignificant.
We require very few changes to an existing DBMS in order to support our method.
Our method can be implemented with different degrees of sophistication depending on the existing features of a DBMS.
Copyright © 1993 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
CDROM Version: Load the CDROM "Volume 1 Issue 5, VLDB '89-'97" and ...
DVD Version: Load ACM SIGMOD Anthology DVD 1" and ...
Printed Edition
Rakesh Agrawal, Seán Baker, David A. Bell (Eds.):
19th International Conference on Very Large Data Bases, August 24-27, 1993, Dublin, Ireland, Proceedings.
Morgan Kaufmann 1993, ISBN 1-55860-152-X
Contents
References
- [CKKS89]
- George P. Copeland, Tom W. Keller, Ravi Krishnamurthy, Marc G. Smith:
The Case For Safe RAM.
VLDB 1989: 327-335
- [Crus84]
- Richard A. Crus:
Data Recovery in IBM Database 2.
IBM Systems Journal 23(2): 178-188(1984)
- [FZTCD92]
- Michael J. Franklin, Michael J. Zwilling, C. K. Tan, Michael J. Carey, David J. DeWitt:
Crash Recovery in Client-Server EXODUS.
SIGMOD Conference 1992: 165-174
- [Haer88]
- Theo Härder:
Handling hot spot in DB-sharing systems.
Inf. Syst. 13(2): 155-166(1988)
- [IBM87]
- ...
- [IBM89]
- ...
- [LeCa87]
- Tobin J. Lehman, Michael J. Carey:
A Recovery Algorithm for A High-Performance Memory-Resident Database System.
SIGMOD Conference 1987: 104-117
- [Levy91]
- Eliezer Levy:
Incremental Restart.
ICDE 1991: 640-648
- [Lome90]
- ...
- [Lome92]
- David B. Lomet:
MLR: A Recovery Method for Multi-level Systems.
SIGMOD Conference 1992: 185-194
- [MHLPS92]
- C. Mohan, Donald J. Haderle, Bruce G. Lindsay, Hamid Pirahesh, Peter M. Schwarz:
ARIES: A Transaction Recovery Method Supporting Fine-Granularity Locking and Partial Rollbacks Using Write-Ahead Logging.
ACM Trans. Database Syst. 17(1): 94-162(1992)
- [Moha90a]
- C. Mohan:
Commit_LSN: A Novel and Simple Method for Reducing Locking and Latching in Transaction Processing Systems.
VLDB 1990: 406-418
- [Moha90b]
- C. Mohan:
ARIES/KVL: A Key-Value Locking Method for Concurrency Control of Multiaction Transactions Operating on B-Tree Indexes.
VLDB 1990: 392-405
- [Moha93a]
- C. Mohan:
ARIES/LHS: A Concurrency Control and Recovery Method Using Write-Ahead Logging for Linear Hashing with Separators.
ICDE 1993: 243-252
- [Moha93b]
- C. Mohan:
IBM's Relational DBMS Products: Features and Technologies.
SIGMOD Conference 1993: 445-448
- [Moha93c]
- C. Mohan:
A Survey of DBMS Research Issues in Supporting Very Large Tables.
FODO 1993: 279-300
- [MoHa93]
- C. Mohan, Donald J. Haderle:
Algorithms for Flexible Space Management in Transaction Systems Supporting Fine-Granularity Locking.
EDBT 1994: 131-144
- [MoLe92]
- C. Mohan, Frank E. Levine:
ARIES/IM: An Efficient and High Concurrency Index Management Method Using Write-Ahead Logging.
SIGMOD Conference 1992: 371-380
- [MoLO86]
- C. Mohan, Bruce G. Lindsay, Ron Obermarck:
Transaction Management in the R* Distributed Database Management System.
ACM Trans. Database Syst. 11(4): 378-396(1986)
- [MoNa91]
- C. Mohan, Inderpal Narang:
Recovery and Coherency-Control Protocols for Fast Intersystem Page Transfer and Fine-Granularity Locking in a Shared Disks Transaction Environment.
VLDB 1991: 193-207
- [MoNa92a]
- C. Mohan, Inderpal Narang:
Efficient Locking and Caching of Data in the Multisystem Shard Disks Transaction Environment.
EDBT 1992: 453-468
- [MoNa92b]
- C. Mohan, Inderpal Narang:
Data Base Recovery in Shared Disks and Client-Server Architectures.
ICDCS 1992: 310-317
- [MoNa93]
- C. Mohan, Inderpal Narang:
ARIES/CSA: A Method for Database Recovery in Client-Server Architectures.
SIGMOD Conference 1994: 55-66
- [MoPi91]
- C. Mohan, Hamid Pirahesh:
ARIES-RRH: Restricted Repeating of History in the ARIES Transaction Recovery Method.
ICDE 1991: 718-727
- [MoTO93]
- C. Mohan, Kent Treiber, Ron Obermarck:
Algorithms for the Management of Remote Backup Data Bases for Disaster Recovery.
ICDE 1993: 511-518
- [Rahm91]
- ...
- [ReSW89]
- ...
- [Reut86]
- Andreas Reuter:
Load Control and Load Balancing in a Shared Database Management System.
ICDE 1986: 188-197
- [RoMo89]
- Kurt Rothermel, C. Mohan:
ARIES/NT: A Recovery Method Based on Write-Ahead Logging for Nested Transactions.
VLDB 1989: 337-346
- [ScRi88]
- ...
- [Ston87]
- Michael Stonebraker:
The Design of the POSTGRES Storage System.
VLDB 1987: 289-300
- [Tand87]
- ...
- [TeGu84]
- James Z. Teng, Robert A. Gumaer:
Managing IBM Database 2 Buffers to Maximize Performance.
IBM Systems Journal 23(2): 211-218(1984)
Copyright © Tue Mar 16 02:22:03 2010
by Michael Ley (ley@uni-trier.de)