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,441 words) - 13:38, 4 May 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,072 words) - 05:15, 10 April 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
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...
10 KB (1,032 words) - 16:51, 29 March 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) - 09:23, 26 April 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
decisions. Business intelligence is querying, reporting, online analytical processing (OLAP), and "alerts". In other words, querying, reporting, and OLAP...
9 KB (980 words) - 07:37, 14 March 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) - 04:23, 13 May 2024
software engineering topics Mobile Location Analytics News analytics Online analytical processing Online video analytics Operational reporting Operations research...
35 KB (3,482 words) - 18:08, 23 April 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:51, 17 April 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
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
Mondrian OLAP server (category Online analytical processing)
Mondrian is an open source OLAP (online analytical processing) server, written in Java. It supports the MDX (multidimensional expressions) query language...
2 KB (130 words) - 07:05, 8 January 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,775 words) - 12:24, 23 April 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) - 05:15, 21 February 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
others. Codd coined the term Online analytical processing (OLAP) and wrote the "twelve laws of online analytical processing". Controversy erupted, however...
17 KB (1,480 words) - 18:01, 27 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
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) - 06:55, 21 December 2024
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
systems Object database (OODBMS) Online analytical processing (OLAP) and ROLAP (Relational Online Analytical Processing) Relational transducer Snowflake...
32 KB (3,869 words) - 06:09, 17 April 2025
relational online transaction processing (OLTP) databases. On the other hand, graph compute engines are used in online analytical processing (OLAP) for...
54 KB (4,745 words) - 00:20, 1 May 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
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
from 1999 to 2002. Tableau products query relational databases, online analytical processing cubes, cloud databases, and spreadsheets to generate graph-type...
21 KB (1,776 words) - 17:59, 7 May 2025
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 (982 words) - 14:48, 18 November 2024
statistical analysis purposes. It is an OLAP (online analytical processing), instead of OLTP (online transaction processing) system. Modern decision, and classical...
6 KB (704 words) - 22:52, 9 January 2025
OLE DB for OLAP (category Online analytical processing)
Online Analytical Processing abbreviated ODBO) is a Microsoft published specification and an industry standard for multi-dimensional data processing....
2 KB (226 words) - 22:27, 13 February 2025
Palo (OLAP database) (category Online analytical processing)
memory resident multidimensional (online analytical processing (OLAP) or multidimensional online analytical processing (MOLAP)) database server and typically...
5 KB (559 words) - 08:28, 6 February 2024