OLAP

(redirected from ROLAP)
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 ?
MicroStrategy's new In-memory ROLAP option is game changing.
We look forward to using MicroStrategy 9 In-memory ROLAP technology to help us improve our user experience with faster response times and to take unnecessary pressure off our Teradata system," said Mark Govostes, Manager of BI Architecture at eBay.
Multi-source ROLAP eliminates the requirement to move data from multiple source databases into a purpose-built data warehouse or data mart.
In-memory ROLAP includes a database that can serve data to reports, dashboards, and OLAP analyses.
When combined with the MicroStrategy 9 Multi-source ROLAP capability, the query system can even join data across multiple relational databases and Excel to populate the in-memory database.
And another poor performing quarter will only serve to widen the gap between the two ROLAP rivals.
In collaboration with the leading vendors in the ETL market, MicroStrategy seeks to bring new functionality to the desktop while adding value to the ETL and ROLAP components of a business intelligence solution.
The MineShare Suite is a unique synthesis of data extraction, data marting, ROLAP, OLAP and report distribution technologies.
The combined products enable our mutual customers to implement scaleable data warehouse solutions with the performance of the MetaCube ROLAP engine and the ease of use of Andyne's PaBLO front end.
Andyne sees MetaCube as a leading edge ROLAP technology," said David Waugh, vice president of product marketing at Andyne.