DBScholar

Back to papers

To Share or Not to Share?

Summary: Shows aggressive multi-query work sharing can hurt on multicore systems by serializing critical paths and reducing parallelism. Introduces a measurement-driven model for selective sharing, outperforming both never-share and always-share strategies. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID
9780
Venue
VLDB
Year
2007
Pagerank
6.6561159e-05
Overall Rank
4,508 | 69.08%
DOI
10.14778/1325851.1325858

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{johnson_vldb07,
        title = {{To Share or Not to Share?}},
        author = {Johnson, Ryan and Harizopoulos, Stavros and Hardavellas, Nikos and Sabirli, Kivanc and Pandis, Ippokratis and Ailamaki, Anastasia and Mancheril, Naju G. and Falsafi, Babak},
        journal = {PVLDB},
        series = {{VLDB} '07},
        pages = {351--362},
        doi = {10.14778/1325851.1325858},
        url = {https://doi.org/10.14778/1325851.1325858},
        year = {2007}
}

Incoming Citations (Sorted by Pagerank)

Showing 9 of 9 citing papers.

Rank Citing Paper Year Venue Pagerank
696 Main-Memory Scan Sharing For Multi-Core CPUs 2008 VLDB 0.00014891322
2,202 Quantifying TPC-H Choke Points and Their Optimizations 2020 VLDB 8.9639459e-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,330 Sharing Data and Work Across Concurrent Analytical Queries 2013 VLDB 6.7563122e-05
4,639 MQJoin: Efficient Shared Execution of Main-Memory Joins 2016 VLDB 6.5918791e-05
6,482 AStream: Ad-hoc Shared Stream Processing 2019 SIGMOD 5.8668582e-05
7,579 Resource-efficient Shared Query Execution via Exploiting Time Slackness 2021 SIGMOD 5.592546e-05
8,905 TensorSocket: Shared Data Loading for Deep Learning Training 2026 SIGMOD 5.3483178e-05
9,723 Reactive and Proactive Sharing Across Concurrent Analytical Queries 2014 SIGMOD 5.2317252e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 15 of 15 cited papers.

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

Rank Cited Paper Year Venue Pagerank
25 NiagaraCQ: A Scalable Continuous Query System for Internet Databases 2000 SIGMOD 0.00054667018
29 Database Architecture Optimized for the New Bottleneck: Memory Access 1999 VLDB 0.00052093615
87 Automated Selection of Materialized Views and Indexes for SQL Databases 2000 VLDB 0.00035281619
128 Efficient and Extensible Algorithms for Multi Query Optimization 2000 SIGMOD 0.0003072825
193 Continuously Adaptive Continuous Queries over Streams 2002 SIGMOD 0.00025964286
328 An Adaptive Query Execution System for Data Integration* 1999 SIGMOD 0.00021081317
383 QPipe: A Simultaneously Pipelined Relational Query Engine 2005 SIGMOD 0.00019520728
630 Performance Tradeoffs in Read-Optimized Databases 2006 VLDB 0.00015591796
822 Pipelining in Multi-Query Optimization 2001 PODS 0.00013807229
932 Buffering Database Operations for Enhanced Instruction Cache Performance 2004 SIGMOD 0.00013119305
1,933 Red Brick Warehouse: A Read-Mostly RDBMS for Open SMP Platforms 1994 SIGMOD 9.4642118e-05
2,131 Optimization Algorithms for Exploiting the Parallelism-Communication Tradeoff in Pipelined Parallelism 1994 VLDB 9.1242116e-05
2,394 A Case for Staged Database Systems 2003 CIDR 8.6362653e-05
2,558 The Oracle Universal Server Buffer Manager 1997 VLDB 8.41572e-05
2,679 Database Servers on Chip Multiprocessors: Limitations and Opportunities 2007 CIDR 8.2675008e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 670 SharedDB: Killing One Thousand Queries With One Stone 2012 VLDB
2 4,792 Analysis of Dynamic Load Balancing Strategies for Parallel Shared Nothing Database Systems 1993 VLDB
3 2,337 Multi-dimensional Resource Scheduling for Parallel Queries 1996 SIGMOD
4 12,087 A Multicore Database Is Not a Distributed System 2015 CIDR
5 696 Main-Memory Scan Sharing For Multi-Core CPUs 2008 VLDB
6 8,243 Effective Resource Utilization for Multiprocessor Join Execution 1989 VLDB
7 2,276 Shared Workload Optimization 2014 VLDB
8 4,085 Deployment of Query Plans on Multicores 2015 VLDB
9 7,637 Workload Optimization using SharedDB 2013 SIGMOD
10 4,330 Sharing Data and Work Across Concurrent Analytical Queries 2013 VLDB