Movatterモバイル変換

[0]ホーム

Jump to content

Online analytical processing

Change links

From Simple English Wikipedia, the free encyclopedia

This article has many issues. Please helpfix them or discuss these issues on the article'stalk page.

The introduction to this articledoes not have enough information for people who do not know much about the subject. Please helpimprove the article with agood introductory style.(February 2023)

Anexpert on the subject should have a look at this article or section.
Please help recruit one orimprove this article yourself. See thetalk page for details.(February 2023)

Online analytical processing (OLAP) is a way of doingdata analysis. It is similar todata mining. Both are business tools that can help management take decisions. Unlike data mining though, OLAP is aboutverifying ahypothesis.

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-->

Thisshort article abouttechnology can be made longer. You can help Wikipedia byadding to it.

Retrieved from "https://simple.wikipedia.org/w/index.php?title=Online_analytical_processing&oldid=9598220"

Category:

Computing

Hidden categories:

[8]ページ先頭