Conceptual Every Record Counts: Data Engineering for Backend Engineers
Part 5: "Other Shapes" — Data Vault, Wide Tables and Modeling Trade-offs
Whose midnight cuts the quarter, and which rate converts the euros? Rohan models Larkspur's refunds as a Data Vault and as one wide table, then fixes the primitives under every model: money, time zones, FX as of the event and bitemporal history. Two revenue defects close to the penny and stock availability drops to 88.5%.