Data Warehouse--Physical data model

There is a concept in the field of data warehousing called physical data model, which is generally translated into "physical data models". Physical data Model design and conceptual data model design and logical data Model design are the three main steps of database and data warehouse model design.

The physical data model is based on the logical data model, considering the specific technical implementation factors, designing the database architecture, and actually realizing the storage of the data in the database.

The contents of the physical data model include determining all the tables and columns, defining the relationships between the tables, and possibly making normalization based on the user's needs. Consideration of physical implementations may result in a large difference between the physical data model and the logical data model.

The goal of the physical data model is to specify how the database schema is used to implement the logical data model and to actually save the data.

Article from: http://www.chinabi.net/blog/user1/lastwood/1708.html

Data Warehouse--Physical data model