15445.courses.cs.cmu.edu

this course is on the design and implementation of database management systems. topics include 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). case studies on open-source and commercial database systems are used to illustrate these techniques and trade-offs. the course is appropriate for students that are prepared to flex their strong systems programming skills.