Introduction to four types of database modeling methods in SQL Server

SQL ServerFour categoriesThe methods of data warehouse modeling are mainly divided into the following Four categories.

The first category is the three-paradigm modeling of relational databases. Usually we use the three-paradigm modeling method to build various operational database systems.

The second category is the three-paradigm data warehouse modeling advocated by Inmon, which is somewhat different in focus from the three-paradigm modeling of operational database systems.

Inmon’s data warehouse modeling method is divided into three layers. The first layer is the entity relationship layer, which is the enterprise’s business data model layer. This layer is combined with the enterprise’s operational database system modeling method. are the same; the second layer is the data item set layer. The modeling method at this layer is different from the modeling method of the enterprise's operational database system based on factors such as the frequency of data generation and access frequency; the third layer is physical. The layer is the specific implementation of the second layer.

The third category is the dimensional modeling of data warehouse advocated by Kimball. We generally call it star structure modeling, and sometimes add some snowflake models to it. Dimensional modeling is a modeling method that is oriented to user needs, easy to understand, and has high access efficiency. It is also a modeling method that the author prefers.

The fourth category is a more flexible modeling method. It is usually used in the backend data preparation area. The modeling method is eclectic and aims to meet the needs. The built tables are not suitable for users. Provides interfaces, mostly temporary tables.

The above is the detailed content of Introduction to four types of database modeling methods in SQL Server. For more information, please follow other related articles on the PHP Chinese website!