Online Analytical Processing

DEFINITION On-line Analytical Processing (OLAP) describes an approach to decision support, which aims to extract knowledge from a data warehouse (see Data Warehouse definitional entry), or more specifically, from data marts (see Data Mart definitional entry). Its main idea is providing navigation through data to non-expert users, so that they are able to interactively generate ad-hoc queries without the intervention of IT professionals. This name was introduced in contrast to On-Line Transactional Processing (OLTP), so that it reflected the different requirements and characteristics between both kinds of uses. The concept falls in the area of business intelligence (see Business Intelligence definitional entry).

[1]  Laks V. S. Lakshmanan,et al.  A Foundation for Multi-dimensional Databases , 1997, VLDB.

[2]  E. F. Codd,et al.  Providing OLAP to User-Analysts: An IT Mandate , 1998 .

[3]  Luca Cabibbo,et al.  From a procedural to a visual query language for OLAP , 1998, Proceedings. Tenth International Conference on Scientific and Statistical Database Management (Cat. No.98TB100243).

[4]  Alberto Abelló,et al.  On the Need of a Reference Algebra for OLAP , 2007, DaWaK.

[5]  Günther Pernul,et al.  Towards OLAP security design — survey and research issues , 2000, DOLAP '00.

[6]  Jiawei Han,et al.  OLAP Mining: Integration of OLAP with Data Mining , 1997, DS-7.

[7]  Alberto Abelló,et al.  Automating multidimensional design from ontologies , 2007, DOLAP '07.