Representing Data Sets

An Enterprise Database Server data set (or data file or relation) can be represented as a table with labeled columns. The column names are the data item names, and each row of the table is a member or record of the data set (or a record of the data file or a tuple of the relation). For example, employees can be described as having a name (consisting of 12 alpha characters), an age (consisting of a 2-digit number), and an employee number (consisting of a 5-digit number). The information about a particular group of employees can be represented as follows:

Name

Age

Employee Number

SMITH

34

04360

JONES

30

06872

SMITH

28

03162

The structure of this database could be represented in the DASDL description as follows. In the DASDL description, the employee number is represented by the identifier EMPNUM.

EMPLOYEES DATA SET
 (
  NAME      ALPHA(12);
  AGE       NUMBER(2);
  EMPNUM    NUMBER(5);
 );

The DASDL description of a database is independent of its data content. The preceding table has three lines, and the corresponding Enterprise Database Server database would have three records stored in the EMPLOYEES data set.