模板: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	商业智能 Dashboard 数据挖掘决策支持系统 OLAP cube Data warehouse automation
Languages	Data Mining Extensions (DMX) MultiDimensional eXpressions (MDX) XML for Analysis (XMLA)
Tools	Business intelligence software Reporting software 电子表格

导航菜单