OLAP

(redirected from MOLAP)
Also found in: Acronyms, Wikipedia.

OLAP

OLAP

(OnLine Analytical Processing) Decision support software that allows the user to quickly analyze information that has been summarized into multidimensional views and hierarchies. OLAP tools are used to perform trend analysis on sales and financial information. They enable users to drill down into masses of sales statistics in order to isolate products that are the most volatile.

OLAP and MOLAP
Traditional OLAP products are also called "multidimensional OLAP" (MOLAP) because they summarize transactions into multidimensional views ahead of time. Data are organized into a cube structure that can be rotated by the user, which is particularly suited for financial summaries. Queries are fast because the consolidation has already been done.

Relational OLAP (ROLAP)
Relational OLAP tools extract data from relational databases. Using complex SQL statements against relational tables, ROLAP is able to create multidimensional views on the fly. ROLAP tends to be used on data that has a large number of attributes, where it cannot be easily placed into a cube structure. For example, customer data with numerous descriptive fields are typically ROLAP candidates, rather than financial data.

Database OLAP and Web OLAP (DOLAP and WOLAP)
A database OLAP refers to a relational DBMS that is designed to host OLAP structures and perform OLAP calculations. Web OLAP refers to OLAP data that is accessible from a Web browser. See MDX.
References in periodicals archive ?
A multi-dimensional model of a data warehouse star schema, snowflake schema, fact constellations and data cube consists of dimensions and measures, OLAP operations includes drilling, rolling, slicing, dicing and pivoting OLAP servers such as ROLAP, MOLAP, HOLAP.
Its optimized MOLAP engine uses new, more sophisticated processing algorithms to speed read and write-back tasks; in addition its workstation-resident data cache uses "intelligent" technology to reduce calls to the central server.
The Excel-to-Web solution also supports the Palo MOLAP Server which extends Excel's data model and is available free of charge under http://www.
It has historically been focused on business analysts at headquarters analyzing myriad data cubes using MOLAP (multi-dimensional online analysis processing) and ROLAP (relational online analysis processing) technology.
This technology brings the speed of MOLAP and the flexibility of ROLAP to both the headquarters and mobile users.
The product line works with legacy and warehoused data, and enhances the efficiency and speed of current OLAP (on-line analytical processing), MOLAP (multi-dimensionql on-line analytical processing) and ROLAP (relational on- line analytical processing) tools by supercharging their performance and effectiveness.
The enterprise ROLAP versus MOLAP argument will end the way all other open versus proprietary technology arguments end - when the performance and functionality gap has been narrowed enough, open technology will be the winner," said Andrew J.