Encyclopedia of Database Systems

2018 Edition
| Editors: Ling Liu, M. Tamer Özsu

Online Analytical Processing

  • Alberto AbellóEmail author
  • Oscar Romero
Reference work entry
DOI: https://doi.org/10.1007/978-1-4614-8265-9_252




On-line analytical processing (OLAP) describes an approach to decision support, which aims to extract knowledge from a data warehouse, or more specifically, from data marts. 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 these classes of uses. The concept falls in the area of business intelligence.

Historical Background

From the beginning of computerized data management, the possibility of using computers in data analysis has been evident for companies. However, early analysis tools needed the involvement of the IT department to help decision makers to query data. They were not interactive at all and demanded specific knowledge in computer science. By the mid-1980s, executive...

This is a preview of subscription content, log in to check access.

Recommended Reading

  1. 1.
    Abelló A, Darmont J, Etcheverry L, Golfarelli M, Mazón J-N, Naumann F, Pedersen TB, Rizzi S, Trujillo J, Vassiliadis P, Vossen G. Fusion cubes: towards self-service business intelligence. Int J Data Warehouse Min. 2013;9(2):66–88.CrossRefGoogle Scholar
  2. 2.
    Abelló A, Romero O, Pedersen TB, Berlanga R, Nebot V, Aramburu MJ, Simitsis A. Using semantic web technologies for exploratory OLAP: a survey. IEEE Trans Data Knowl Eng. 2014; PP(99):1.  https://doi.org/10.1109/TKDE.2014.2330822.CrossRefGoogle Scholar
  3. 3.
    Aufaure M-A, Cuzzocrea A, Favre C, Marcel P, Missaoui R. An envisioned approach for modeling and supporting user-centric query activities on data warehouses. Int J Data Warehouse Min. 2013;9(2):89–109.CrossRefGoogle Scholar
  4. 4.
    Cabibbo L, Torlone R. From a procedural to a visual query language for OLAP. In: Proceedings of the 10th International Conference on Scientific and Statistical Database Management; 1998. p. 74–83.Google Scholar
  5. 5.
    Codd EF, Codd SB, Salley CT. Providing OLAP to user-analysts: an IT mandate. Technical report, E. F. Codd & Associates; 1993.Google Scholar
  6. 6.
    Etcheverry L, Vaisman A, Zimanyi E. Modeling and querying data warehouses on the semantic web using QB4OLAP. In: Proceedings of the 16th International Conference on Data Warehousing and Knowledge Discovery; 2014.Google Scholar
  7. 7.
    Golfarelli M, Graziani S, Rizzi S. Shrink: an OLAP operation for balancing precision and size of pivot tables. Data Knowl Eng. 2014;93(Sept): 19–41.CrossRefGoogle Scholar
  8. 8.
    Gómez LI, Gómez SA, Vaisman AA. A generic data model and query language for spatiotemporal OLAP cube analysis. In: Proceedings of the 15th International Conference on Extending Database Technology; 2012. p. 300–11.Google Scholar
  9. 9.
    Gyssens M, Lakshmanan LVS. A foundation for multi-dimensional databases. In: Proceedings of the 23rd International Conference on Very Large Data Bases; 1997. p. 106–15.Google Scholar
  10. 10.
    Jaecksch B, Lehner W. The planning OLAP model – a multidimensional model with planning support. In: Proceedings of the 15th International Conference on Data Warehousing and Knowledge Discovery; 2013. p. 32–52.Google Scholar
  11. 11.
    Markl V. Situational business intelligence. In: Proceedings of the 2nd International Workshop on Business Intelligence for the Real Time Enterprise (in conjunction with the VLDB Conference); 2008.Google Scholar
  12. 12.
    Microsoft. Multidimensional expressions (MDX) reference; 2007. Available at http://msdn2.microsoft.com/en-us/library/ms145506.aspx. SQL Server books online.
  13. 13.
    Pendse N. The OLAP report – what is OLAP? 2007. Business Application Research Center.Google Scholar
  14. 14.
    Romero O, Abelló A. On the need of a reference algebra for OLAP. In: Proceedings of the 9th International Conference on Data Warehousing and Knowledge Discovery; 2007. p. 99–110.Google Scholar
  15. 15.
    W3C. The RDF data cube vocabulary; 2014. Available at http://www.w3.org/TR/vocab-data-cube. Recommendation.

Copyright information

© Springer Science+Business Media, LLC, part of Springer Nature 2018

Authors and Affiliations

  1. 1.Polytechnic University of CataloniaBarcelonaSpain