A Comprehensive Review on OLAP Models and operations

Authors : Max Rodrigues

Volume/Issue : Volume 2 - 2017, Issue 6 - June

Google Scholar : https://goo.gl/uGJodY

Scribd : https://goo.gl/caq5qW

Thomson Reuters ResearcherID : https://goo.gl/3bkzwv

In this paper, the Online Analytical Processing system (OLAP) and its logical models have been discussed. By the use of OLAP operations, data analysis is done which can be used to help the user or the person in decision making. The modern data warehouses store or accumulate a large amount of data to perform computations. Here, OLAP operations are used for the computation of complex sub queries in the data warehouse. Decision support systems depend on multidimensional modeling. Therefore, by using OLAP (Online Analytical Processing), decision makers can analyze the data and can arrive at a point where the highest probability of the decision taken will result in success. Data at different aggregation levels, are analyzed using OLAP operators such as roll-up and drilldown. Roll-up operators decrease the details of the measure, aggregating it along the dimension hierarchy and drill-down operators increase the details of the measure.

Keywords : OLAP, data warehousing, logical models


Paper Submission Last Date
30 - September - 2023

Paper Review Notification
In 1-2 Days

Paper Publishing
In 2-3 Days

Video Explanation for Published paper

Never miss an update from Papermashup

Get notified about the latest tutorials and downloads.

Subscribe by Email

Get alerts directly into your inbox after each post and stay updated.

Subscribe by RSS

Add our RSS to your feedreader to get regular updates from us.