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.00010862758
Overall Rank
1,380 | 90.73%
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.00024013745
950 Lakehouse: A New Generation of Open Platforms that Unify Data Warehousing and Advanced Analytics 2021 CIDR 0.00012895553
1,200 Bridging the Archipelago between Row-Stores and Column-Stores for Hybrid Workloads 2016 SIGMOD 0.00011563303
1,215 Overview of Data Exploration Techniques 2015 SIGMOD 0.00011492648
1,279 AI Meets AI: Leveraging Query Executions to Improve Index Recommendations 2019 SIGMOD 0.00011226878
1,605 The Data Calculator*: Data Structure Design and Cost Synthesis from First Principles and Learned Cost Models 2018 SIGMOD 0.00010093796
1,889 Design Continuums and the Path Toward Self-Designing Key-Value Stores that Know and Learn 2019 CIDR 9.4273689e-05
2,347 Filter Before You Parse: Faster Analytics on Raw Data with Sparser 2018 VLDB 8.6012176e-05
2,419 How to Architect a Query Compiler, Revisited 2018 SIGMOD 8.4923505e-05
2,788 Lethe: A Tunable Delete-Aware LSM Engine 2020 SIGMOD 8.0133966e-05
2,882 Optimal Column Layout for Hybrid Workloads 2019 VLDB 7.9116043e-05
3,069 Adaptive Query Processing on RAW Data 2014 VLDB 7.6822697e-05
3,081 Skipping-oriented Partitioning for Columnar Layouts 2017 VLDB 7.6653727e-05
3,122 Analytics in Motion: High Performance Event-Processing AND Real-Time Analytics in the Same Database 2015 SIGMOD 7.6236292e-05
3,505 Fast Queries Over Heterogeneous Data Through Engine Customization 2016 VLDB 7.2508161e-05
3,525 Key-Value Storage Engines 2020 SIGMOD 7.2327042e-05
3,590 Make Your Database System Dream of Electric Sheep: Towards Self-Driving Operation 2021 VLDB 7.1865343e-05
3,599 Access Path Selection in Main-Memory Optimized Data Systems: Should I Scan or Should I Probe? 2017 SIGMOD 7.1773938e-05
3,935 The Case For Heterogeneous HTAP 2017 CIDR 6.9166006e-05
4,616 The Price of Tailoring the Index to Your Data: Poisoning Attacks on Learned Index Structures 2022 SIGMOD 6.5000712e-05
4,832 ReCache: Reactive Caching for Fast Analytics over Heterogeneous Data 2018 VLDB 6.3895407e-05
5,091 Towards Scalable Hybrid Stores: Constraint-Based Rewriting to the Rescue 2019 SIGMOD 6.2797352e-05
5,131 Holistic Indexing in Main-memory Column-stores 2015 SIGMOD 6.2602133e-05
5,316 CliffGuard: A Principled Framework for Finding Robust Database Designs 2015 SIGMOD 6.1836681e-05
5,424 GraphOS: Towards Oblivious Graph Processing 2023 VLDB 6.1359011e-05
6,080 From Auto-tuning One Size Fits All to Self-designed and Learned Data-intensive Systems 2019 SIGMOD 5.8924903e-05
6,278 Just-In-Time Data Virtualization: Lightweight Data Management with ViDa 2015 CIDR 5.8263939e-05
6,297 Mainlining Databases: Supporting Fast Transactional Workloads on Universal Columnar Data File Formats 2021 VLDB 5.81916e-05
6,598 Proteus: Autonomous Adaptive Storage for Mixed Workloads 2022 SIGMOD 5.7405915e-05
6,622 Everything is a Transaction: Unifying Logical Concurrency Control and Physical Data Structure Maintenance in Database Management Systems 2021 CIDR 5.7307819e-05
6,970 Jigsaw: A Data Storage and Query Processing Engine for Irregular Table Partitioning 2021 SIGMOD 5.6311067e-05
7,034 Wide Table Layout Optimization based on Column Ordering and Duplication 2017 SIGMOD 5.6167737e-05
7,528 Invisible Glue: Scalable Self-Tuning Multi-Stores 2015 CIDR 5.5011847e-05
9,791 TiQuE: Improving the Transactional Performance of Analytical Systems for True Hybrid Workloads 2023 VLDB 5.1259267e-05
10,156 Generating Application-Specific Data Layouts for In-memory Databases 2019 VLDB 5.0707546e-05
10,335 Zed: Leveraging Data Types to Process Eclectic Data 2023 CIDR 5.0254535e-05
10,694 FlatStor: An Efficient Embedded-Index Based Columnar Data Layout for Multimodal Data Workloads 2026 VLDB 4.9793485e-05
10,703 Breaking the Isolation-Freshness Trade-off: Joint Adaptive Storage Optimization for HTAP Systems 2026 VLDB 4.9793485e-05
11,787 On-the-fly Data Transformation in Action 2023 VLDB 4.9793485e-05
12,085 Demonstration of Chestnut: An In-memory Data Layout Designer for Database Applications 2020 SIGMOD 4.9793485e-05
12,389 Capturing the Laws of (Data) Nature 2015 CIDR 4.9793485e-05
12,440 Databases and Hardware: The Beginning and Sequel of a Beautiful Friendship 2015 VLDB 4.9793485e-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.00064031282
21 Efficiently Compiling Efficient Query Plans for Modern Hardware 2011 VLDB 0.00056855599
27 Database Architecture Optimized for the New Bottleneck: Memory Access 1999 VLDB 0.0005158963
48 Weaving Relations for Cache Performance 2001 VLDB 0.00043805923
110 DBMSs On A Modern Processor: Where Does Time Go? 1999 VLDB 0.00032700879
163 DB2 with BLU Acceleration: So Much More than Just a Column Store 2013 VLDB 0.0002749118
179 The Vertica Analytic Database: C-Store 7 Years Later 2012 VLDB 0.00026611886
195 Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design 2004 SIGMOD 0.00025628849
253 Database Cracking 2007 CIDR 0.00023042111
331 Column-Stores vs. Row-Stores: How Different Are They Really? 2008 SIGMOD 0.0002077683
401 A Case for Fractured Mirrors 2002 VLDB 0.00019108281
431 HYRISE—A Main Memory Hybrid Storage Engine 2011 VLDB 0.00018403783
634 Performance Tradeoffs in Read-Optimized Databases 2006 VLDB 0.00015373122
751 Automatic Physical Database Tuning: A Relaxation-based Approach 2005 SIGMOD 0.0001425375
944 Enhancements to SQL Server Column Stores 2013 SIGMOD 0.00012939697
980 Sybase IQ Multiplex – Designed For Analytics 2004 VLDB 0.00012720677
1,069 NoDB: Efficient Query Execution on Raw Data Files 2012 SIGMOD 0.00012185253
1,273 Database Partitioning in a Cluster of Processors 1983 VLDB 0.00011247988
1,642 Data Morphing: An Adaptive, Cache-Conscious Storage Technique 2003 VLDB 0.00010006413
1,694 Self-organizing Tuple Reconstruction in Column-stores 2009 SIGMOD 9.8562172e-05
1,836 Merging What's Cracked, Cracking What's Merged: Adaptive Indexing in Main-Memory Column-Stores 2011 VLDB 9.535551e-05
1,848 Towards a One Size Fits All Database Architecture 2011 CIDR 9.5082163e-05
1,863 The Researcher's Guide to the Data Deluge: Querying a Scientific Database in Just a Few Seconds 2011 VLDB 9.4846052e-05
1,925 Here are my Data Files. Here are my Queries. Where are my Results? 2011 CIDR 9.3670488e-05
2,129 Guided Interaction: Rethinking the Query-Result Paradigm 2011 VLDB 8.9960018e-05
2,383 The Uncracked Pieces in Database Cracking 2014 VLDB 8.5435328e-05
2,605 dbTouch: Analytics at your Fingertips 2013 CIDR 8.229938e-05
3,056 The Case for RodentStore, an Adaptive, Declarative Storage System 2009 CIDR 7.6972474e-05
3,606 Updating a Cracked Database 2007 SIGMOD 7.1686756e-05
3,878 Stochastic Database Cracking: Towards Robust Adaptive Indexing in Main-Memory Column-Stores 2012 VLDB 6.9512776e-05
6,005 Concurrency Control for Adaptive Indexing 2012 VLDB 5.9164805e-05
8,605 A Storage Advisor for Hybrid-Store Databases 2012 VLDB 5.3042445e-05
Previous Page 1 / 1 Next

Semantically Similar Papers