Andrew Pavlo

According to our database, Andrew Pavlo authored at least 82 papers between 2006 and 2024.

Collaborative distances:

• Dijkstra number of three.
• Erdős number of three.

2024

Dear User-Defined Functions, Inlining isn't working out so great for us. Let's try batching to make our relationship work. Sincerely, SQL.

Kai Franz, Samuel Arch, Denis Hirn, Torsten Grust, Todd C. Mowry, Andrew Pavlo

Proceedings of the 14th Conference on Innovative Data Systems Research, 2024

2023

An Empirical Evaluation of Columnar Storage Formats.

Xinyu Zeng, Yulong Hui, Jiahong Shen, Andrew Pavlo, Wes McKinney, Huanchen Zhang

Proc. VLDB Endow., 2023

Tigger: A Database Proxy That Bounces With User-Bypass.

Matthew Butrovich, Karthik Ramanathan, John Rollinson, Wan Shen Lim, William Zhang, Justine Sherry, Andrew Pavlo

Proc. VLDB Endow., 2023

Database Gyms.

Wan Shen Lim, Matthew Butrovich, William Zhang, Andrew Crotty, Lin Ma, Peijing Xu, Johannes Gehrke, Andrew Pavlo

Proceedings of the 13th Conference on Innovative Data Systems Research, 2023

2022

Tastes Great! Less Filling! High Performance and Accurate Training Data Collection for Self-Driving Database Management Systems.

Matthew Butrovich, Wan Shen Lim, Lin Ma, John Rollinson, William Zhang, Yu Xia, Andrew Pavlo

Proceedings of the SIGMOD '22: International Conference on Management of Data, Philadelphia, PA, USA, June 12, 2022

Litmus: Towards a Practical Database Management System with Verifiable ACID Properties and Transaction Correctness.

Yu Xia, Xiangyao Yu, Matthew Butrovich, Andrew Pavlo, Srinivas Devadas

Proceedings of the SIGMOD '22: International Conference on Management of Data, Philadelphia, PA, USA, June 12, 2022

Are You Sure You Want to Use MMAP in Your Database Management System?

Andrew Crotty, Viktor Leis, Andrew Pavlo

Proceedings of the 12th Conference on Innovative Data Systems Research, 2022

2021

Make Your Database System Dream of Electric Sheep: Towards Self-Driving Operation.

Andy Pavlo, Matthew Butrovich, Lin Ma, Prashanth Menon, Wan Shen Lim, Dana Van Aken, William Zhang

Proc. VLDB Endow., 2021

An Inquiry into Machine Learning-based Automatic Configuration Tuning Services on Real-World Database Management Systems.

Dana Van Aken, Dongsheng Yang, Sebastien Brillard, Ari Fiorino, Bohan Zhang, Christian Billian, Andrew Pavlo

Proc. VLDB Endow., 2021

Succinct range filters.

Huanchen Zhang, Hyeontaek Lim, Viktor Leis, David G. Andersen, Michael Kaminsky, Kimberly Keeton, Andrew Pavlo

Commun. ACM, 2021

Spitfire: A Three-Tier Buffer Manager for Volatile and Non-Volatile Memory.

Xinjing Zhou, Joy Arulraj, Andrew Pavlo, David E. Cohen

Proceedings of the SIGMOD '21: International Conference on Management of Data, 2021

MB2: Decomposed Behavior Modeling for Self-Driving Database Management Systems.

Lin Ma, William Zhang, Jie Jiao, Wuwen Wang, Matthew Butrovich, Wan Shen Lim, Prashanth Menon, Andrew Pavlo

Proceedings of the SIGMOD '21: International Conference on Management of Data, 2021

Filter Representation in Vectorized Query Execution.

Amadou Ngom, Prashanth Menon, Matthew Butrovich, Lin Ma, Wan Shen Lim, Todd C. Mowry, Andrew Pavlo

Proceedings of the 17th International Workshop on Data Management on New Hardware, 2021

