Components of a Data Model
- Entities (or tables) - The “things” you track (like customers, orders, products).
- Attributes (or columns) - Details about those things (like customer name, order date, product price).
- Relationships - How things connect (like which customer placed which order).
Data Model Types
- Conceptual Data Models
- Logical Data Models
- Physical Data Models
Data Model Techniques
- Dimensional Modeling
- Fact Tables
- Dimensions
- Data Vault Modeling
References: Fayyad, U., Piatetsky-Shapiro, G., & Smyth, P. (1996). From Data Mining to Knowledge Discovery in Databases. AI Magazine, 17(3), 37. https://doi.org/10.1609/aimag.v17i3.1230
This blog is authored solely by me and reflects my personal opinions and experiences, not those of my employer. All references to products, including names, logos, and trademarks, belong to their respective owners and are used for identification purposes only.