Shulou(Shulou.com)06/01 Report--

What does OLAP mean? I believe many inexperienced people are at a loss about it. Therefore, this article summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

Interpretation

OLAP:On line Analysis Processing online analytical processing

It enables analysts, managers or executives to quickly, consistently and interactively access the information transformed from the original data, which can be truly understood by users, and truly reflect the dimensional characteristics of the enterprise, from a variety of angles. in order to obtain a more in-depth understanding of the data of a kind of software technology.

Put forward

E.F.Codd (Father of Relational Database)

1993

Characteristics

Directly imitate the user's multi-angle thinking mode, and build a multi-dimensional data model for the user in advance.

Once the multi-dimensional data model is established, users can quickly obtain data from various analysis angles, and can also dynamically switch between various angles or carry out multi-angle comprehensive analysis, which has great analysis flexibility.

Function

Drillthrough (Drill-up and Drill-down):

Change the hierarchy of dimensions and transform the granularity of analysis-including drilling down (Drill-down) and drilling up (Drill-up) / up (Roll-up).

Drill-up is to generalize low-level detail data to high-level summary data in a certain dimension, or to reduce the dimension.

Drill-down, on the other hand, goes from aggregate data to detailed data to observe or add new dimensions.

Slice / Dice:

It is concerned about the distribution of the measurement data on the remaining dimensions after the values are selected on some dimensions. If there are only two remaining dimensions, it is sliced; if there are three or more, it is sliced.

Rotate (Pivot):

Is the direction of transforming dimensions, that is, rearranging the placement of dimensions in a table (such as column interchange)

Data warehouse VS OLAP

The relationship between data warehouse and OLAP is complementary. Modern OLAP systems are generally based on data warehouse, that is, a subset of detailed data is extracted from the data warehouse and stored in OLAP memory after necessary aggregation for front-end analysis tools to read.

OLAP VS OLTP

OLTP is the main application of traditional relational database, which mainly deals with basic and daily transactions, such as bank transactions.

OLAP is the main application of data warehouse system, supporting complex analysis operations, focusing on decision support, and providing intuitive and easy-to-understand query results.

After reading the above, have you mastered the method of what OLAP means? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.