Introduction to Data Models

A data model is a logical structure that incorporates the various tables present within a database, and the relationships between them. In essence, it outlines the connections present between the datasets existing in a particular database, thus illustrating how these datasets are stored and processed within the system.

Astera Data Warehouse Builder allows its users to create a data model from scratch using the entities available in the toolbox, or to generate a data model for an already existing database using the reverse engineer option. Moreover, you can also create and edit entity relationships, modify entity layouts, and add and modify indexes using this functionality.

Here is a sample data model that has been reverse engineered from an existing database.

The boxes represent the tables present in the database and the lines connecting these boxes are an indicator of the relationships between these tables.

In the next article, we will learn how to open a new data model in Astera Data Warehouse Builder.