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
5324
Venue
SIGMOD
Year
2017
Pagerank
4.9242249e-05
Overall Rank
6,777 | 52.91%
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,354 Northstar: An Interactive Data Science System 2018 VLDB 0.00012424105
2,286 SMOKE: Fine-grained Lineage at Interactive Speed 2018 VLDB 9.102574e-05
3,610 EVA: A Symbolic Approach to Accelerating Exploratory Video Analytics with Materialized Views 2022 SIGMOD 6.919859e-05
4,020 Revisiting Reuse for Approximate Query Processing 2017 VLDB 6.5209063e-05
5,304 ReCache: Reactive Caching for Fast Analytics over Heterogeneous Data 2018 VLDB 5.5738777e-05
5,323 Can Learned Models Replace Hash Functions? 2023 VLDB 5.5671086e-05
6,152 Crystal: A Unified Cache Storage System for Analytical Databases 2021 VLDB 5.1802666e-05
7,397 Intermittent Query Processing 2019 VLDB 4.7367491e-05
8,886 Provenance-based Data Skipping 2022 VLDB 4.4237386e-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
59 Efficiently Compiling Efficient Query Plans for Modern Hardware 2011 VLDB 0.0006445664
71 How Good Are Query Optimizers, Really? 2016 VLDB 0.00059446482
444 Semantic Data Caching and Replacement 1996 VLDB 0.0002303513
515 QPipe: A Simultaneously Pipelined Relational Query Engine 2005 SIGMOD 0.00021209491
728 Optimizing Queries Using Materialized Views: A Practical, Scalable Solution 2001 SIGMOD 0.00017459654
826 Main-Memory Scan Sharing For Multi-Core CPUs 2008 VLDB 0.00016161625
934 SharedDB: Killing One Thousand Queries With One Stone 2012 VLDB 0.00015201246
1,027 Cooperative Scans: Dynamic Bandwidth Sharing in a DBMS 2007 VLDB 0.0001458537
1,100 Generic Database Cost Models for Hierarchical Memory Systems 2002 VLDB 0.00014062265
1,401 Analytic Database Technologies for a New Kind of User - The Data Enthusiast 2012 SIGMOD 0.00012190914
1,430 A Scalable, Predictable Join Operator for Highly Concurrent Data Warehouses 2009 VLDB 0.0001202506
1,610 A Comprehensive Study of Main-Memory Partitioning and its Application to Large-Scale Comparison- and Radix-Sort 2014 SIGMOD 0.00011155922
2,053 Optimal Top-Down Join Enumeration 2007 SIGMOD 9.682841e-05
2,361 Merging What’s Cracked, Cracking What’s Merged: Adaptive Indexing in Main-Memory Column-Stores 2011 VLDB 8.9648608e-05
2,372 Predictable Performance for Unpredictable Workloads 2009 VLDB 8.940791e-05
2,421 Tupleware: "Big" Data, Big Analytics, Small Clusters 2015 CIDR 8.8471956e-05
2,695 An Architecture for Recycling Intermediates in a Column-store 2009 SIGMOD 8.2827669e-05
2,928 Shared Workload Optimization 2014 VLDB 7.881485e-05
3,709 Multi-Query Optimization in MapReduce Framework 2014 VLDB 6.8211506e-05
3,825 Locality-aware Partitioning in Parallel Database Systems 2015 SIGMOD 6.7225803e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
2,281 Adopting Worst-Case Optimal Joins in Relational Database Systems 2020 VLDB 9.122455e-05
1,063 Tradeoffs in Processing Complex Join Queries via Hashing in Multiprocessor Database Machines 1990 VLDB 0.00014352292
1,337 Query Processing in Main Memory Database Management Systems 1986 SIGMOD 0.00012515176
11,155 Pipeline Group Optimization on Disaggregated Systems 2023 CIDR 4.1905499e-05
5,304 ReCache: Reactive Caching for Fast Analytics over Heterogeneous Data 2018 VLDB 5.5738777e-05
1,046 Buffering Database Operations for Enhanced Instruction Cache Performance 2004 SIGMOD 0.00014446882
1,016 Memory-Efficient Hash Joins 2015 VLDB 0.00014630024
9,466 Memory Efficient Scheduling of Query Pipeline Execution 2022 CIDR 4.3314303e-05
538 Design and Evaluation of Main Memory Hash Join Algorithms for Multi-core CPUs 2011 SIGMOD 0.00020632609
2,695 An Architecture for Recycling Intermediates in a Column-store 2009 SIGMOD 8.2827669e-05