CMM222 Database Organisations & Design (Minor)

Database Terminologies

Database

A collection of data stored in a standardized format, designed to be shared by multiple users. A collection of tables for a particular business situation.

Constraint

In SQL, a constraint is a rule that is enforced on the data. For example, there can be primary-key and foreign-key constraints that limit the data that can be entered into the declared columns. Other business rules can form constraints , such as Price > 0.

Data warehouse

A specialized database that is optimized for management queries. Data is extracted from online transaction processing systems, The data is cleaned and optimized for searching and analysis. Generally supported by parallel processing and RAID storage.

Durability

The transaction element that specifies that when a transaction is committed, all changes are permanently saved even if there is a hardware or system failure.

Edit

The Microsoft DAO command to alter data on the current row.