강의 정보
| 제공 | 교수 | 강의 시기 |
|---|---|---|
| Seoul National Univ. Graduate School of Data Science | 정형수 교수님 | 2024년 가을학 기 |
목차
이론
- 01. Overview and Relational Model
- 02. SQL
- 03. Storage (Part 1 - Page, Slot)
- 04. Storage (Part 2 - File Organization)
- 05. Storage (Part 3 - File Format)
- 06. Buffer Pool Design
- 07. Hash Tables (Part 1 - Static Hash)
- 08. Hash Tables (Part 2 - Dynamic Hash)
- 09. Tree Indexes (Part 1 - ISAM, B+Tree)
- 10. Tree Indexes (Part 2 - B+Tree Optimization, Other Data Structures)
- 11. Index Concurrency
- 12. External Sorting and Hashing
- 13. Join Algorithms
- 14. Query Execution (Part 1 - Execution)
- 15. Query Execution (Part 2 - Execution Optimization)
- 16. Query Optimization (Part 1 - Rule-based)
- 17. Query Optimization (Part 2 - Cost-based)
- 18. Transaction
- 19. Two-Phase Locking, 2PL
- 20. Timestamp Ordering Concurrency Control
- 21. Multi-Version Concurrency Control
- 22. Database Logging
- 23. Database Recovery