OLAP
OLAP is Online Analytic Processing Tool is a data structure that allows fast analysis of data.This is to store and manage data’s that can be used to generate informations
OLAP is Online Analytic Processing Tool is a data structure that allows fast analysis of data.This is to store and manage data’s that can be used to generate informations
OLAP Cube
OLAP cubes is an array of data’s that helps in to rapid analysis. OLAP data is typically stored in a star schema or snowflake schema in a relational data warehouse or in a special-purpose data management system.
OLAP Tools
There are two types of OLAP tools, MOLAP (Multidimensional OLAP) and ROLAP (Relational OLAP).
Ø MOLAP - A cube is aggregated from the relational data source (data warehouse). When user generates a report request, the MOLAP tool can generate the create quickly because all data is already pre-aggregated within the cube.
Ø ROLAP - ROLAP engine essentially acts as a smart SQL generator instead of pre-aggregating everything into a cube.
Now, there is a convergence between the traditional ROLAP and MOLAP vendors. ROLAP vendor recognize that users want their reports fast, so they are implementing MOLAP functionalities in their tools.
OLAP cubes is an array of data’s that helps in to rapid analysis. OLAP data is typically stored in a star schema or snowflake schema in a relational data warehouse or in a special-purpose data management system.
OLAP Tools
There are two types of OLAP tools, MOLAP (Multidimensional OLAP) and ROLAP (Relational OLAP).
Ø MOLAP - A cube is aggregated from the relational data source (data warehouse). When user generates a report request, the MOLAP tool can generate the create quickly because all data is already pre-aggregated within the cube.
Ø ROLAP - ROLAP engine essentially acts as a smart SQL generator instead of pre-aggregating everything into a cube.
Now, there is a convergence between the traditional ROLAP and MOLAP vendors. ROLAP vendor recognize that users want their reports fast, so they are implementing MOLAP functionalities in their tools.