Multidimensional Online Analytical Processing (MOLAP)

Multidimensional Online Analytical Programming (MOLAP) - OLAP that stores data and aggregations in a multidimensional database structures.

[Category=Data Warehousing ]

Source: SDG Computing Inc., 10 May 2010 09:40:02, SDG Computing, now offline

---

These advertisers support this free service

---

MOLAP - Multidimensional OLAP. MOLAP systems store data in the multidimensional cubes.

[Category=Data Warehousing ]

Source: Aexis Business Intelligence, 20 December 2010 10:08:23 , http://www.aexis.eu/DataWarehouse-Glossary/

---

MOLAP - When data is pre-calculated and stored in a cube, this is referred to as MOLAP or Multi-dimensional Online Analytical Processing.

[Category=Business Intelligence ]

Source: Deanna Dicken, 08 November 2012 11:20:03, http://www.databasejournal.com/features/mssql/article.php/3919011/Business-Intelligence-Terminology-101.htm  

---

MOLAP (multidimensional online analytical processing) - MOLAP (multidimensional online analytical processing) is online analytical processing (OLAP) that indexes directly into a multidimensional database. In general, an OLAP application treats data multidimensionally; the user is able to view different aspects or facets of data aggregates such as sales by time, geography, and product model. If the data is stored in a relational data base, it can be viewed multidimensionally, but only by successively accessing and processing a table for each dimension or aspect of a data aggregate. MOLAP processes data that is already stored in a multidimensonal array in which all possible combinations of data are reflected, each in a cell that can be accessed directly. For this reason, MOLAP is, for most uses, faster and more user-responsive than relational online analytical processing (ROLAP), the main alternative to MOLAP. There is also hybrid OLAP (HOLAP), which combines some features from both ROLAP and MOLAP.

MOLAP is often used as part of a data warehouse application.

Related glossary terms: Universal Data Access (UDA), hybrid online analytical processing (HOLAP or Hybrid OLAP), geographic information system (GIS), DSTP (Data Space Transfer Protocol), FileMaker (FMP), meta, data mining, pivot table, data warehouse / database warehouse, data preprocessing

[Category=Data Management ]

Source: WhatIs.com, 26 August 2013 09:26:42, http://whatis.techtarget.com/glossary/Data-and-Data-Management