Database Theory
Just as perhaps we take movie special effects for granted until we see what state of the art was in previous eras, so we can't fully appreciate the power of relational databases without seeing what preceded them.
Relational databases allow any table to relate to any other table through means of common fields. It is a highly flexible system, and most modern databases are relational.
-
Introduction to Relational Databases
Brief introduction to the concept of a relational database. -
Exploring Early Database Models
Before relational databases there were a number of other models -
Understanding the Hierarchical Database Model
The earliest model was the hierarchical database model, resembling an upside-down tree. -
Understanding the Network Database Model
A progression from the hierarchical model designed to solve some of its problems -
Understanding the Relational Database Model
The relational database model was a huge leap forward from the network data... -
Relational Databases: Basic Terms
The relational database model uses certain terms to describe its components -
Relational Databases: Table Keys
A key, or index, unlocks access to the tables -
Relational Databases: Foreign Keys
Foreign keys are the primary key in a foreign table -
Relational Databases: Views
Views are virtual tables -
Database Design
Articles about the database design process -
Database Normalization
Normalization is a powerful tool for designing databases -
ACID: Concurrency Control with Transactions
Ensuring data integrity.
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.