DBScholar

Back to papers

Hashing Methods and Relational Algebra Operations

Summary: Introduces hash-based algorithms for relational algebra and set operations, with execution-time analysis against nested-loop and sort-merge methods on disk-based monoprocessors. Highlights hashing’s promise for multiprocessor/multimachine database machines and implementation in the TECHRA technical database system. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID
7849
Venue
VLDB
Year
1984
Pagerank
0.00036536643
Overall Rank
80 | 99.46%
DOI
-

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{bratbergsengen_vldb84,
        title = {{Hashing Methods and Relational Algebra Operations}},
        author = {Bratbergsengen, Kjell},
        journal = {PVLDB},
        series = {{VLDB} '84},
        pages = {323},
        year = {1984}
}

Incoming Citations (Sorted by Pagerank)

Showing 42 of 42 citing papers.

Rank Citing Paper Year Venue Pagerank
9 Online Aggregation 1997 SIGMOD 0.00077458002
52 GAMMA - A High Performance Dataflow Database Machine 1986 VLDB 0.00041107291
152 Multiprocessor Hash-Based Join Algorithms 1985 VLDB 0.00029038365
192 Grammar-like Functional Rules for Representing Query Optimization Alternatives 1988 SIGMOD 0.00026028406
242 A Performance Evaluation of Four Parallel Join Algorithms in a Shared-Nothing Multiprocessor Environment 1989 SIGMOD 0.00023604323
252 Multi-Core, Main-Memory Joins: Sort vs. Hash Revisited 2014 VLDB 0.00023242719
342 R* Optimizer Validation and Performance Evaluation for Distributed Queries 1986 VLDB 0.00020673706
396 R* Optimizer Validation and Performance Evaluation for Local Queries 1986 SIGMOD 0.00019287574
698 Optimization of Large Join Queries: Combining Heuristics and Combinatorial Techniques 1989 SIGMOD 0.00014879675
801 Query Execution Techniques for Caching Expensive Methods 1996 SIGMOD 0.00013909408
1,151 Set Containment Joins: The Good, The Bad and The Ugly 2000 VLDB 0.00011938186
1,355 Query Processing in Main Memory Database Management Systems 1986 SIGMOD 0.0001105702
1,568 Evaluation of Main Memory Join Algorithms for Joins with Subset Join Predicates 1997 VLDB 0.0001034191
1,650 Some Experimental Results on Distributed Join Algorithms in a Local Network 1985 VLDB 0.00010115373
1,779 An Adaptive Hash Join Algorithm for Multiuser Environments 1990 VLDB 9.7764427e-05
1,809 Hash joins and hash teams in Microsoft SQL Server 1998 VLDB 9.7034998e-05
1,975 Morton Filters: Faster, Space-Efficient Cuckoo Filters via Biasing, Compression, and Decoupled Logical Sparsity 2018 VLDB 9.3645236e-05
2,470 Hash-Based Join Algorithms for Multiprocessor Computers with Shared Memory 1990 VLDB 8.5330174e-05
2,846 Dynamic Load Balancing in Hierarchical Parallel Database Systems 1996 VLDB 8.0594267e-05
3,011 Design and Evaluation of Parallel Pipelined Join Algorithms 1987 SIGMOD 7.8532781e-05
3,571 Looking Ahead Makes Query Plans Robust: Making the Initial Case with In-Memory Star Schema Data Warehouse Workloads 2017 VLDB 7.2991953e-05
4,073 Stable Learned Bloom Filters for Data Streams 2020 VLDB 6.9242783e-05
4,104 Memory-Contention Responsive Hash Joins 1994 VLDB 6.8987972e-05
4,347 Avoiding Sorting and Grouping In Processing Queries 2003 VLDB 6.7509984e-05
4,501 GhostDB: Querying Visible and Hidden Data Without Leaks 2007 SIGMOD 6.6601566e-05
4,553 Predicate Transfer: Efficient Pre-Filtering on Multi-Join Queries 2024 CIDR 6.6346951e-05
4,849 Bitvector-aware Query Optimization for Decision Support Queries 2020 SIGMOD 6.4803828e-05
5,443 Generalized Hash Teams for Join and Group-by 1999 VLDB 6.2177595e-05
5,495 Efficient Main Memory Data Management Using the DBGraph Storage Model 1990 VLDB 6.1987657e-05
5,529 Debunking the Myth of Join Ordering: Toward Robust SQL Analytics 2025 SIGMOD 6.18591e-05
6,207 The 3D Hash Join: Building On Non-Unique Join Attributes 2022 CIDR 5.9429869e-05
6,539 Prefix Filter: Practically and Theoretically Better Than Bloom 2022 VLDB 5.8473945e-05
6,586 Diag-Join: An Opportunistic Join Algorithm for 1:N Relationships 1998 VLDB 5.8345497e-05
6,608 A Superjoin Algorithm for Deductive Databases 1986 VLDB 5.8231458e-05
6,823 A Performance Analysis of the Gamma Database Machine 1988 SIGMOD 5.7627061e-05
7,109 An Observation on Database Buffering Performance Metrics 1986 VLDB 5.7004478e-05
7,595 Query Processing Techniques for Multiversion Access Methods 1996 VLDB 5.5888857e-05
7,705 A Study of Sort Algorithms for Multiprocessor Database Machines 1986 VLDB 5.5642777e-05
8,413 Conditional Cuckoo Filters 2021 SIGMOD 5.4306049e-05
8,721 Accelerate Distributed Joins with Predicate Transfer 2025 SIGMOD 5.3772617e-05
9,279 Including Bloom Filters in Bottom-up Optimization 2025 SIGMOD 5.2934632e-05
10,989 Selective Late Materialization in Modern Analytical Databases 2025 VLDB 5.093636e-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
45 Benchmarking Database Systems: A Systematic Approach 1983 VLDB 0.00045531113
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 904 Tradeoffs in Processing Complex Join Queries via Hashing in Multiprocessor Database Machines 1990 VLDB
2 5,443 Generalized Hash Teams for Join and Group-by 1999 VLDB
3 242 A Performance Evaluation of Four Parallel Join Algorithms in a Shared-Nothing Multiprocessor Environment 1989 SIGMOD
4 152 Multiprocessor Hash-Based Join Algorithms 1985 VLDB
5 4,668 Performance Analysis of a Load Balancing Hash-Join Algorithm for a Shared Memory Multiprocessor 1991 VLDB
6 2,470 Hash-Based Join Algorithms for Multiprocessor Computers with Shared Memory 1990 VLDB
7 360 Design and Evaluation of Main Memory Hash Join Algorithms for Multi-core CPUs 2011 SIGMOD
8 3,011 Design and Evaluation of Parallel Pipelined Join Algorithms 1987 SIGMOD
9 1,479 Computing Joins Of Relations 1975 SIGMOD
10 1,809 Hash joins and hash teams in Microsoft SQL Server 1998 VLDB