SQL relational database and system terminology

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.
Member. A defined subset of records in a physical file.	Partition. A defined subset of rows in a table.
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.