Weaviate: An Architectural Deep Dive (Etienne Dilocker) CMU Database Group 2023-10-08 | CMU Database Group - ML⇄DB Seminar Series (2023)Speakers: Etienne Dilocker (Weaviate)October 2, 2023https://db.cs.cmu.edu/seminar2023/#db4Sponsors:Google DAPA Team (google.com)
S2024 #22 - Amazon Redshift Data Warehouse System (CMU Advanced Database Systems) CMU Database Group 2024-04-25 | Andy Pavlo (https://www.cs.cmu.edu/~pavlo/)Slides: https://15721.courses.cs.cmu.edu/spring2024/slides/22-redshift.pdfNotes: https://15721.courses.cs.cmu.edu/spring2024/notes/22-redshift.pdf15-721 Advanced Database Systems (Spring 2024)Carnegie Mellon Universityhttps://15721.courses.cs.cmu.edu/spring2024/
S2024 #21 - Yellowbrick Data Warehouse System (CMU Advanced Database Systems) CMU Database Group 2024-04-23 | Andy Pavlo (https://www.cs.cmu.edu/~pavlo/)Slides: https://15721.courses.cs.cmu.edu/spring2024/slides/21-yellowbrick.pdfNotes: https://15721.courses.cs.cmu.edu/spring2024/notes/21-yellowbrick.pdf15-721 Advanced Database Systems (Spring 2024)Carnegie Mellon Universityhttps://15721.courses.cs.cmu.edu/spring2024/
S2024 #20 - DuckDB Embedded Database System (CMU Advanced Database Systems) CMU Database Group 2024-04-18 | Andy Pavlo (https://www.cs.cmu.edu/~pavlo/)Slides: https://15721.courses.cs.cmu.edu/spring2024/slides/20-duckdb.pdfNotes: https://15721.courses.cs.cmu.edu/spring2024/notes/20-duckdb.pdf15-721 Advanced Database Systems (Spring 2024)Carnegie Mellon Universityhttps://15721.courses.cs.cmu.edu/spring2024/
S2024 #19 - Snowflake Data Warehouse Internals (CMU Advanced Database Systems) CMU Database Group 2024-04-16 | Andy Pavlo (https://www.cs.cmu.edu/~pavlo/)Slides: https://15721.courses.cs.cmu.edu/spring2024/slides/19-snowflake.pdfNotes: https://15721.courses.cs.cmu.edu/spring2024/notes/19-snowflake.pdf15-721 Advanced Database Systems (Spring 2024)Carnegie Mellon Universityhttps://15721.courses.cs.cmu.edu/spring2024/
S2024 #18 - Databricks Photon / Spark SQL (CMU Advanced Database Systems) CMU Database Group 2024-04-11 | Andy Pavlo (https://www.cs.cmu.edu/~pavlo/)Slides: https://15721.courses.cs.cmu.edu/spring2024/slides/18-databricks.pdfNotes: https://15721.courses.cs.cmu.edu/spring2024/notes/18-databricks.pdf15-721 Advanced Database Systems (Spring 2024)Carnegie Mellon Universityhttps://15721.courses.cs.cmu.edu/spring2024/
S2024 #17 - Google BigQuery / Dremel (CMU Advanced Database Systems) CMU Database Group 2024-04-09 | Andy Pavlo (https://www.cs.cmu.edu/~pavlo/)Slides: https://15721.courses.cs.cmu.edu/spring2024/slides/17-bigquery.pdfNotes: https://15721.courses.cs.cmu.edu/spring2024/notes/17-bigquery.pdf15-721 Advanced Database Systems (Spring 2024)Carnegie Mellon Universityhttps://15721.courses.cs.cmu.edu/spring2024/
S2024 #15 - Query Optimizer Implementation 3 (CMU Advanced Database Systems) CMU Database Group 2024-04-03 | Andy Pavlo (https://www.cs.cmu.edu/~pavlo/)Slides: https://15721.courses.cs.cmu.edu/spring2024/slides/15-optimizer3.pdfNotes: https://15721.courses.cs.cmu.edu/spring2024/notes/15-optimizer3.pdf15-721 Advanced Database Systems (Spring 2024)Carnegie Mellon Universityhttps://15721.courses.cs.cmu.edu/spring2024/
S2024 #14 - Query Optimizer Implementation 2 (CMU Advanced Database Systems) CMU Database Group 2024-03-21 | Andy Pavlo (https://www.cs.cmu.edu/~pavlo/)Slides: https://15721.courses.cs.cmu.edu/spring2024/slides/14-optimizer2.pdfNotes: https://15721.courses.cs.cmu.edu/spring2024/notes/14-optimizer2.pdf15-721 Advanced Database Systems (Spring 2024)Carnegie Mellon Universityhttps://15721.courses.cs.cmu.edu/spring2024/
S2024 #13 - Query Optimizer Implementation 1 (CMU Advanced Database Systems) CMU Database Group 2024-03-19 | Andy Pavlo (https://www.cs.cmu.edu/~pavlo/)Slides: https://15721.courses.cs.cmu.edu/spring2024/slides/13-optimizer1.pdfNotes: https://15721.courses.cs.cmu.edu/spring2024/notes/13-optimizer1.pdf15-721 Advanced Database Systems (Spring 2024)Carnegie Mellon Universityhttps://15721.courses.cs.cmu.edu/spring2024/
S2024 #12 - Database Networking Protocols (CMU Advanced Database Systems) CMU Database Group 2024-03-14 | Andy Pavlo (https://www.cs.cmu.edu/~pavlo/)Slides: https://15721.courses.cs.cmu.edu/spring2024/slides/12-networking.pdfNotes: https://15721.courses.cs.cmu.edu/spring2024/notes/12-networking.pdf15-721 Advanced Database Systems (Spring 2024)Carnegie Mellon Universityhttps://15721.courses.cs.cmu.edu/spring2024/
S2024 #11 - User-Defined Function Optimizations (CMU Advanced Database Systems) CMU Database Group 2024-03-12 | Andy Pavlo (https://www.cs.cmu.edu/~pavlo/)Slides: https://15721.courses.cs.cmu.edu/spring2024/slides/11-udfs.pdfNotes: https://15721.courses.cs.cmu.edu/spring2024/notes/11-udfs.pdf15-721 Advanced Database Systems (Spring 2024)Carnegie Mellon Universityhttps://15721.courses.cs.cmu.edu/spring2024/
S2024 #10 - Multi-Way Join Algorithms / Worst-Case Optimal Joins (CMU Advanced Database Systems) CMU Database Group 2024-02-27 | Andy Pavlo (https://www.cs.cmu.edu/~pavlo/)Slides: https://15721.courses.cs.cmu.edu/spring2024/slides/10-multiwayjoins.pdfNotes: https://15721.courses.cs.cmu.edu/spring2024/notes/10-multiwayjoins.pdf15-721 Advanced Database Systems (Spring 2024)Carnegie Mellon Universityhttps://15721.courses.cs.cmu.edu/spring2024/
S2024 #09 - Parallel Hash Join Algorithms (CMU Advanced Database Systems) CMU Database Group 2024-02-22 | Andy Pavlo (https://www.cs.cmu.edu/~pavlo/)Slides: https://15721.courses.cs.cmu.edu/spring2024/slides/09-hashjoins.pdfNotes: https://15721.courses.cs.cmu.edu/spring2024/notes/09-hashjoins.pdf15-721 Advanced Database Systems (Spring 2024)Carnegie Mellon Universityhttps://15721.courses.cs.cmu.edu/spring2024/
S2024 #08 - Query Scheduling & Coordination (CMU Advanced Database Systems) CMU Database Group 2024-02-20 | Andy Pavlo (https://www.cs.cmu.edu/~pavlo/)Slides: https://15721.courses.cs.cmu.edu/spring2024/slides/08-scheduling.pdfNotes: https://15721.courses.cs.cmu.edu/spring2024/notes/08-scheduling.pdf15-721 Advanced Database Systems (Spring 2024)Carnegie Mellon Universityhttps://15721.courses.cs.cmu.edu/spring2024/
S2024 #07 - JIT Query Compilation & Code Generation (CMU Advanced Database Systems) CMU Database Group 2024-02-15 | Andy Pavlo (https://www.cs.cmu.edu/~pavlo/)Slides: https://15721.courses.cs.cmu.edu/spring2024/slides/07-compilation.pdfNotes: https://15721.courses.cs.cmu.edu/spring2024/notes/07-compilation.pdf15-721 Advanced Database Systems (Spring 2024)Carnegie Mellon Universityhttps://15721.courses.cs.cmu.edu/spring2024/
S2024 #06 - Vectorized Query Execution Using SIMD (CMU Advanced Database Systems) CMU Database Group 2024-02-13 | Andy Pavlo (https://www.cs.cmu.edu/~pavlo/)Slides: https://15721.courses.cs.cmu.edu/spring2024/slides/06-vectorization.pdfNotes: https://15721.courses.cs.cmu.edu/spring2024/notes/06-vectorization.pdf15-721 Advanced Database Systems (Spring 2024)Carnegie Mellon Universityhttps://15721.courses.cs.cmu.edu/spring2024/
S2024 #05 - Query Execution & Processing Part 2 (CMU Advanced Database Systems) CMU Database Group 2024-02-08 | Andy Pavlo (https://www.cs.cmu.edu/~pavlo/)Slides: https://15721.courses.cs.cmu.edu/spring2024/slides/05-execution2.pdfNotes: https://15721.courses.cs.cmu.edu/spring2024/notes/05-execution2.pdf15-721 Advanced Database Systems (Spring 2024)Carnegie Mellon Universityhttps://15721.courses.cs.cmu.edu/spring2024/
S2024 #04 - Query Execution & Processing Part 1 (CMU Advanced Database Systems) CMU Database Group 2024-02-06 | Andy Pavlo (https://www.cs.cmu.edu/~pavlo/)Slides: https://15721.courses.cs.cmu.edu/spring2024/slides/04-execution1.pdfNotes: https://15721.courses.cs.cmu.edu/spring2024/notes/04-execution1.pdf15-721 Advanced Database Systems (Spring 2024)Carnegie Mellon Universityhttps://15721.courses.cs.cmu.edu/spring2024/
S2024 #03 - Data Formats & Encoding Part 2 (CMU Advanced Database Systems) CMU Database Group 2024-01-30 | Andy Pavlo (https://www.cs.cmu.edu/~pavlo/)Slides: https://15721.courses.cs.cmu.edu/spring2024/slides/03-data2.pdfNotes: https://15721.courses.cs.cmu.edu/spring2024/notes/03-data2.pdf15-721 Advanced Database Systems (Spring 2024)Carnegie Mellon Universityhttps://15721.courses.cs.cmu.edu/spring2024/
S2024 #02 - Data Formats & Encoding Part 1 (CMU Advanced Database Systems) CMU Database Group 2024-01-25 | Andy Pavlo (https://www.cs.cmu.edu/~pavlo/)Slides: https://15721.courses.cs.cmu.edu/spring2024/slides/02-data1.pdfNotes: https://15721.courses.cs.cmu.edu/spring2024/notes/02-data1.pdf15-721 Advanced Database Systems (Spring 2024)Carnegie Mellon Universityhttps://15721.courses.cs.cmu.edu/spring2024/
S2024 #01 - Modern OLAP Database Systems (CMU Advanced Database Systems) CMU Database Group 2024-01-23 | Andy Pavlo (https://www.cs.cmu.edu/~pavlo/)Slides: https://15721.courses.cs.cmu.edu/spring2024/slides/01-modernolap.pdfNotes: https://15721.courses.cs.cmu.edu/spring2024/notes/01-modernolap.pdf15-721 Advanced Database Systems (Spring 2024)Carnegie Mellon Universityhttps://15721.courses.cs.cmu.edu/spring2024/
S2024 #00 - Course Overview & Logistics (CMU Advanced Database Systems) CMU Database Group 2024-01-18 | Andy Pavlo (https://www.cs.cmu.edu/~pavlo/)Slides: https://15721.courses.cs.cmu.edu/spring2024/slides/00-introduction.pdf15-721 Advanced Database Systems (Spring 2024)Carnegie Mellon Universityhttps://15721.courses.cs.cmu.edu/spring2024/
F2023 #25 - Potpourri: Redis, CockroachDB, Snowflake, MangoDB, TabDB (CMU Intro to Database Systems) CMU Database Group 2023-12-07 | Andy Pavlo (https://www.cs.cmu.edu/~pavlo/)Slides: https://15445.courses.cs.cmu.edu/fall2023/slides/25-potpourri.pdf15-445/645 Intro to Database Systems (Fall 2023)Carnegie Mellon Universityhttps://15445.courses.cs.cmu.edu/fall2023/
F2023 #24 - SingleStore Database Overview (CMU Intro to Database Systems) CMU Database Group 2023-12-05 | Guest Speaker: Cheng Chen (linkedin.com/in/cheng-ch)Slides: https://15445.courses.cs.cmu.edu/fall2023/slides/24-singlestore.pdf15-445/645 Intro to Database Systems (Fall 2023)Carnegie Mellon Universityhttps://15445.courses.cs.cmu.edu/fall2023/
F2023 #23 - Distributed Data Warehouse OLAP Databases (CMU Intro to Database Systems) CMU Database Group 2023-11-30 | Andy Pavlo (https://www.cs.cmu.edu/~pavlo/)Slides: https://15445.courses.cs.cmu.edu/fall2023/slides/23-distributedolap.pdfNotes: https://15445.courses.cs.cmu.edu/fall2023/notes/23-distributedolap.pdf15-445/645 Intro to Database Systems (Fall 2023)Carnegie Mellon Universityhttps://15445.courses.cs.cmu.edu/fall2023/
Chroma Vector Database: Retrieval for LLMs (Hammad Bashir + Liquan Pei) CMU Database Group 2023-11-28 | CMU Database Group - ML⇄DB Seminar Series (2023)Speakers: Hammad Bashir + Liquan Pei (Chroma)November 20, 2023https://db.cs.cmu.edu/seminar2023/#db12Sponsors:Google DAPA Team (google.com)
F2023 #22 - Distributed Transaction Processing Databases (CMU Intro to Database Systems) CMU Database Group 2023-11-28 | Andy Pavlo (https://www.cs.cmu.edu/~pavlo/)Slides: https://15445.courses.cs.cmu.edu/fall2023/slides/22-distributedoltp.pdfNotes: https://15445.courses.cs.cmu.edu/fall2023/notes/22-distributedoltp.pdf15-445/645 Intro to Database Systems (Fall 2023)Carnegie Mellon Universityhttps://15445.courses.cs.cmu.edu/fall2023/
pgvector: Stylish Hierarchical Navigable Small World Indexes (Jonathan Katz) CMU Database Group 2023-11-21 | CMU Database Group - ML⇄DB Seminar Series (2023)Speakers: Jonathan Katz (Amazon / PostgreSQL)November 20, 2023https://db.cs.cmu.edu/seminar2023/#db11Sponsors:Google DAPA Team (google.com)
F2023 #21 - Intro to Distributed Databases (CMU Intro to Database Systems) CMU Database Group 2023-11-21 | Andy Pavlo (https://www.cs.cmu.edu/~pavlo/)Slides: https://15445.courses.cs.cmu.edu/fall2023/slides/21-distributed.pdfNotes: https://15445.courses.cs.cmu.edu/fall2023/notes/21-distributed.pdf15-445/645 Intro to Database Systems (Fall 2023)Carnegie Mellon Universityhttps://15445.courses.cs.cmu.edu/fall2023/
F2023 #20 - Database Recovery (CMU Intro to Database Systems) CMU Database Group 2023-11-16 | Jignesh Patel (jigneshpatel.org)Slides: https://15445.courses.cs.cmu.edu/fall2023/slides/20-recovery.pdfNotes: https://15445.courses.cs.cmu.edu/fall2023/notes/20-recovery.pdf15-445/645 Intro to Database Systems (Fall 2023)Carnegie Mellon Universityhttps://15445.courses.cs.cmu.edu/fall2023/
Alibaba: Domain Knowledge Augmented AI for Databases (Jian Tan) CMU Database Group 2023-11-14 | CMU Database Group - ML⇄DB Seminar Series (2023)Speakers: Jian Tan (Alibaba)November 13, 2023https://db.cs.cmu.edu/seminar2023/#db10Sponsors:Google DAPA Team (google.com)
F2023 #19 - Database Logging (CMU Intro to Database Systems) CMU Database Group 2023-11-14 | Jignesh Patel (jigneshpatel.org)Slides: https://15445.courses.cs.cmu.edu/fall2023/slides/19-logging.pdfNotes: https://15445.courses.cs.cmu.edu/fall2023/notes/19-logging.pdf15-445/645 Intro to Database Systems (Fall 2023)Carnegie Mellon Universityhttps://15445.courses.cs.cmu.edu/fall2023/
Milvus: A Purpose-Built Vector Data Management System! (Li Liu) CMU Database Group 2023-11-10 | CMU Database Group - ML⇄DB Seminar Series (2023)Speakers: Li Liu (Zilliz / Milvus)November 6, 2023https://db.cs.cmu.edu/seminar2023/#db9Sponsors:Google DAPA Team (google.com)
F2023 #18 - Multi-Version Concurrency Control (CMU Intro to Database Systems) CMU Database Group 2023-11-09 | Jignesh Patel (jigneshpatel.org)Slides: https://15445.courses.cs.cmu.edu/fall2023/slides/18-multiversioning.pdfNotes: https://15445.courses.cs.cmu.edu/fall2023/notes/18-multiversioning.pdf15-445/645 Intro to Database Systems (Fall 2023)Carnegie Mellon Universityhttps://15445.courses.cs.cmu.edu/fall2023/
F2023 #17 - Timestamp Ordering Concurrency Control (CMU Intro to Database Systems) CMU Database Group 2023-11-07 | Jignesh Patel (jigneshpatel.org)Slides: https://15445.courses.cs.cmu.edu/fall2023/slides/17-timestampordering.pdfNotes: https://15445.courses.cs.cmu.edu/fall2023/notes/17-timestampordering.pdf15-445/645 Intro to Database Systems (Fall 2023)Carnegie Mellon Universityhttps://15445.courses.cs.cmu.edu/fall2023/
F2023 #16 - Two-Phase Locking Concurrency Control (CMU Intro to Database Systems) CMU Database Group 2023-11-02 | Jignesh Patel (jigneshpatel.org)Slides: https://15445.courses.cs.cmu.edu/fall2023/slides/16-twophaselocking.pdfNotes: https://15445.courses.cs.cmu.edu/fall2023/notes/16-twophaselocking.pdf15-445/645 Intro to Database Systems (Fall 2023)Carnegie Mellon Universityhttps://15445.courses.cs.cmu.edu/fall2023/
Akamas: Autonomous Performance Optimization (Stefano Cereda) CMU Database Group 2023-11-01 | CMU Database Group - ML⇄DB Seminar Series (2023)Speakers: Stefano Cereda (Akamas)October 30, 2023https://db.cs.cmu.edu/seminar2023/#db8Sponsors:Google DAPA Team (google.com)
F2023 #15 - Concurrency Control Theory (CMU Intro to Database Systems) CMU Database Group 2023-10-31 | Jignesh Patel (jigneshpatel.org)Slides: https://15445.courses.cs.cmu.edu/fall2023/slides/15-concurrencycontrol.pdfNotes: https://15445.courses.cs.cmu.edu/fall2023/notes/15-concurrencycontrol.pdf15-445/645 Intro to Database Systems (Fall 2023)Carnegie Mellon Universityhttps://15445.courses.cs.cmu.edu/fall2023/
Lance: A Modern Columnar Data Format (Chang She) CMU Database Group 2023-10-27 | CMU Database Group - ML⇄DB Seminar Series (2023)Speakers: Chang She (LanceDB)October 23, 2023https://db.cs.cmu.edu/seminar2023/#db7Sponsors:Google DAPA Team (google.com)
F2023 #14 - Query Planning & Optimization (CMU Intro to Database Systems) CMU Database Group 2023-10-26 | Jignesh Patel (jigneshpatel.org)Slides: https://15445.courses.cs.cmu.edu/fall2023/slides/14-optimization.pdfNotes: https://15445.courses.cs.cmu.edu/fall2023/notes/14-optimization.pdf15-445/645 Intro to Database Systems (Fall 2023)Carnegie Mellon Universityhttps://15445.courses.cs.cmu.edu/fall2023/
F2023 #13 - Query Execution Part 2 (CMU Intro to Database Systems) CMU Database Group 2023-10-24 | Jignesh Patel (jigneshpatel.org)Slides: https://15445.courses.cs.cmu.edu/fall2023/slides/13-queryexecution2.pdfNotes: https://15445.courses.cs.cmu.edu/fall2023/notes/13-queryexecution2.pdf15-445/645 Intro to Database Systems (Fall 2023)Carnegie Mellon Universityhttps://15445.courses.cs.cmu.edu/fall2023/
FeatureBase: A Deep Dive (Pat OKeeffe) CMU Database Group 2023-10-17 | CMU Database Group - ML⇄DB Seminar Series (2023)Speakers: Pat O'Keeffe (FeatureBase)October 16, 2023https://db.cs.cmu.edu/seminar2023/#db6Sponsors:Google DAPA Team (google.com)
FeatureForm: Feature Store Architectures & Technical Challenges (Simba Khadder) CMU Database Group 2023-10-16 | CMU Database Group - ML⇄DB Seminar Series (2023)Speakers: Simba Khadder (FeatureForm)October 9, 2023https://db.cs.cmu.edu/seminar2023/#db5Sponsors:Google DAPA Team (google.com)
F2023 #12 - Query Execution Part 1 (CMU Intro to Database Systems) CMU Database Group 2023-10-10 | Jignesh Patel (jigneshpatel.org)Slides: https://15445.courses.cs.cmu.edu/fall2023/slides/12-queryexecution1.pdfNotes: https://15445.courses.cs.cmu.edu/fall2023/notes/12-queryexecution1.pdf15-445/645 Intro to Database Systems (Fall 2023)Carnegie Mellon Universityhttps://15445.courses.cs.cmu.edu/fall2023/
F2023 #11 - Join Algorithms (CMU Intro to Database Systems) CMU Database Group 2023-10-05 | Matt Butrovich (https://mattbutrovi.ch/)Slides: https://15445.courses.cs.cmu.edu/fall2023/slides/11-joins.pdfNotes: https://15445.courses.cs.cmu.edu/fall2023/notes/11-joins.pdf15-445/645 Intro to Database Systems (Fall 2023)Carnegie Mellon Universityhttps://15445.courses.cs.cmu.edu/fall2023/
F2023 #10 - Sorting & Aggregation Algorithms (CMU Intro to Database Systems) CMU Database Group 2023-10-04 | Jignesh Patel (linkedin.com/in/jigneshmpatel)Slides: https://15445.courses.cs.cmu.edu/fall2023/slides/10-sorting.pdfNotes: https://15445.courses.cs.cmu.edu/fall2023/notes/10-sorting.pdf15-445/645 Intro to Database Systems (Fall 2023)Carnegie Mellon Universityhttps://15445.courses.cs.cmu.edu/fall2023/
F2023 #09 - Index Concurrency Control (CMU Intro to Database Systems) CMU Database Group 2023-09-28 | Andy Pavlo (https://www.cs.cmu.edu/~pavlo/)Slides: https://15445.courses.cs.cmu.edu/fall2023/slides/09-indexconcurrency.pdfNotes: https://15445.courses.cs.cmu.edu/fall2023/notes/09-indexconcurrency.pdf15-445/645 Intro to Database Systems (Fall 2023)Carnegie Mellon Universityhttps://15445.courses.cs.cmu.edu/fall2023/
Less is More with PostgresML (Montana Low) CMU Database Group 2023-09-26 | CMU Database Group - ML⇄DB Seminar Series (2023)Speakers: Montana Low (PostgresML)September 25, 2023https://db.cs.cmu.edu/seminar2023/#db3Sponsors:Google DAPA Team (google.com)
F2023 #08 - B+Tree Indexes (CMU Intro to Database Systems) CMU Database Group 2023-09-26 | Andy Pavlo (https://www.cs.cmu.edu/~pavlo/)Slides: https://15445.courses.cs.cmu.edu/fall2023/slides/08-trees.pdfNotes: https://15445.courses.cs.cmu.edu/fall2023/notes/08-trees.pdf15-445/645 Intro to Database Systems (Fall 2023)Carnegie Mellon Universityhttps://15445.courses.cs.cmu.edu/fall2023/