Everything is a Transaction: Unifying Logical Concurrency Control and Physical Data Structure Maintenance in Database Management Systems.

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

Proceedings of the 11th Conference on Innovative Data Systems Research, 2021

2020

Taurus: Lightweight Parallel Logging for In-Memory Database Management Systems.

Yu Xia, Xiangyao Yu, Andrew Pavlo, Srinivas Devadas

Proc. VLDB Endow., 2020

Permutable Compiled Queries: Dynamically Adapting Compiled Queries without Recompiling.

Prashanth Menon, Amadou Ngom, Todd C. Mowry, Andrew Pavlo, Lin Ma

Proc. VLDB Endow., 2020

Mainlining Databases: Supporting Fast Transactional Workloads on Universal Columnar Data File Formats.

Tianyu Li, Matthew Butrovich, Amadou Ngom, Wan Shen Lim, Wes McKinney, Andrew Pavlo

Proc. VLDB Endow., 2020

Taurus: Lightweight Parallel Logging for In-Memory Database Management Systems (Extended Version).

Yu Xia, Xiangyao Yu, Andrew Pavlo, Srinivas Devadas

CoRR, 2020

Vilamb: Low Overhead Asynchronous Redundancy for Direct Access NVM.

Rajat Kateja, Andy Pavlo, Gregory R. Ganger

CoRR, 2020

Order-Preserving Key Compression for In-Memory Search Trees.

Huanchen Zhang, Xiaoxuan Liu, David G. Andersen, Michael Kaminsky, Kimberly Keeton, Andrew Pavlo

Proceedings of the 2020 International Conference on Management of Data, 2020

2019

Non-Volatile Memory Database Management Systems

Joy Arulraj, Andrew Pavlo

Synthesis Lectures on Data Management, Morgan & Claypool Publishers, ISBN: 978-3-031-01868-8, 2019

Succinct Range Filters.

Huanchen Zhang, Hyeontaek Lim, Viktor Leis, David G. Andersen, Kimberly Keeton, Andrew Pavlo

SIGMOD Rec., 2019

The Seattle Report on Database Research.

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

SIGMOD Rec., 2019

On Supporting Efficient Snapshot Isolation for Hybrid Workloads with Multi-Versioned Indexes.

Yihan Sun, Guy E. Blelloch, Wan Shen Lim, Andrew Pavlo

Proc. VLDB Endow., 2019

External vs. Internal: An Essay on Machine Learning Agents for Autonomous Database Management Systems.

Andrew Pavlo, Matthew Butrovich, Ananya Joshi, Lin Ma, Prashanth Menon, Dana Van Aken, Lisa Lee, Ruslan Salakhutdinov

IEEE Data Eng. Bull., 2019

Scheduling OLTP Transactions via Machine Learning.

Yangjun Sheng, Anthony Tomasic, Tieying Sheng, Andrew Pavlo

CoRR, 2019

Multi-Tier Buffer Management and Storage System Design for Non-Volatile Memory.

Joy Arulraj, Andy Pavlo, Krishna Teja Malladi

CoRR, 2019

Predictive Indexing.

Joy Arulraj, Ran Xian, Lin Ma, Andrew Pavlo

CoRR, 2019

Scheduling OLTP transactions via learned abort prediction.

Yangjun Sheng, Anthony Tomasic, Tieying Zhang, Andrew Pavlo

Proceedings of the Second International Workshop on Exploiting Artificial Intelligence Techniques for Data Management, 2019

In-memory, horizontal, and transactional: the H-store OLTP DBMS project.

Andy Pavlo

Proceedings of the Making Databases Work: the Pragmatic Wisdom of Michael Stonebraker, 2019

2018

A Demonstration of the OtterTune Automatic Database Management System Tuning Service.

Bohan Zhang, Dana Van Aken, Justin Wang, Tao Dai, Shuli Jiang, Jacky Lao, Siyuan Sheng, Andrew Pavlo, Geoffrey J. Gordon

Proc. VLDB Endow., 2018

