Data Modeling

Purpose

Design a schema that supports the queries you need and the changes you will want. Schema mistakes are the most expensive category of technical debt because the data outlives every application that touched it.

When to Use

• Designing a new schema or a significant new table.
• Adding multi-tenancy to an existing model.
• Modeling history, versioning, or audit requirements.
• Reviewing a schema before it becomes hard to change.

Capabilities