Data Modeling Overview

What is data model?

A data model is a conceptual framework that defines the structure and relationships of data within a database or information system. It encompasses the organization of data elements and their interactions, providing a blueprint for storage, access, and manipulation. Typically categorized into conceptual, logical, and physical models, data models facilitate communication among stakeholders and guide the design and implementation of databases, ensuring data is organized efficiently and accurately to meet business requirements.

Models

Models are a fundamental unit in WrenAI that combines schemas, metadatas, relationships, calculated fields and more custom semantic information from the tables of your data source. Models help both people and our AI service to better understand data.

Views

Views are virtual tables that presents data retrieved from one or more underlying models in WrenAI. It does not store data itself but rather displays data derived from the tables based on a predefined query.
In WrenAI, we offer a save as view button in threads that allows you to save the result SQLs as views.

Entity Relationship Diagram (ERD)

In the Modeling page, WrenAI provides a entity relationship diagram that shows the schema of each model, and the relationships between models. In the diagram, you can distinguish between models and views based on block colors. Models are represented in blue, while views are depicted in green.