Andrew Pavlo

Publication Activity (10 Years)

Years Active: 2006-2024
Publications (10 Years): 56

Top Topics

Database Management

Concurrency Control

Top Venues

Proc. VLDB Endow.

SIGMOD Conference

Publications

Xinyu Zeng, Ruijun Meng, Andrew Pavlo, Wes McKinney, Huanchen Zhang
NULLS!: Revisiting Null Representation in Modern Columnar Formats. DaMoN (2024)
Michael Stonebraker, Andrew Pavlo
What Goes Around Comes Around... And Around... SIGMOD Rec. 53 (2) (2024)
Kai Franz, Samuel Arch, Denis Hirn, Torsten Grust, Todd C. Mowry, Andrew Pavlo
Dear User-Defined Functions, Inlining isn't working out so great for us. Let's try batching to make our relationship work. Sincerely, SQL. CIDR (2024)
Matthew Butrovich, Karthik Ramanathan, John Rollinson, Wan Shen Lim, William Zhang, Justine Sherry, Andrew Pavlo
Tigger: A Database Proxy That Bounces With User-Bypass. Proc. VLDB Endow. 16 (11) (2023)
Wan Shen Lim, Matthew Butrovich, William Zhang, Andrew Crotty, Lin Ma, Peijing Xu, Johannes Gehrke, Andrew Pavlo
Database Gyms. CIDR (2023)
Xinyu Zeng, Yulong Hui, Jiahong Shen, Andrew Pavlo, Wes McKinney, Huanchen Zhang
An Empirical Evaluation of Columnar Storage Formats. Proc. VLDB Endow. 17 (2) (2023)
Xinyu Zeng, Yulong Hui, Jiahong Shen, Andrew Pavlo, Wes McKinney, Huanchen Zhang
An Empirical Evaluation of Columnar Storage Formats. CoRR (2023)
Matthew Butrovich, Wan Shen Lim, Lin Ma, John Rollinson, William Zhang, Yu Xia, Andrew Pavlo
Tastes Great! Less Filling! High Performance and Accurate Training Data Collection for Self-Driving Database Management Systems. SIGMOD Conference (2022)
Daniel Abadi, Anastasia Ailamaki, David G. Andersen, Peter Bailis, Magdalena Balazinska, Philip A. Bernstein, Peter A. Boncz, Surajit Chaudhuri, Alvin Cheung, AnHai Doan, Luna Dong, Michael J. Franklin, Juliana Freire, Alon Y. Halevy, Joseph M. Hellerstein, Stratos Idreos, Donald Kossmann, Tim Kraska, Sailesh Krishnamurthy, Volker Markl, Sergey Melnik, Tova Milo, C. Mohan, Thomas Neumann, Beng Chin Ooi, Fatma Ozcan, Jignesh M. Patel, Andrew Pavlo, Raluca A. Popa, Raghu Ramakrishnan, Christopher Ré, Michael Stonebraker, Dan Suciu
The Seattle report on database research. Commun. ACM 65 (8) (2022)
Yu Xia, Xiangyao Yu, Matthew Butrovich, Andrew Pavlo, Srinivas Devadas
Litmus: Towards a Practical Database Management System with Verifiable ACID Properties and Transaction Correctness. SIGMOD Conference (2022)
Andrew Crotty, Viktor Leis, Andrew Pavlo
Are You Sure You Want to Use MMAP in Your Database Management System? CIDR (2022)
Amadou Ngom, Prashanth Menon, Matthew Butrovich, Lin Ma, Wan Shen Lim, Todd C. Mowry, Andrew Pavlo
Filter Representation in Vectorized Query Execution. DaMoN (2021)
Huanchen Zhang, Hyeontaek Lim, Viktor Leis, David G. Andersen, Michael Kaminsky, Kimberly Keeton, Andrew Pavlo
Succinct range filters. Commun. ACM 64 (4) (2021)
Lin Ma, William Zhang, Jie Jiao, Wuwen Wang, Matthew Butrovich, Wan Shen Lim, Prashanth Menon, Andrew Pavlo
MB2: Decomposed Behavior Modeling for Self-Driving Database Management Systems. SIGMOD Conference (2021)
Xinjing Zhou, Joy Arulraj, Andrew Pavlo, David Cohen
Spitfire: A Three-Tier Buffer Manager for Volatile and Non-Volatile Memory. SIGMOD Conference (2021)
Ling Zhang, Matthew Butrovich, Tianyu Li, Andrew Pavlo, Yash Nannapaneni, John Rollinson, Huanchen Zhang, Ambarish Balakumar, Daniel Biales, Ziqi Dong, Emmanuel J. Eppinger, Jordi E. Gonzalez, Wan Shen Lim, Jianqiao Liu, Lin Ma, Prashanth Menon, Soumil Mukherjee, Tanuj Nayak, Amadou Ngom, Dong Niu, Deepayan Patra, Poojita Raj, Stephanie Wang, Wuwen Wang, Yao Yu, William Zhang
Everything is a Transaction: Unifying Logical Concurrency Control and Physical Data Structure Maintenance in Database Management Systems. CIDR (2021)
Dana Van Aken, Dongsheng Yang, Sebastien Brillard, Ari Fiorino, Bohan Zhang, Christian Billian, Andrew Pavlo
An Inquiry into Machine Learning-based Automatic Configuration Tuning Services on Real-World Database Management Systems. Proc. VLDB Endow. 14 (7) (2021)
Tianyu Li, Matthew Butrovich, Amadou Ngom, Wan Shen Lim, Wes McKinney, Andrew Pavlo
Mainlining Databases: Supporting Fast Transactional Workloads on Universal Columnar Data File Formats. Proc. VLDB Endow. 14 (4) (2020)
Huanchen Zhang, Hyeontaek Lim, Viktor Leis, David G. Andersen, Michael Kaminsky, Kimberly Keeton, Andrew Pavlo
Succinct Range Filters. ACM Trans. Database Syst. 45 (2) (2020)
Yu Xia, Xiangyao Yu, Andrew Pavlo, Srinivas Devadas
Taurus: Lightweight Parallel Logging for In-Memory Database Management Systems. Proc. VLDB Endow. 14 (2) (2020)
Huanchen Zhang, Xiaoxuan Liu, David G. Andersen, Michael Kaminsky, Kimberly Keeton, Andrew Pavlo
Order-Preserving Key Compression for In-Memory Search Trees. CoRR (2020)
Tianyu Li, Matthew Butrovich, Amadou Ngom, Wan Shen Lim, Wes McKinney, Andrew Pavlo
Mainlining Databases: Supporting Fast Transactional Workloads on Universal Columnar Data File Formats. CoRR (2020)
Yu Xia, Xiangyao Yu, Andrew Pavlo, Srinivas Devadas
Taurus: Lightweight Parallel Logging for In-Memory Database Management Systems (Extended Version). CoRR (2020)
Prashanth Menon, Amadou Ngom, Todd C. Mowry, Andrew Pavlo, Lin Ma
Permutable Compiled Queries: Dynamically Adapting Compiled Queries without Recompiling. Proc. VLDB Endow. 14 (2) (2020)
Huanchen Zhang, Xiaoxuan Liu, David G. Andersen, Michael Kaminsky, Kimberly Keeton, Andrew Pavlo
Order-Preserving Key Compression for In-Memory Search Trees. SIGMOD Conference (2020)
Yihan Sun, Guy E. Blelloch, Wan Shen Lim, Andrew Pavlo
On Supporting Efficient Snapshot Isolation for Hybrid Workloads with Multi-Versioned Indexes. Proc. VLDB Endow. 13 (2) (2019)
Joy Arulraj, Ran Xian, Lin Ma, Andrew Pavlo
Predictive Indexing. CoRR (2019)
Yangjun Sheng, Anthony Tomasic, Tieying Sheng, Andrew Pavlo
Scheduling OLTP Transactions via Machine Learning. CoRR (2019)
Daniel Abadi, Anastasia Ailamaki, David G. Andersen, Peter Bailis, Magdalena Balazinska, Philip A. Bernstein, Peter A. Boncz, Surajit Chaudhuri, Alvin Cheung, AnHai Doan, Luna Dong, Michael J. Franklin, Juliana Freire, Alon Y. Halevy, Joseph M. Hellerstein, Stratos Idreos, Donald Kossmann, Tim Kraska, Sailesh Krishnamurthy, Volker Markl, Sergey Melnik, Tova Milo, C. Mohan, Thomas Neumann, Beng Chin Ooi, Fatma Ozcan, Jignesh M. Patel, Andrew Pavlo, Raluca A. Popa, Raghu Ramakrishnan, Christopher Ré, Michael Stonebraker, Dan Suciu
The Seattle Report on Database Research. SIGMOD Rec. 48 (4) (2019)
Yangjun Sheng, Anthony Tomasic, Tieying Zhang, Andrew Pavlo
Scheduling OLTP transactions via learned abort prediction. aiDM@SIGMOD (2019)
Andrew Pavlo, Matthew Butrovich, Ananya Joshi, Lin Ma, Prashanth Menon, Dana Van Aken, Lisa Lee, Ruslan Salakhutdinov
External vs. Internal: An Essay on Machine Learning Agents for Autonomous Database Management Systems. IEEE Data Eng. Bull. 42 (2) (2019)
Huanchen Zhang, Hyeontaek Lim, Viktor Leis, David G. Andersen, Kimberly Keeton, Andrew Pavlo
Succinct Range Filters. SIGMOD Rec. 48 (1) (2019)
Tieying Zhang, Anthony Tomasic, Yangjun Sheng, Andrew Pavlo
Performance of OLTP via Intelligent Scheduling. ICDE (2018)
Bohan Zhang, Dana Van Aken, Justin Wang, Tao Dai, Shuli Jiang, Jacky Lao, Siyuan Sheng, Andrew Pavlo, Geoffrey J. Gordon
A Demonstration of the OtterTune Automatic Database Management System Tuning Service. Proc. VLDB Endow. 11 (12) (2018)
Lin Ma, Dana Van Aken, Ahmed Hefny, Gustavo Mezerhane, Andrew Pavlo, Geoffrey J. Gordon
Query-based Workload Forecasting for Self-Driving Database Management Systems. SIGMOD Conference (2018)
Ziqi Wang, Andrew Pavlo, Hyeontaek Lim, Viktor Leis, Huanchen Zhang, Michael Kaminsky, David G. Andersen
Building a Bw-Tree Takes More Than Just Buzz Words. SIGMOD Conference (2018)
Xiangyao Yu, Yu Xia, Andrew Pavlo, Daniel Sánchez, Larry Rudolph, Srinivas Devadas
Sundial: Harmonizing Concurrency Control and Caching in a Distributed OLTP Database Management System. Proc. VLDB Endow. 11 (10) (2018)
Timo Kersten, Viktor Leis, Alfons Kemper, Thomas Neumann, Andrew Pavlo, Peter A. Boncz
Everything You Always Wanted to Know About Compiled and Vectorized Queries But Were Afraid to Ask. Proc. VLDB Endow. 11 (13) (2018)
Huanchen Zhang, Hyeontaek Lim, Viktor Leis, David G. Andersen, Michael Kaminsky, Kimberly Keeton, Andrew Pavlo
SuRF: Practical Range Query Filtering with Fast Succinct Tries. SIGMOD Conference (2018)
Franz Faerber, Alfons Kemper, Per-Åke Larson, Justin J. Levandoski, Thomas Neumann, Andrew Pavlo
Main Memory Database Systems. Found. Trends Databases 8 (1-2) (2017)
Lianghong Xu, Andrew Pavlo, Sudipta Sengupta, Gregory R. Ganger
Online Deduplication for Databases. SIGMOD Conference (2017)
Rachael Harding, Dana Van Aken, Andrew Pavlo, Michael Stonebraker
An Evaluation of Distributed Concurrency Control. Proc. VLDB Endow. 10 (5) (2017)
Prashanth Menon, Andrew Pavlo, Todd C. Mowry
Relaxed Operator Fusion for In-Memory Databases: Making Compilation, Vectorization, and Prefetching Work Together At Last. Proc. VLDB Endow. 11 (1) (2017)
Yingjun Wu, Joy Arulraj, Jiexi Lin, Ran Xian, Andrew Pavlo
An Empirical Evaluation of In-Memory Multi-Version Concurrency Control. Proc. VLDB Endow. 10 (7) (2017)
Dana Van Aken, Andrew Pavlo, Geoffrey J. Gordon, Bohan Zhang
Automatic Database Management System Tuning Through Large-scale Machine Learning. SIGMOD Conference (2017)
Andrew Pavlo
What Are We Doing With Our Lives?: Nobody Cares About Our Concurrency Control Research. SIGMOD Conference (2017)
Joy Arulraj, Andrew Pavlo
How to Build a Non-Volatile Memory Database Management System. SIGMOD Conference (2017)
Andrew Pavlo, Gustavo Angulo, Joy Arulraj, Haibin Lin, Jiexi Lin, Lin Ma, Prashanth Menon, Todd C. Mowry, Matthew Perron, Ian Quah, Siddharth Santurkar, Anthony Tomasic, Skye Toor, Dana Van Aken, Ziqi Wang, Yingjun Wu, Ran Xian, Tieying Zhang
Self-Driving Database Management Systems. CIDR (2017)
Marco Serafini, Rebecca Taft, Aaron J. Elmore, Andrew Pavlo, Ashraf Aboulnaga, Michael Stonebraker
Clay: Fine-Grained Adaptive Partitioning for General Database Schemas. Proc. VLDB Endow. 10 (4) (2016)
Xiangyao Yu, Andrew Pavlo, Daniel Sánchez, Srinivas Devadas
TicToc: Time Traveling Optimistic Concurrency Control. SIGMOD Conference (2016)
Lin Ma, Joy Arulraj, Sam Zhao, Andrew Pavlo, Subramanya R. Dulloor, Michael J. Giardino, Jeff Parkhurst, Jason L. Gardner, Kshitij A. Doshi, Stanley B. Zdonik
Larger-than-memory data management on modern storage hardware for in-memory OLTP database systems. DaMoN (2016)
Joy Arulraj, Andrew Pavlo, Prashanth Menon
Bridging the Archipelago between Row-Stores and Column-Stores for Hybrid Workloads. SIGMOD Conference (2016)
Joy Arulraj, Matthew Perron, Andrew Pavlo
Write-Behind Logging. Proc. VLDB Endow. 10 (4) (2016)
Peter Bailis, Joy Arulraj, Andrew Pavlo
Research for practice: distributed consensus and implications of NVM on database management systems. Commun. ACM 59 (11) (2016)
Andrew Pavlo, Matthew Aslett
What's Really New with NewSQL? SIGMOD Rec. 45 (2) (2016)
Huanchen Zhang, David G. Andersen, Andrew Pavlo, Michael Kaminsky, Lin Ma, Rui Shen
Reducing the Storage Overhead of Main-Memory OLTP Databases with Hybrid Indexes. SIGMOD Conference (2016)
John Meehan, Nesime Tatbul, Stanley B. Zdonik, Cansu Aslantas, Ugur Çetintemel, Jiang Du, Tim Kraska, Samuel Madden, David Maier, Andrew Pavlo, Michael Stonebraker, Kristin Tufte, Hao Wang
S-Store: Streaming Meets Transaction Processing. CoRR (2015)
Dana Van Aken, Djellel Eddine Difallah, Andrew Pavlo, Carlo Curino, Philippe Cudré-Mauroux
BenchPress: Dynamic Workload Control in the OLTP-Bench Testbed. SIGMOD Conference (2015)
Lianghong Xu, Andrew Pavlo, Sudipta Sengupta, Jin Li, Gregory R. Ganger
Reducing replication bandwidth for distributed document databases. SoCC (2015)
Joy Arulraj, Andrew Pavlo, Subramanya Dulloor
Let's Talk About Storage & Recovery Methods for Non-Volatile Memory Database Systems. SIGMOD Conference (2015)
Aaron J. Elmore, Vaibhav Arora, Rebecca Taft, Andrew Pavlo, Divyakant Agrawal, Amr El Abbadi
Squall: Fine-Grained Live Reconfiguration for Partitioned Main Memory Databases. SIGMOD Conference (2015)
John Meehan, Nesime Tatbul, Stan Zdonik, Cansu Aslantas, Ugur Çetintemel, Jiang Du, Tim Kraska, Samuel Madden, David Maier, Andrew Pavlo, Michael Stonebraker, Kristin Tufte, Hao Wang
S-Store: Streaming Meets Transaction Processing. Proc. VLDB Endow. 8 (13) (2015)
Andrew Pavlo
Emerging Hardware Trends in Large-Scale Transaction Processing. IEEE Internet Comput. 19 (3) (2015)
Rebecca Taft, Essam Mansour, Marco Serafini, Jennie Duggan, Aaron J. Elmore, Ashraf Aboulnaga, Andrew Pavlo, Michael Stonebraker
E-Store: Fine-Grained Elastic Partitioning for Distributed Transaction Processing. Proc. VLDB Endow. 8 (3) (2014)
Xiangyao Yu, George Bezerra, Andrew Pavlo, Srinivas Devadas, Michael Stonebraker
Staring into the Abyss: An Evaluation of Concurrency Control with One Thousand Cores. Proc. VLDB Endow. 8 (3) (2014)
Ugur Çetintemel, Jiang Du, Tim Kraska, Samuel Madden, David Maier, John Meehan, Andrew Pavlo, Michael Stonebraker, Erik Sutherland, Nesime Tatbul, Kristin Tufte, Hao Wang, Stanley B. Zdonik
S-Store: A Streaming NewSQL System for Big Velocity Applications. Proc. VLDB Endow. 7 (13) (2014)
Justin A. DeBrabant, Joy Arulraj, Andrew Pavlo, Michael Stonebraker, Stanley B. Zdonik, Subramanya Dulloor
A Prolegomenon on OLTP Database Systems for Non-Volatile Memory. ADMS@VLDB (2014)
Michael Stonebraker, Andrew Pavlo, Rebecca Taft, Michael L. Brodie
Enterprise Database Applications and the Cloud: A Difficult Road Ahead. IC2E (2014)
Djellel Eddine Difallah, Andrew Pavlo, Carlo Curino, Philippe Cudré-Mauroux
OLTP-Bench: An Extensible Testbed for Benchmarking Relational Databases. Proc. VLDB Endow. 7 (4) (2013)
Justin A. DeBrabant, Andrew Pavlo, Stephen Tu, Michael Stonebraker, Stanley B. Zdonik
Anti-Caching: A New Approach to Database Management System Architecture. Proc. VLDB Endow. 6 (14) (2013)
Carlo Curino, Djellel Eddine Difallah, Andrew Pavlo, Philippe Cudré-Mauroux
Benchmarking OLTP/web databases in the cloud: the OLTP-bench framework. CloudDB@CIKM (2012)
Xin Jia, Andrew Pavlo, Stanley B. Zdonik
Tastes Great, Less Filling: Low-Impact OLAP MapReduce Queries on High-Performance OLTP Systems. Tiny Trans. Comput. Sci. 1 (2012)
Andrew Pavlo, Carlo Curino, Stanley B. Zdonik
Skew-aware automatic database partitioning in shared-nothing, parallel OLTP systems. SIGMOD Conference (2012)
Andrew Pavlo, Evan P. C. Jones, Stanley B. Zdonik
On Predictive Modeling for Optimizing Transaction Execution in Parallel OLTP Systems. Proc. VLDB Endow. 5 (2) (2011)
Andrew Pavlo, Ning Shi
Graffiti Networks: A Subversive, Internet-Scale File Sharing Model CoRR (2011)
Andrew Pavlo, Evan P. C. Jones, Stanley B. Zdonik
On Predictive Modeling for Optimizing Transaction Execution in Parallel OLTP Systems CoRR (2011)
Michael Stonebraker, Daniel J. Abadi, David J. DeWitt, Samuel Madden, Erik Paulson, Andrew Pavlo, Alexander Rasin
MapReduce and parallel DBMSs: friends or foes? Commun. ACM 53 (1) (2010)
Andrew Pavlo, Erik Paulson, Alexander Rasin, Daniel J. Abadi, David J. DeWitt, Samuel Madden, Michael Stonebraker
A comparison of approaches to large-scale data analysis. SIGMOD Conference (2009)
Robert Kallman, Hideaki Kimura, Jonathan Natkins, Andrew Pavlo, Alex Rasin, Stanley B. Zdonik, Evan P. C. Jones, Samuel Madden, Michael Stonebraker, Yang Zhang, John Hugg, Daniel J. Abadi
H-store: a high-performance, distributed main memory transaction processing system. Proc. VLDB Endow. 1 (2) (2008)
Christopher Homan, Andrew Pavlo, Jonathan Schull
Smoother Transitions Between Breadth-First-Spanning-Tree-Based Drawings. Graph Drawing (2006)
Andrew Pavlo, Peter Couvares, Rebekah Gietzel, Anatoly Karp, Ian D. Alderman, Miron Livny, Charles Bacon
The NMI Build & Test Laboratory: Continuous Integration Framework for Distributed Computing Software. LISA (2006)
Ewa Deelman, Miron Livny, Gaurang Mehta, Andrew Pavlo, Gurmeet Singh, Mei-Hui Su, Karan Vahi, R. Kent Wenger
Pegasus and DAGMan From Concept to Execution: Mapping Scientific Workflows onto Today's Cyberinfrastructure. High Performance Computing Workshop (2006)
Andrew Pavlo, Christopher Homan, Jonathan Schull
A parent-centered radial layout algorithm for interactive graph visualization and animation CoRR (2006)