Database Paper Browser

Back to papers

Revisiting Reuse in Main Memory Database Systems

Summary: Proposes a reuse model that caches and externalizes internal data structures (hash tables) created during query processing, avoiding operator-level materialization. A reuse-aware optimizer reasons about hash-table reuse with cache-aware cost models, delivering about 2x speedups on analytical workloads with no extra materialization overhead. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
5323
Venue
SIGMOD
Year
2017
Pagerank
4.9288776e-05
Overall Rank
6,777 | 52.86%
DOI
10.1145/3035918.3035957

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 9 of 9 citing papers.

Rank Citing Paper Year Venue Pagerank
1,350 Northstar: An Interactive Data Science System 2018 VLDB 0.00012431059
2,280 SMOKE: Fine-grained Lineage at Interactive Speed 2018 VLDB 9.1111033e-05
3,606 EVA: A Symbolic Approach to Accelerating Exploratory Video Analytics with Materialized Views 2022 SIGMOD 6.9260354e-05
4,030 Revisiting Reuse for Approximate Query Processing 2017 VLDB 6.5129665e-05
5,301 ReCache: Reactive Caching for Fast Analytics over Heterogeneous Data 2018 VLDB 5.5790928e-05
5,314 Can Learned Models Replace Hash Functions? 2023 VLDB 5.5724608e-05
6,149 Crystal: A Unified Cache Storage System for Analytical Databases 2021 VLDB 5.1847534e-05
7,407 Intermittent Query Processing 2019 VLDB 4.7373205e-05
8,886 Provenance-based Data Skipping 2022 VLDB 4.4279829e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 20 of 20 cited papers.

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

Rank Cited Paper Year Venue Pagerank
60 Efficiently Compiling Efficient Query Plans for Modern Hardware 2011 VLDB 0.00064439773
71 How Good Are Query Optimizers, Really? 2016 VLDB 0.00059038975
442 Semantic Data Caching and Replacement 1996 VLDB 0.000230437
515 QPipe: A Simultaneously Pipelined Relational Query Engine 2005 SIGMOD 0.00021214633
731 Optimizing Queries Using Materialized Views: A Practical, Scalable Solution 2001 SIGMOD 0.00017468889
830 Main-Memory Scan Sharing For Multi-Core CPUs 2008 VLDB 0.00016171897
940 SharedDB: Killing One Thousand Queries With One Stone 2012 VLDB 0.00015173166
1,026 Cooperative Scans: Dynamic Bandwidth Sharing in a DBMS 2007 VLDB 0.00014589172
1,101 Generic Database Cost Models for Hierarchical Memory Systems 2002 VLDB 0.00014070632
1,397 Analytic Database Technologies for a New Kind of User - The Data Enthusiast 2012 SIGMOD 0.00012199672
1,429 A Scalable, Predictable Join Operator for Highly Concurrent Data Warehouses 2009 VLDB 0.00012033518
1,607 A Comprehensive Study of Main-Memory Partitioning and its Application to Large-Scale Comparison- and Radix-Sort 2014 SIGMOD 0.00011162682
2,050 Optimal Top-Down Join Enumeration 2007 SIGMOD 9.6886663e-05
2,363 Merging What’s Cracked, Cracking What’s Merged: Adaptive Indexing in Main-Memory Column-Stores 2011 VLDB 8.9580928e-05
2,372 Predictable Performance for Unpredictable Workloads 2009 VLDB 8.947963e-05
2,418 Tupleware: "Big" Data, Big Analytics, Small Clusters 2015 CIDR 8.8556595e-05
2,693 An Architecture for Recycling Intermediates in a Column-store 2009 SIGMOD 8.2883398e-05
2,925 Shared Workload Optimization 2014 VLDB 7.888494e-05
3,703 Multi-Query Optimization in MapReduce Framework 2014 VLDB 6.8289978e-05
3,821 Locality-aware Partitioning in Parallel Database Systems 2015 SIGMOD 6.7281515e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
2,275 Adopting Worst-Case Optimal Joins in Relational Database Systems 2020 VLDB 9.1262202e-05
1,063 Tradeoffs in Processing Complex Join Queries via Hashing in Multiprocessor Database Machines 1990 VLDB 0.00014362773
1,309 Query Processing in Main Memory Database Management Systems 1986 SIGMOD 0.00012660929
11,152 Pipeline Group Optimization on Disaggregated Systems 2023 CIDR 4.1945683e-05
5,301 ReCache: Reactive Caching for Fast Analytics over Heterogeneous Data 2018 VLDB 5.5790928e-05
1,050 Buffering Database Operations for Enhanced Instruction Cache Performance 2004 SIGMOD 0.00014453896
1,016 Memory-Efficient Hash Joins 2015 VLDB 0.00014638492
9,464 Memory Efficient Scheduling of Query Pipeline Execution 2022 CIDR 4.3355852e-05
540 Design and Evaluation of Main Memory Hash Join Algorithms for Multi-core CPUs 2011 SIGMOD 0.0002063443
2,693 An Architecture for Recycling Intermediates in a Column-store 2009 SIGMOD 8.2883398e-05