skip to main content
10.1145/872757.872806acmconferencesArticle/Chapter ViewAbstractPublication PagesmodConference Proceedingsconference-collections
Article

A theory of redo recovery

Published:09 June 2003Publication History

ABSTRACT

Our goal is to understand redo recovery. We define an installation graph of operations in an execution, an ordering significantly weaker than conflict ordering from concurrency control. The installation graph explains recoverable system state in terms of which operations are considered installed. This explanation and the set of operations replayed during recovery form an invariant that is the contract between normal operation and recovery. It prescribes how to coordinate changes to system components such as the state, the log, and the cache. We also describe how widely used recovery techniques are modeled in our theory, and why they succeed in providing redo recovery.

References

  1. P. Bernstein, V. Hadzilacos, and N. Goodman. Concurrency Control and Recovery in Database Systems. Addison-Wesley Publishing Company, Reading, MA, 1987. Google ScholarGoogle ScholarDigital LibraryDigital Library
  2. R. Crus. Data recovery in IBM Database 2. IBM Systems Journal, 23(2):178--188, 1984.Google ScholarGoogle ScholarDigital LibraryDigital Library
  3. K. Elhardt and R. Bayer. A database cache for high performance and fast restart in database systems. ACM TODS, 9(4):503--525, December 1984. Google ScholarGoogle ScholarDigital LibraryDigital Library
  4. J. Gray. Notes on database operating systems. In R. Bayer, R. Graham, and G. Seegmuller, editors, Operating Systems--An Advanced Course, volume 60 of Lecture Notes in Computer Science. Springer-Verlag, 1978. Also appears as IBM Research Report RJ 2188, 1978. Google ScholarGoogle ScholarDigital LibraryDigital Library
  5. J. Gray, P. McJones, M. Blasgen, B. Lindsay, R. Lorie, T. Price, and F. Putzolu. The recovery manager of the System R database manager. ACM Computing Surveys, 13(2):223--242, June 1981. Google ScholarGoogle ScholarDigital LibraryDigital Library
  6. J. Gray and A. Reuter. Transaction Processing: Concepts and Techniques. Morgan Kaufmann, 1993. Google ScholarGoogle ScholarDigital LibraryDigital Library
  7. T. Haerder and A. Reuter. Principles of transaction oriented database recovery--a taxonomy. ACM Computing Surveys, 15(4):287--318, December 1983. Google ScholarGoogle ScholarDigital LibraryDigital Library
  8. V. Kumar, M. Hsu (eds). Recovery Mechanisms in Database Systems. Prentice Hall, 1998. Google ScholarGoogle ScholarDigital LibraryDigital Library
  9. D. Kuo. Model and verification of a data manager based on ARIES. In ICDT 1992 231--245. Google ScholarGoogle ScholarDigital LibraryDigital Library
  10. D. Lomet. Persistent Applications Using Generalized Redo Recovery. ICDE 1998 154--163. Google ScholarGoogle ScholarDigital LibraryDigital Library
  11. D. Lomet. Advanced Recovery Techniques in Practice. in Recovery Mechanisms in Database Systems Prentice Hall, 1998Google ScholarGoogle Scholar
  12. D. Lomet and M. Tuttle. Redo recovery after system crashes. VLDB 1995 457--468 Google ScholarGoogle ScholarDigital LibraryDigital Library
  13. D. Lomet and M. Tuttle. Logical Logging to Extend Recovery to New Domains. SIGMOD 1999 73--84. Google ScholarGoogle ScholarDigital LibraryDigital Library
  14. C. Mohan, D. Haderle, B. Lindsay, H. Pirahesh, and P. Schwarz. ARIES: A transaction recovery method supporting fine-granularity locking and partial rollbacks using write-ahead logging. ACM TODS, 17(1):94--162, March 1992. Google ScholarGoogle ScholarDigital LibraryDigital Library

Index Terms

  1. A theory of redo recovery

          Recommendations

          Comments

          Login options

          Check if you have access through your login credentials or your institution to get full access on this article.

          Sign in
          • Published in

            cover image ACM Conferences
            SIGMOD '03: Proceedings of the 2003 ACM SIGMOD international conference on Management of data
            June 2003
            702 pages
            ISBN:158113634X
            DOI:10.1145/872757

            Copyright © 2003 ACM

            Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

            Publisher

            Association for Computing Machinery

            New York, NY, United States

            Publication History

            • Published: 9 June 2003

            Permissions

            Request permissions about this article.

            Request Permissions

            Check for updates

            Qualifiers

            • Article

            Acceptance Rates

            SIGMOD '03 Paper Acceptance Rate53of342submissions,15%Overall Acceptance Rate785of4,003submissions,20%

          PDF Format

          View or Download as a PDF file.

          PDF

          eReader

          View online with eReader.

          eReader