Database Paper Browser

Back to papers

Hashing Methods and Relational Algebra Operations

Summary: Hashing-based relational-algebra algorithms for projection, equi-join, division, union, difference, and intersection; performance vs nested-loop and sort-merge on a monoprocessor with disks. Excludes selection and inequijoins; demonstrates hashing scalability for multiprocessor/multi-machine DBMS, with TECHRA in CAD, utility maps, and oil-field exploration. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
7659
Venue
VLDB
Year
1984
Pagerank
0.00078665259
Overall Rank
30 | 99.80%
DOI
-

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 42 of 42 citing papers.

Rank Citing Paper Year Venue Pagerank
14 Online Aggregation 1997 SIGMOD 0.0010813443
21 GAMMA - A High Performance Dataflow Database Machine 1986 VLDB 0.00086104592
77 Multiprocessor Hash-Based Join Algorithms 1985 VLDB 0.00056488357
196 R* Optimizer Validation and Performance Evaluation for Distributed Queries 1986 VLDB 0.00035240105
220 Grammar-like Functional Rules for Representing Query Optimization Alternatives 1988 SIGMOD 0.00033312045
230 A Performance Evaluation of Four Parallel Join Algorithms in a Shared-Nothing Multiprocessor Environment 1989 SIGMOD 0.00032145125
269 R* Optimizer Validation and Performance Evaluation for Local Queries 1986 SIGMOD 0.00029665158
403 Multi-Core, Main-Memory Joins: Sort vs. Hash Revisited 2014 VLDB 0.00024176677
699 Query Execution Techniques for Caching Expensive Methods 1996 SIGMOD 0.0001794078
782 Optimization of Large Join Queries: Combining Heuristics and Combinatorial Techniques 1989 SIGMOD 0.00016665859
1,043 Set Containment Joins: The Good, The Bad and The Ugly 2000 VLDB 0.00014468616
1,277 Some Experimental Results on Distributed Join Algorithms in a Local Network 1985 VLDB 0.00012859308
1,337 Query Processing in Main Memory Database Management Systems 1986 SIGMOD 0.00012515176
1,559 Evaluation of Main Memory Join Algorithms for Joins with Subset Join Predicates 1997 VLDB 0.00011368746
1,861 An Adaptive Hash Join Algorithm for Multiuser Environments 1990 VLDB 0.00010297093
1,902 Hash joins and hash teams in Microsoft SQL Server 1998 VLDB 0.0001015225
2,416 Dynamic Load Balancing in Hierarchical Parallel Database Systems 1996 VLDB 8.8520203e-05
2,469 Morton Filters: Faster, Space-Efficient Cuckoo Filters via Biasing, Compression, and Decoupled Logical Sparsity 2018 VLDB 8.7255912e-05
2,599 Design and Evaluation of Parallel Pipelined Join Algorithms 1987 SIGMOD 8.4655075e-05
2,622 Hash-Based Join Algorithms for Multiprocessor Computers with Shared Memory 1990 VLDB 8.4404954e-05
4,149 Memory-Contention Responsive Hash Joins 1994 VLDB 6.4043572e-05
4,223 GhostDB: Querying Visible and Hidden Data Without Leaks 2007 SIGMOD 6.3409417e-05
4,272 Looking Ahead Makes Query Plans Robust: Making the Initial Case with In-Memory Star Schema Data Warehouse Workloads 2017 VLDB 6.2933353e-05
4,336 Avoiding Sorting and Grouping In Processing Queries 2003 VLDB 6.2716355e-05
4,448 Stable Learned Bloom Filters for Data Streams 2020 VLDB 6.1741316e-05
5,005 Efficient Main Memory Data Management Using the DBGraph Storage Model 1990 VLDB 5.7599923e-05
5,195 Bitvector-aware Query Optimization for Decision Support Queries 2020 SIGMOD 5.6314278e-05
5,329 Generalized Hash Teams for Join and Group-by 1999 VLDB 5.5652298e-05
5,772 Predicate Transfer: Efficient Pre-Filtering on Multi-Join Queries 2024 CIDR 5.3313794e-05
5,912 A Superjoin Algorithm for Deductive Databases 1986 VLDB 5.2712815e-05
6,343 An Observation on Database Buffering Performance Metrics 1986 VLDB 5.0970995e-05
6,453 Diag-Join: An Opportunistic Join Algorithm for 1:N Relationships 1998 VLDB 5.0514579e-05
6,523 The 3D Hash Join: Building On Non-Unique Join Attributes 2022 CIDR 5.0228804e-05
6,629 A Performance Analysis of the Gamma Database Machine 1988 SIGMOD 4.9817911e-05
6,829 Prefix Filter: Practically and Theoretically Better Than Bloom 2022 VLDB 4.9083308e-05
7,122 Debunking the Myth of Join Ordering: Toward Robust SQL Analytics 2025 SIGMOD 4.8199209e-05
7,457 A Study of Sort Algorithms for Multiprocessor Database Machines 1986 VLDB 4.7202404e-05
7,601 Query Processing Techniques for Multiversion Access Methods 1996 VLDB 4.6967949e-05
8,499 Conditional Cuckoo Filters 2021 SIGMOD 4.4929219e-05
8,777 Accelerate Distributed Joins with Predicate Transfer 2025 SIGMOD 4.4492064e-05
9,193 Including Bloom Filters in Bottom-up Optimization 2025 SIGMOD 4.372803e-05
10,762 Selective Late Materialization in Modern Analytical Databases 2025 VLDB 4.1905499e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 1 of 1 cited papers.

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

Rank Cited Paper Year Venue Pagerank
10 Benchmarking Database Systems: A Systematic Approach 1983 VLDB 0.0012093675
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
1,063 Tradeoffs in Processing Complex Join Queries via Hashing in Multiprocessor Database Machines 1990 VLDB 0.00014352292
5,329 Generalized Hash Teams for Join and Group-by 1999 VLDB 5.5652298e-05
230 A Performance Evaluation of Four Parallel Join Algorithms in a Shared-Nothing Multiprocessor Environment 1989 SIGMOD 0.00032145125
77 Multiprocessor Hash-Based Join Algorithms 1985 VLDB 0.00056488357
4,398 Performance Analysis of a Load Balancing Hash-Join Algorithm for a Shared Memory Multiprocessor 1991 VLDB 6.2137073e-05
2,622 Hash-Based Join Algorithms for Multiprocessor Computers with Shared Memory 1990 VLDB 8.4404954e-05
538 Design and Evaluation of Main Memory Hash Join Algorithms for Multi-core CPUs 2011 SIGMOD 0.00020632609
2,599 Design and Evaluation of Parallel Pipelined Join Algorithms 1987 SIGMOD 8.4655075e-05
445 Computing Joins Of Relations 1975 SIGMOD 0.00023029279
1,902 Hash joins and hash teams in Microsoft SQL Server 1998 VLDB 0.0001015225