SKKU Database Project Fall 2022
This course is mainly based on the last year's course, thanks to the contribution of Dr. An and Dr. Park.
- Instructor: Prof. Sang-Won Lee ([email protected])
- TA
- Jonghyeok Park ([email protected])
- 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 | Introduction | 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 | Introduction to buffer manager, exercise some buffer manager related parameter tuning | Bo-Hyun Lee |
| 4 | TPC-C on MySQL | Buffer manager code review, and project assignment | 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 | DBMS Space Management | Bo-Hyun Lee |
| 8 | Mid-term exam | ||
| 9 | RocksDB | Space Amplification in DBMS | Bo-Hyun Lee |
| 10 | RocksDB | Project #2 RocksDB | Bo-Hyun Lee |
| 11 | Androbench on SQLite | Introduction to SQLite and AndroBench | Jonghyeok Park |
| 12 | Androbench on SQLite | Transaction Management in SQlite | Jonghyeok Park |
| 13 | Androbench on SQLite | Logging & Recovery in SQLite | Jonghyeok Park |
| 14 | Androbench on SQLite | Project #3 SQLite | Jonghyeok Park |
| 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
- If you have any questions about this course, please contact the teaching assistant: Bo-Hyun Lee([email protected]) and Jong-Hyeok Park ([email protected]).
- You must attend Q & A session every Wednesday 18:00PM - 19:00PM at 제2과학관 32동 32255.