Storage Structure

Duration: 20 min

This video lesson is available to enrolled students.

Return to /learn/ASRB-ICAR-T3-T4-INFORMATION-TECHNOLOGY-PRELIMS-MAINS/database-management-systemdbms/database-recovery/failure-types-recovery-fundamentals/asset-storage-structure after enrolling

Inside: a video lesson and guided study material.

Module outline

  1. Prelims: General Knowledge: Physics Chemistry Biology History Geography Polity Indian Economy Static General Knowledge GK- Current Affairs Environment
  2. Prelims: General English: Vocabulary Noun Pronoun Adjectives Preposition Articles Direct and Indirect Speech Tenses Conjunction Subject Verb Agreement (Verb Noun Agreement) Modals Sentence Re-arrangements (Para Jumbles) (Narrative Sequencing) Sentence Correction (Error Correction) Sentence Completion (Fill in the blanks) Comprehension / Reading Comprehension / Unseen Passages (Critical Reasoning) (Paragraph Questions) Cloze Test (Cloze Passage) Verbal Analogy (Word Based Analogy) Sentence Construction Adverb Verb
  3. Prelims: Quantitative Aptitude: Percentage Ratio and Proportion (Ratios) HCF LCM Divisibility Rules Average Sequence and Series (Series) Number System Powers and Exponents (Surds and Indices) Algebra Profit and Loss Simple Interest and Compound Interest Time and Work Pipe and Cistern Speed Time and Distance Mixture and Alligation Mensuration and Geometry Age Problems Partnership Statistics Data Interpretation Arithmetic
  4. Prelims: General Agriculture: Agriculture in India and Tripura Natural Resource Management Fundamentals of Crop Production Horticulture Crop Improvement Crop Protection Social Science
  5. IT Mains: Operating System: Introduction to OS Process Management CPU Scheduling Process Synchronization Threads & Process Creation Deadlock Memory Management Virtual Memory Disc Scheduling File Management Distributed Systems
  6. IT Mains: Computer Networking: Introduction to CN DLL: Access Control DLL: Flow Control DLL: Error Control Data Link Layer - Ethernet Net Layer: IPv4 & Proto Net Layer: IP Addressing Net Layer:Routing Protocol Transport Layer Services TL: Congestion & UDP Application Layer Hardware Basics Network Security
  7. IT Mains: DBMS: Basics of DBMS ER Diagram Relational Model & Functional Dependencies Keys & Integrity Constraints Normalization (1NF - BCNF) Decomposition Properties & 4NF Relational Algebra SQL Relational Calculus Transaction Management Concurrency Control Database Recovery Big Data Systems Database Security & Authorization Enhanced Data Models NoSQL
  8. IT Mains: Software Engineering: Fundamentals of Software Engineering Software Requirements and Quality Assurance Software Design, Estimation and Metrics Software Testing Software Maintenance and Configuration Management
  9. IT Mains: Data Structures & Algorithms: Introduction to DS Array Stack Queue Linked List Tree Graphs Hashing Algorithm Analysis Time Complexity Analysis Sorting Algorithms
  10. IT Mains: OOPS with C++ & Java: C Fundamentals OOPS with C++ Java Fundamentals Array, String, IO & References OOPS with Java Generic & Collections Multithreading File Handling & I/O
  11. IT Mains: Python: Introduction to Python Tokens, Variables, Data Types, I/O Operators & Expressions Control Flow & Looping Collections & Strings Functions & Modules
  12. IT Mains: Website Development: Website, Browser & Services Internet Fundamentals Web Design & Development Protocols & Services Web Publishing & Hosting Server Side & Security Emerging Technologies HTML Basics HTML5 CSS JavaScript-Basics .Net Programming PHP
  13. IT Mains: Mobile App Development: Mobile Computing Multimedia
  14. IT Mains: Linux / Windows Server Admin: Unix OS Linux OS
AI summary & chapters

AI Summary

An AI-generated summary of this video lecture.

