The content is just an excerpt from the complete note for SS3 First Term Data Processing Lesson Note – Crash Recovery. Check below to download the complete DOCUMENT
WEEK FOUR
TOPIC: CRASH RECOVERY
CONTENT:
Sub-topic 1
Crash Recovery: Is the process by which the database is moved back to a consistent and usable state. This is done by rolling back incomplete transactions and completing committed transactions that were still in memory when the crash occurred.
To be able to do this, the DBMS maintains a record, called the Log, of all write to the database.
What is Log?
This is the history of actions executed by the DBMS. Physically, Log is a file of records stored in stable storage, which is assumed to survive crashes.
For recovery purposes, every page in the database contains the LSN of the most recent log record that describe a change to this page. This LSN is called the pageLSN. Every log record is given a unique ID called the Log Sequence Number (LSN).
Introduction to Aries (analysis, redo and undo)
ARIES (Algorithm for Recovery and Isolation Exploiting Semantics) is a recovery algorithm that is designed to work with a steal, no-force approach.
When the recovery manager is invoked after a crash, restart proceeds in three phases:
There three main principles behind the ARIES recovery algorithm:
To gain full access to the note: DOWNLOAD FILE
Veterinary medicine is the branch of medicine that deals with the prevention, diagnosis, and treatment…
Anthropology is the scientific study of human beings and their cultures. It encompasses a wide…
Sociology is the scientific study of human society, culture, and behavior. It examines the social…
Social Work is a profession dedicated to helping individuals, families, and communities to cope with…
Religious studies is an academic discipline that explores the beliefs, practices, and history of various…
Public administration is the field of study and practice that focuses on the organization and…