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...
DP-600 Fabric Analytics Engineer Exam: Impressions and Learning Tips!
Introduction The DP-600: Implementing Analytics Solutions Using Microsoft Fabric is a...
Understanding Star Schema vs. Snowflake Schema
When building data warehouses, the choice between a star schema and a snowflake schema is crucial....
Working with JSON in PostgreSQL, MySQL & SQL Server
Working with JSON in PostgreSQL, MySQL & SQL Server "Your data isn't always flat —...
Data Modeling - Entities and Events
Structuring data thoughtfully is critical for both operational efficiency and analytical value. Data...
Advanced Single Table Design Patterns With DynamoDB
To start the year strong I wanted to discuss and illustrate some essential concepts of solid DynamoDB...
Unlocking the Power of Dimensional Data Modeling (DDM)
Introduction Dimensional Data Modeling (DDM) is a key technique used in data warehousing to optimize...
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}...
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...
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...
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...
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...