강의 정보
| 제공 | 교수 | 강의 시기 |
|---|---|---|
| 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