ON-LINE ANALYTICAL PROCESSING

Copyright © Philip M. Parker, INSEAD. Terms of Use.

ON-LINE ANALYTICAL PROCESSING

Specialty Definition: ON-LINE ANALYTICAL PROCESSING

Domain	Definition
Computing	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. The OLAP Council (http://www.olapcouncil.org/). (http://www.access.digex.net/~grimes/olap/). Usenet newsgroup: news:comp.databases.olap. (http://www.arborsoft.com/papers/finkTOC.html). [What's a "multidimensional conceptual view"?] (1996-09-24). Source: The Free On-line Dictionary of Computing.
Post & Telecom	Análisis mutidimensional de datos corporativos. Source: European Union. (references)
Source: compiled by the editor from various references; see credits.

Crosswords: ON-LINE ANALYTICAL PROCESSING

Specialty definitions using "ON-LINE ANALYTICAL PROCESSING": OLAP. (references)

Source: compiled by the editor from various references; see credits.

Non-Fiction Usage: ON-LINE ANALYTICAL PROCESSING

Subject	Topic	Quote
Business		Banks operating here still have a need for data warehousing, multidimensional and other On-Line Analytical Processing software, call center, ATM, and phone banking solutions. (references)
Source: compiled by the editor from ICON Group International, Inc.; see credits.

Modern Translation: ON-LINE ANALYTICAL PROCESSING

Language		Translations for "ON-LINE ANALYTICAL PROCESSING"; alternative meanings/domain in parentheses.
Spanish		proceso analítico en línea (OLAP). (various references)
Source: compiled by the editor from various translation references.

INDEX

1. Crosswords
2. Quotations: Non-fiction
3. Translations: Modern
4. Bibliography

Copyright © Philip M. Parker, INSEAD. Terms of Use.