Teradata/dbms/sql
Data Modeling Techniques There are 3 major modeling approaches : 1️⃣ ER Model (Entity Relationship Model) The Entity Relationship (ER) Model is a conceptual way of designing databases using: Entities Attributes Relationships Created by: Peter Chen Traditional OLTP systems Used in normalized databases Used in: Banking systems Transactional systems 2️⃣ Dimensional Modeling Dimensional Modeling is a data design technique used in Data Warehousing to support: Reporting BI tools Analytics Fast query performance It was popularized by Ralph Kimball . 👉 It is optimized for read performance , not transactions. Created by: Ralph Kimball Used in: Data Warehousing BI systems Reporting U...