Olap Data Cube Operations PDF

Preview

Summary

OLAP data cube...

Description

OLAP DATA CUBE

1

Olap Data Cube Operations Gualm Mohammad SEC 6050 Wilmington University

The term Online Analytic Processing also called as the OLAP and data warehousing have

OLAP DATA CUBE

2

a direct and huge impact on the decision support system and the business intelligence systems of the organizations. The primary function of the OLAP systems is to help the organizations in data warehousing and also to analyze the data of the organization in a more effective and efficient manner. The dimensional modelling in the data warehousing that allows the organizations to analyze the data effectively is the support that they get from using OLAP. this efficiency allows for a greater category of business intelligence like relational database, data mining and report writing (Rouse, 2012). A majority of the OLAP applications include sales reporting, marketing, business process management, forecasting, budgeting, creating finance reports and many others. To put it in simple words, OLAP data cube is a method of storing data in a multidimensional form, that generally is used for reporting purpose. In OLAP cubes, data is primarily is categorized by the measure of dimensions. OLAP cubes are often pre-summarized across dimensions to drastically improve query time over relational databases. The query language that is used to interact with the OLAP cubes and perform multiple tasks is called as the multidimensional expressions also known as the MDX (Rouse, 2012). The origin of MDX can be traced back to the early 1990’s and it was first founded by a technology giant Microsoft. Since its introduction, MDX has been adopted by millions of vendors that are the users of the multidimensional database. Out of the many of its one features, of the OLAP data cube, it stores data like a traditional database even though it is very much different in the structure. In contrast to the traditional databases which are designed in accordance to the very specific requirements of the IT systems that use them, whereas teh OLAP cubes are however, are primarily used by business owners for advanced analytics. The basic infrastructure of the OLAP data cubes are designed keeping in mind the business logic and the primary usage of the business owner. The OLAP data

OLAP DATA CUBE

3

cubes are specifically optimized for analytical purposes such that they can be used to generate report on millions of records of time. To make it simpler for business owners to operate, business owners can query OLAP data cubes using plain English. OLAP is known to provide a very convenient and user friendly environment for the use of interactive data analysis. A number of OLAP data cube operations exist to materialize different views of data, allowing interactive querying and analysis of data (Rouse, 2012). One major operation of the OLAP data cube is a roll up operation. A roll up operation is also known as the drill up or aggregation operation which is used to perform aggregation operations on a data cube, which is either by climbing up a concept hierarchy for a dimension or by climbing down a concept hierarchy, which is also called as the dimension reduction (Perficient, 2017). Another operation in the OLAP data cube is the slice operation. A slice in a multidimensional array is a column of data corresponding to a single value for one or more members of the dimension. In other words, it helps the users and business owners to visualize the information and gather information that is very specific to the dimension. Slicing operation can be visualized as a specific filter for a particular value in a dimension (Perficient, 2017). Another one of the OLAP data cube operation is the dicing function. Dicing is similar to slicing, but it works a little bit differently. When one thinks of slicing, filtering is done to focus on a particular attribute. Dicing, on the other hand, is more of a zoom feature that selects a subset over all the dimensions, but for specific values of the dimension (Perficient, 2017). Drill down is another operation for the OLAP data cube. It is actually the complete opposite of the roll up operation of the OLAP data cube operation. In this operation, the data is gathered and aggregated from a higher level summary to a lower level summary or detailed data (Perficient, 2017).

OLAP DATA CUBE

4

References M. Rouse., (April, 2017). OLAP cube. Retrieved from: https://searchdatamanagement.techtarget.com/definition/OLAP-cube PERFICIENT., (2017, August 02). Data Cubes Operations - SQL queries. Retrieved

OLAP DATA CUBE

from: https://blogs.perficient.com/2017/08/02/data-cube-operations-sql-queries/

5...