DBScholar

Back to papers

On Predictive Modeling for Optimizing Transaction Execution in Parallel OLTP Systems

Summary: Introduces Markov-model prediction to infer transaction properties (partition span, abort risk) at runtime. Uses these predictions to select concurrency control, scheduling, logging, and speculative-execution optimizations, improving diverse parallel OLTP workloads. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID
10526
Venue
VLDB
Year
2012
Pagerank
9.6635729e-05
Overall Rank
1,831 | 87.44%
DOI
10.14778/2078324.2078326

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{pavlo_vldb12,
        title = {{On Predictive Modeling for Optimizing Transaction Execution in Parallel OLTP Systems}},
        author = {Pavlo, Andrew and Jones, Evan P.C. and Zdonik, Stanley},
        journal = {PVLDB},
        series = {{VLDB} '12},
        volume = {5},
        number = {2},
        pages = {85--96},
        doi = {10.14778/2078324.2078326},
        url = {https://doi.org/10.14778/2078324.2078326},
        year = {2012}
}

Incoming Citations (Sorted by Pagerank)

Showing 26 of 26 citing papers.

Rank Citing Paper Year Venue Pagerank
226 OLTP-Bench: An Extensible Testbed for Benchmarking Relational Databases 2014 VLDB 0.00024027277
234 Self-Driving Database Management Systems 2017 CIDR 0.00023810722
378 Bao: Making Learned Query Optimization Practical 2021 SIGMOD 0.00019638121
461 Query-based Workload Forecasting for Self-Driving Database Management Systems 2018 SIGMOD 0.00018068441
471 Skew-Aware Automatic Database Partitioning in Shared-Nothing, Parallel OLTP Systems 2012 SIGMOD 0.0001793564
568 SageDB: A Learned Database System 2019 CIDR 0.0001641553
655 ERMIA: Fast Memory-Optimized Database System for Heterogeneous Workloads 2016 SIGMOD 0.00015263509
887 E-Store: Fine-Grained Elastic Partitioning for Distributed Transaction Processing Systems 2015 VLDB 0.00013403455
1,250 Data Management in Machine Learning: Challenges, Techniques, and Systems 2017 SIGMOD 0.00011485301
1,345 The End of a Myth: Distributed Transactions Can Scale 2017 VLDB 0.00011090483
1,964 OLTP on Hardware Islands 2012 VLDB 9.3880822e-05
2,407 Squall: Fine-Grained Live Reconfiguration for Partitioned Main Memory Databases 2015 SIGMOD 8.6184333e-05
2,765 An Evaluation of the Advantages and Disadvantages of Deterministic Database Systems 2014 VLDB 8.1530951e-05
2,998 Handling Highly Contended OLTP Workloads Using Fast Dynamic Partitioning 2020 SIGMOD 7.8727047e-05
3,053 Lazy Evaluation of Transactions in Database Systems 2014 SIGMOD 7.8098188e-05
3,586 Make Your Database System Dream of Electric Sheep: Towards Self-Driving Operation 2021 VLDB 7.2834069e-05
3,809 Auto-WLM: Machine Learning Enhanced Workload Management in Amazon Redshift 2023 SIGMOD 7.1074195e-05
5,487 Remus: Efficient Live Migration for Distributed Databases with Snapshot Isolation 2022 SIGMOD 6.2006149e-05
5,974 Towards instance-optimized data systems 2021 VLDB 6.0230488e-05
6,770 PolarDB-MP: A Multi-Primary Cloud-Native Database via Disaggregated Shared Memory 2024 SIGMOD 5.7783709e-05
7,722 ChronoCache: Predictive and Adaptive Mid-Tier Query Result Caching 2020 SIGMOD 5.5586232e-05
7,740 Oracle Workload Intelligence 2015 SIGMOD 5.5550801e-05
7,998 P4DB - The Case for In-Network OLTP 2022 SIGMOD 5.5093728e-05
9,536 Database Gyms 2023 CIDR 5.2529727e-05
9,934 BenchPress: Dynamic Workload Control in the OLTP-Bench Testbed 2015 SIGMOD 5.1955087e-05
10,107 Re-evaluating Designs for Multi-Tenant OLTP Workloads on SSD-based I/O Subsystems 2014 SIGMOD 5.1435736e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 8 of 8 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Previous Page 1 / 1 Next

Semantically Similar Papers