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
hed6ef62b9c377b68
Venue
VLDB
Year
1984
Pagerank
0.00035942723
Overall Rank
83 | 99.45%
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 43 of 43 citing papers.

Rank Citing Paper Year Venue Pagerank
9 Online Aggregation 1997 SIGMOD 0.00076079812
55 GAMMA - A High Performance Dataflow Database Machine 1986 VLDB 0.00040385073
156 Multiprocessor Hash-Based Join Algorithms 1985 VLDB 0.00028431734
197 Grammar-like Functional Rules for Representing Query Optimization Alternatives 1988 SIGMOD 0.00025558952
249 A Performance Evaluation of Four Parallel Join Algorithms in a Shared-Nothing Multiprocessor Environment 1989 SIGMOD 0.00023099455
250 Multi-Core, Main-Memory Joins: Sort vs. Hash Revisited 2014 VLDB 0.00023080446
345 R* Optimizer Validation and Performance Evaluation for Distributed Queries 1986 VLDB 0.00020445813
396 R* Optimizer Validation and Performance Evaluation for Local Queries 1986 SIGMOD 0.00019119719
714 Optimization of Large Join Queries: Combining Heuristics and Combinatorial Techniques 1989 SIGMOD 0.00014578551
822 Query Execution Techniques for Caching Expensive Methods 1996 SIGMOD 0.00013616674
1,173 Set Containment Joins: The Good, The Bad and The Ugly 2000 VLDB 0.00011659702
1,386 Query Processing in Main Memory Database Management Systems 1986 SIGMOD 0.00010809129
1,598 Evaluation of Main Memory Join Algorithms for Joins with Subset Join Predicates 1997 VLDB 0.00010096339
1,676 Some Experimental Results on Distributed Join Algorithms in a Local Network 1985 VLDB 9.8971983e-05
1,808 An Adaptive Hash Join Algorithm for Multiuser Environments 1990 VLDB 9.5852314e-05
1,811 Hash joins and hash teams in Microsoft SQL Server 1998 VLDB 9.5759277e-05
1,856 Morton Filters: Faster, Space-Efficient Cuckoo Filters via Biasing, Compression, and Decoupled Logical Sparsity 2018 VLDB 9.4802321e-05
2,515 Hash-Based Join Algorithms for Multiprocessor Computers with Shared Memory 1990 VLDB 8.3437209e-05
2,911 Dynamic Load Balancing in Hierarchical Parallel Database Systems 1996 VLDB 7.8616647e-05
3,072 Design and Evaluation of Parallel Pipelined Join Algorithms 1987 SIGMOD 7.6662888e-05
3,602 Looking Ahead Makes Query Plans Robust: Making the Initial Case with In-Memory Star Schema Data Warehouse Workloads 2017 VLDB 7.1572829e-05
3,709 Stable Learned Bloom Filters for Data Streams 2020 VLDB 7.0586477e-05
4,136 Memory-Contention Responsive Hash Joins 1994 VLDB 6.7717644e-05
4,396 Predicate Transfer: Efficient Pre-Filtering on Multi-Join Queries 2024 CIDR 6.6072577e-05
4,415 Bitvector-aware Query Optimization for Decision Support Queries 2020 SIGMOD 6.5965677e-05
4,423 Avoiding Sorting and Grouping In Processing Queries 2003 VLDB 6.5900826e-05
4,608 GhostDB: Querying Visible and Hidden Data Without Leaks 2007 SIGMOD 6.4893006e-05
4,971 Debunking the Myth of Join Ordering: Toward Robust SQL Analytics 2025 SIGMOD 6.3209003e-05
5,169 The 3D Hash Join: Building On Non-Unique Join Attributes 2022 CIDR 6.2335575e-05
5,553 Generalized Hash Teams for Join and Group-by 1999 VLDB 6.0707293e-05
5,596 Efficient Main Memory Data Management Using the DBGraph Storage Model 1990 VLDB 6.054203e-05
6,205 Prefix Filter: Practically and Theoretically Better Than Bloom 2022 VLDB 5.8336044e-05
6,706 Diag-Join: An Opportunistic Join Algorithm for 1:N Relationships 1998 VLDB 5.6860841e-05
6,748 A Superjoin Algorithm for Deductive Databases 1986 VLDB 5.6736068e-05
6,976 A Performance Analysis of the Gamma Database Machine 1988 SIGMOD 5.6140776e-05
7,277 An Observation on Database Buffering Performance Metrics 1986 VLDB 5.5514928e-05
7,754 Query Processing Techniques for Multiversion Access Methods 1996 VLDB 5.443551e-05
7,874 A Study of Sort Algorithms for Multiprocessor Database Machines 1986 VLDB 5.4196188e-05
7,949 Including Bloom Filters in Bottom-up Optimization 2025 SIGMOD 5.4031665e-05
8,291 Accelerate Distributed Joins with Predicate Transfer 2025 SIGMOD 5.3445863e-05
8,604 Conditional Cuckoo Filters 2021 SIGMOD 5.2899825e-05
10,039 Selective Late Materialization in Modern Analytical Databases 2025 VLDB 5.0786422e-05
10,987 No Silver Bullet: Boosting GaussDB Performance on the 30TB TPC-H Workload 2026 VLDB 4.9605343e-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
46 Benchmarking Database Systems: A Systematic Approach 1983 VLDB 0.00044656322
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 5,553 Generalized Hash Teams for Join and Group-by 1999 VLDB
2 921 Tradeoffs in Processing Complex Join Queries via Hashing in Multiprocessor Database Machines 1990 VLDB
3 249 A Performance Evaluation of Four Parallel Join Algorithms in a Shared-Nothing Multiprocessor Environment 1989 SIGMOD
4 156 Multiprocessor Hash-Based Join Algorithms 1985 VLDB
5 4,775 Performance Analysis of a Load Balancing Hash-Join Algorithm for a Shared Memory Multiprocessor 1991 VLDB
6 2,515 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,072 Design and Evaluation of Parallel Pipelined Join Algorithms 1987 SIGMOD
9 1,516 Computing Joins Of Relations 1975 SIGMOD
10 1,811 Hash joins and hash teams in Microsoft SQL Server 1998 VLDB