Data Modeling Learning Note-"High quality Database Modeling 1-significance"

Https://edu.hellobi.com/course/54

High-quality Database modeling 1-significance

1. The concept and significance of the data model

dikw--(data) information (information) knowledge (knowledge) wisdom (Wisdom)

, I understand that information is obtained through data, knowledge is gained through information, and wisdom is generated through knowledge. The ultimate goal is to generate wisdom to generate decisions

2. What is a data model?

A data model is an organization of data elements in a standardized pattern to simulate the real-world information Framework Blueprint

3, the requirements of the data model:

1) Intuitive simulation of the world

2), easy to understand

3), convenient for computer implementation

4. Low-quality data Model 10 cases of crime

1), there is no accurate capture to the demand

2), the data model is incomplete

3), each layer model does not match its role

4), the data structure is unreasonable

5), lack of abstraction, resulting in inflexible models

6), no or do not follow the naming convention

7), lack of definition and description of the data model

8), data model readability is poor

9), meta data and data mismatch

10), data model inconsistent with enterprise standards

5. Impact of low-quality data models

1), a large number of modifications and redo

2), repeat construction

3), knowledge loss

4), Downstream development difficulties

5), High cost

6), Low data quality

7), new business can not be launched

6, the significance of building high-quality data model

1), System

A. More convenient system integration

B. More streamlined interfaces

2), data

A. Minimizing data redundancy

B. Compatible data

3), Commercial

A. More Business opportunities

B. Higher efficiency

C. Less risk

D. Lower costs

Reaching--Gong Zizhen

Data Warehouse is the cornerstone of all data projects, a slight change to a structure may affect a lot of ETL and reporting, so design should be considered thoughtful, adjust to be as cautious as possible

Qin people glance from the grief and then the sorrow of the future generations of grief and not to be judged, also make later generations also--du Mu

Upstream Data Warehouse modeling is not built, do not just spit groove squalling, at least you have to do the modeling in hand now, or your downstream will spit groove you

Data Modeling Learning Note-"High quality Database Modeling 1-significance"