Data model

The data model defines how we provide structure for data and how to connect data to other data.

Data modelDefine how we provide structure for data and how to connect data to other data.

We have many different types of data models. They can all be classified into 2 main categories:Conceptual modelwithLogical model.

The most famous conceptual model isEntity relationshipModel, also called ER. This is the best way to organize your data when you are in the design phase, because it is the closest model we believe is the closest and is not linked to any specific implementation.

On the other hand, the logical model isCloser to implementation.

The logical model includes (among others):

You can see that the name has provided us with hints on how to implement these models: the table of the relational model, the tree of the hierarchical model, the graph of the mesh model, the object of the object model.

ThisRelational modelWe will introduce this logical model in detail soon because it is the basis of popular relational databases (including PostgreSQL, MySQL, SQLite, and SQL Server).

Conceptual model and logical model are two different tools. Using one does not exclude the other. We can start with the conceptual model, and then use the logical model to implement it.


More database tutorials: