DBScholar

Back to papers

H2O: A Hands-free Adaptive Store

Summary: H2O supports multiple storage layouts within a single engine and adapts layout choices on-the-fly per query. No fixed storage design; data parts are materialized in patterns per workload, yielding best-case performance across workloads without tuning. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
h5e94e8a7b0b7ed26
Venue
SIGMOD
Year
2014
Pagerank
0.00010826996
Overall Rank
1,383 | 90.74%
DOI
10.1145/2588555.2610502

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{alagiannis_sigmod14,
        title = {{H2O: A Hands-free Adaptive Store}},
        author = {Alagiannis, Ioannis and Idreos, Stratos and Ailamaki, Anastasia},
        series = {{SIGMOD} '14},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/2588555.2610502},
        url = {https://dl.acm.org/doi/10.1145/2588555.2610502},
        year = {2014}
}

Incoming Citations (Sorted by Pagerank)

Showing 42 of 42 citing papers.

Rank Citing Paper Year Venue Pagerank
224 Self-Driving Database Management Systems 2017 CIDR 0.00023973185
955 Lakehouse: A New Generation of Open Platforms that Unify Data Warehousing and Advanced Analytics 2021 CIDR 0.00012856295
1,188 Bridging the Archipelago between Row-Stores and Column-Stores for Hybrid Workloads 2016 SIGMOD 0.00011580449
1,220 Overview of Data Exploration Techniques 2015 SIGMOD 0.00011449992
1,282 AI Meets AI: Leveraging Query Executions to Improve Index Recommendations 2019 SIGMOD 0.00011197535
1,611 The Data Calculator*: Data Structure Design and Cost Synthesis from First Principles and Learned Cost Models 2018 SIGMOD 0.00010066379
1,900 Design Continuums and the Path Toward Self-Designing Key-Value Stores that Know and Learn 2019 CIDR 9.3926585e-05
2,356 Filter Before You Parse: Faster Analytics on Raw Data with Sparser 2018 VLDB 8.5715425e-05
2,433 How to Architect a Query Compiler, Revisited 2018 SIGMOD 8.4614165e-05
2,796 Lethe: A Tunable Delete-Aware LSM Engine 2020 SIGMOD 7.9849253e-05
2,891 Optimal Column Layout for Hybrid Workloads 2019 VLDB 7.887378e-05
3,079 Adaptive Query Processing on RAW Data 2014 VLDB 7.6544931e-05
3,094 Skipping-oriented Partitioning for Columnar Layouts 2017 VLDB 7.637515e-05
3,127 Analytics in Motion: High Performance Event-Processing AND Real-Time Analytics in the Same Database 2015 SIGMOD 7.6047902e-05
3,510 Fast Queries Over Heterogeneous Data Through Engine Customization 2016 VLDB 7.2263115e-05
3,532 Key-Value Storage Engines 2020 SIGMOD 7.2054521e-05
3,575 Make Your Database System Dream of Electric Sheep: Towards Self-Driving Operation 2021 VLDB 7.1769215e-05
3,606 Access Path Selection in Main-Memory Optimized Data Systems: Should I Scan or Should I Probe? 2017 SIGMOD 7.1528863e-05
3,869 The Case For Heterogeneous HTAP 2017 CIDR 6.9434054e-05
4,621 The Price of Tailoring the Index to Your Data: Poisoning Attacks on Learned Index Structures 2022 SIGMOD 6.4828493e-05
4,855 ReCache: Reactive Caching for Fast Analytics over Heterogeneous Data 2018 VLDB 6.3657929e-05
5,112 Towards Scalable Hybrid Stores: Constraint-Based Rewriting to the Rescue 2019 SIGMOD 6.2578491e-05
5,149 Holistic Indexing in Main-memory Column-stores 2015 SIGMOD 6.2382463e-05
5,324 CliffGuard: A Principled Framework for Finding Robust Database Designs 2015 SIGMOD 6.1645235e-05
5,444 GraphOS: Towards Oblivious Graph Processing 2023 VLDB 6.1127169e-05
6,095 From Auto-tuning One Size Fits All to Self-designed and Learned Data-intensive Systems 2019 SIGMOD 5.8706416e-05
6,293 Just-In-Time Data Virtualization: Lightweight Data Management with ViDa 2015 CIDR 5.8045404e-05
6,295 Mainlining Databases: Supporting Fast Transactional Workloads on Universal Columnar Data File Formats 2021 VLDB 5.8042139e-05
6,429 Proteus: Autonomous Adaptive Storage for Mixed Workloads 2022 SIGMOD 5.7691021e-05
6,626 Everything is a Transaction: Unifying Logical Concurrency Control and Physical Data Structure Maintenance in Database Management Systems 2021 CIDR 5.7130318e-05
6,977 Jigsaw: A Data Storage and Query Processing Engine for Irregular Table Partitioning 2021 SIGMOD 5.6135617e-05
7,054 Wide Table Layout Optimization based on Column Ordering and Duplication 2017 SIGMOD 5.5956321e-05
7,551 Invisible Glue: Scalable Self-Tuning Multi-Stores 2015 CIDR 5.4804472e-05
9,830 TiQuE: Improving the Transactional Performance of Analytical Systems for True Hybrid Workloads 2023 VLDB 5.1065586e-05
10,195 Generating Application-Specific Data Layouts for In-memory Databases 2019 VLDB 5.0516135e-05
10,369 Zed: Leveraging Data Types to Process Eclectic Data 2023 CIDR 5.0064651e-05
10,765 FlatStor: An Efficient Embedded-Index Based Columnar Data Layout for Multimodal Data Workloads 2026 VLDB 4.9605343e-05
10,774 Breaking the Isolation-Freshness Trade-off: Joint Adaptive Storage Optimization for HTAP Systems 2026 VLDB 4.9605343e-05
11,837 On-the-fly Data Transformation in Action 2023 VLDB 4.9605343e-05
12,135 Demonstration of Chestnut: An In-memory Data Layout Designer for Database Applications 2020 SIGMOD 4.9605343e-05
12,438 Capturing the Laws of (Data) Nature 2015 CIDR 4.9605343e-05
12,489 Databases and Hardware: The Beginning and Sequel of a Beautiful Friendship 2015 VLDB 4.9605343e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 32 of 32 cited papers.

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

Rank Cited Paper Year Venue Pagerank
14 MonetDB/X100: Hyper-Pipelining Query Execution 2005 CIDR 0.00063972112
21 Efficiently Compiling Efficient Query Plans for Modern Hardware 2011 VLDB 0.00056737487
27 Database Architecture Optimized for the New Bottleneck: Memory Access 1999 VLDB 0.0005146739
48 Weaving Relations for Cache Performance 2001 VLDB 0.00043770511
111 DBMSs On A Modern Processor: Where Does Time Go? 1999 VLDB 0.00032621499
161 DB2 with BLU Acceleration: So Much More than Just a Column Store 2013 VLDB 0.00027629724
177 The Vertica Analytic Database: C-Store 7 Years Later 2012 VLDB 0.00026571747
196 Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design 2004 SIGMOD 0.00025581936
253 Database Cracking 2007 CIDR 0.00023037921
332 Column-Stores vs. Row-Stores: How Different Are They Really? 2008 SIGMOD 0.00020739447
403 A Case for Fractured Mirrors 2002 VLDB 0.00019067656
431 HYRISE—A Main Memory Hybrid Storage Engine 2011 VLDB 0.00018411252
635 Performance Tradeoffs in Read-Optimized Databases 2006 VLDB 0.00015334073
756 Automatic Physical Database Tuning: A Relaxation-based Approach 2005 SIGMOD 0.00014209974
946 Enhancements to SQL Server Column Stores 2013 SIGMOD 0.00012911968
980 Sybase IQ Multiplex – Designed For Analytics 2004 VLDB 0.0001268915
1,072 NoDB: Efficient Query Execution on Raw Data Files 2012 SIGMOD 0.00012143482
1,277 Database Partitioning in a Cluster of Processors 1983 VLDB 0.00011210172
1,646 Data Morphing: An Adaptive, Cache-Conscious Storage Technique 2003 VLDB 9.9748468e-05
1,696 Self-organizing Tuple Reconstruction in Column-stores 2009 SIGMOD 9.8272691e-05
1,845 Towards a One Size Fits All Database Architecture 2011 CIDR 9.507323e-05
1,846 Merging What's Cracked, Cracking What's Merged: Adaptive Indexing in Main-Memory Column-Stores 2011 VLDB 9.5057831e-05
1,870 The Researcher's Guide to the Data Deluge: Querying a Scientific Database in Just a Few Seconds 2011 VLDB 9.4495246e-05
1,937 Here are my Data Files. Here are my Queries. Where are my Results? 2011 CIDR 9.3333463e-05
2,141 Guided Interaction: Rethinking the Query-Result Paradigm 2011 VLDB 8.9671737e-05
2,392 The Uncracked Pieces in Database Cracking 2014 VLDB 8.5172189e-05
2,618 dbTouch: Analytics at your Fingertips 2013 CIDR 8.1988906e-05
3,068 The Case for RodentStore, an Adaptive, Declarative Storage System 2009 CIDR 7.6696594e-05
3,614 Updating a Cracked Database 2007 SIGMOD 7.1420426e-05
3,890 Stochastic Database Cracking: Towards Robust Adaptive Indexing in Main-Memory Column-Stores 2012 VLDB 6.926806e-05
6,013 Concurrency Control for Adaptive Indexing 2012 VLDB 5.8958102e-05
8,630 A Storage Advisor for Hybrid-Store Databases 2012 VLDB 5.2843511e-05
Previous Page 1 / 1 Next

Semantically Similar Papers