In computing, online analytical processing, or OLAP (/ˈoʊlæp/), is an approach to quickly answer multi-dimensional analytical (MDA) queries. The term...
37 KB (4,468 words) - 14:25, 8 October 2024
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,126 words) - 19:28, 25 October 2024
and business-sector information systems. Online analytical processing (OLAP) covers the analytical processing involved in creating, synthesizing, and managing...
8 KB (882 words) - 16:01, 5 July 2024
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) - 22:31, 13 October 2024
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...
7 KB (842 words) - 00:20, 14 November 2024
MicroStrategy (redirect from MicroStrategy Analytics)
Virginia, in the Washington metropolitan area. Its primary business analytics competitors include SAP AG Business Objects, IBM Cognos, and Oracle Corporation's...
22 KB (1,833 words) - 08:09, 24 November 2024
decisions. Business intelligence is querying, reporting, online analytical processing (OLAP), and "alerts". In other words, querying, reporting, and OLAP...
9 KB (976 words) - 13:56, 6 July 2024
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:02, 17 September 2024
transactional (OLTP) applications and instead is specialized for online analytical processing (OLAP) workloads. The project has over 6 million downloads per...
13 KB (1,018 words) - 20:35, 20 November 2024
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...
34 KB (3,480 words) - 15:18, 26 October 2024
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,535 words) - 13:57, 2 October 2024
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 (498 words) - 13:37, 9 October 2024
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) - 20:16, 16 November 2024
development kit (SDK) is provided for native integration. For online analytical processing (OLAP) applications, the Multidimensional Expressions (MDX) extension...
5 KB (441 words) - 19:52, 24 October 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,934 words) - 12:03, 7 August 2024
from 1999 to 2002. Tableau products query relational databases, online analytical processing cubes, cloud databases, and spreadsheets to generate graph-type...
21 KB (1,779 words) - 02:11, 11 November 2024
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
statistical analysis purposes. It is an OLAP (online analytical processing), instead of OLTP (online transaction processing) system. Modern decision, and classical...
5 KB (709 words) - 17:48, 14 July 2024
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) - 09:18, 26 March 2024
Snowflake schema (category Online analytical processing)
'tv' GROUP BY B.Brand, G.Country Star schema Data warehouse Online analytical processing (OLAP) Paulraj Ponniah. Data Warehousing Fundamentals for IT...
8 KB (1,023 words) - 14:44, 18 November 2024
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 (142 words) - 16:06, 24 November 2024
Holos (software) (category Online analytical processing)
Holos was an influential OLAP (Online Analytical Processing) product of the 1990s. Developed by Holistic Systems in 1987, the product remained in use until...
3 KB (394 words) - 13:08, 23 October 2023
others. Codd coined the term Online analytical processing (OLAP) and wrote the "twelve laws of online analytical processing". Controversy erupted, however...
17 KB (1,479 words) - 18:37, 5 November 2024
Essbase (category Online analytical processing)
F. Codd coined the term "on-line analytical processing" (OLAP) in a whitepaper that set out twelve rules for analytic systems (an allusion to his earlier...
22 KB (2,493 words) - 13:36, 20 September 2024
Crystal Analysis (category Online analytical processing)
Crystal Analysis (a.k.a. Crystal Analysis Professional) is an On Line Analytical Processing (OLAP) application for analysing business data originally developed...
3 KB (249 words) - 16:21, 9 April 2024
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) - 12:26, 7 January 2024
MonetDB has been applied in high-performance applications for online analytical processing, data mining, geographic information system (GIS), Resource Description...
27 KB (2,866 words) - 22:07, 6 November 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) - 13:46, 21 August 2024
Jedox (category Online analytical processing)
Enterprise Performance Management software which is used for planning, analytics and reporting in finance and other areas such as sales, human resources...
6 KB (601 words) - 19:05, 19 November 2024