# CMU 15-445/645 :: Intro to Database Systems (Fall 2025) https://15445.courses.cs.cmu.edu/fall2025/ [![](https://15445.courses.cs.cmu.edu/fall2025/images/cmudb-icon-white.svg) CMU 15-445/645](https://15445.courses.cs.cmu.edu/fall2025 "CMU 15-445/645") * [Assignments](https://15445.courses.cs.cmu.edu/fall2025/assignments.html) * [FAQ](https://15445.courses.cs.cmu.edu/fall2025/faq.html) * [Schedule](https://15445.courses.cs.cmu.edu/fall2025/schedule.html) * [Syllabus](https://15445.courses.cs.cmu.edu/fall2025/syllabus.html) * [ Youtube](https://www.youtube.com/playlist?list=PLSE8ODhjZXjYMAgsGH-GtY5rJYZ6zjsd5 "Youtube") * [ Piazza](https://piazza.com/cmu/fall2025/15445645 "Piazza") # Database Systems ## CMU 15-445/645 ## Fall 2025 ## CMU 15-445/645 ## Fall 2025 ## Fall 2025 [ **NOTICE:** This is an archived version of the course. Click here to view the latest offering. ](https://15445.courses.cs.cmu.edu/ "View latest version of 15-445/645") ## 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 ](https://maps.app.goo.gl/8jiEATjcUw1hkQTx5) Textbook: [DB System Concepts (7th Ed.) ](https://www.db-book.com/) Discussion: [Piazza](https://piazza.com/cmu/fall2025/15445645) #### Acknowledgements Thanks to the following organizations for their support towards course development as part of the [CMU-DB Affiliates Program](https://db.cs.cmu.edu/affiliates/). [![](https://15445.courses.cs.cmu.edu/fall2025/images/sponsors/clickhouse.svg)](https://clickhouse.com/ "ClickHouse \(Sponsor\)") [![](https://15445.courses.cs.cmu.edu/fall2025/images/sponsors/datastax.svg)](https://www.datastax.com/ "DataStax \(Sponsor\)") [![](https://15445.courses.cs.cmu.edu/fall2025/images/sponsors/dbt.svg)](https://www.getdbt.com/ "dbt \(Sponsor\)") [![](https://15445.courses.cs.cmu.edu/fall2025/images/sponsors/firebolt.svg)](https://www.firebolt.io/ "Firebolt \(Sponsor\)") [![](https://15445.courses.cs.cmu.edu/fall2025/images/sponsors/motherduck.svg)](https://www.motherduck.com/ "MotherDuck \(Sponsor\)") [![](https://15445.courses.cs.cmu.edu/fall2025/images/sponsors/relationalai.svg)](https://relational.ai/ "RelationalAI \(Sponsor\)") [![](https://15445.courses.cs.cmu.edu/fall2025/images/sponsors/singlestore.svg)](https://www.singlestore.com/ "SingleStore \(Sponsor\)") [![](https://15445.courses.cs.cmu.edu/fall2025/images/sponsors/spiraldb.svg)](https://spiraldb.com/ "SpiralDB \(Sponsor\)") [![](https://15445.courses.cs.cmu.edu/fall2025/images/sponsors/tidb.svg)](https://www.pingcap.com/ "TiDB \(Sponsor\)") [![](https://15445.courses.cs.cmu.edu/fall2025/images/sponsors/yellowbrick.svg)](https://yellowbrick.com/ "Yellowbrick \(Sponsor\)") [![](https://15445.courses.cs.cmu.edu/fall2025/images/sponsors/yugabyte.svg)](https://www.yugabyte.com/ "Yugabyte \(Sponsor\)") * ![](https://15445.courses.cs.cmu.edu/fall2025/images/award5.svg) * ![](https://15445.courses.cs.cmu.edu/fall2025/images/award4.svg) * ![](https://15445.courses.cs.cmu.edu/fall2025/images/award3.svg) * ![](https://15445.courses.cs.cmu.edu/fall2025/images/award2.svg) * ![](https://15445.courses.cs.cmu.edu/fall2025/images/award1.svg) ## Instructors | | Name | Office Hours | Location | | --- | --- | --- | --- | | [![](https://15445.courses.cs.cmu.edu/fall2025/images/people/pavlo.webp)](https://www.cs.cmu.edu/~pavlo "Andy Pavlo") | [Andy Pavlo](https://www.cs.cmu.edu/~pavlo) | Wednesday 4:00-5:00pm GHC 9019 | GHC 9019 | ## Teaching Assistants | | Name | Office Hours | Location | | --- | --- | --- | --- | | [![](https://15445.courses.cs.cmu.edu/fall2025/images/people/ruiqiwan.webp)](https://www.linkedin.com/in/ruiqi-wang-010867223/ "Ruiqi Wang") | [Ruiqi Wang](https://www.linkedin.com/in/ruiqi-wang-010867223/) | Tuesday 7:00-8:00pm GHC 5th Floor (Commons, Table 5) | GHC 5th Floor (Commons, Table 5) | | [![](https://15445.courses.cs.cmu.edu/fall2025/images/people/dfreifel.webp)](https://quantumi.sh "David Freifeld") | [David Freifeld](https://quantumi.sh) | Monday 6:00-7:00pm GHC 5th Floor (Commons, Table 5) | GHC 5th Floor (Commons, Table 5) | | [![](https://15445.courses.cs.cmu.edu/fall2025/images/people/yuqixian.webp)](https://www.linkedin.com/in/yuqi-xiang-365103248/ "Yuqi Xiang") | [Yuqi Xiang](https://www.linkedin.com/in/yuqi-xiang-365103248/) | Wednesday 10:00-11:00am GHC 5th Floor (Commons, Table 5) | GHC 5th Floor (Commons, Table 5) | | [![](https://15445.courses.cs.cmu.edu/fall2025/images/people/saransh.webp)](https://www.linkedin.com/in/saranshmalik/ "Saransh Malik") | [Saransh Malik](https://www.linkedin.com/in/saranshmalik/) | Friday 4:00-5:00pm GHC 5th Floor (Commons, Table 7) | GHC 5th Floor (Commons, Table 7) | | [![](https://15445.courses.cs.cmu.edu/fall2025/images/people/wcz2.webp)](https://17zhangw.github.io/ "William Zhang") | [William Zhang](https://17zhangw.github.io/) | Tuesday 3:00-4:00pm GHC 5th Floor (Commons, Table 1) | GHC 5th Floor (Commons, Table 1) | | [![](https://15445.courses.cs.cmu.edu/fall2025/images/people/shinyuh.webp)](https://www.linkedin.com/in/melodyyhu/ "Melody Hu") | [Melody Hu](https://www.linkedin.com/in/melodyyhu/) | Tuesday 9:30-10:30am GHC 5th Floor (Commons, Table 5) | GHC 5th Floor (Commons, Table 5) | | [![](https://15445.courses.cs.cmu.edu/fall2025/images/people/songf.webp)](https://www.linkedin.com/in/wenda-song-fu/ "Song Fu") | [Song Fu](https://www.linkedin.com/in/wenda-song-fu/) | Thursday 9:40-10:40am GHC 5th Floor (Commons, Table 5) | GHC 5th Floor (Commons, Table 5) | | [![](https://15445.courses.cs.cmu.edu/fall2025/images/people/siruih.webp)](https://www.linkedin.com/in/srhuang25/ "Sirui Huang") | [Sirui Huang](https://www.linkedin.com/in/srhuang25/) | Friday 2:00-3:00pm GHC 5th Floor (Commons, Table 7) | GHC 5th Floor (Commons, Table 7) | ## House DJ | | Name | Equipment | Playlist | | --- | --- | --- | --- | | ![](https://15445.courses.cs.cmu.edu/fall2025/images/people/dj-cache.webp) | DJ Cache | [Roland SP-404MKII](https://www.roland.com/global/products/sp-404mk2/) [ Spotify](https://15445.courses.cs.cmu.edu/fall2025/) | [ Spotify](https://15445.courses.cs.cmu.edu/fall2025/) | [![](https://15445.courses.cs.cmu.edu/fall2025/images/cmu-db-group.svg)](https://db.cs.cmu.edu "Carnegie Mellon Database Group") Archives * [Spring 2025 ](https://15445.courses.cs.cmu.edu/spring2025/ "View Previous Course Website") * [Fall 2024 ](https://15445.courses.cs.cmu.edu/fall2024/ "View Previous Course Website") * [Spring 2024 ](https://15445.courses.cs.cmu.edu/spring2024/ "View Previous Course Website") * [Fall 2023 ](https://15445.courses.cs.cmu.edu/fall2023/ "View Previous Course Website") * [Spring 2023 ](https://15445.courses.cs.cmu.edu/spring2023/ "View Previous Course Website") * [Fall 2022 ](https://15445.courses.cs.cmu.edu/fall2022/ "View Previous Course Website") * [Fall 2021 ](https://15445.courses.cs.cmu.edu/fall2021/ "View Previous Course Website") * [Fall 2020 ](https://15445.courses.cs.cmu.edu/fall2020/ "View Previous Course Website") * [Fall 2019 ](https://15445.courses.cs.cmu.edu/fall2019/ "View Previous Course Website") * [Fall 2018 ](https://15445.courses.cs.cmu.edu/fall2018/ "View Previous Course Website") * [Fall 2017 ](https://15445.courses.cs.cmu.edu/fall2017/ "View Previous Course Website")