Conceptual model: refers to a model that abstracts and summarizes the essential characteristics of things with words. For example, the literal description of the same characteristics of eukaryotic cells, the explanation of the changes of matter and energy during photosynthesis, and the explanation model of Darwin's natural selection theory.
Mathematical model: a mathematical form used to describe a system or its characteristics. Such as: temperature (PH value), cell cycle duration of different cells and other effects on enzyme activity.
Extended data
Physical model, like the infrastructure of a building, is a common industry standard. Whether it is a skyscraper or a thatched cottage, in the eyes of an architect, he is just a building, and the foundation-a layer-by-layer building-is capped. This process is indispensable, which is related to the safety of residents and the quality of buildings must be guaranteed. The only difference is the building materials, the foundation is reinforced concrete or stone, and the walls are wood or reinforced concrete or bricks.
Of course, there will still be differences in materials and architectural details, depending on the cost given by users; Another point that can't be ignored is that the data in the data warehouse ranges from several hundred GB to several tens of TB. Faced with such a huge data management, no matter how powerful the RDBMS (Relational Database) supporting these data is, it is inevitable to consider the physical design of the database.
design basis
The work of physical model design is to determine the software and hardware configuration of data warehouse system, hierarchical design mode of data warehouse, data storage structure, indexing strategy, data storage location and storage allocation according to the capacity and complexity of information system, project resources and software life cycle of data warehouse project itself (of course, it can also be a non-data warehouse project). This part should be realized by the project manager and the data warehouse architect.
References:
Baidu encyclopedia physical model