Template:Data warehouses

From HandWiki

Revision as of 14:39, 11 July 2021 by imported>Jworkorg (import)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Data warehouses

Creating a data warehouse

Concepts	Database Dimension Dimensional modeling Fact OLAP Star schema Snowflake schema Reverse star schema Aggregate
Variants	Anchor modeling Column-oriented DBMS Data vault 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 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 Ralph Kimball
Products	Comparison of OLAP servers Data warehousing products and their producers

Template documentation[create]

Editors can experiment in this template's sandbox and testcases pages.
Please add categories to the /doc subpage. Subpages of this template.

Retrieved from "https://handwiki.org/wiki/index.php?title=Template:Data_warehouses&oldid=13073"

Hidden category:

Computing navigational boxes