olap
2 ResultsDictionary
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...
Dictionary
Definition: 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.
THIS DEFINITION IS FOR PERSONAL USE ONLY
All other reproduction is strictly prohibited without permission from the publisher.
© 1981-2010 The Computer Language Company Inc. All rights reserved.
Sponsored White Papers, Webcasts & Resources
-
Simplified Management in the Real World with VMware vCenter Operations
With so much of your network becoming virtual, it can be difficult to visualize and manage things. Check out this webcast to learn more about simplified management in a virtualized world.
-
Artificial intelligence to detect heart attacks?
Greek researchers have used online analytical processing (OLAP), a technique usually associated with financial and marketing analysis, to build the foundations for a heart attack calculator. Their...
-
Consolidation Reported in Business Intelligence
Driven by the current focus on vendor management costs, IT organizations are trying to reduce the number of vendor relationships. The BI tool vendors, almost without exception, are responding by...
Additional Results
-
Artificial intelligence to detect heart attacks?
Greek researchers have used online analytical processing (OLAP), a technique usually associated with financial and marketing analysis, to build the foundations for a heart attack calculator. Their...
-
Consolidation Reported in Business Intelligence
Driven by the current focus on vendor management costs, IT organizations are trying to reduce the number of vendor relationships. The BI tool vendors, almost without exception, are responding by...
The best of ZDNet, delivered
ZDNet Newsletters
Get the best of ZDNet delivered straight to your inbox
Vendor Showcase
