Basic HTML version of Foils prepared 7 October 97

Foil 5 Some Basic Terminology for Relational Database Model

From untitled presentation ARL Database Tutorial -- February 98. by Gang Cheng, C.W. Ou, Geoffrey C. Fox


Data Structure
  • relations (files, tables)
  • tuples (records, rows)
  • attributes (fields, columns)
Relation operators
  • scan (select-project) (one or more tables , a condition to satisfy, and an attribute list)
  • sort (reorder)
  • aggregate operators (SUM,AVG,MAX,MIN,...)
  • insert/delete/update modification of tables
  • set operators (union, intersection, difference)
  • join, merge and division
  • operators can be embedded recursively with the characteristics:
    • uniformity of the data and operators as input and output is same data object (feature of 4GL)
    • source of data-flow execution model



© Northeast Parallel Architectures Center, Syracuse University, npac@npac.syr.edu

If you have any comments about this server, send e-mail to webmaster@npac.syr.edu.

Page produced by wwwfoil on Thu Feb 5 1998