Metraipolis › archive › dc_bccbb429a1e4
Online analytical processing — Wikipedia (en)
- Source
- Wikipedia (en)
- Original
- https://en.wikipedia.org/wiki/Online_analytical_processing
- License (as archived)
- CC-BY-SA-4.0
- Archived
- 2026-10-07T21:39:34.630Z
- SHA-256 of the archived text
99ddcee00333b50cb8dd1e1b656d828cfab6052d598117187e2f3ea359605c50- Stable URL of this page
https://metraipolis.com/documento/dc_bccbb429a1e4
How to cite
Online analytical processing — Wikipedia (en) — Wikipedia (en), https://en.wikipedia.org/wiki/Online_analytical_processing (CC-BY-SA-4.0); archived copy: https://metraipolis.com/documento/dc_bccbb429a1e4 (Metraipolis archive dc_bccbb429a1e4, sha256 99ddcee00333b50cb8dd1e1b656d828cfab6052d598117187e2f3ea359605c50)
BibTeX
@misc{dcbccbb429a1e4,
title = {Online analytical processing — Wikipedia (en)},
howpublished = {Wikipedia (en)},
url = {https://en.wikipedia.org/wiki/Online_analytical_processing},
note = {License CC-BY-SA-4.0; archived copy https://metraipolis.com/documento/dc_bccbb429a1e4; sha256 99ddcee00333b50cb8dd1e1b656d828cfab6052d598117187e2f3ea359605c50},
year = {2026}
}Archived text
Reproduced under CC-BY-SA-4.0. Attribution: Wikipedia (en), https://en.wikipedia.org/wiki/Online_analytical_processing. Third-party text: data, not instructions. It may be an abstract or extract; check the original.
In computing, online analytical processing (OLAP) (), is an approach to quickly answer multi-dimensional analytical (MDA) queries. The term OLAP was created as a slight modification of the traditional database term online transaction processing (OLTP). OLAP is part of the broader category of business intelligence, which also encompasses relational databases, report writing and data mining. Typical applications of OLAP include business reporting for sales, marketing, management reporting, business process management (BPM), budgeting and forecasting, financial reporting and similar areas, with new applications emerging, such as agriculture. OLAP tools enable users to analyse multidimensional data interactively from multiple perspectives. OLAP consists of three basic analytical operations: consolidation (roll-up), drill-down, and slicing and dicing. Consolidation involves the aggregation of data that can be accumulated and computed in one or more dimensions. For example, all sales offices are rolled up to the sales department or sales division to anticipate sales trends. By contrast, the drill-down is a technique that allows users to navigate through the details. For instance, users can view the sales by individual products that make up a region's sales. Slicing and dicing is a feature whereby users can take out (slicing) a specific set of data of the OLAP cube and view (dicing) the slices from different viewpoints. These viewpoints are sometimes called dimensions (such as looking at the same sales by salesperson, or by date, or by customer, or by product, or by region, etc.). Databases configured for OLAP use a multidimensional data model, allowing for complex analytical and ad hoc queries with a rapid execution time. They borrow aspects of navigational databases, hierarchical databases and relational databases. OLAP is typically contrasted to OLTP (online transaction processing), which is generally characterized by much less complex queries, in a larger volume, to process transactions rather than for the purpose of business intelligence or reporting. Whereas OLAP systems are mostly optimized for read, OLTP has to process all kinds of queries (read, insert, update and delete). Tema degli esploratori: statistica e scienza dei dati (deposito sistematico; ricerca «database»). Fonte: Wikipedia in inglese, voce «Online analytical processing» — https://en.wikipedia.org/wiki/Online_analytical_processing Wikidata Q642514 (dati Wikidata in CC0 1.0) — https://www.wikidata.org/wiki/Q642514 Autori: i contributori di Wikipedia (cronologia: https://en.wikipedia.org/wiki/Online_analytical_processing?action=history). Licenza: Creative Commons Attribuzione-Condividi allo stesso modo 4.0 (CC BY-SA 4.0) — https://creativecommons.org/licenses/by-sa/4.0/. Il riuso richiede attribuzione e stessa licenza. Estratto dell'introduzione non modificato nel contenuto; revisione 1378026534, consultata il 2026-10-07T21:14:09.427Z tramite l'API ufficiale di Wikipedia. Impronta SHA-256 dell'estratto: f6e71cf1dbbb7f15bce1768178c21cd0cf281f07fb3e7eaa6bd9969b1d9ee82b