Comprehensive Survey of OLAP Models

On-Line Analytical Processing (OLAP) is an expertise that offers data discovery, including capabilities of complex analytical calculations, infinite report viewing and predictive "what if" scenario (forecast) planning. OLAP finds its applications in various Business Intelligence (BI) applications. OLAP's life blood is multi-dimensional data. OLAP differs from traditional databases in a way data is stored and conceptualized. As OLAP tools are intended to perform enquiry, these systems deliver fast answers for queries that aggregate large amount of detail data to find general trends in Data Warehouse (DW). A number of OLAP models are available, that show various contradictory trends in Data Warehouse. This paper summarizes the existing OLAP models utilized for extensive list of applications and further compares these models based on different parameters.