Recovery Mechanisms in Database Systems

61421-4 The first complete guide to today's business-critical database recovery technologies. This is the first book to bring together all you need to know about database recovery(both theory and practice. It covers not just recovery mechanisms in today's relational databases, but also the critically important new techniques for main memory databases, mobile computing, and enterprise workflow systems. Recovery Mechanisms in Database Systems includes contributions from virtually all of the field's leading computer scientists, with insightful coverage of: *The intricate relationship between recovery and concurrency control Redo recovery, multilevel recovery, and ARIES-type recovery mechanisms, Crash recovery in client/server systems Hardware solutions, including RAID5, disk array striping, and Safe RAM. Database architects and designers will find invaluable technical guidance here. The book compares four major recovery algorithms for centralized DBMSs, presents stochastic models for analyzing database recovery control performance, and shows how to model buffer coherency and dirty page propagation policies.It covers virtually every approach to recovery, including compensating transactions, nested sagas, directory-based software coherency schemes, fuzzy checkpointing, update-in-place and shadow approaches, and more. Then, in four exceptionally detailed chapters, the book demonstrates advanced recovery techniques in practice, in Oracle( and other leading DBMSs. Recovery Mechanisms in Database Systems will be an essential resource for all database designers, architects, decision-makers, and advanced students in the field.