In the relational model of data,
all data is perceived as existing in tables. Db2 for
i objects
are created and maintained as system objects.
The following table shows the relationship between system terms and SQL
relational database terms.
Table 1. Relationship of system terms to SQL terms
| System terms |
SQL terms |
| Library. Groups related objects and
allows you to find the objects by name. |
Schema. Consists of a library, a journal,
a journal receiver, an SQL catalog, and optionally a data dictionary. A schema
groups related objects and allows you to find the objects by name. |
| Physical file. A set of records. |
Table. A set of columns and rows. |
| Record. A set of fields. |
Row. The horizontal part of a table
containing a serial set of columns. |
| Field. One or more characters of related
information of one data type. |
Column. The vertical part of a table
of one data type. |
| Logical file. A subset of fields and
records of one or more physical files. |
View. A subset of columns and rows
of one or more tables. |
| SQL package. An object type that is
used to run SQL statements. |
Package. An object type that is used
to run SQL statements. |
| User Profile |
Authorization name or Authorization ID. |
|