COMP1638 – Managing Database Storage Structures part 1 скачать в хорошем качестве

COMP1638 – Managing Database Storage Structures part 1

Alright. I’ll teach this *as your lecturer**, step-by-step, **conceptual first, then practical**, using **real-world examples* so you actually understand *how Oracle database storage works*, not just memorize terms. I’ll follow the **same flow as your lecture (COMP1638 – Managing Database Storage Structures)**. --- 1. Big Picture First (Very Important) Before details, understand **this one idea**: 👉 *An Oracle database separates LOGICAL storage from PHYSICAL storage* Think of it like this: *Logical storage* = how Oracle organizes data (conceptual) *Physical storage* = how data is actually stored on disk 📌 Users and developers mostly see *logical storage* 📌 The operating system sees *physical files* --- 2. Three-Level Architecture (Foundation Concept) What does Oracle consist of? Oracle database = *Logical structures + Physical structures* 2.1 Physical Structures (OS level) These are **real files on disk**: Data files Control files Redo log files Temp files 🧠 The *Operating System knows these* --- 2.2 Logical Structures (Oracle level) These exist **inside Oracle**, not the OS: Tablespaces Segments Extents Data blocks 🧠 ---