SKKU Database Project Spring 2023
- Instructor: Prof. Sang-Won Lee ([email protected])
- TA: Bo-Hyun Lee ([email protected])
Almost every important computer application must manage, update, and query databases using a database system(s) that best fits its workload. In this course, you will learn the three most popular database systems and their major workloads:
- MySQL and TPC-C (OLTP workload)
- RocksDB and YCSB (Key-value store workload)
- SQLite and AndroBench (Mobile workload)
From these three projects, you can learn how each database system works and understand the characteristics of popular workloads. You can also learn how to measure key (performance-related) metrics and analyze their impacts on performance.
| Week # | Topic | Contents | TA |
|---|---|---|---|
| 1 | Install TPC-C and MySQL | Bo-Hyun Lee | |
| 2 | TPC-C on MySQL | Load & run TPC-C, measure tpmC, and key metrics and analyze the results | Bo-Hyun Lee |
| 3 | TPC-C on MySQL | Measuring buffer hit rate while varying the buffer size | Bo-Hyun Lee |
| 4 | TPC-C on MySQL | Quantifying the cost of single page flush | Bo-Hyun Lee |
| 5 | TPC-C on MySQL | Project #1 MySQL | Bo-Hyun Lee |
| 6 | RocksDB | Introduction to RocksDB and DBBench | Bo-Hyun Lee |
| 7 | RocksDB | RocksDB Compaction Styles | Bo-Hyun Lee |
| 8 | Mid-term exam | ||
| 9 | RocksDB | PA2: Space Amplification in RocksDB | Bo-Hyun Lee |
| 10 | RocksDB | RocksDB Compaction Details | Bo-Hyun Lee |
| 11 | Androbench on SQLite | SQLite and Androbench Installation Guide | Bo-Hyun Lee |
| 12 | Androbench on SQLite | Transaction Management in SQLite | Bo-Hyun Lee |
| 13 | Androbench on SQLite | Journal Modes in SQLite | Bo-Hyun Lee |
| 14 | Androbench on SQLite | WAL and Checkpoint in SQLite | Bo-Hyun Lee |
| 15 | Final exam |
- Lecture video and experiment guide uploaded every Monday: recommend you to watch the videos before Wednesday
- Offline Q&A lab every Wednesday: Ask questions and try to end the experiments during that time
- Submit 2-page report before Sunday. Report format: Link
- If you have any questions about this course, please contact the teaching assistant: Bo-Hyun Lee ([email protected]).
- You must attend Q & A session every Wednesday 18:00PM - 19:00PM at 제2공학관, 2nd Engineering building, 26515.