1. CHƯƠNG 1: OVERALL INTRODUCTION TO DATABASE MANAGEMENT SYSTEMS
2. CHƯƠNG 2: DISK STORAGE AND BASIC FILE STRUCTURES
2.1. References
2.2. Other File Structures
2.3. Disk Storage
2.4. Computer Organization - Hardware
2.5. Types of storage with capacity, access time, max bandwidth, and commodity cost
2.6. Storage organization of databases
2.7. Magnetic disks
2.8. Disk Storage (a) A single-sided disk with read/write hardware. (b) A disk pack with read/write hardware.
2.9. Disk Storage Different sector organizations on disk.
2.10. Magnetic disks - disk pack, tracks, cylinders
2.11. Magnetic disks - sectors and blocks
2.12. Magnetic disks - blocks and interblock gaps
2.13. Magnetic disks - data transfer and hardware address
2.14. Magnetic disks - hard disk drive and read/write heads
2.15. Magnetic disks - disk controller and data transfer optimization
2.16. Disk parameters - block size, interblock gap, speed, seek time, etc.
2.17. Disk parameters - rotational delay
2.18. Disk parameters - block transfer time
2.19. Disk parameters - rewrite time
2.20. Disk parameters - transfer rate
2.21. Disk parameters - bulk transfer rate
2.22. Average time to find and transfer blocks
2.23. Making data access more efficient on disk - buffering and scheduling
2.24. Making data access more efficient on disk - double buffering
2.25. Making data access more efficient on disk - buffer manager and replacement strategies
2.26. File Operations - placing file records on disk
2.27. File Operations - fixed-length and variable-length records
2.28. File Operations - unspanned and spanned records
2.29. File Operations - blocking factor
2.30. File Operations - placing file blocks on disk
2.31. File Operations - representative operations
2.32. File organization and access methods
2.33. Unordered Files (Heap files) - characteristics and operations
2.34. Ordered Files (Sorted files) - characteristics and operations
3. CHƯƠNG 3: INDEXING STRUCTURES FOR FILES
4. CHƯƠNG 4: QUERY PROCESSING AND OPTIMIZATION
5. CHƯƠNG 5: INTRODUCTION TO TRANSACTION PROCESSING CONCEPTS AND THEORY
6. CHƯƠNG 6: CONCURRENCY CONTROL TECHNIQUES
7. CHƯƠNG 7: DATABASE RECOVERY TECHNIQUES
