Choose Index below for a list of all words and phrases defined in this glossary.

On-Line Analytical Processing (OLAP)

index | Index

On-Line Analytical Processing (OLAP) / Online Analytical Processing (OLAP) - definitions

OLAP - Acronym for On-Line Analytical Processing. Software technology that transforms data into multidimensional views and that supports multidimensional data interaction, exploration, and analysis

[Category=Data Quality ]

Source: Larry English, External, 04-Feb-2009 10:48

These advertisers support this free service

On-Line Analytical Processing (OLAP) - The OLAP Council defines online analytical processing as, "A category of software technology that enables analysis, managers and executives to gain insight into data through fast, consistent, interactive access to wide variety of possible views of information that have been transformed from raw data to reflect the real dimensionality of the enterprise as understood by the user."

[Category=Database Management ]

Source: Northwest Database Services, 12 November 2009 11:12:55, External

On-Line Analytical Processing (OLAP) - A process that allows a person, using an application, to analyze data stored in a database or data warehouse, in real-time. The focus is on analysis and decision-making. OLAP is in contrast  to OLTP (On-Line Transaction Processing), which is used in transactional systems.

[Category=Data Governance ]

Source: The Data Governance Institute, 17 December 2009 09:51:47, External

OLAP (On-Line Analytical Processing) - The use of computers to analyze an organization's data.

"OLAP" is the most widely used term for Multidimensional Analysis software. The term "On-Line Analytical Processing" was developed to distinguish data warehousing activities from "On-Line Transaction Processing" - the use of computers to run the on-going operation of a business.

In its broadest usage the term "OLAP" is used as a synonym of "data warehousing". In a more narrow usage, the term OLAP is used to refer to the tools used for Multidimensional Analysis.

"Think of an OLAP data structure as a Rubik's Cube of data that users can twist and twirl in different ways to work through what-if and what-happened scenarios." - Lee The, Editor, Datamation (May 1995)

[Category=Data Warehousing ]

Source: SDG Computing Inc., 10 May 2010 09:43:15, SDG Computing, now offline

Online Analytical Processing (OLAP) - Processing that supports the analysis of business trends and projections.

[Category=Information Management ]

Source:, 30 June 2010 09:24:58, External

On-Line Analytical Processing - Processing that supports the analysis of business trends and projections. It is also known as decision support processing and OLAP.

[Category=Data Warehousing ]

Source:, 09 August 2010 07:14:06, External

OLAP - On-Line Analytical Processing. OLAP should be designed to provide end users a quick way of slicing and dicing the data.

[Category=Data Warehousing ]

On-Line Analytical Processing (OLAP) - On-line retrieval and analysis of data to reveal business trends and statistics not directly visible in the data directly retrieved from a data warehouse. Also known as Multidimensional Analysis.

[Category=Data Warehousing ]

Source: Aexis Business Intelligence, 21 December 2010 08:10:18, External

OLAP - Acronym for online analytical processing - a set of techniques that can be applied to data to support strategic decision making.

[Category=Data Quality ]

Source: DAMA UK, 18 July 2011 11:26:01, External

OLAP - Online Analytical Processing.  OLAP is a category of database software which provides an interface such that users can quickly and interactively examine the results in various dimensions of the data.  OLAP primarily involves aggregating large amounts of diverse data. OLAP can involve millions of data items with complex relationships. Its objective is to analyze these relationships and look for patterns, trends, and exceptions.  A cube is an OLAP tool.

[Category=Business Intelligence ]

Source: University of Toronto Business Intelligence, 25 October 2012 08:43:53, External

Online Analytical Processing - (OLAP) - Online Analytical Processing is an approach to quickly providing answers to complex analytical queries. Short for Online Analytical Processing, technology approach , it enables fast analysis of shared, multi-dimensional data. Databases configured for OLAP employ a multidimensional data model, which is optimised for complex analytical and ad-hoc queries by using the concept of a "˜cube,' pre-calculated data dimensions. For example, it would allow a user to ask questions like "How many computers have been sold in Canada this year?, Of those sold in Canada, how many were sold to people over 50?, etc. Refer OLAP Cube for more information.

[Category=Business Intelligence ]

Source: ElegantJ BI Business Intelligence, 02 November 2012 09:16:54, External

OLAP - Online Analytical Processing is a strategy for summarizing and analyzing large amounts of data using a multi-dimensional data model. Implementations of OLAP include MOLAP and ROLAP.

[Category=Business Intelligence ]

Source: Deanna Dicken, 08 November 2012 11:20:34, External 

online analytical processing (OLAP) - The process of analyzing multidimensional data using three operations: consolidation (the aggregation of available), drill-down (the ability for users to see the underlying details), and slice and dice (the ability for users to select subsets and view them from different perspectives).

[Category=Big Data ]

Source: DataInformed, 05 November 2013 09:17:36, External  

Data Quality Glossary.  A free resource from GRC Data Intelligence. For comments, questions or feedback: