Overview This course,15-445/645 Intro to Database Systems, 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 will be used to illustrate these techniques and trade-offs.
Slides PDF: https://15445.courses.cs.cmu.edu/fall2018/slides/01-introduction.pdf
Prof. Andy Pavlo (http://www.cs.cmu.edu/~pavlo/)
15-445/645 Intro to Database Systems (Fall 2018)
Carnegie Mellon University
https://15445.courses.cs.cmu.edu/fall2018
Write a public review