Database Systems Concepts and Design
CS6400 A, Fall 2024
Instructor: Kexin Rong
Time: Mon & Wed 5:00-6:15PM
Location: Instructional Center 211
TAs: Shreyas Kanjalkar, Rajveer Bachkaniwala, Sashankh Chengavalli Kumar
Contact: cs6400-staff@groups.gatech.edu
Office Hours
- Instructor: Wednesdays 3-4PM, KACB 3322
- TA OH1: Monday 3:30-4:30PM, common space near KACB 3322
- TA OH2: Thursday 3:30-4:30PM, common space near KACB 3322
Course Description
This course provides an advanced introduction to the use, design, and implementation of databases, focusing on relational databases. Topics include data models, schema design, data storage, indexing techniques, query processing, optimization, concurrency control, transactions, and failure recovery. These concepts are essential for organizing data effectively, ensuring efficient retrieval and management, maintaining data integrity and consistency in multi-user environments, and protecting against data loss. While this course will introduce these concepts at a high level, the implementation details will be covered more extensively in the second course CS 6422 offered by Prof. Arulraj.
What to expect
Students are expected to be comfortable programming in languages such as Python and Java. While the course will cover SQL programming, it will not provide a highly detailed introduction to the language. Those who have completed a first course in database management that covers an introduction to relational databases and programming may find some repetition of material. However, the instructor aims to provide a deeper conceptual understanding of the database area for all students, regardless of their prior experience.
Students who have sufficient undergraduate database coursework and a strong conceptual understanding of the subject matter are advised to proceed directly to CS6422, which emphasizes the inner workings of a database system and its internal system issues.
Acknowledgements
This course is adapted from prior offerings of CS6400 taught by Prof. Sham Navathe, and reference materials from the following courses: