This is the first post, and I wrote this as a review of the lectures I learned last semester.
Overall, English is not good and there will be many grammatical errors.
English writing practice is also part of writing this blog. So, I hope everyone who reads this article understands.
Table of Contents
Reference
- I took the database system in 2021-fall, Hanyang Univ. ITE2038 taught by Prof. Hyungsoo Jung. Most of the content will be based on this lecture.
- Also, some of the materials from CS186, UC Berkeley can be utilized.
- Textbook is Database Management Systems, 3rd Edition, by Ramakrishnan and Gehrke
Contents
I will not deal with sql, but will develop the contents according to the layered architecture of DBMSHow is a SQL query executed.
But I didn’t fully understand the query optimization and relational operations. So I won’t cover or mention it last.
- Disk Space Management
- Translate page requests into physical bytes on one or more device(s).
- Buffer Management
- providee the illusion of operating in memory
- File and Index Management
- Organize tables and Records as groups of pages in a logical file
- Concurrency Control(Transaction)
- storage and memory management
- Recovery Protocol
- storage and memory management
- Others…(add later)
I will provide simple codes used in the project of the course I took. Although it’s not perfect code, it’s good enough for some examples.
In the next post, I will explain the basics of layered architecture and disk space management.
Relative Post
- This post!
- [DataBase Systems] Disk Space Management
- Add more…