Skip to search formSkip to main contentSkip to account menu

Join (SQL)

Known as: Full outer join, Inner join sql, Cartesian join 
A SQL join clause combines columns from one or more tables in a relational database. It creates a set that can be saved as a table or used as it is… 
Wikipedia (opens in a new tab)

Related topics

Related topics

50 relations
ACIDAlgorithmAssociative entityBitmap index

Papers overview

Semantic Scholar uses AI to extract papers important to this topic.
2010
2010
A Global Relaxation Labeling Approach to Coreference Resolution
This paper presents a constraint-based graph partitioning approach to coreference resolution solved by relaxation labeling. The… 
2003
2003
Evaluation of Iceberg Distance Joins
The iceberg distance join returns object pairs within some distance from each other, provided that the first object appears at… 
2003
2003
Bitmap techniques for optimizing decision support queries and association rule algorithms
In this paper, we discuss some new bitmap techniques for optimizing decision support queries and association rule algorithm. We… 
2002
2002
Assessing Information Quality for the Composite Relational Operation Join
Information plays an increasingly important role in strategic decision-making processes within businesses. Therefore, information… 
2001
2001
Community assembly and the emergence of ecosystem pattern
A fundamental problem challenging natural scientists is to understand how macroscopic patterns, such as population abundance… 
1998
1998
Efficient Dynamic Programming Algorithms for Ordering Expensive Joins and Selections
The generally accepted optimization heuristics of pushing selections down does not yield optimal plans in the presence of… 
Highly Cited
1987
Highly Cited
1987
Design and evaluation of parallel pipelined join algorithms
The join operation is the most costly operation in relational database management systems. Distributed and parallel processing… 
1985
1985
The Equi-Join Operation on a Multiprocessor Database Machine: Algorithms and the Evaluation of their Performance
The equi-join operation is one of the most important operations of the relational data model. It participates in all queries… 
Highly Cited
1985
Highly Cited
1985
A fault-tolerant scheme for multistage interconnection networks
A scheme is proposed to e n h a n c e the fault-tolerance of multistage interconnection networks which only have a unique path… 
Highly Cited
1975
Highly Cited
1975
Computing joins of relations
Little has appeared on the problems of efficiently storing, accessing, and manipulating relations. These are of considerable… 
By clicking accept or continuing to use the site, you agree to the terms outlined in our Privacy Policy (opens in a new tab), Terms of Service (opens in a new tab), and Dataset License (opens in a new tab)