Data warehouse data model refers to using entity , Attributes and their relationships define the operation and logic rules of enterprises , Coding and naming
Business system model Data warehouse model
For operational data For analytical data
Business oriented Orientation is the theme
Transactional , A large number of users DML handle Query analysis of a small number of users with large amount of data
Data processed by business processes Historical data and external data sets
High demand for real-time It has a certain degree of time delay
Online transaction processing （OLTP ） On line analytical processing （OLAP）
Data warehouse model =ods+ Dimension model + Wide table model
Dimension model is to analyze the needs of decision-making model design , Star model and snowflake model belong to dimension model .
The wide table is a combination of different business domains , Data fusion of different dimensions , It is convenient for data mining and analysis , Primary storage , Multiple reads , reduce IO, Trade space for time .
data warehouse （Data Warehouse）： It's a topic oriented one （Subject
Oriented）, Integrated （Integrated）, Relatively stable （Non-Volatile）, Reflecting historical changes （Time
Variant） Data collection for , Used to support management decisions (Decision Making Support).
ODS
： It's a topic oriented one , Integrated , Variable , Current detail data set , It is used to support the enterprise's , Operational , Requirements for integrated all information ,ods It is generally incremental or full storage of detailed data , Retain original cleaned data
Technology
Daily Recommendation