relationalalgebra课程.pptVIP

Fall 2001 Relational Algebra Relational Algebra A relation is a set of tuples. Each relational algebra operation takes as input a list of relations and produces a single relation. General form: OperatorArguments (List of Relations) ? New Relation After each operation, the remaining attributes are carried to the new relation. The attributes may be renamed, but their domain remains the same. Relational Algebra Operations Union R ? S Intersection R ? S Difference R - S Assignment S(B1…Bn) := R(A1…An) Selection R where C Projection R[A1…An] Product