Template:Data warehouse
|
|---|
创建数据仓库 |
|---|
| Concepts |
- 数据库
- Dimension
- Dimensional modeling
- Fact
- 線上分析處理
- 星型模式
- Snowflake schema
- Reverse star schema
- Aggregate
|
|---|
| Variants |
- Anchor Modeling
- 列式数据库
- Data vault modeling
- HOLAP
- MOLAP
- ROLAP
- ODS
|
|---|
| Elements | |
|---|
| Fact |
- Fact table
- Early-arriving fact
- Measure
|
|---|
| Dimension |
- Dimension table
- Degenerate
- Slowly changing
|
|---|
| Filling |
- ETL
- Extract
- Transform
- Load
|
|---|
|
|
使用数据仓库 |
|---|
| Concepts | |
|---|
| Languages |
- Data Mining Extensions (DMX)
- MultiDimensional eXpressions (MDX)
- XML for Analysis (XMLA)
|
|---|
| Tools |
- Business intelligence software
- Reporting software
- 電子試算表
|
|---|
|
|