Andy Pavlo (@andypavlo.bsky.social) (@andy

Andy Pavlo (@andypavlo.bsky.social)

3,629 posts

Andy Pavlo (@andypavlo.bsky.social)

@andy_pavlo

Associate Professor of Databases @CarnegieMellon.

Pittsburgh, PA

Joined April 2011

Andy Pavlo (@andypavlo.bsky.social)
@andy_pavlo
May 20, 2023
Thanks for this hot take dude who doesn't know the 60 year history of databases. H/T @prempv Mike and I have a WIP paper that analyzes all the (failed) attempts to replace SQL + relational model. This tweet has motivated me to finish it and submit it.
Gagan Biyani 🏛
@gaganbiyani
May 18, 2023
SQL is going to die at the hands of an AI. I’m serious. @mayowaoshin is already doing this. Takes your company’s data and ingests it into ChatGPT. Then, you can create a chatbot for the data and just ask it questions using natural language. This video demoes the output. 🤯
1.2M
Andy Pavlo (@andypavlo.bsky.social)
@andy_pavlo
May 4, 2022
In today's episode of why I love the internet, people in Iran are discussing whether I live with my mother and work on databases.
PEMIDI
@PEMIDI1
May 4, 2022
اولش فک کردم من اشتباه می‌کنم. بعد دیدم جدا طرف داره دیتابیس رو توی حموم درس میده!
Andy Pavlo (@andypavlo.bsky.social)
@andy_pavlo
Apr 11, 2024
Somebody tipped me off that a 2022 paper out of Saudia Arabia blatantly stole our entire 2019 ICDE Bulletin survey paper on using ML automatically optimize databases. + 2022 Plagiarism: eajournals.org/ejcsit/vol10-i… + 2019 Original: db.cs.cmu.edu/papers/2019/pa…
8.8M
Andy Pavlo (@andypavlo.bsky.social)
@andy_pavlo
Jul 1, 2024
It took three years to finish, but our follow-up to the 2006 "What Goes Around Comes Around" is finally out! Stonebraker and I examine the last 20 years in databases and discuss why relational databases + SQL will continue to remain on top. 📄PDF: db.cs.cmu.edu/papers/2024/wh…
173K
Andy Pavlo (@andypavlo.bsky.social)
@andy_pavlo
Aug 25, 2025
Today is the new semester for @CMUDB's Intro to Database Systems! We're going harder into material than ever before. Projects are more challenging but you can use LLMs to help. We also have 10min talks each Wed from leading DB companies. Follow on YouTube:
CMU 15-445/645 :: Intro to Database Systems (Fall 2025)
From 15445.courses.cs.cmu.edu
76K
Andy Pavlo (@andypavlo.bsky.social)
@andy_pavlo
Aug 27, 2024
New semester of @CMUDB's Intro to Database Systems! We're back with vengeance with new lectures on vector/full-text indexes + distributed databases! Also featuring 10min flash talks each Wednesday from leading DB companies! You can follow along on YouTube.
15445.courses.cs.cmu.edu
CMU 15-445/645 :: Intro to Database Systems (Fall 2024)
Yes, this is the premier course at Carnegie Mellon University on the design and implementation of database management systems. Topics include data models (relational, document, key/value), storage...
55K
Andy Pavlo (@andypavlo.bsky.social)
@andy_pavlo
May 14, 2024
Columnar file formats like Parquet/ORC are ubiquitous. Our VLDB paper with @XinyuZeng218 + @huanchenzhang + @wesmckinn studies their internals. TLDR: They're not optimized for modern hardware. Something new is needed. Paper: vldb.org/pvldb/vol17/p1… Code: github.com/XinyuZeng/Eval…
96K
Andy Pavlo (@andypavlo.bsky.social)
@andy_pavlo
Jan 1, 2025
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
Databases in 2024: A Year in Review
Andy rises from the ashes of his dead startup and discusses what happened in 2024 in the database game.
88K
Andy Pavlo (@andypavlo.bsky.social)
@andy_pavlo
Jan 16, 2025
New @CMUDB Course: Database Query Optimization! A survey of how to build a SQL optimizer from scratch covering foundational and state-of-the-art implementations. All lectures available on Youtube: 15799.courses.cs.cmu.edu/spring2025/
49K
Andy Pavlo (@andypavlo.bsky.social)
@andy_pavlo
Oct 25, 2019
INSERT INTO people (name, sex, dob, mother, alleged_father) VALUES ('Clara X Pavlo', 'F', '2019-10-24', @DeepGenes, @andy_pavlo);
Andy Pavlo (@andypavlo.bsky.social)
@andy_pavlo
Jun 14, 2024
I'm to sad to announce that @OtterTuneAI is officially dead. Our service is shutdown and we let everyone go today (1mo notice). I can't got into details of what happened but we got screwed over by a PE Postgres company on an acquisition offer.
OtterTune is Dead (2020-2024)
From ottertune.com
129K
Andy Pavlo (@andypavlo.bsky.social)
@andy_pavlo
Jan 26, 2020
This is Thomas Neumann: db.in.tum.de/~neumann/index… People outside of academia may not know but he is probably the #1 DB systems researcher in the world. He sold his last DBMS (HyPer) to Tableau: hyper-db.de He just announced his new DBMS Umbra: umbra-db.com
Andy Pavlo (@andypavlo.bsky.social)
@andy_pavlo
Dec 5, 2024
For my last class this semester, I crammed our Advanced Database Systems course into one lecture. We cover the following databases in 60min: • Google BigQuery • @SnowflakeDB • Amazon Redshift • @YellowbrickData • @databricks • @duckdb • TabDB
25K
Andy Pavlo (@andypavlo.bsky.social)
@andy_pavlo
Jan 26, 2023
The new semester has started and I'm back in the cut teaching @CMUDB's Advanced DB Systems course. We will focus on modern OLAP / data warehouse systems. Lectures will be on Youtube. Thanks to @awscloud for sponsoring!
15721.courses.cs.cmu.edu
CMU 15-721 :: Advanced Database Systems (Spring 2023)
This course is a comprehensive study of the internals of modern database management systems. It will cover the core concepts and fundamentals of the components that are used in large-scale analytical...
44K