3/17/2021 0 Comments Mysql Olap Cube
Hybrid OnlineAnalytical Processing (HOLAP) In HOLAP approach the aggregated totals are stored in a multidimensional database while the detailed data is stored in the relational database.It is a technology that enables analysts to extract and view business data from different points of view.These operations in relational databases are resource intensive.With OLAP data can be pre-calculated and pre-aggregated, making analysis faster.
The cubes are designed in such a way that creating and viewing reports become easy. In this tutorial, you will learn- OLAP cube Basic analytical operations of OLAP Types of OLAP systems ROLAP MOLAP Hybrid OLAP Advantages of OLAP Disadvantages of OLAP OLAP cube: At the core of the OLAP concept, is an OLAP Cube. The OLAP cube is a data structure optimized for very quick data analysis. ![]() Usually, data operations and analysis are performed using the simple spreadsheet, where data values are arranged in row and column format. However, OLAP contains multidimensional data, with data usually obtained from a different and unrelated source. The cube can store and analyze multidimensional data in a logical and orderly manner. How does it work A Data warehouse would extract information from multiple data sources and formats like text files, excel sheet, multimedia files, etc. ![]() Basic analytical operations of OLAP Four types of analytical operations in OLAP are: Roll-up Drill-down Slice and dice Pivot (rotate) 1) Roll-up: Roll-up is also known as consolidation or aggregation. The Roll-up operation can be performed in 2 ways Reducing dimensions Climbing up concept hierarchy. Concept hierarchy is a system of grouping things based on their order or level. They become 2000 after roll-up In this aggregation process, data is location hierarchy moves up from city to the country. In the roll-up process at least one or more dimensions need to be removed. In this example, Quater dimension is removed. Drill-down In drill-down data is fragmented into smaller parts. It can be done via Moving down the concept hierarchy Increasing a dimension Consider the diagram above Quater Q1 is drilled down to months January, February, and March. In this example, dimension months are added. Slice: Here, one dimension is selected, and a new sub-cube is created. Following diagram explain how slice operation performed: Dimension Time is Sliced with Q1 as the filter. The difference in dice is you select 2 or more dimensions that result in the creation of a sub-cube. Pivot In Pivot, you rotate the data axes to provide a substitute presentation of data. Types of OLAP systems OLAP Hierarchical Structure Type of OLAP Explanation Relational OLAP(ROLAP): ROLAP is an extended RDBMS along with multidimensional data mapping to perform the standard relational operation. Multidimensional OLAP (MOLAP) MOLAP Implementes operation in multidimensional data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |