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… (More)
Wikipedia

Papers overview

Semantic Scholar uses AI to extract papers important to this topic.
Review
2016
Review
2016
People are sharing their opinions, stories and reviews through online video sharing websites every day. Studying sentiment and… (More)
  • figure 1
  • figure 2
  • figure 3
  • table 1
  • table 3
Is this relevant?
Highly Cited
2005
Highly Cited
2005
Devising a scheme for efficient and scalable querying of Resource Description Framework (RDF) data has been an active area of… (More)
  • figure 1
  • figure 2
  • table 2
  • figure 3
  • table 3
Is this relevant?
Highly Cited
2003
Highly Cited
2003
A plethora of data sources contain data entities that could be ordered according to a variety of attributes associated with the… (More)
  • figure 1
  • figure 3
  • figure 4
  • figure 5
  • figure 7
Is this relevant?
Highly Cited
2002
Highly Cited
2002
XML employs a tree-structured data model, and, naturally, XML queries specify patterns of selection predicates on multiple… (More)
  • figure 1
  • figure 2
  • figure 3
  • figure 5
  • figure 4
Is this relevant?
Highly Cited
2002
Highly Cited
2002
XML queries typically specify patterns of selection predicates on multiple elements that have some specified tree structured… (More)
  • figure 1
  • figure 2
  • figure 3
  • figure 4
  • figure 5
Is this relevant?
Highly Cited
1999
Highly Cited
1999
A major bottleneck in implementing sampling as a primitive relational operation is the inefficiency of sampling the output of a… (More)
  • table 1
  • figure 1
Is this relevant?
Highly Cited
1998
Highly Cited
1998
Two new spatial join operations, distance join and distance semi-join, are introduced where the join output is ordered by the… (More)
  • figure 2
  • figure 3
  • figure 4
  • table 1
  • figure 6
Is this relevant?
Highly Cited
1997
Highly Cited
1997
In this paper, we study a simple SQL extension that enables query writers to explicitly limit the cardinality of a query result… (More)
  • figure 1
  • figure 2
  • figure 6
  • figure 7
Is this relevant?
Highly Cited
1996
Highly Cited
1996
This paper describes PBSM (Partition Based Spatial-Merge), a new algorithm for performing spatial join operation. This algorithm… (More)
  • table 1
  • figure I
  • figure 3
  • figure 2
  • figure 5
Is this relevant?
Highly Cited
1987
Highly Cited
1987
In new application areas of relational database systems, such as artificial intelligence, the join operator is used more… (More)
  • figure 1
  • figure 2
  • figure 3
  • figure 5
  • figure 6
Is this relevant?