• 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
  • 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
  • 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
  • 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
  • Thumbnail for ClickHouse
    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
  • Thumbnail for DuckDB
    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
  • Thumbnail for OLAP cube
    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
  • Thumbnail for Analytics
    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
  • 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
  • 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
  • Thumbnail for Snowflake schema
    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
  • Thumbnail for Aggregate function
    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
  • Thumbnail for Jedox
    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