Data warehouse-Logical Data Model and data warehouse logic model

Data warehouse-Logical Data Model and data warehouse logic model

In the data warehouse field, there is a concept called the logical data model. Chinese characters are generally translated as "logical data Models ". Logical Data Model Design and conceptual data model design and physical data model design are the three main steps for database and data warehouse model design.

The Logical Data Model reflects the point of view of the system analysis designer on data storage and further decomposes and refines the conceptual data model. The Logical Data Model is determined based on business rules. It provides a basic blueprint for the relationship between business objects, data items of business objects, and business objects.

The content of the Logical Data Model includes all objects and relationships. The attributes of each object are determined, the primary keys of each object are defined, and the foreign keys of the objects are specified, which must be normalized.

The goal of the Logical Data Model is to describe the data in as much detail as possible, but it does not consider how the data is physically implemented.

Logical Data Modeling not only affects the direction of database design, but also indirectly affects the performance and management of the final database. If you invest enough in implementing the Logical Data Model, there are many options to choose when designing the physical data model.

Article Source: http://www.chinabi.net/blog/user1/lastwood/1707.html