ABSTRACT

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.