Chapter 9
Non-Data-Warehouse Antipatterns
Most applications rely on their database structure to help enforce data quality. Data warehouse applications are an exception—a data warehouse emphasizes the reading of data and makes data quality the responsibility of loading programs. The antipatterns in this chapter simplify reading but compromise the ability of database structure to enforce quality. Hence, these antipatterns are acceptable for data warehouses, but you should avoid them otherwise.
9.1 Derived Data Antipattern
9.1.1 Observation
A model has elements (entity types, relationships, attributes) that are not fundamental. These elements can be computed from other elements and lack substance in their own right. Derived data can complicate development ...
Get Patterns of Data Modeling now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
