In computing, online analytical processing (OLAP) (/ˈoʊlæp/), is an approach to quickly answer multi-dimensional analytical (MDA) queries. The term OLAP...
37 KB (4,457 words) - 12:09, 4 July 2025
real-time (process transactions). The term is contrasted with online analytical processing (OLAP) which instead focuses on data analysis (for example planning...
10 KB (1,127 words) - 02:19, 28 April 2025
Pivot table (section Online analytical processing)
Excel pivot tables include the feature to directly query an online analytical processing (OLAP) server for retrieving data instead of getting the data...
20 KB (2,107 words) - 22:47, 2 July 2025
Operational analytical processing, more popularly known as operational analytics, is a subset of data analytics that focuses on improving the operational...
8 KB (1,037 words) - 20:16, 10 February 2025
Business intelligence (redirect from Multi-channel analytics)
include reporting, online analytical processing, analytics, dashboard development, data mining, process mining, complex event processing, business performance...
24 KB (2,522 words) - 13:06, 4 June 2025
OLAP cube (category Online analytical processing)
An OLAP cube is a multi-dimensional array of data. Online analytical processing (OLAP) is a computer-based technique of analyzing data to look for insights...
11 KB (1,305 words) - 15:13, 30 June 2025
ClickHouse (category Online analytical processing)
(columnar database management system) for online analytical processing (OLAP) that allows users to generate analytical reports using SQL queries in real-time...
11 KB (1,101 words) - 07:46, 19 July 2025
transactional (OLTP) applications and instead is specialized for online analytical processing (OLAP) workloads. The project has over 6 million downloads per...
14 KB (1,079 words) - 21:59, 21 May 2025
software engineering topics Mobile Location Analytics News analytics Online analytical processing Online video analytics Operational reporting Operations research...
35 KB (3,482 words) - 20:17, 16 July 2025
Data orientation (redirect from Column-based analytical technology)
commonly used in Online transaction processing (OLTP) and column-oriented formats are more commonly used in Online analytical processing (OLAP). Examples...
8 KB (865 words) - 15:39, 6 April 2025
and business-sector information systems. Online analytical processing (OLAP) covers the analytical processing involved in creating, synthesizing, and managing...
8 KB (886 words) - 10:19, 24 February 2025
multidimensional online analytical processing (MOLAP) - may be constructed. Designing a cube may be an elaborate and lengthy process, and changing the...
16 KB (1,944 words) - 07:51, 25 May 2025
XML for Analysis (category Online analytical processing)
(XMLA) is an industry standard for data access in analytical systems, such as online analytical processing (OLAP) and data mining. XMLA is based on other...
4 KB (393 words) - 18:10, 8 March 2025
Comparison of OLAP servers (category Online analytical processing)
tables compare general and technical information for a number of online analytical processing (OLAP) servers. Please see the individual products articles for...
30 KB (496 words) - 20:48, 7 July 2025
mining Data processing Extract, transform, load Fold (higher-order function) Group by (SQL), SQL clause OLAP cube Online analytical processing Pivot table...
11 KB (1,472 words) - 15:21, 17 July 2025
decisions. Business intelligence is querying, reporting, online analytical processing (OLAP), and "alerts". In other words, querying, reporting, and OLAP...
9 KB (980 words) - 11:22, 31 May 2025
Data warehouse (redirect from Electronic data processing datawarehouse)
data through ETL processes that periodically migrate data from the operational systems to the warehouse. Online analytical processing (OLAP) is characterized...
39 KB (4,777 words) - 17:51, 20 July 2025
others. Codd coined the term Online analytical processing (OLAP) and wrote the "twelve laws of online analytical processing". Controversy erupted, however...
17 KB (1,476 words) - 22:54, 7 June 2025
MultiDimensional eXpressions (category Online analytical processing)
Multidimensional Expressions (MDX) is a query language for online analytical processing (OLAP) using a database management system. Much like SQL, it is...
9 KB (1,183 words) - 00:24, 1 September 2023
relational online transaction processing (OLTP) databases. On the other hand, graph compute engines are used in online analytical processing (OLAP) for...
53 KB (4,715 words) - 05:34, 14 July 2025
development kit (SDK) is provided for native integration. For online analytical processing (OLAP) applications, the Multidimensional Expressions (MDX) extension...
5 KB (463 words) - 09:45, 23 April 2025
Data cube (category Image processing)
called facts) along some dimensions of interest. For example, in online analytical processing (OLAP) such dimensions could be the subsidiaries a company has...
10 KB (1,242 words) - 18:48, 1 May 2024
Panorama Software (category Online analytical processing)
its headquarters to Toronto, Canada in 2003. Panorama sold its online analytical processing (OLAP) technology to Microsoft in 1996, which was built into...
6 KB (460 words) - 19:11, 19 June 2024
GROUP BY P.Brand, S.Country Data warehouse Fact constellation Online analytical processing Reverse star schema Snowflake schema Dedić, N. and Stanier C...
7 KB (981 words) - 17:05, 30 June 2025
Fact constellation (category Online analytical processing)
complex data warehouses. The fact constellation is a measure of online analytical processing and can be seen as an extension of the star schema. A fact constellation...
1 KB (146 words) - 02:08, 3 April 2025
systems Object database (OODBMS) Online analytical processing (OLAP) and ROLAP (Relational Online Analytical Processing) Relational transducer Snowflake...
32 KB (3,869 words) - 06:42, 20 July 2025
Functional database model (category Online analytical processing)
functional language databases. The functional model is part of the online analytical processing (OLAP) category since it comprises multidimensional hierarchical...
19 KB (2,869 words) - 17:44, 28 April 2025
enable developer mode in Power Bi, or by Power Bi online domain administrators. Online analytical processing (OLAP) Data Analysis Expressions (DAX), a complementary...
11 KB (1,088 words) - 14:00, 17 April 2025
from 1999 to 2002. Tableau products query relational databases, online analytical processing cubes, cloud databases, and spreadsheets to generate graph-type...
22 KB (1,816 words) - 03:37, 20 July 2025
Multidimensional analysis (redirect from Multi-dimensional analytical)
two-dimensional panel data sets. Computer software for MDA include Online analytical processing (OLAP) for data in relational databases, pivot tables for data...
2 KB (283 words) - 06:34, 1 April 2025