09 June 2009

DBMS: Joins (Definitions)

 "A basic operation in a relational system which links the rows in two or more tables by comparing the values in specified columns." (Karen Paulsell et al, "Sybase SQL Server: Performance and Tuning Guide", 1996)

"Process of combining data from two or more tables into a single operation." (Owen Williams, "MCSE TestPrep: SQL Server 6.5 Design and Implementation", 1998)

"As a verb, to combine the contents of two or more tables and produce a result set that incorporates rows and columns from each table. Tables are typically joined using data that they have in common. As a noun, join means the process or result of joining tables, as in the term inner join, which indicates a particular method of joining tables." (Microsoft Corporation, "SQL Server 7.0 System Administration Training Kit", 1999)

"The relational operator that allows data from multiple tables to be combined. A join matches rows of multiple tables based on columns with common values." (Peter Gulutzan & Trudy Pelzer, "SQL Performance Tuning", 2002)

"To combine two or more tables in a query to produce rows as a result of a comparison between columns in the tables." (Bob Bryla, "Oracle Database Foundations", 2004)

"The act of combining the data in two tables based on values found in each of the tables." (Thomas Moore, "EXAM CRAM™ 2: Designing and Implementing Databases with SQL Server 2000 Enterprise Edition", 2005)

"To combine data in two tables based on matching values found in each of the tables." (Thomas Moore, "MCTS 70-431: Implementing and Maintaining Microsoft SQL Server 2005", 2006)

"The matching of a record from one relational database table with a record in a second relational database table using a common column." (Reed Jacobsen & Stacia Misner, "Microsoft SQL Server 2005 Analysis Services Step by Step", 2006)

"Used to combine the contents of two or more tables. The most common join is an inner join. Other joins are left, right, full, and cross." (Darril Gibson, "MCITP SQL Server 2005 Database Developer All-in-One Exam Guide", 2008)

"A query that selects data from more than one table, usually using a JOIN or WHERE clause to indicate which records in the two tables go together." (Rod Stephens, "Beginning Database Design Solutions", 2008)

"A process or a result of combining the contents of two or more tables and producing a resultset that incorporates rows and columns from each table." (Jim Joseph, "Microsoft SQL Server 2008 Reporting Services Unleashed", 2009)

"A database operation used to merge data from two related tables that have common attributes." (Paulraj Ponniah, "Data Warehousing Fundamentals for IT Professionals", 2010)

"A relational algebra operation that combines two tables making new rows that are a combination of one row from each of the two source tables." (Jan L Harrington, "SQL Clearly Explained 3rd Ed. ", 2010)

"An operation in which the data from two tables is combined into a larger results table based on shared data values in each table." (Craig S Mullins, "Database Administration", 2012)

"To combine the contents of two or more tables and produce a result set that incorporates rows and columns from each table. Tables are typically joined using data that they have in common." (SQL Server 2012 Glossary, "Microsoft", 2012)

"A statement that retrieves data from multiple tables specified in the FROM clause of a SQL statement. Join types include inner joins, outer joins, and Cartesian joins." (Oracle, "Database SQL Tuning Guide Glossary", 2013)

"The process of merging two or more tables on the basis of a common key" (Daniel Linstedt & W H Inmon, "Data Architecture: A Primer for the Data Scientist", 2014)

"An SQL relational operation in which data can be retrieved from two tables, typically based on a join condition specifying join columns. See also equijoin, full outer join, inner join, left outer join, outer join, right outer join, star join." (Sybase, "Open Server Server-Library/C Reference Manual", 2019)

No comments:

Related Posts Plugin for WordPress, Blogger...

About Me

My photo
IT Professional with more than 24 years experience in IT in the area of full life-cycle of Web/Desktop/Database Applications Development, Software Engineering, Consultancy, Data Management, Data Quality, Data Migrations, Reporting, ERP implementations & support, Team/Project/IT Management, etc.