Please enable JavaScript.
Coggle requires JavaScript to display documents.
data management and visualization - Coggle Diagram
data management and visualization
First Part
Data warehouse design
Servers for data warehouse
Conceptual design
Dimensional Fact Model
Comparison with ER
Advanced DFM
Aggregate operators
Non distributive operators
Data Warehouse: Basic Concepts
What Is a Data Warehouse?
key features.
Subject-oriented
Integrated
Time-variant
Nonvolatile
Differences between Operational Database Systems
and Data Warehouses
OLTP vs OLAP
major distinguishing features of OLTP and OLAP
Users and system orientation
Data contents
Database design
View
Access patterns
database size
frequency of operations
performance metrics
But, Why Have a Separate DataWarehouse?
DataWarehousing: A Multitiered Architecture
three-tier data warehousing architecture
bottom tier: warehouse database server
The middle tier: OLAP server
The top tier: front-end client layer
DataWarehouse Models: EnterpriseWarehouse,
Data Mart, and VirtualWarehouse
OLAP analysis
Seconde part
NOSQL analysis
Third part
Data visulization
DBDMG.polito.it
Road map
Data source
Data storage (Data warehouse | Data matrs)
OLAP Analysis
Data visualization
