OLAP

(redirected from Online analytical processing)
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 ?
AIS is a Business Intelligence consulting and software development firm providing Online Analytical Processing (OLAP) solutions to companies in a variety of industries throughout North America.
0's new framework for enhanced online analytical processing (OLAP).
As the foundation of GERS' Enterprise1, the Retail Data Warehouse leverages industry standard Online Analytical Processing (OLAP) tools to facilitate efficient, accurate, and timely analysis of transaction data and multi-year historical performance.
The Retail Data Warehouse leverages industry standard Online Analytical Processing (OLAP) tools to facilitate efficient and timely analysis of transaction data and multi-year historical performance.
The OLAP Report, which has delivered in-depth guidance for buyers of Online Analytical Processing (OLAP) solutions since 1995, provides detailed information about OutlookSoft's product architecture, platform and application-specific functionalities.
Embedded with technology components such as data warehousing, online analytical processing (OALP) and data mining, AsiaInfo's CRM solution can analyze data generated by any Business Operation Support System, providing telecom carriers with a highly flexible and powerful tool for decision making.
Picis offers enterprise-wide operating room management along with patient tracking, quality management and an online analytical processing tool for decision support.

Full browser ?