Online analytical processing (OLAP) is a way of doing data analysis. It is similar to data mining. Both are business tools that can help management take decisions. Unlike data mining though, OLAP is about verifying a hypothesis.
|
|---|
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
- 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
|
|---|
|
|
Related |
|---|
| People |
- Bill Inmon
- Ralph Kimball
- Dan Linstedt
|
|---|
| Products |
- Comparison of OLAP servers
!--<*Data warehousing products and their producers-->
|
|---|
|
|