Basic HTML version of Foils prepared 7 October 97

Foil 32 Some basic terminology for relational database model

From untitled presentation ARL Database Tutorial -- February 98. by Gang Cheng Marek Podgorny Chao-Wei Ou
Data Structure
  • relations (files, tables)
  • tuples (records, rows)
  • attributes (fields, columns)
Relation operators
  • scan (select-project) (a relation, a predicate, and an attribute list)
  • sort (reorder)
  • aggregate operators (SUM,AVG,MAX,MIN,...)
  • insert/delete/update
  • set operators (union, intersection, difference)
  • join, merge and division
embedded operators
  • uniformity of the data and operators
  • source of data-flow execution model

© on Mon Oct 13 1997