Modern Database Management Chapter 6 – Introduction to SQL

Relational DBMS (RDBMS)
A database management system that manages data as a collection of tables in which all data relationships are represented by common values in related tables.
Catalog
A set of schemas that, when put together, constitute a description of a database.
Schema
A structure that contains descriptions of objects created by a user, such as base tables, views, and constraints, as part of a database.
Data definition language (DDL)
Commands used to define a database, including those for creating, altering, and dropping tables and establishing constraints.
Data manipulation language (DML)
Commands used to maintain and query a database, including those for updating, inserting, modifying and querying data.
Data control language (DCL)
Commands used to control a database, including those for administering privileges and committing (saving) data.
Scalar Aggregate
A single value returned from an SQL query that includes an aggregate function.
Vector aggregate
Multiple values returned from an SQL query that includes an aggregate function.
Base table
A table in the relational data model containing the inserted raw data. They correspond to the relations that are identified in the database’s conceptual schema.
Virtual table
A table constructed automatically as needed by a DBMS. They are not maintained as real data.
Dynamic view
A virtual table that is created dynamically upon request by a user. It is not a temporary table. Rather, its definition is stored in the system catalog, and the contents of the view are materialized as a result of an SQL query that uses the view. It differs a materialized view, which may be stored on a disk and refreshed at intervals or when used, depending on the RDBMS.
Materialized view
Copies or replicas of data, based on SQL queries created in the same manner as dynamic views. Hower, it exists as a table and thus care must be taken to keep it synchronized with its associated base tables.