.CMU Database Group Intro to Database Systems 2021 ➜ Lecture #14: Query Optimization Pt. 2 Video: youtube.com/watch?v=oXPhD8… Slides: 15445.courses.cs.cmu.edu/fall2021/slide… Statistics and plan enumeration.

.CMU Database Group Intro to Database Systems 2021 ➜ Lecture #15: Concurrency Control Theory Video: youtube.com/watch?v=7u-XH_… Slides: 15445.courses.cs.cmu.edu/fall2021/slide… Transactions and serializability.

.CMU Database Group Intro to Database Systems 2021 ➜ Lecture #16: Two-Phase Locking Concurrency Control Video: youtube.com/watch?v=4O1-tX… Slides: 15445.courses.cs.cmu.edu/fall2021/slide… With deadlock detection demos on Postgres and MySQL.

.CMU Database Group Intro to Database Systems 2021 ➜ Lecture #17: Timestamp Ordering Concurrency Control Video: youtube.com/watch?v=6UbWb9… Slides: 15445.courses.cs.cmu.edu/fall2021/slide… Basic timestamp ordering protocol and optimistic concurrency control.

.CMU Database Group Intro to Database Systems 2021 ➜ Lecture #18: Multi-Version Concurrency Control Video: youtube.com/watch?v=QXWf1s… Slides: 15445.courses.cs.cmu.edu/fall2021/slide… With demo on Postgres under different isolation levels!

.CMU Database Group Intro to Database Systems 2021 ➜ Lecture #19: Logging Protocols + Schemes Video: youtube.com/watch?v=mD5znx… Slides: 15445.courses.cs.cmu.edu/fall2021/slide… Shadow paging and write-ahead logging.

.CMU Database Group Intro to Database Systems 2021 ➜ Lecture #20: Crash Recovery Algorithms Video: youtube.com/watch?v=0wocj5… Slides: 15445.courses.cs.cmu.edu/fall2021/slide… Checkpointing and ARIES.

.CMU Database Group Intro to Database Systems 2021 ➜ Lecture #21: Introduction to Distributed Databases Video: youtube.com/watch?v=h838F6… Slides: 15445.courses.cs.cmu.edu/fall2021/slide… Architecture and partitioning.

.CMU Database Group Intro to Database Systems 2021 ➜ Lecture #22: Distributed OLTP Database Systems Video: youtube.com/watch?v=n4TEdX… Slides: 15445.courses.cs.cmu.edu/fall2021/slide… Commit protocol, replication, and CAP theorem.

.CMU Database Group Intro to Database Systems 2021 ➜ Lecture #23: Distributed OLAP Database Systems Video: youtube.com/watch?v=t6dpjp… Slides: 15445.courses.cs.cmu.edu/fall2021/slide… Execution models, query planning, and distributed join algorithms.

Personal update: I'll be joining the University of Michigan, Ann Arbor in the Division of Computer Science and Engineering Computer Science and Engineering at Michigan as an Assistant Professor in Fall 2023! Thrilled to work on exciting database research with everyone at University of Michigan!

Just to add that, as part of this transition, I recently joined Databricks to work on the Delta Lake/Lakehouse. I've moved to Ann Arbor, but will visit the DB SF/SV office periodically. Look forward to hanging out and collaborating with friends both in A2 and the bay area:)

I'm recruiting PhD students for my lab Computer Science and Engineering at Michigan on applied ML for databases, starting Fall 2023. My research and industry experience convinces me that database automation and simplification are more important than ever, and ML/AI can play a big role. Please apply and reach out!

The ⁦ACM SIGMOD/PODS⁩ 2023 conference program is now posted online. We have a packed program. Early registration deadline is May 1st. Looking forward to seeing you all in person in Seattle in June. 2023.sigmod.org/schedule_overv…

Buckle up because we're crashing into the new year with my annual database retrospective: License change blowbacks! Databricks vs. SnowflakeDB gangwar! @DuckDB shotgun weddings! Buying a college quarterback with database money for your new lover! cs.cmu.edu/~pavlo/blog/20…

GPU memory capacity and I/O bandwidth limitations have been major bottlenecks for GPU-accelerated databases. We tackle such a challenge in our latest VLDB 2025 🇬🇧 2025 paper: vldb.org/pvldb/vol18/p1… We present a novel resource-sharing method for multi-GPU systems that enables GPU

Thrilled to share that our project "Accelerating Large-Scale Data Analytics with Multi-GPU Resource Redistribution" in collaboration with Nishil Talati, has been selected for the NVIDIA Academic Grant Program (nvidia.com/en-us/industri…)! 🚀 Shout-out to NVIDIA AI Developer for their

Honored to receive a Google ML & Systems Junior Faculty Award! Grateful for Google's support as our young lab advances AI- and GPU-driven database systems. This support and recognition will help us turn new ideas into open-source tools and a faster, smarter data infrastructure.