(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.
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.
 | Reproduced with permission from Computer Desktop Encyclopedia. Copyright (c) 1981-2008 The Computer Language Company Inc. All rights reserved. |
Additional Resources
- BI Crystal Ball – Next Gen BI May Be Closer Than You Think
- Most modern large enterprise Business Intelligence BI tools are very robust and feature rich these days. Up until a few years ago BI users could blame vendors for most of their BI ills. This is getting harder and harder to do. Many of the BI tools, especially the ones reviewed...
- Blog posts 2008-10-07
- Federation Supplements The Data Warehouse - Not Either/Or, Never Was
- Few enterprise data warehousing EDW professionals regard the key rival approach--data federation--to be a best practice. Usually, the reasons for this disdain are valid, such as the fact that federated environments are not optimized for heavy-hitting data matching, merging, transformation and cleansing, all of which are essential functions to deliver...
- Blog posts 2008-09-18
- RSVP Reporting Software for Visualization and Performance (exe)
- RSVP Reporting Software for Visualization and Performance is a fully integrated, dynamic data visualization and business intelligence reporting tool for SQL relational and OLAP data. Data visualization capabilities include a broad range of relational and OLAP presentation elements, including a unique 3-D data representation allowing display of up to 4...
- Software downloads 2008-09-15
- Guest post: An ode to the humble spreadsheet
- Guest blog: Bob Warfield has founded three startups, run R&D at Borland, developed software for Callidus and Oracle and created tools for Rational/Pure Atria. He currently works for SaaS customer service company Helpstream. He is responsible for Quattro Pro, the Borland spreadsheet, and is the inventor of the notebook tabs...
- Blog posts 2008-07-02
- Dynamics AX 2009: The 'Halo' for Microsoft's app platform
- Microsoft began rolling out to customers on June 2 the latest version of its high-end ERP application, Dynamics AX 2009. The latest Axapta release (also known as AX 5.0) has lots of new bells and whistles: A compliance center dashboard that displays all kinds of key performance...
- Blog posts 2008-06-02
- DB2 Maestro (exe)
- DB2 Maestro is a powerful Windows GUI solution for DB2 administration and database management. The software provides you with the ability to perform all the necessary database operations such as creating, editing, copying, and dropping of the database objects; you can also build queries visually, execute queries and SQL scripts,...
- Software downloads 2008-05-16
- PivotWebTable (zip)
- PivotWebTable is an interactive and easy-to-use ASP.NET OLAP analysis control that presents the OLAP cube in popular web browsers. It has the following powerful features.PivotWebTable supports popular web browsers such as Internet Explorer and Mozilla Firefox.PivotWebTable has its own OLAP processing engine. It doesn't rely on any third party libraries...
- Software downloads 2008-05-05
- SH Electric Power Improves Data Analysis and Reporting With Integrated Data Warehouse
- The Shanghai Municipal Electric Power Company SH Electric Power handles the transmission, distribution, and sale of electrical power in Shanghai. A major challenge under the Business Information BI project was to move the company's routine reporting function away from its production system database, which would reduce the load on the...
- Case studies 2008-05-01
- Accelerating Data Warehouses
- An option of Oracle Database 11g Enterprise Edition, Oracle OLAP 11g is a full-featured online analytical processing engine. Because Oracle OLAP 11g is embedded in Oracle Database, it benefits from database scalability, security, and manageability features. Key new features in Oracle OLAP 11g include database-managed relational views of a cube,...
- White papers 2008-05-01
- What's New in SAS Web Report Studio 4.2
- Web Report Studio is a web-based reporting tool with many capabilities added over the course of three major releases. The upcoming release adds many new features driven by requests from users. This paper organizes the key capabilities in Web Report Studio 4.2 into categories. Virtually all features affect the user...
- White papers 2008-03-24
- Controlling OLAP Applications End to End
- In SAS 9.2, there are several new features that help administrators to secure and control the use of OLAP Cubes in a reporting environment. This paper highlights the following new and existing features: ability to include or exclude members from aggregated values parent values, member Level Security user interface, subsetting...
- White papers 2008-03-24
- What's New in SAS OLAP Cube Studio 4.2
- With the release of SAS 9.2, new functionality and enhancements have been added to SAS OLAP Cube Studio 4.2. New features include the ability to: update a cube incremental update, view an input data set within SAS OLAP Cube Studio, view a cube to validate the build process, set cube...
- White papers 2008-03-24
- Microsoft Webcast Series for Lockheed Martin: What Aren't You Getting Out of SQL Server?
- People may be familiar with SQL Server as a data platform, but may be missing out on some powerful capabilities SQL Server has "Under the hood" - Extract, Transform, Load ETL engine; the leading OLAP engine; SQL Server Analysis Services provides a dimensional analysis capability that goes far beyond "Pivot...
- Webcasts 2008-03-20
- Getting Started With the ESRI Map Component in a Unix Environment for 2010 Census Planning
- The basic steps in setting up the ESRI Map Component for geospatial display of data on a SAS BI platform are well documented. As one followed these steps at the Bureau of the Census to get from ESRI map development on Windows to map-displayed OLAP Cube data on the Unix-based...
- White papers 2008-03-13
- Data Integration With SAS Intelligence Storage: How a Business Division in a Fortune 50 Company Uses SAS Scalable Performance Data Server to Make Better Decisions
- The business division integrates the data sources with SAS into one of the world's largest SAS Intelligence Storage systems. The largest component is SAS SPD Server data libraries with 25 TB terabytes of storage where the paper has analytical control of the data. The paper also has SAS OLAP Server...
- White papers 2008-03-13
- Avoid Growing Pains: New Cube Update Features You Should Know About
- After a SAS OLAP cube is created, it is possible to update the data for the cube without completely recreating it. The SAS 9.2 OLAP Server enables one to incrementally update SAS OLAP cubes. An incremental update involves adding cell data and members to an existing SAS OLAP cube. Incremental...
- White papers 2008-03-12
- AnySQL Maestro (exe)
- AnySQL Maestro is the premier multi-purpose admin tool for management, control and development of any database engine (SQL Server, MySQL, MS Access, and Oracle.) which is available via ODBC driver or OLE DB provider. The application allows you to design your database as ER diagram, build visually, edit and execute...
- Software downloads 2008-02-29
- About the Windows Server 2008 stack
- There's an old saying about the devil making work for idle hands - so there I was last week, feeling a little bored and idly clicking through a story both about and by some guy named Whitehorn who's going to blog an extensive development project based on the...
- Blog posts 2008-01-30
- 3-way Tangram (exe)
- 3-way TANGRAM is a self-help or survival OLAP. It caters for the business analyst who has no time and budget to install a major OLAP and yet must respond to requests in a time-scale of hours. It can handle any typical hypercube problem and features several innovative operations on hypercubes....
- Software downloads 2008-01-18
- XtraPivotGrid (exe)
- The XtraPivotGrid Suite is a comprehensive multi-dimensional OLAP data analysis, data mining, and visual reporting solution for WinForms applications. It was engineered from the ground up to provide a unique bridge between on-screen forms and printed reports. With it, your users can break down raw data in any manner they...
- Software downloads 2008-01-18
Premier Vendor Content Whitepapers, webcasts & resources from our Power Center Sponsors
- Intel Xeon 7400 highlights available now!
-
With key platform innovations built-in, the Intel Xeon processor 7400 series offers more headroom, reliability, and the highest expandability for large-scale server consolidation. See highlights from Summer IDF, SAP Tech-Ed, VMWorld, and more.
- Get blogs, videos and more from past tech events >>
Fusion
- There’s a new energy coming from the people of AMD. Its the power of Fusion.
- Learn about the power of fusion at work and the industry-changing impact of accelerated computing.
-
- View AMD video, case studies, blogs, forums, and more on ZDNet »
-
