Articles by Tag #datamodeling
Browse our collection of articles on various topics related to IT technologies. Dive in and explore something new!
A Novel Pattern for Documenting DynamoDB Access Patterns
This blog post will introduce and explore a way of documenting Access Patterns for DynamoDB in JSON...
Understanding Star Schema vs. Snowflake Schema
When building data warehouses, the choice between a star schema and a snowflake schema is crucial....
Data Modeling - Entities and Events
Structuring data thoughtfully is critical for both operational efficiency and analytical value. Data...
DP-600 Fabric Analytics Engineer Exam: Impressions and Learning Tips!
Introduction The DP-600: Implementing Analytics Solutions Using Microsoft Fabric is a...
Data Modeling: From Basics to Advanced Techniques for Business Impact
Introduction: Why Data Modeling Matters In today’s fast-evolving, data-driven landscape,...
Slowly Changing Dimensions: Strategies for Maintaining History and Integrity in Analytical Systems
In analytical systems, dimensional data rarely remains static. Customer profiles, product attributes,...
Working with JSON in PostgreSQL, MySQL & SQL Server
Working with JSON in PostgreSQL, MySQL & SQL Server "Your data isn't always flat —...
Advanced Single Table Design Patterns With DynamoDB
To start the year strong I wanted to discuss and illustrate some essential concepts of solid DynamoDB...
What the Heck is Data Build Tool (dbt)
When I first started with dbt, I couldn't understand the idea behind running SQL on top of {Jinja}...
Study Notes 4.3.1 - Build the First dbt Models
1. Introduction to dbt Models dbt (Data Build Tool) sits on top of data platforms like...
From Redundancy to Reusability: A Better Way to Manage Shared Records in Relational Databases
The Use Case Let’s say we’re building a system to track maintenance sessions (WorkSession). Each...
Capture Slowly Changing Attributes in SQL - SCD Type 2
SCD is a data modeling technique used to track how changes in entity attributes affect behavior over...
Why Your API Strategy Fails Without a Proper Data Model
Let’s talk about something that’s been bugging me for years: the disconnect between how we design...
How to Design and Deploy Data Models as APIs with Negroni
You know the drill: you define your data model in one place, then spend hours (or days) wiring up...
Unlocking the Power of Dimensional Data Modeling (DDM)
Introduction Dimensional Data Modeling (DDM) is a key technique used in data warehousing to optimize...
Loop: life DWH, logical and physical models. Part 1
Loop is my pet project. Pet projects are sandboxes where any sandcastles can be built with the...
Star Schema vs Snowflake in 2025: The Final Verdict
Modern data warehouse design principles that will shape your architecture decisions As we navigate...