The video presents a lecture on storage structures and recovery approaches in database systems. It begins by defining three types of storage: volatile storage, which is lost on system crash (e.g., main memory); nonvolatile storage, which survives crashes (e.g., disk, flash memory); and stable storage, a theoretical concept that survives all failures by maintaining multiple copies on distinct media. The lecture then transitions to recovery approaches, explaining the steal and no-steal methods, which determine when updated cache pages are written to disk relative to transaction commit, and the force and no-force methods, which determine if writes are immediate upon commit. The final section details the implementation of stable storage, emphasizing the need to maintain multiple copies on separate disks, often at remote sites, to protect against disasters. It discusses the risks of data transfer failure, which can lead to inconsistent copies, and outlines a recovery strategy: first, identify inconsistent blocks by comparing copies, and then resolve the inconsistency by overwriting the incorrect copy with the correct one, a method used in hardware RAID systems.

Chapters

  1. 0:00 – 2:00 00:00-02:00

    The video opens with a slide titled "Storage Structure". It defines three types of storage. 1. Volatile storage: does not survive system crashes, examples include main memory and cache memory. 2. Nonvolatile storage: survives system crashes, examples include disk, tape, flash memory, and battery-backed-up RAM. 3. Stable storage: described as a mythical form of storage that survives all failures, approximated by maintaining multiple copies on distinct nonvolatile media. The instructor uses a yellow highlighter to emphasize key terms like "volatile storage", "nonvolatile storage", and "stable storage" on the slide.

  2. 2:00 – 5:00 02:00-05:00

    The slide changes to "Recovery approaches". The instructor explains four methods. 1. Steal approach: cache pages updated by a transaction can be written to disk before the transaction commits. 2. No-steal approach: cache pages cannot be written to disk before the transaction commits. 3. Force approach: when a transaction commits, all updated pages are immediately written to disk. 4. No-force approach: when a transaction commits, updated pages are not immediately written to disk. A diagram on the left shows the flow from CPU to cache to main memory to disk, with handwritten annotations like "before" and "after" to illustrate the steal and no-steal concepts. The instructor also draws a diagram at the bottom for "Cache Page Replacement" and "Write Back".

  3. 5:00 – 10:00 05:00-10:00

    The video returns to the "Storage Structure" slide, where the instructor continues to highlight key terms. The focus is on the definition of stable storage, which is described as a "mythical form of storage that survives all failures". The instructor emphasizes that this is approximated by maintaining multiple copies on distinct nonvolatile media. The slide also lists examples of nonvolatile storage, including disk, tape, flash memory, and non-volatile (battery-backed up) RAM. The instructor uses a yellow highlighter to underline and circle important words like "volatile", "nonvolatile", and "stable".

  4. 10:00 – 15:00 10:00-15:00

    The slide changes to "Stable-Storage Implementation". The instructor explains that to implement stable storage, multiple copies of each block are maintained on separate disks, which can be at remote sites to protect against disasters like fire or flooding. The slide then discusses failure during data transfer, which can result in inconsistent copies. It lists three outcomes: successful completion, partial failure (destination block has incorrect information), and total failure (destination block was never updated). The instructor emphasizes the need for a recovery procedure to restore the block to a consistent state if a data-transfer failure occurs.

  5. 15:00 – 19:39 15:00-19:39

    The final slide, titled "Protecting storage media from failure during data transfer", outlines a procedure for executing an output operation with two copies of each block. The steps are: 1. Write the information to the first physical block. 2. When the first write successfully completes, write the same information to the second physical block. 3. The output is completed only after the second write successfully completes. The instructor draws a diagram showing two sites, Site 1 and Site 2, with a write operation. The slide then explains how to recover from failure: first, find inconsistent blocks by comparing the two copies of every disk block. It presents an expensive solution (comparing all blocks) and a better solution (recording in-progress writes in non-volatile storage, like NVRAM, to only compare potentially inconsistent blocks). The final step is to overwrite the inconsistent copy with the correct one.

The lecture systematically builds a conceptual framework for reliable data storage. It starts by classifying storage types based on their resilience to failure, from volatile to the theoretical ideal of stable storage. This foundation leads to the practical discussion of recovery approaches, which are the mechanisms used to ensure data consistency in the face of system crashes. The core of the lesson is the implementation of stable storage, which is presented as a solution to the problem of data loss during a write operation. The video demonstrates that this is achieved not through a single magical technology, but through a robust, multi-step process involving redundancy, careful sequencing of writes, and a well-defined recovery protocol to handle the inevitable failures that occur during data transfer.

Loading lesson…