Microsoft Fabric
The Secret Life of Keys
Most people who have come into contact with a database will be familiar with basic concepts like primary and foreign keys. Yet, many people, including many engineers, lack a formal background in database modeling, let alone set theory, and may be unfamiliar with the many key-related terms used by other team members and in online […]
Conceptual, Logical, Physical Data Modeling — What’s the Difference?
Data modeling is the craft of turning messy, real‑world questions into data that systems can trust and people can use. This article walks through the three classic layers of that craft—conceptual, logical, and physical modeling—showing how each one tightens the focus from broad business meaning to platform‑specific DDL while ensuring the integrity, performance, and governance that […]
From the Birth of Data Modeling to AI – Milestones and Timeline
These days, powerful cloud data platforms like Snowflake, Databricks, and BigQuery empower business-critical use cases from petabyte-scale analytics to cross-cloud data lakes and machine learning. But how did we get here? Many young data engineers might be surprised to learn that the journey of databases as we know them today dates back to the 1970s. […]
