Data Modeling Styles in Data Warehousing

The paper presents a coordinated set of data modeling styles relevant for data warehouse design in the context of relational databases. The scope of presented models covers: a) entity relationship models of existing relational DB sources, b) logical data vault model for integrated enterprise data warehouses as a system of records, c) dimensional fact model for analysis leading to query prototyping and dimensional models, and d) dimensional model for data marts. There is no claim of sufficiency, uniqueness, and/or universality of the selected styles set except utility. The principal contributions of the paper are: definition of data modeling styles as distinct modeling mechanisms, and initial coordination of selected complementary styles.