Online Analytical Processing is a widely used software technology that supports multi-dimensional data structures. OLAP systems are primarily used in IT organizations where tactical and strategic decisions are made by the workers. In doing so, these organizations help their workers by providing them adequate decision supporting systems that are enriched with the required corporate information. These systems are also called Online Analytical Processing which is best suited for those workers who want to manipulate operational data in a quick, intuitive and flexible manner using familiar terms.
OLAP systems are primarily used when there is a need of:
• Supporting complex analysis against large input data sets.
• Analyzing the data from different business dimensions.
• Supporting the complex analysis requirements of decision-makers
OLAP systems are mainly based on two major architectures. These architectures may be relational OLAP (ROLAP) and multidimensional OLAP (MOLAP). A multidimensional database is required during MOLAP architectures analysis whereas ROLAP architectures provide the end users access to data directly from data warehouses.
No comments:
Post a Comment