Sundial: Harmonizing Concurrency Control and Caching in a Distributed OLTP Database Management System.

Xiangyao Yu, Yu Xia, Andrew Pavlo, Daniel Sánchez, Larry Rudolph, Srinivas Devadas

Proc. VLDB Endow., 2018

Everything You Always Wanted to Know About Compiled and Vectorized Queries But Were Afraid to Ask.

Timo Kersten, Viktor Leis, Alfons Kemper, Thomas Neumann, Andrew Pavlo, Peter A. Boncz

Proc. VLDB Endow., 2018

SuRF: Practical Range Query Filtering with Fast Succinct Tries.

Huanchen Zhang, Hyeontaek Lim, Viktor Leis, David G. Andersen, Michael Kaminsky, Kimberly Keeton, Andrew Pavlo

Proceedings of the 2018 International Conference on Management of Data, 2018

Building a Bw-Tree Takes More Than Just Buzz Words.

Ziqi Wang, Andrew Pavlo, Hyeontaek Lim, Viktor Leis, Huanchen Zhang, Michael Kaminsky, David G. Andersen

Proceedings of the 2018 International Conference on Management of Data, 2018

Query-based Workload Forecasting for Self-Driving Database Management Systems.

Lin Ma, Dana Van Aken, Ahmed Hefny, Gustavo Mezerhane, Andrew Pavlo, Geoffrey J. Gordon

Proceedings of the 2018 International Conference on Management of Data, 2018

Performance of OLTP via Intelligent Scheduling.

Tieying Zhang, Anthony Tomasic, Yangjun Sheng, Andrew Pavlo

Proceedings of the 34th IEEE International Conference on Data Engineering, 2018

2017

An Empirical Evaluation of In-Memory Multi-Version Concurrency Control.

Yingjun Wu, Joy Arulraj, Jiexi Lin, Ran Xian, Andrew Pavlo

Proc. VLDB Endow., 2017

Relaxed Operator Fusion for In-Memory Databases: Making Compilation, Vectorization, and Prefetching Work Together At Last.

Prashanth Menon, Andrew Pavlo, Todd C. Mowry

Proc. VLDB Endow., 2017

An Evaluation of Distributed Concurrency Control.

Rachael Harding, Dana Van Aken, Andrew Pavlo, Michael Stonebraker

Proc. VLDB Endow., 2017

Main Memory Database Systems.

Franz Faerber, Alfons Kemper, Per-Åke Larson, Justin J. Levandoski, Thomas Neumann, Andrew Pavlo

Found. Trends Databases, 2017

Online Deduplication for Databases.

Lianghong Xu, Andrew Pavlo, Sudipta Sengupta, Gregory R. Ganger

Proceedings of the 2017 ACM International Conference on Management of Data, 2017

What Are We Doing With Our Lives?: Nobody Cares About Our Concurrency Control Research.

Andrew Pavlo

Proceedings of the 2017 ACM International Conference on Management of Data, 2017

How to Build a Non-Volatile Memory Database Management System.

Joy Arulraj, Andrew Pavlo

Proceedings of the 2017 ACM International Conference on Management of Data, 2017

Automatic Database Management System Tuning Through Large-scale Machine Learning.

Dana Van Aken, Andrew Pavlo, Geoffrey J. Gordon, Bohan Zhang

Proceedings of the 2017 ACM International Conference on Management of Data, 2017

Self-Driving Database Management Systems.

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

Proceedings of the 8th Biennial Conference on Innovative Data Systems Research, 2017

2016

What's Really New with NewSQL?

Andrew Pavlo, Matthew Aslett

SIGMOD Rec., 2016

Research for Practice: Distributed Consensus and Implications of NVM on Database Management Systems.

Peter Bailis, Camille Fournier, Joy Arulraj, Andy Pavlo

ACM Queue, 2016

Clay: Fine-Grained Adaptive Partitioning for General Database Schemas.

Marco Serafini, Rebecca Taft, Aaron J. Elmore, Andrew Pavlo, Ashraf Aboulnaga, Michael Stonebraker

