Template:Data warehouses

Data warehouses

Creating a data warehouse

Concepts	Database Dimension Dimensional modeling Fact OLAP Star schema Snowflake schema Reverse star schema Aggregate Single version of the truth
Variants	Column-oriented DBMS Data hub Data mesh Ensemble modeling patterns Anchor modeling Data vault modeling Focal point modeling HOLAP MOLAP ROLAP Operational data store
Elements	Data dictionary/Metadata Data mart Sixth normal form Surrogate key
Fact	Fact table Early-arriving fact Measure
Dimension	Dimension table Degenerate Slowly changing
Filling	Extract, transform, load (ETL) Extract, load, transform (ELT) Extract Transform Load

Using a data warehouse

Concepts	Business intelligence Dashboard Data mining Decision support system (DSS) OLAP cube Data warehouse automation
Languages	Data Mining Extensions (DMX) MultiDimensional eXpressions (MDX) XML for Analysis (XMLA)
Tools	Business intelligence software Reporting software Spreadsheet

People	Bill Inmon Information factory Ralph Kimball Enterprise bus Dan Linstedt
Products	Comparison of OLAP servers !--<*Data warehousing products and their producers-->

Retrieved from "https://simple.wikipedia.org/w/index.php?title=Template:Data_warehouses&oldid=9588109"