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
5133
Venue
SIGMOD
Year
2015
Pagerank
6.3103741e-05
Overall Rank
5,222 | 64.18%
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.00014147905
798 DBSherlock: A Performance Diagnostic Tool for Transactional Databases 2016 SIGMOD 0.00013919795
1,108 Approximate Query Processing: No Silver Bullet 2017 SIGMOD 0.00012145154
1,995 Database Learning: Toward a Database that Becomes Smarter Every Time 2017 SIGMOD 9.3403665e-05
2,592 SQLShare: Results from a Multi-Year SQL-as-a-Service Experiment 2016 SIGMOD 8.3657526e-05
2,866 Optimal Column Layout for Hybrid Workloads 2019 VLDB 8.0175489e-05
2,868 SnappyData: A Unified Cluster for Streaming, Transactions, and Interactive Analytics 2017 CIDR 8.0156936e-05
3,080 Distributed Lock Management with RDMA: Decentralization without Starvation 2018 SIGMOD 7.7746739e-05
3,460 DIAMetrics: Benchmarking Query Engines at Scale 2020 VLDB 7.3939262e-05
4,816 A Top-Down Approach to Achieving Performance Predictability in Database Systems 2017 SIGMOD 6.4949878e-05
5,552 Enabling Incremental Query Re-Optimization 2016 SIGMOD 6.1778488e-05
5,743 Joins on Samples: A Theoretical Guide for Practitioners 2020 VLDB 6.1025457e-05
5,766 Endure: A Robust Tuning Paradigm for LSM Trees Under Workload Uncertainty 2022 VLDB 6.094771e-05
5,906 Approximate Query Engines: Commercial Challenges and Research Opportunities 2017 SIGMOD 6.0457047e-05
8,204 PilotDB: Database-Agnostic Online Approximate Query Processing with A Priori Error Guarantees 2025 SIGMOD 5.4667903e-05
9,016 DBSeer: Pain-free Database Administration through Workload Intelligence 2015 VLDB 5.3312701e-05
10,955 DobLIX: A Dual-Objective Learned Index for Log-Structured Merge Trees 2025 VLDB 5.093636e-05
11,916 Demonstration of VerdictDB, the Platform-Independent AQP System 2018 SIGMOD 5.093636e-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
186 The Vertica Analytic Database: C-Store 7 Years Later 2012 VLDB 0.00026182534
259 Database Cracking 2007 CIDR 0.00023119313
492 Robust Query Processing through Progressive Optimization 2004 SIGMOD 0.0001756877
524 Automatic SQL Tuning in Oracle 10g 2004 VLDB 0.00017120666
553 Congressional Samples for Approximate Answering of Group-By Queries 2000 SIGMOD 0.00016590619
566 Towards a Robust Query Optimizer: A Principled and Practical Approach 2005 SIGMOD 0.00016436005
682 Robust Estimation of Resource Consumption for SQL Queries using Statistical Techniques 2012 VLDB 0.00015014887
931 Aqua: A Fast Decision Support System Using Approximate Query Answers 1999 VLDB 0.00013125812
942 Materialized View Selection for Multidimensional Datasets 1998 VLDB 0.00013076262
1,104 Least Expected Cost Query Optimization: An Exercise in Utility 1999 PODS 0.00012157634
1,227 Blink and It's Done: Interactive Queries on Very Large Data 2012 VLDB 0.00011582387
1,266 Compressing SQL Workloads 2002 SIGMOD 0.00011412078
1,367 H2O: A Hands-free Adaptive Store 2014 SIGMOD 0.00011014419
1,401 Knowing When You’re Wrong: Building Fast and Reliable Approximate Query Processing Systems 2014 SIGMOD 0.00010889902
1,679 Self-organizing Tuple Reconstruction in Column-stores 2009 SIGMOD 0.00010029136
1,872 The Analytical Bootstrap: a New Method for Fast Error Estimation in Approximate Query Processing 2014 SIGMOD 9.5759874e-05
1,931 Performance and Resource Modeling in Highly-Concurrent OLTP Workloads 2013 SIGMOD 9.4664741e-05
1,969 PIQL: Success-Tolerant Query Processing in the Cloud 2012 VLDB 9.3749819e-05
2,149 Probabilistic Optimization of Top N Queries 1999 VLDB 9.0821709e-05
3,513 Variance Aware Optimization of Parameterized Queries 2010 SIGMOD 7.354613e-05
3,830 Stochastic Database Cracking: Towards Robust Adaptive Indexing in Main-Memory Column-Stores 2012 VLDB 7.0877801e-05
4,000 DBSeer: Resource and Performance Prediction for Building a Next Generation Database Cloud 2013 CIDR 6.9666198e-05
5,307 Materialized View and Index Selection Tool for Microsoft SQL Server 2000 2001 SIGMOD 6.2728074e-05
5,358 ABS: a System for Scalable Approximate Queries with Accuracy Guarantees 2014 SIGMOD 6.2492955e-05
5,720 Opportunistic Physical Design for Big Data Analytics 2014 SIGMOD 6.1092082e-05
7,346 An Automated, Yet Interactive and Portable DB Designer 2010 SIGMOD 5.6377748e-05
Previous Page 1 / 1 Next

Semantically Similar Papers