Database Systems

Intro to Database Systems

You want to know whether this is the premier course at Carnegie Mellon University on the design and implementation of database management systems? Well, it is. This course rips through data models (relational, document, key/value), storage models (n-ary, decomposition), query languages (SQL, stored procedures), storage architectures (heaps, log-structured), indexes + filters (order preserving trees, hash tables, vector indexes), transaction processing (ACID, concurrency control), recovery (logging, checkpoints), query processing (joins, sorting, aggregation, optimization), and parallel architectures (multi-core, distributed). We will also use case studies on open-source and commercial database systems to illustrate these techniques and trade-offs. You should straight know that this course is appropriate for students that are ready to commit to a database-centric lifestyle and flex their systems programming skills.

Time:

Mon/Wed 2:00pm-3:20pm ET

Location:

Posner Hall A35

Textbook:

DB System Concepts (7th Ed.)

Discussion:

Piazza