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: 6785
Venue: SIGMOD
Year: 2023
Pagerank: 5.093636e-05
Overall Rank: 11,413 | 21.70%
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.0020210012
18	How Good Are Query Optimizers, Really?	2016	VLDB	0.00059284255
103	DuckDB: an Embeddable Analytical Database	2019	SIGMOD	0.00034161428
193	Continuously Adaptive Continuous Queries over Streams	2002	SIGMOD	0.00025964286
227	Small Materialized Aggregates: A Light Weight Index Structure for Data Warehousing	1998	VLDB	0.00023958508
345	Column-Stores vs. Row-Stores: How Different Are They Really?	2008	SIGMOD	0.00020656723
383	QPipe: A Simultaneously Pipelined Relational Query Engine	2005	SIGMOD	0.00019520728
401	Deep Unsupervised Cardinality Estimation	2020	VLDB	0.00019092557
670	SharedDB: Killing One Thousand Queries With One Stone	2012	VLDB	0.00015157572
696	Main-Memory Scan Sharing For Multi-Core CPUs	2008	VLDB	0.00014891322
697	Selectivity Estimation for Range Predicates using Lightweight Models	2019	VLDB	0.00014888851
761	Cooperative Scans: Dynamic Bandwidth Sharing in a DBMS	2007	VLDB	0.00014254351
1,022	A Scalable, Predictable Join Operator for Highly Concurrent Data Warehouses	2009	VLDB	0.00012602841
1,024	The DataPath System: A Data-Centric Analytic Processing Engine for Large Data Warehouses	2010	SIGMOD	0.0001258839
1,044	Fine-grained Partitioning for Aggressive Data Skipping	2014	SIGMOD	0.0001244236
1,135	Qd-tree: Learning Data Layouts for Big Data Analytics	2020	SIGMOD	0.00012032847
1,494	Procella: Unifying serving and analytical data at YouTube	2019	VLDB	0.00010577585
1,879	Predictable Performance for Unpredictable Workloads	2009	VLDB	9.5613416e-05
3,106	Skipping-oriented Partitioning for Columnar Layouts	2017	VLDB	7.7515666e-05
3,137	Pushing Data-Induced Predicates Through Joins in Big-Data Clusters	2020	VLDB	7.7204167e-05
3,598	Access Path Selection in Main-Memory Optimized Data Systems: Should I Scan or Should I Probe?	2017	SIGMOD	7.2718988e-05
4,639	MQJoin: Efficient Shared Execution of Main-Memory Joins	2016	VLDB	6.5918791e-05
5,686	OLTPShare: The Case for Sharing in OLTP Workloads	2018	VLDB	6.1220514e-05
6,848	Jigsaw: A Data Storage and Query Processing Engine for Irregular Table Partitioning	2021	SIGMOD	5.7550624e-05
7,213	Scalable Multi-Query Execution using Reinforcement Learning	2021	SIGMOD	5.670422e-05

Semantically Similar Papers

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