(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-2009 The Computer Language Company Inc. All rights reserved. |
Additional Resources
- MDAccess 2.5.8 (Windows)
- MDAccess is a charting/reporting program that reads data from OLAP/multi-dimensional Access/SQL Server databases created by ETR, PointMan Reporter, or MDAccess itself. Due to the multi-dimensional structure of the databases, data can be easily accessed, rotated, or manipulated. MDAccess is offering the following features: Flexible element selector allows for easy manipulation...
- Software downloads 2009-11-10
- Small Business Communications Expert Cbeyond Enjoys Dramatic Time Savings and Turns Higher Quality Data Into Strategic Intelligence With IBM Cognos TM1
- Cbeyond is a communications provider with a difference. They offer small businesses a highly integrated portfolio of telephone and Internet services, normally only afforded by the biggest organizations. The company needed an automated solution that produced higher quality data and sophisticated analytical tools that would empower Cbeyond's staff to provide...
- Case studies 2009-07-07
- Response42 Query & Report 1.0 (Windows)
- Response42 Query & Report lets you create database queries and reports in plain English. Simply ask an English question and the software will answer it with a fully formatted database report or an interactive dashboard. Response42 Query & Report is a web-based software that requires Microsoft IISc. It supports Microsoft...
- Software downloads 2009-07-03
- Enhanced Business Intelligence for Oracle OLA P Environments
- The challenge was to assess information from a growing collection of sources to support decision making, to simplify user access to Oracle OLAP data, to enable IT organization to quickly deploy new BI solutions and to provide intuitive BI tools that enhance the value of Oracle OLAP investment. SAP BusinessObjects...
- Case studies 2009-07-01
- Valentina Studio Pro 4.2 (Mac)
- Valentina Studio Pro is a complete solution for managing data on the OLAP ready Valentina database system, locally or on a server. A visual SQL builder makes it easy to build, execute and store regularly used queries. Import your local or live server data, import via ODBC and run complex...
- Software downloads 2009-06-25
- .NET ModelKit Suite 4.0.3 (Windows)
- .NET ModelKit Suite contains data analysis, visualization, and processing components for .NET Framework. The package includes OLAP ModelKit and Report Sharp-Shooter, the use-proven BI components intended for intelligent data handling and presentation; Instrumentation ModelKit, a tool for digital dashboards and KPI creation; and Chart ModelKit, a component for charts and...
- Software downloads 2009-06-10
- Firebird Maestro 9.5 (Windows)
- Firebird Maestro is a powerful solution for the Firebird server administration and development. Key features include: support for all the Firebird versions from 1.0 to 2.5; database designer; complete data management tools with viewing, editing, grouping, sorting and filtering abilities and BLOB Viewer/Editor; Unicode/UTF8 support; handy SQL Editor with code...
- Software downloads 2009-06-02
- Business Intelligence - HP DL785 G5 server reference configurations for Microsoft SQL Server 2008
- Trying to determine the correct hardware configuration to support a Business Intelligence BI workload may be challenging. Therefore, HP has made available several documents to simplify the hardware selection process by documenting various configurations to support pre-defined workloads, which access various sized databases and/or OLAP cubes. This paper provides with...
- White papers 2009-06-01
- Cubus Embeds Unrivalled Performance and Scalability Into First-to-Market Project and Strategy Planning Tool
- Cubus wanted to build on success of Cubis' customizable, Excel-based planning tool, ABC for OLAP, with a solution that consolidates project management, financial management, and strategy management and enable clients to replace disconnected standalone Excel, Word, and PowerPoint-based planning tools with a single application. The challenge was to integrate structured...
- Case studies 2009-06-01
- SpreadsheetWEB 2.1 (Windows)
- Create Web based OLAP pivot table reports. Build Web forms like online databases and surveys, sign-up and registration forms, invoices, time sheets, and many other applications with SpreadsheetWEB. It is free. It is easy to use. Anyone with basic Excel spreadsheet skills can create professional looking Web applications in no...
- Software downloads 2009-05-17
- Oracle Maestro 9.4 (Windows)
- Oracle Maestro is a powerful solution for the Oracle server administration and development. The application also provides you with a powerful set of tools to edit and execute SQL scripts, build visual diagrams for numeric data, and compose OLAP cubes. Version 9.4 introduces advanced transaction management, significantly improves Data Export...
- Software downloads 2009-05-14
- Consideo Modeler 5.0 (Windows)
- Consideo Modeler to model and simulate any complex problem. The first software combining the leading methods (Mind Mapping, Brainstorming, CLD, System Dynamics) in an easy to use crossplatform tech-advanced tool. Explore, visualize, communicate and simulate any context, project, process, strategy with quick results. Connect to existing data (e.g. Excel or...
- Software downloads 2009-05-11
- InfoReporter 2.65 (Windows)
- InfoReporter a tool for building reports and analyzing data What you do with the Tool. You build up reports. Table reports, table & graph reports. The reports are based on local cubes, MSAS cubes or SQL relational databases or plain excel files. First of all you have to set up...
- Software downloads 2009-05-06
- MS SQL Maestro 9.4 (Windows)
- MS SQL Maestro is a powerful solution for the Microsoft SQL Server administration and development. The application also provides you with a powerful set of tools to edit and execute SQL scripts, build visual diagrams for numeric data, and compose OLAP cubes. Supports all the SQL Server latest features up...
- Software downloads 2009-04-24
- Configuring the Default OLAP Cubes
- The default Online Analytical Processing OLAP cubes that are provided with Microsoft Dynamics AX require full license and configuration keys. If any license or configuration key is turned off, one must complete the procedures in this white paper. The procedures in this white paper will help one to configure the...
- White papers 2009-04-20
- Implementing and Maintaining SQL Server 2008 Analysis Services and Business Intelligence Solutions
- View Available Dates and LocationsIn this five-day instructor-led course, you will learn to design and maintain business intelligence solutions for your organization using SQL Server 2008. You will learn how to use the SQL Server development tools to create Analysis Services databases and OLAP cubes. In addition,...
- Training 2009-04-01
- Best Practice: Optimizing the Cube Build Process in SAS 9.2
- The loading and processing of the data into a cube needs to be controlled and optimized to get the best performance out of one's system and meet appropriate time window constraints that may be set by IT or the business user. The SAS OLAP Server 9.2 shows several performance improvements...
- White papers 2009-04-01
- Gallup, Inc. Ensures Reliable, Rapid Access to Critical Operational and Business Data
- Gallup, Inc. wanted to provide a standard infrastructural solution that enables the presentation of research - such as industry-specific employee and customer engagement data - to clients and creates a data infrastructure that is scalable, reliable, secure, and accessible to multiple applications without need for a proprietary access layer. The...
- Case studies 2009-04-01
- Multinational Dealer Gains Efficient Business Intelligence Solution
- Mantrac Group, a multinational dealer that represents many leading companies including Caterpillar, deployed Microsoft SQL Server 2008 data management software to enhance its Business Intelligence BI. With this solution, Mantrac has accelerated data extraction, the building of multidimensional Online Analytical Processing OLAP cubes, and reporting. The company is phasing in...
- Case studies 2009-04-01
- Intelligencia Query for SQL 2005 3.0.23 (Windows)
- Intelligencia Query for BIDS and Reporting Services delivers add-in functionality for Visual Studio that transforms the task of creating OLAP reports with Microsoft SQL Server Reporting Services. State-of-the-art query tools are combined with a custom data extension that understands how OLAP reporting should work. Implemented using the Microsoft Fluent user...
- Software downloads 2009-03-09
Premier Vendor Content Whitepapers, webcasts & resources from our Power Center Sponsors
- The best support in the Linux business
-
If Linux is going to power your mission-critical applications, you'd better have the best support known to business. Novell was rated the top provider of Linux technical support.
- Learn more >>
- Reduce risk. Reduce complexity. Increase reliability.
-
A simplified IT environment isn't just less complex. It's also more reliable. Standardize on a single Linux platform with SUSE Linux Enterprise from Novell, and get the world's most interoperable Linux
- Learn more >>
- New Online Dashboard for IT Leaders
-
Read about top issues IT decision-makers face every day, plus get cost-effective solutions to real-life IT problems.
- Learn more >>
- The best support in the Linux business
-
If Linux is going to power your mission-critical applications, you'd better have the best support known to business. Novell was rated the top provider of Linux technical support.
- Learn more >>
SmartPlanet
- Thought-provoking progressive ideas on diverse topics that intersect with technology, business, and life, and matter to the world at large. Visit SmartPlanet
- More from IBM
-
- Can your business work smarter? Learn more about Lotus Symphony
- Learn how to work smarter and optimize cost using the IBM Smart SOA approach Download the eBook
- Smarter ways to make smarter products Read the brief from IBM
