Tag: data modeling
All the articles with the tag "data modeling".
Data Modeling for Analytics: Optimize for Queries, Not Transactions
Published: at 03:00 PMThe data model that runs your production application is almost never the right model for analytics. Transactional systems are designed for fast writes — inse...
Slowly Changing Dimensions: Types 1-3 with Examples
Published: at 02:00 PMDimensions change. A customer moves cities. A product gets reclassified. An employee changes departments. How your data model handles these changes determine...
Dimensional Modeling: Facts, Dimensions, and Grains
Published: at 01:00 PMDimensional modeling is the most widely used approach for organizing analytics data. Developed by Ralph Kimball, it structures data into two types of tables:...