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.1645235e-05
Overall Rank
5,324 | 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
757 DBSherlock: A Performance Diagnostic Tool for Transactional Databases 2016 SIGMOD 0.00014202187
770 VerdictDB: Universalizing Approximate Query Processing 2018 SIGMOD 0.00014086699
1,065 Approximate Query Processing: No Silver Bullet 2017 SIGMOD 0.00012181098
2,040 Database Learning: Toward a Database that Becomes Smarter Every Time 2017 SIGMOD 9.1319608e-05
2,543 SQLShare: Results from a Multi-Year SQL-as-a-Service Experiment 2016 SIGMOD 8.2993351e-05
2,871 SnappyData: A Unified Cluster for Streaming, Transactions, and Interactive Analytics 2017 CIDR 7.9024682e-05
2,891 Optimal Column Layout for Hybrid Workloads 2019 VLDB 7.887378e-05
2,896 Distributed Lock Management with RDMA: Decentralization without Starvation 2018 SIGMOD 7.8855049e-05
3,474 DIAMetrics: Benchmarking Query Engines at Scale 2020 VLDB 7.256029e-05
4,932 A Top-Down Approach to Achieving Performance Predictability in Database Systems 2017 SIGMOD 6.3369302e-05
5,272 Endure: A Robust Tuning Paradigm for LSM Trees Under Workload Uncertainty 2022 VLDB 6.1887235e-05
5,673 Enabling Incremental Query Re-Optimization 2016 SIGMOD 6.0252485e-05
5,841 Joins on Samples: A Theoretical Guide for Practitioners 2020 VLDB 5.9569427e-05
6,014 Approximate Query Engines: Commercial Challenges and Research Opportunities 2017 SIGMOD 5.8956963e-05
7,745 PilotDB: Database-Agnostic Online Approximate Query Processing with A Priori Error Guarantees 2025 SIGMOD 5.4457135e-05
9,195 DBSeer: Pain-free Database Administration through Workload Intelligence 2015 VLDB 5.1958544e-05
10,335 DobLIX: A Dual-Objective Learned Index for Log-Structured Merge Trees 2025 VLDB 5.0225409e-05
12,264 Demonstration of VerdictDB, the Platform-Independent AQP System 2018 SIGMOD 4.9605343e-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
177 The Vertica Analytic Database: C-Store 7 Years Later 2012 VLDB 0.00026571747
253 Database Cracking 2007 CIDR 0.00023037921
471 Robust Query Processing through Progressive Optimization 2004 SIGMOD 0.00017691682
532 Automatic SQL Tuning in Oracle 10g 2004 VLDB 0.0001681305
564 Congressional Samples for Approximate Answering of Group-By Queries 2000 SIGMOD 0.00016251304
568 Towards a Robust Query Optimizer: A Principled and Practical Approach 2005 SIGMOD 0.00016221103
676 Robust Estimation of Resource Consumption for SQL Queries using Statistical Techniques 2012 VLDB 0.00014838681
951 Aqua: A Fast Decision Support System Using Approximate Query Answers 1999 VLDB 0.00012886042
961 Materialized View Selection for Multidimensional Datasets 1998 VLDB 0.0001281898
1,124 Least Expected Cost Query Optimization: An Exercise in Utility 1999 PODS 0.00011898749
1,246 Compressing SQL Workloads 2002 SIGMOD 0.00011355447
1,254 Blink and It's Done: Interactive Queries on Very Large Data 2012 VLDB 0.00011314204
1,383 H2O: A Hands-free Adaptive Store 2014 SIGMOD 0.00010826996
1,435 Knowing When You’re Wrong: Building Fast and Reliable Approximate Query Processing Systems 2014 SIGMOD 0.00010659454
1,696 Self-organizing Tuple Reconstruction in Column-stores 2009 SIGMOD 9.8272691e-05
1,924 The Analytical Bootstrap: a New Method for Fast Error Estimation in Approximate Query Processing 2014 SIGMOD 9.3535088e-05
1,940 Performance and Resource Modeling in Highly-Concurrent OLTP Workloads 2013 SIGMOD 9.3179491e-05
2,018 PIQL: Success-Tolerant Query Processing in the Cloud 2012 VLDB 9.1687512e-05
2,193 Probabilistic Optimization of Top N Queries 1999 VLDB 8.8828694e-05
3,406 Variance Aware Optimization of Parameterized Queries 2010 SIGMOD 7.3151509e-05
3,890 Stochastic Database Cracking: Towards Robust Adaptive Indexing in Main-Memory Column-Stores 2012 VLDB 6.926806e-05
4,091 DBSeer: Resource and Performance Prediction for Building a Next Generation Database Cloud 2013 CIDR 6.7959748e-05
5,450 Materialized View and Index Selection Tool for Microsoft SQL Server 2000 2001 SIGMOD 6.1103095e-05
5,487 ABS: a System for Scalable Approximate Queries with Accuracy Guarantees 2014 SIGMOD 6.0974772e-05
5,847 Opportunistic Physical Design for Big Data Analytics 2014 SIGMOD 5.9537345e-05
7,451 An Automated, Yet Interactive and Portable DB Designer 2010 SIGMOD 5.5106847e-05
Previous Page 1 / 1 Next

Semantically Similar Papers