DBScholar

Back to papers

CliffGuard: A Principled Framework for Finding Robust Database Designs

Summary: CliffGuard applies robust optimization to select physical designs (indices, materialized views) under workload uncertainty. Users set risk tolerance to trade nominal optimality for robustness, yielding predictable performance amid workload shifts. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
h5459bd145610be67
Venue
SIGMOD
Year
2015
Pagerank
6.184026e-05
Overall Rank
5,310 | 64.32%
DOI
10.1145/2723372.2749454

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{mozafari_sigmod15,
        title = {{CliffGuard: A Principled Framework for Finding Robust Database Designs}},
        author = {Mozafari, Barzan and Goh, Eugene Zhen Ye and Yoon, Dong Young},
        series = {{SIGMOD} '15},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/2723372.2749454},
        url = {https://dl.acm.org/doi/10.1145/2723372.2749454},
        year = {2015}
}

Incoming Citations (Sorted by Pagerank)

Showing 18 of 18 citing papers.

Rank Citing Paper Year Venue Pagerank
772 VerdictDB: Universalizing Approximate Query Processing 2018 SIGMOD 0.0001409096
783 DBSherlock: A Performance Diagnostic Tool for Transactional Databases 2016 SIGMOD 0.0001401708
1,061 Approximate Query Processing: No Silver Bullet 2017 SIGMOD 0.00012208639
2,028 Database Learning: Toward a Database that Becomes Smarter Every Time 2017 SIGMOD 9.1584244e-05
2,549 SQLShare: Results from a Multi-Year SQL-as-a-Service Experiment 2016 SIGMOD 8.3096391e-05
2,873 SnappyData: A Unified Cluster for Streaming, Transactions, and Interactive Analytics 2017 CIDR 7.9190136e-05
2,880 Optimal Column Layout for Hybrid Workloads 2019 VLDB 7.9118308e-05
2,881 Distributed Lock Management with RDMA: Decentralization without Starvation 2018 SIGMOD 7.9114212e-05
3,462 DIAMetrics: Benchmarking Query Engines at Scale 2020 VLDB 7.280037e-05
4,913 A Top-Down Approach to Achieving Performance Predictability in Database Systems 2017 SIGMOD 6.3548977e-05
5,250 Endure: A Robust Tuning Paradigm for LSM Trees Under Workload Uncertainty 2022 VLDB 6.2092552e-05
5,663 Enabling Incremental Query Re-Optimization 2016 SIGMOD 6.0448133e-05
5,829 Joins on Samples: A Theoretical Guide for Practitioners 2020 VLDB 5.9764044e-05
6,002 Approximate Query Engines: Commercial Challenges and Research Opportunities 2017 SIGMOD 5.9149725e-05
7,749 PilotDB: Database-Agnostic Online Approximate Query Processing with A Priori Error Guarantees 2025 SIGMOD 5.4585522e-05
9,192 DBSeer: Pain-free Database Administration through Workload Intelligence 2015 VLDB 5.2091836e-05
10,307 DobLIX: A Dual-Objective Learned Index for Log-Structured Merge Trees 2025 VLDB 5.0392037e-05
12,221 Demonstration of VerdictDB, the Platform-Independent AQP System 2018 SIGMOD 4.9769913e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 26 of 26 cited papers.

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

Rank Cited Paper Year Venue Pagerank
178 The Vertica Analytic Database: C-Store 7 Years Later 2012 VLDB 0.00026620521
252 Database Cracking 2007 CIDR 0.00023101361
471 Robust Query Processing through Progressive Optimization 2004 SIGMOD 0.00017744392
529 Automatic SQL Tuning in Oracle 10g 2004 VLDB 0.00016859276
564 Congressional Samples for Approximate Answering of Group-By Queries 2000 SIGMOD 0.00016297598
569 Towards a Robust Query Optimizer: A Principled and Practical Approach 2005 SIGMOD 0.00016244162
682 Robust Estimation of Resource Consumption for SQL Queries using Statistical Techniques 2012 VLDB 0.00014814858
947 Aqua: A Fast Decision Support System Using Approximate Query Answers 1999 VLDB 0.00012920489
957 Materialized View Selection for Multidimensional Datasets 1998 VLDB 0.00012855863
1,122 Least Expected Cost Query Optimization: An Exercise in Utility 1999 PODS 0.00011933634
1,244 Compressing SQL Workloads 2002 SIGMOD 0.00011369155
1,246 Blink and It's Done: Interactive Queries on Very Large Data 2012 VLDB 0.000113499
1,380 H2O: A Hands-free Adaptive Store 2014 SIGMOD 0.00010858313
1,428 Knowing When You’re Wrong: Building Fast and Reliable Approximate Query Processing Systems 2014 SIGMOD 0.0001069161
1,693 Self-organizing Tuple Reconstruction in Column-stores 2009 SIGMOD 9.8522869e-05
1,916 The Analytical Bootstrap: a New Method for Fast Error Estimation in Approximate Query Processing 2014 SIGMOD 9.3822742e-05
1,940 Performance and Resource Modeling in Highly-Concurrent OLTP Workloads 2013 SIGMOD 9.3298436e-05
2,009 PIQL: Success-Tolerant Query Processing in the Cloud 2012 VLDB 9.1949132e-05
2,183 Probabilistic Optimization of Top N Queries 1999 VLDB 8.9044171e-05
3,396 Variance Aware Optimization of Parameterized Queries 2010 SIGMOD 7.3386533e-05
3,879 Stochastic Database Cracking: Towards Robust Adaptive Indexing in Main-Memory Column-Stores 2012 VLDB 6.9481594e-05
4,078 DBSeer: Resource and Performance Prediction for Building a Next Generation Database Cloud 2013 CIDR 6.8154962e-05
5,434 Materialized View and Index Selection Tool for Microsoft SQL Server 2000 2001 SIGMOD 6.1303275e-05
5,474 ABS: a System for Scalable Approximate Queries with Accuracy Guarantees 2014 SIGMOD 6.1159955e-05
5,836 Opportunistic Physical Design for Big Data Analytics 2014 SIGMOD 5.9732317e-05
7,429 An Automated, Yet Interactive and Portable DB Designer 2010 SIGMOD 5.5288521e-05
Previous Page 1 / 1 Next

Semantically Similar Papers