Shared Flashcard Set

Details

UCLA CS 143 Final Study
A couple cards for Cardenas' CS 143 ('12W)
5
Computer Science
Undergraduate 2
03/20/2012

Additional Computer Science Flashcards

 


 

Cards

Term
semi-join
Definition
Join A & B, but exclude all columns from B except join columns
Term
composition join
Definition
Join A & B, then exclude the joining domain
Term
outer join
Definition
An left outer join preserves elements in the left table that don't match the right table, filling in the right side with NULL values.
Term
equijoin
Definition
Basically a simple join (could be different-named columns)
Term
division
Definition
A (binary S:T) divided by B (unary T) produces values of S in A with matching T values.
Supporting users have an ad free experience!