15-445/645 Database Systems

Frequency Offered: Generally offered every fall semester - confirm course offerings for upcoming semesters by accessing the university Schedule of Classes.

Course Relevance (who should take this course?): This course is for students interested in the design and implementation of database management systems.

• data models (relational, document, key/value)
• storage models (n-ary, decomposition)
• query languages (SQL, stored procedures)
• storage architectures (heaps, log-structured)
• indexing (order preserving trees, hash tables)
• transaction processing (ACID, concurrency control)
• recovery (logging, checkpoints), query processing (joins, sorting, aggregation, optimization)
• and parallel architectures (multi-core, distributed).

Systems Programming, C/C++

Sample class notes: not provided

Sample Assignment: not provided

• not yet provided

Sample Lecture Recording: not provided

• Not yet provided

Course Website: http://15445.courses.cs.cmu.edu/

• SQLite

• Prerequisites Required: 15-213
• Minimum Grades in Prereqs: B in 15213
• Corequisites: None
• Prerequisite for: 
• Anti-requisites: None
• Cross-Listed: 15-645
• Substitutes: By instructor consent only
• Related Courses: 15-415, 15-721
• Reservations: Some reservations are for Students in CS; Some reservations are for Students in ECE