On-Line Analytical Processing

On-Line Analytical Processing

(OLAP) A category of database software which provides an interface such that users can transform or limit raw data according to user-defined or pre-defined functions, and 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.

The term was originally coined by Dr. Codd in 1993 with 12 "rules". Since then, the OLAP Council, many vendors, and Dr. Codd himself have added new requirements and confusion.

Richard Creeth and Nigel Pendse define OLAP as fast analysis of shared multidimensional information. Their definition requires the system to respond to users within about five seconds. It should support logical and statistical processing of results without the user having to program in a 4GL. It should implement all the security requirements for confidentiality and concurrent update locking. The system must provide a multidimensional conceptual view of the data, including full support for multiple hierarchies. Other aspects to consider include data duplication, RAM and disk space requirements, performance, and integration with data warehouses.

Various bodies have attempted to come up with standards for OLAP, including The OLAP Council and the Analytical Solutions Forum (ASF), however, the Microsoft OLE DB for OLAP API is the most widely adopted and has become the de facto standard.


Usenet newsgroup: news:comp.databases.olap.


Mentioned in ?
References in periodicals archive ?
Microsoft has also created the Microsoft Repository, a database that stores descriptive information about data warehouse information such as database schema, data transformations, and On-Line Analytical Processing (OLAP), which permits many datamarts to be integrated over time into a federated data warehouse, as well as extensive integration of third-party solutions and many other data warehouse services and features.
LMS will assist VHA's EES in achieving its mission to continuously improve the quality of offered classes and will feature predictive analytics and on-line analytical processing to allow for efficient analysis, interpretation, and presentation of processed data.
Expert Analytics is a powerful business intelligence data warehouse and on-line analytical processing (OLAP) solution designed specifically for the core analysis needs of professional services firms.
Alphablox passed in the Query and Reporting tools category for tools that provide end-users with mechanisms for designing and distributing reports, building decision support (DSS) and executive information (EIS) systems, and for performing On-Line Analytical Processing (OLAP) against multi-dimensional databases.
Song is a renowned expert in the field of database modeling and design, on-line analytical processing (OLAP), and object-oriented analysis and design.
Paul, Minnesota, is an expert in On-Line Analytical Processing (OLAP), providing products, consulting, and training that specializes in analytical applications and decision support solutions.
Paul, Minnesota, is an expert in On-Line Analytical Processing (OLAP) providing products, consulting, and training that specializes in analytical applications and decision support solutions.
To make it easy to analyze data on supply chain operations and integrate GR Force/SCE with business intelligence applications, GR Force/SCE automatically populates a data warehouse with actual manufacturing performance metrics, allowing a variety of on-line analytical processing (OLAP) and data mining tools to be used for analysis.
Built on On-Line Analytical Processing (OLAP) technology from Hyperion(R) Essbase(R), IBM DB2 OLAP Server(TM), and ShowCase Essbase/400, SpreadsheetObjects' core strength is its ability to deliver and collect key business information in a familiar Microsoft(R) Excel format.
The Stratum suite includes Silvon's DataTracker technology, featuring a relational data warehouse, on-line analytical processing engine, closed-loop processing functionality, a built-in planning application, and enterprise connectors for extracting, transforming and loading data from ERP, CRM and other web-based business transaction systems into the data warehouse for analysis purposes.