...

/

Data Models Overview

Data Models Overview

Learn how different data models define the structure and relationships of data.

We'll cover the following...

Before we can build powerful databases, we need to understand the blueprints that guide their construction. Imagine trying to build a house without a plan. We might end up with a very strange and unstable structure! A data model is like a blueprint for our data. 

By the end of this lesson, we will be able to:

  • Understand the concept of a data model and its importance.

  • Describe the characteristics of the hierarchical and network models.

  • Explain the structure and advantages of the relational model.

  • Understand the basics of modern document and graph models.

  • Learn how to choose the appropriate data model for different use cases.

Data model

A data model is a set of concepts and rules used to describe the structure of a database.

Think of it as the architect’s master plan. It provides a framework for organizing data and determining the relationships between different pieces of information. For example, in our OnlineStore database, a data model defines how a Customer is linked to their Orders, and how each Order is linked to specific Products.

Choosing the right data model is crucial because it affects how efficiently we can store, access, and manage data.

Just as a skyscraper needs a different blueprint than a single-family home, different types ...