Proc. VLDB Endow., 2016

Write-Behind Logging.

Joy Arulraj, Matthew Perron, Andrew Pavlo

Proc. VLDB Endow., 2016

Research for practice: distributed consensus and implications of NVM on database management systems.

Peter Bailis, Joy Arulraj, Andrew Pavlo

Commun. ACM, 2016

Reducing the Storage Overhead of Main-Memory OLTP Databases with Hybrid Indexes.

Huanchen Zhang, David G. Andersen, Andrew Pavlo, Michael Kaminsky, Lin Ma, Rui Shen

Proceedings of the 2016 International Conference on Management of Data, 2016

TicToc: Time Traveling Optimistic Concurrency Control.

Xiangyao Yu, Andrew Pavlo, Daniel Sánchez, Srinivas Devadas

Proceedings of the 2016 International Conference on Management of Data, 2016

Bridging the Archipelago between Row-Stores and Column-Stores for Hybrid Workloads.

Joy Arulraj, Andrew Pavlo, Prashanth Menon

Proceedings of the 2016 International Conference on Management of Data, 2016

Larger-than-memory data management on modern storage hardware for in-memory OLTP database systems.

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

Proceedings of the 12th International Workshop on Data Management on New Hardware, 2016

2015

S-Store: Streaming Meets Transaction Processing.

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

Proc. VLDB Endow., 2015

Emerging Hardware Trends in Large-Scale Transaction Processing.

Andrew Pavlo

IEEE Internet Comput., 2015

Squall: Fine-Grained Live Reconfiguration for Partitioned Main Memory Databases.

Aaron J. Elmore, Vaibhav Arora, Rebecca Taft, Andrew Pavlo, Divyakant Agrawal, Amr El Abbadi

Proceedings of the 2015 ACM SIGMOD International Conference on Management of Data, Melbourne, Victoria, Australia, May 31, 2015

Let's Talk About Storage & Recovery Methods for Non-Volatile Memory Database Systems.

Joy Arulraj, Andrew Pavlo, Subramanya Dulloor

Proceedings of the 2015 ACM SIGMOD International Conference on Management of Data, Melbourne, Victoria, Australia, May 31, 2015

BenchPress: Dynamic Workload Control in the OLTP-Bench Testbed.

Dana Van Aken, Djellel Eddine Difallah, Andrew Pavlo, Carlo Curino, Philippe Cudré-Mauroux

Proceedings of the 2015 ACM SIGMOD International Conference on Management of Data, Melbourne, Victoria, Australia, May 31, 2015

Reducing replication bandwidth for distributed document databases.

Lianghong Xu, Andrew Pavlo, Sudipta Sengupta, Jin Li, Gregory R. Ganger

Proceedings of the Sixth ACM Symposium on Cloud Computing, 2015

2014

On Scalable Transaction Execution in Partitioned Main Memory Database Management Systems.

Andrew Pavlo

PhD thesis, 2014

Staring into the Abyss: An Evaluation of Concurrency Control with One Thousand Cores.

Xiangyao Yu, George Bezerra, Andrew Pavlo, Srinivas Devadas, Michael Stonebraker

Proc. VLDB Endow., 2014

E-Store: Fine-Grained Elastic Partitioning for Distributed Transaction Processing.

Rebecca Taft, Essam Mansour, Marco Serafini, Jennie Duggan, Aaron J. Elmore, Ashraf Aboulnaga, Andrew Pavlo, Michael Stonebraker

Proc. VLDB Endow., 2014

S-Store: A Streaming NewSQL System for Big Velocity Applications.

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

Proc. VLDB Endow., 2014

A Prolegomenon on OLTP Database Systems for Non-Volatile Memory.

Justin A. DeBrabant, Joy Arulraj, Andrew Pavlo, Michael Stonebraker, Stanley B. Zdonik, Subramanya Dulloor

Proceedings of the International Workshop on Accelerating Data Management Systems Using Modern Processor and Storage Architectures, 2014

