|
Erstellt von Amelie Stute
vor mehr als 4 Jahre
|
|
CAP-Theorem
Availability (CAP-Theorem)
Partition tolerance (CAP-Theorem)
Consistency (CAP-Theorem)
Is eventual consistency ok?
New Data related trends
New Data Sources
(Near) real-time ETL
Self-service BI & data discovery
Information Needs Analysis (Components)
Requested information
Information supply
Objective Information need
subjective Information need
Operational Objectives & Business Strategy
DWH Definition Inmon
Data mart
Disadvantages of Data marts
Design principles
Design principle Examples for each step
Designing the multidimensional model (Process)
Logical data modeling Schema /
Generic DWH schema
Advantages Snowflake-schema
Disadvantages snowflake-schema
Advantages Star Schema
Disadvantages Star-Schema
Ways to handle slowly changing dimensions