Online analytical processing
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-->
The article is a derivative under the Creative Commons Attribution-ShareAlike License .
A link to the original article can be found here and attribution parties here
By using this site, you agree to the Terms of Use . Gpedia ® is a registered trademark of the Cyberajah Pty Ltd
