Database systems have become so crucial that it is difficult to think the absence of databases in application developments. In addition, database programming has become one of the basic knowledge that program developers MUST know. However, many developers simply understand and exploit the database system as a means of storing tabular data. In this lecture, students will acquire knowledge about database design techniques and the internals of the database for effective uses. In addition, a big data system for efficiently storing and utilizing a massive volume of data that is difficult to process within a single sited DBMS and how to use it will be studied.
- This course meets for in-class lecture Fri 10:00AM - 1:00PM (Seminar room No.2 at KISTI KIUM).
- For all inquiries related to this course, please contact kyongha@kisti.re.kr
This lecture will be conducted by three instructors who are involved in KISTI campus.
- Dr. Dongmin Seo(dmseo@kisti.re.kr)
- Dr. Kyong-Ha Lee(kyongha@kisti.re.kr)
- Dr. Kyongseok Park(gspark@kisti.re.kr)
- Fri. 10:00 AM ~ 1:00PM
- Due to the spread of COVID 19 virus, some lectures may be held online.
- Book: Database System Concepts(7th edition) by Avi Silberschatz et al.(but not mandatory)
- All slides for this class will be available here.
- All course announcements take place though this page. Please check this page frequently.
- This course has the following components:
- In-class lecture (3H) (attendance 20%)
- 3 Homeworks (30%)
- A final exam(50%)
| Event | Date | In-class lecture | Materials and Assignments | Instructor |
|---|---|---|---|---|
| Lecture 1 | 03/04 |
|
None | Dongmin Seo |
| Lecture 2 | 03/11 | Database modeling(2) | None | Dongmin Seo |
| Lecture 3 | 03/18 | Database modeling(3) | None | Dongmin Seo |
| Lecture 4 | 03/25 | Database language: SQL(1) | None | Dongmin Seo |
| Lecture 5 | 04/01 | Database language: SQL(2) | Assignment 1 | Dongmin Seo |
| Lecture 6 | 04/08 | Database language: SQL(3) | None | Dongmin Seo |
| Lecture 7 | 04/15 | Storage systems & Data Storage Structure(Zoom) | None | Kyong-Ha Lee |
| Lecture 8 | 04/22 | Index mechanisms (Zoom) | None | Kyong-Ha Lee |
| Lecture 9 | 04/29 | Query processing and Optimimzation (Zoom) | None | Kyong-Ha Lee |
| Lecture 10 | 05/06 | Transactions and Concurrency Control (Zoom) | None | Kyong-Ha Lee |
| Lecture 11 | 05/13 | Recovery system (Zoom) | Assignment 2 | Kyong-Ha Lee |
| Lecture 12 | 05/20 | Big data techniques: Overview and Theories | None | Kyongseok Park |
| Lecture 13 | 05/27 | Hadoop and Spark | None | Kyongseok Park |
| Lecture 14 | 06/03 | No SQL systems | Assignment 3 | Kyongseok Park |
| Lecture 15 | 06/10 | Advances in Bigdata systems | None | Kyongseok Park |
| Lecture 16 | 06/17 | Final exam | None | Kyongseok Park |