Shulou(Shulou.com)06/03 Report--

Data model: a tool and method for abstract description of the real world, a mapping of the relationship between transactions in the real world through abstract entities and the form of relationships between entities. Here, the data model abstracts the relationship between entities and entities, and expresses the specific business relations in the actual business through the definition and description of the relationship between entities and entities.

.

Data warehouse model: a specific data model for a specific data warehouse application system in a data model. Generally speaking, the data warehouse model is divided into the following levels.

1) Business modeling, generating business model, mainly solving the decomposition and programming of business level, including the following parts:

.. a) divide the business of the whole unit, generally according to the business units, define the business work between the various parts, and clarify the relationship between the business departments.

.. b) in-depth understanding and programming of the internal specific business processes of each business unit.

C) propose and program ways to modify and improve the workflow of business units.

D) the scope definition of data modeling, the goal and phase division of the entire data warehouse project.

2) Domain modeling, generating domain model, mainly abstracting the business model and generating domain conceptual model, including the following parts:

.. a) extract and abstract key business concepts.

.. b) grouping business concepts and aggregating similar grouping concepts according to the main line of business.

.. c) refine the concept of grouping, clarify the business processes within the concept of grouping and abstract it.

.. d) sort out the relationship between grouping concepts and form a complete domain conceptual model.

3) logical modeling, generating logical model, mainly logicalizing the conceptual entities and the relationship between entities in the domain model at the database level, including the following parts:

.. a) materialize the business concept and consider its specific attributes

.. b) the event is materialized, taking into account its attribute content

.. C) describe the materialization and consider the content of its attributes

4) physical modeling, generating physical model, mainly solving the physical and chemical problems of logical model for different relational databases, including data redundancy and performance tradeoff, data type, length, index, data storage and other details. It includes the following parts:

.. a) make corresponding technical adjustments to the specific physical and chemical platform

.. b) adjust the specific platform accordingly according to the performance considerations of the model

.. C) make corresponding adjustments according to the needs of management and combined with specific platforms

.. d) generate the final execution script and improve

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.