SQL Server four class Data Warehouse modeling method

The methods for modeling SQL Server four data warehouses are mainly grouped into the following four categories.

The first class is the three-paradigm modeling of relational databases, and we usually use the three-normal modeling method to build various operational database systems.

The second type is the three-paradigm Data warehouse model advocated by Inmon, which is different from the three-paradigm modeling of operational database system.

Inmon Data Warehouse Modeling method is divided into three layers, the first layer is the entity relationship layer, also is the enterprise's business data Model layer, in this layer and enterprise's Operation database system modeling method is the same; the second layer is the data item set layer, The modeling method in this layer is different from the modeling method of operation database system based on the factors such as the frequency of data generation and the frequency of access. The third layer is the concrete realization of the second layer.

The third category is the dimension modeling of the Data warehouse advocated by Kimball, which we generally call star structure modeling, and sometimes adding some snowflake models in it. Dimension modeling is a kind of user-oriented, easy to understand, access-efficient modeling method, but also the author prefers a modeling approach.

The fourth class is a more flexible mode of modeling, usually used in the background of the data preparation area, modeling the way eclectic, to meet the needs of the purpose, built tables do not provide interface to users, mostly temporary tables.