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.


This article is provided by FOLDOC - Free Online Dictionary of Computing (foldoc.org)
Mentioned in ?
References in periodicals archive ?
Many vendors want you to believe that in order to make the best possible business decisions, your small to midsized company needs a full-fledged cube-based OLAP or on-line analytical processing BI solution that delivers real time, * 28 up to the nanosecond data.
Business intelligence (BI) is relatively new field of information technologies which includes usage of different tools as data warehouse, knowledge discovery from databases, on-line analytical processing for improving business decision making.
BI has long been dominated by a number of commercial-product vendors in areas including reporting, on-line analytical processing (OLAP), data mining, extract, transform, and load (ETL), and dashboards and visualization.
The real-time overview is complemented with comprehensive data logging, and Atkins has championed the use of an On-Line Analytical Processing (OLAP) tool to provide a very fast and flexible historical reporting system that enables both standard reports and ad-hoc querying.
SQL and OLAP (on-line analytical processing)--by its ability to find and characterize previously unknown relationships in complex data and to predict future outcomes based on that understanding.
Version 10 is Windows-based, has hyperlinked online help and includes integrated OLAP (on-line analytical processing) business intelligence tools.
The third topic is the utility of external data and the fourth topic is a high-level system design including an outline of a Student Input Process (SIP) and the differences between On-Line Transaction Processing (OLTP) and On-Line Analytical Processing (OLAP) systems.
Many of the BSC applications already include the ability to perform multi-dimensional data analysis (on-line analytical processing), which enables users to "slice and dice" data so they can analyse information from different perspectives and angles.
ShowCase Corporation (Nasdaq: SHWC), a provider of Enterprise Intelligence solutions for business users and AS/400 IT professionals, will significantly extend its offerings to thousands of AS/400 organizations with the launch of the new IBM DB2 OLAP (On-Line Analytical Processing) Server for the AS/400 - a joint development effort between IBM and ShowCase.
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.
If all the customer data in your warehouse should be available to all of your users, a Relational On-Line Analytical Processing (ROLAP) structure is recommended.
The software division's revenue are now solely focused around business intelligence tools with the Crystal Reports client-based query and reporting tool, the Holos on-line analytical processing package and a server-based information architecture that underpins those two known as Crystal Info.