Multidimensional Online Analytical Processing System
Jump to navigation
Jump to search
A Multidimensional Online Analytical Processing System is an OLAP system that (solves OLAP tasks) by means of a pre-computed OLAP cube.
- AKA: MOLAP.
- Context:
- It can be a HOLAP System.
- Example(s):
- Counter-Example(s):
- a ROLAP System.
- See: OLAP, Multidimensional Data Model, Pre-Computation, OLAP Cube, Relational Database.
References
2016
- (Wikipedia, 2016) ⇒ http://wikipedia.org/wiki/MOLAP Retrieved:2016-2-5.
- MOLAP (multidimensional online analytical processing) is an alternative to the ROLAP (Relational OLAP) technology. While both ROLAP and MOLAP analytic tools are designed to allow analysis of data through the use of a multidimensional data model, MOLAP differs significantly in that (in some software) it requires the pre-computation and storage of information in the cube — the operation known as processing. Most MOLAP solutions store these data in an optimized multidimensional array storage, rather than in a relational database (i.e. in ROLAP).
There are many methodologies and algorithms for efficient data storage, aggregation and implementation specific business logic with a MOLAP Solution. As a result there are many misconceptions to what the term specifically implies.
- MOLAP (multidimensional online analytical processing) is an alternative to the ROLAP (Relational OLAP) technology. While both ROLAP and MOLAP analytic tools are designed to allow analysis of data through the use of a multidimensional data model, MOLAP differs significantly in that (in some software) it requires the pre-computation and storage of information in the cube — the operation known as processing. Most MOLAP solutions store these data in an optimized multidimensional array storage, rather than in a relational database (i.e. in ROLAP).