• analytical processing, or OLAP (/ˈoʊlæp/), is an approach to quickly answer multi-dimensional analytical (MDA) queries. The term OLAP was created as a slight...
    37 KB (4,468 words) - 07:08, 15 December 2024
  • Thumbnail for OLAP cube
    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
  • SQL Server Analysis Services (SSAS) is an online analytical processing (OLAP) and data mining tool in Microsoft SQL Server. SSAS is used as a tool by...
    11 KB (1,049 words) - 10:12, 9 December 2024
  • (OLAP) servers. Please see the individual products articles for further information. APIs and query languages OLAP servers support. A list of OLAP features...
    30 KB (498 words) - 13:37, 9 October 2024
  • The Oracle Database OLAP Option implements On-line Analytical Processing (OLAP) within an Oracle database environment. Oracle Corporation markets the Oracle...
    2 KB (232 words) - 13:39, 27 December 2023
  • Chris Date and others. Codd coined the term Online analytical processing (OLAP) and wrote the "twelve laws of online analytical processing". Controversy...
    17 KB (1,479 words) - 15:10, 24 December 2024
  • of an OLAP server. Excel's PivotTable not only allows for connecting to Microsoft's Analysis Service, but to any XML for Analysis (XMLA) OLAP standard-compliant...
    20 KB (2,072 words) - 22:31, 13 October 2024
  • 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) - 19:23, 16 August 2021
  • OLE DB for OLAP (Object Linking and Embedding Database for Online Analytical Processing abbreviated ODBO) is a Microsoft published specification and an...
    2 KB (225 words) - 22:00, 18 July 2023
  • transactions). The term is contrasted with online analytical processing (OLAP) which instead focuses on data analysis (for example planning and management...
    10 KB (1,126 words) - 20:39, 5 December 2024
  • Thumbnail for Data warehouse
    is an effective performance measure of OLAP systems. OLAP applications are widely used for data mining. OLAP databases store aggregated, historical data...
    35 KB (4,434 words) - 02:43, 28 November 2024
  • Thumbnail for DuckDB
    applications and instead is specialized for online analytical processing (OLAP) workloads. The project has over 6 million downloads per month. DuckDB was...
    13 KB (1,029 words) - 13:50, 29 November 2024
  • version of Essbase as DB2 OLAP Server. The database researcher E. F. Codd coined the term "on-line analytical processing" (OLAP) in a whitepaper that set...
    22 KB (2,491 words) - 17:55, 11 December 2024
  • Thumbnail for Star schema
    cubes – star schemas are used by all OLAP systems to build proprietary OLAP cubes efficiently; in fact, most major OLAP systems provide a ROLAP mode of operation...
    7 KB (982 words) - 14:48, 18 November 2024
  • open-source, distributed data store written in Java. Pinot is designed to execute OLAP queries with low latency. It is suited in contexts where fast analytics,...
    10 KB (922 words) - 20:07, 4 September 2024
  • Thumbnail for Palo (OLAP database)
    Palo is a memory resident multidimensional (online analytical processing (OLAP) or multidimensional online analytical processing (MOLAP)) database server...
    5 KB (559 words) - 08:28, 6 February 2024
  • retains its historical name TM1. Data is stored in in-memory multidimensional OLAP cubes, generally at the "leaf" level, and consolidated on demand. In addition...
    7 KB (732 words) - 18:35, 28 August 2024
  • online analytical processing (OLAP) using a database management system. Much like SQL, it is a query language for OLAP cubes. It is also a calculation...
    9 KB (1,183 words) - 00:24, 1 September 2023
  • should be divided into querying, reporting, Online analytical processing (OLAP), an "alerts" tool, and business analytics. In this definition, business...
    24 KB (2,535 words) - 13:57, 2 October 2024
  • Cubes is a light-weight open source multidimensional modelling and OLAP toolkit for development reporting applications and browsing of aggregated data...
    8 KB (705 words) - 08:36, 10 July 2023
  • Thumbnail for Dimension (data warehouse)
    A dimension table in an OLAP cube with a star schema...
    18 KB (2,585 words) - 03:34, 10 April 2024
  • Thumbnail for SAP HANA
    hybrid systems suitable for both OLAP and OLTP capabilities, removing the need to maintain separate systems for OLTP and OLAP operations. The index server...
    31 KB (3,002 words) - 16:41, 5 July 2024
  • Thumbnail for Snowflake schema
    some advantages over the star schema in certain situations, including: Some OLAP multidimensional database modeling tools are optimized for snowflake schemas...
    8 KB (1,023 words) - 14:44, 18 November 2024
  • Thumbnail for ClickHouse
    (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) - 19:26, 20 December 2024
  • array of values OLAP cube, an extension to a spreadsheet's two-dimensional array optimized for multidimensional analysis Cubes (OLAP server), a light-weight...
    4 KB (504 words) - 15:58, 10 September 2024
  • Foundation. Gremlin works for both OLTP-based graph databases as well as OLAP-based graph processors. Gremlin's automata and functional language foundation...
    14 KB (1,478 words) - 16:27, 18 January 2024
  • Thumbnail for Thomas Neumann
    in the Digital Bibliography & Library Project (DBLP) HyPer: Hybrid OLTP&OLAP High-Performance Database System Umbra: A Disk-Based System with In-Memory...
    6 KB (397 words) - 09:30, 10 August 2024
  • Microsoft Power Pivot Developer(s) Microsoft Operating system Microsoft Windows Type OLAP, Data analysis, Business intelligence License Microsoft EULA...
    8 KB (960 words) - 09:39, 27 August 2024
  • Gremlin is an Apache Software Foundation graph traversal language for OLTP and OLAP graph systems. GraphQL is a data query language developed by Facebook as...
    8 KB (928 words) - 20:40, 5 December 2024
  • Thumbnail for Pentaho
    (PDI) and Pentaho Business Analytics (PBA)]. These provide data integration, OLAP services, reporting, information dashboards, data mining and extract, transform...
    28 KB (1,062 words) - 02:23, 21 December 2024