Referential integrity
RDBMS usually support referential integrity. The idea of ensuring that values linking the tables together through the primary and foreign keys are valid and correctly synchronised.
A violation of referential integrity will happen if a foreign key value in a related table does not have a corresponding primary key value in the primary table. An RDBM prevents such a record from being entered.
Structured Query Language (SQL)
SQL is a standard language for accessing data in relational databases. It is used for querying, updating, and managing the data within these databases.
Performance optimisation
The goal of RDBMS performance optimisation is to improve storage efficiency (minimise storage space) and speed of access (minimise time to retrieve information).
- Storage efficiency
- Reduce redundant data
- Limit null values
- Database normalisation
Back to parent page: Database Systems