Enterprise Database Applications and the Cloud: A Difficult Road Ahead.

Michael Stonebraker, Andrew Pavlo, Rebecca Taft, Michael L. Brodie

Proceedings of the 2014 IEEE International Conference on Cloud Engineering, 2014

2013

OLTP-Bench: An Extensible Testbed for Benchmarking Relational Databases.

Djellel Eddine Difallah, Andrew Pavlo, Carlo Curino, Philippe Cudré-Mauroux

Proc. VLDB Endow., 2013

Anti-Caching: A New Approach to Database Management System Architecture.

Justin A. DeBrabant, Andrew Pavlo, Stephen Tu, Michael Stonebraker, Stanley B. Zdonik

Proc. VLDB Endow., 2013

2012

14th International Workshop on High Performance Transaction Systems (HPTS).

Michael Armbrust, Yingyi Bu, Aaron J. Elmore, Rik Farrow, Eugenia Gabrielova, Hatem Mahmoud, Andy Pavlo, Stephen Revilak, Pinar Tözün

login Usenix Mag., 2012

Tastes Great, Less Filling: Low-Impact OLAP MapReduce Queries on High-Performance OLTP Systems.

Xin Jia, Andrew Pavlo, Stanley B. Zdonik

Tiny Trans. Comput. Sci., 2012

Skew-aware automatic database partitioning in shared-nothing, parallel OLTP systems.

Andrew Pavlo, Carlo Curino, Stanley B. Zdonik

Proceedings of the ACM SIGMOD International Conference on Management of Data, 2012

Benchmarking OLTP/web databases in the cloud: the OLTP-bench framework.

Carlo Curino, Djellel Eddine Difallah, Andrew Pavlo, Philippe Cudré-Mauroux

Proceedings of the Fourth International Workshop on Cloud Data Management, 2012

2011

On Predictive Modeling for Optimizing Transaction Execution in Parallel OLTP Systems.

Andrew Pavlo, Evan P. C. Jones, Stanley B. Zdonik

Proc. VLDB Endow., 2011

Graffiti Networks: A Subversive, Internet-Scale File Sharing Model

Andrew Pavlo, Ning Shi

CoRR, 2011

2010

MapReduce and parallel DBMSs: friends or foes?

Michael Stonebraker, Daniel J. Abadi, David J. DeWitt, Samuel Madden, Erik Paulson, Andrew Pavlo, Alexander Rasin

Commun. ACM, 2010

2009

A comparison of approaches to large-scale data analysis.

Andrew Pavlo, Erik Paulson, Alexander Rasin, Daniel J. Abadi, David J. DeWitt, Samuel Madden, Michael Stonebraker

Proceedings of the ACM SIGMOD International Conference on Management of Data, 2009

2008

H-store: a high-performance, distributed main memory transaction processing system.

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

Proc. VLDB Endow., 2008

2006

A parent-centered radial layout algorithm for interactive graph visualization and animation

Andrew Pavlo, Christopher Homan, Jonathan Schull

CoRR, 2006

The NMI Build & Test Laboratory: Continuous Integration Framework for Distributed Computing Software.

Andrew Pavlo, Peter Couvares, Rebekah Gietzel, Anatoly Karp, Ian D. Alderman, Miron Livny, Charles Bacon

Proceedings of the 20th Conference on Systems Administration (LISA 2006), 2006

Pegasus and DAGMan From Concept to Execution: Mapping Scientific Workflows onto Today's Cyberinfrastructure.

Ewa Deelman, Miron Livny, Gaurang Mehta, Andrew Pavlo, Gurmeet Singh, Mei-Hui Su, Karan Vahi, R. Kent Wenger

Proceedings of the High Performance Computing and Grids in Action, 2006

Smoother Transitions Between Breadth-First-Spanning-Tree-Based Drawings.

Christopher Homan, Andrew Pavlo, Jonathan Schull

Proceedings of the Graph Drawing, 14th International Symposium, 2006