SH2O: Efficient Data Access for Work-Sharing Databases

Summary: SH2O replaces shared filters with multidimensional range access patterns to reduce bottlenecks in highly concurrent work-sharing databases. Three-tier design: spatial indices, a range-optimizer, and partitioned, independent access with tuning—yields 1.8–22.2× speedups on hundreds of queries. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: h0d7673ae0ff302b9
Venue: SIGMOD
Year: 2023
Pagerank: 4.9793485e-05
Overall Rank: 11,727 | 21.16%
DOI: 10.1145/3617340

Incoming Non-self Citations Over Time

No non-self incoming citations found for this paper in this database.

Authors

1. Panagiotis Sioulas (Oracle)
2. Ioannis Mytilinis (Oracle)
3. Anastasia Ailamaki (EPFL)

BibTeX Citation

@inproceedings{sioulas_sigmod23,
        title = {{SH2O: Efficient Data Access for Work-Sharing Databases}},
        author = {Sioulas, Panagiotis and Mytilinis, Ioannis and Ailamaki, Anastasia},
        series = {{SIGMOD} '23},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3617340},
        url = {https://dl.acm.org/doi/10.1145/3617340},
        year = {2023}
}

Incoming Citations (Sorted by Pagerank)

Showing 0 of 0 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank

Outgoing Citations (Sorted by Pagerank)

Showing 25 of 25 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
2	R-Trees: A Dynamic Index Structure For Spatial Searching	1984	SIGMOD	0.001992968
15	How Good Are Query Optimizers, Really?	2016	VLDB	0.00061066921
71	DuckDB: an Embeddable Analytical Database	2019	SIGMOD	0.00037720227
200	Continuously Adaptive Continuous Queries over Streams	2002	SIGMOD	0.000254553
216	Small Materialized Aggregates: A Light Weight Index Structure for Data Warehousing	1998	VLDB	0.00024485024
331	Column-Stores vs. Row-Stores: How Different Are They Really?	2008	SIGMOD	0.0002077683
389	QPipe: A Simultaneously Pipelined Relational Query Engine	2005	SIGMOD	0.00019269777
406	Deep Unsupervised Cardinality Estimation	2020	VLDB	0.00019045544
667	SharedDB: Killing One Thousand Queries With One Stone	2012	VLDB	0.00014978213
692	Selectivity Estimation for Range Predicates using Lightweight Models	2019	VLDB	0.00014741011
705	Main-Memory Scan Sharing For Multi-Core CPUs	2008	VLDB	0.00014657491
762	Cooperative Scans: Dynamic Bandwidth Sharing in a DBMS	2007	VLDB	0.00014140446
1,034	A Scalable, Predictable Join Operator for Highly Concurrent Data Warehouses	2009	VLDB	0.00012394538
1,036	Fine-grained Partitioning for Aggressive Data Skipping	2014	SIGMOD	0.00012377471
1,040	The DataPath System: A Data-Centric Analytic Processing Engine for Large Data Warehouses	2010	SIGMOD	0.00012364063
1,132	Qd-tree: Learning Data Layouts for Big Data Analytics	2020	SIGMOD	0.00011898257
1,423	Procella: Unifying serving and analytical data at YouTube	2019	VLDB	0.00010719956
1,918	Predictable Performance for Unpredictable Workloads	2009	VLDB	9.3789552e-05
3,073	Pushing Data-Induced Predicates Through Joins in Big-Data Clusters	2020	VLDB	7.6777283e-05
3,081	Skipping-oriented Partitioning for Columnar Layouts	2017	VLDB	7.6653727e-05
3,599	Access Path Selection in Main-Memory Optimized Data Systems: Should I Scan or Should I Probe?	2017	SIGMOD	7.1773938e-05
4,730	MQJoin: Efficient Shared Execution of Main-Memory Joins	2016	VLDB	6.4468007e-05
5,801	OLTPShare: The Case for Sharing in OLTP Workloads	2018	VLDB	5.9901054e-05
6,970	Jigsaw: A Data Storage and Query Processing Engine for Irregular Table Partitioning	2021	SIGMOD	5.6311067e-05
7,341	Scalable Multi-Query Execution using Reinforcement Learning	2021	SIGMOD	5.5481233e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	7,706	Query Centric Partitioning and Allocation for Partially Replicated Database Systems	2017	SIGMOD
2	9,621	Parallelizing Query Optimization on Shared-Nothing Architectures	2016	VLDB
3	7,722	Resource-efficient Shared Query Execution via Exploiting Time Slackness	2021	SIGMOD
4	1,034	A Scalable, Predictable Join Operator for Highly Concurrent Data Warehouses	2009	VLDB
5	1,583	On the Design and Scalability of Distributed Shared-Data Databases	2015	SIGMOD
6	1,380	H2O: A Hands-free Adaptive Store	2014	SIGMOD
7	667	SharedDB: Killing One Thousand Queries With One Stone	2012	VLDB
8	4,400	Shared Arrangements: practical inter-query sharing for streaming dataflows	2020	VLDB
9	7,790	Workload Optimization using SharedDB	2013	SIGMOD
10	2,225	Shared Workload Optimization	2014	VLDB