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).

: 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

©2019-2020 Toolsou All rights reserved,
AWS Elastic Compute Cloud (Amazon EC2) Study notes ControllerAdvice Common scenes of PTA-MOOC《Python Programming Zhejiang University 》 Puzzle A Chapter 2 programming problems Dart In Isolatejetson Nano debugging CSI Interface camera , Combined use opencv Turn on the camera Knowledge points of preparing for the Blue Bridge Cup find method Force button 496 The next bigger element IBert/Transformer Calculation of model parameters 2020 year Java industry , General analysis of market environment and position Lambda Expression and functional interface