Andrew Pavlo Associate Professor Website CMU Scholars Page Office 9019 Gates and Hillman Centers Email pavlo@cs.cmu.edu Phone (412) 268-3057 Department Computer Science Department Administrative Support Person Tracy Farbacher Research Interests Systems Data-Intensive and Cloud Computing Databases Distributed Systems Advisees Sam Arch Wan Shen Lim William Zhang CSD Courses Taught 15799 - Spring, 2025 15445 - Fall, 2024 15645 - Fall, 2024 15721 - Spring, 2024 Biography Andy Pavlo is an Associate Professor of Databaseology in the Computer Science Department at Carnegie Mellon University. His (unnatural) infatuation with database systems has inadvertently caused him to incur several distinctions, such as the NSF CAREER (2019), a Sloan Fellowship (2018), and the ACM SIGMOD Jim Gray Dissertation Award (2014). He is also the CEO & co-founder of the OtterTune database tuning start-up (2020). I only care about databases. Publications Conference NULLS!: Revisiting Null Representation in Modern Columnar Formats 2024 • 20th International Workshop on Data Management on New Hardware, DaMoN 2024 Zeng X, Meng R, Pavlo A, McKinney W, Zhang H Journal Article What Goes Around Comes Around... and Around... 2024 • SIGMOD Record • 53(2):21-37 Stonebraker M, Pavlo A Journal Article An Empirical Evaluation of Columnar Storage Formats 2023 • Proceedings of the VLDB Endowment • 17(2):148-161 Zeng X, Hui Y, Shen J, Pavlo A, McKinney W, Zhang H Conference Database Gyms 2023 • 13th Annual Conference on Innovative Data Systems Research, CIDR 2023 Lim WS, Crotty A, Butrovich M, Ma L, Zhang W, Xu P, Gehrke J, Pavlo A Journal Article Tigger: A Database Proxy That Bounces With User-Bypass 2023 • Proceedings of the VLDB Endowment • 16(11):3335-3348 Butrovich M, Ramanathan K, Rollinson J, Lim WS, Zhang W, Sherry J, Pavlo A
Conference NULLS!: Revisiting Null Representation in Modern Columnar Formats 2024 • 20th International Workshop on Data Management on New Hardware, DaMoN 2024 Zeng X, Meng R, Pavlo A, McKinney W, Zhang H
Journal Article What Goes Around Comes Around... and Around... 2024 • SIGMOD Record • 53(2):21-37 Stonebraker M, Pavlo A
Journal Article An Empirical Evaluation of Columnar Storage Formats 2023 • Proceedings of the VLDB Endowment • 17(2):148-161 Zeng X, Hui Y, Shen J, Pavlo A, McKinney W, Zhang H
Conference Database Gyms 2023 • 13th Annual Conference on Innovative Data Systems Research, CIDR 2023 Lim WS, Crotty A, Butrovich M, Ma L, Zhang W, Xu P, Gehrke J, Pavlo A
Journal Article Tigger: A Database Proxy That Bounces With User-Bypass 2023 • Proceedings of the VLDB Endowment • 16(11):3335-3348 Butrovich M, Ramanathan K, Rollinson J, Lim WS, Zhang W, Sherry J, Pavlo A