The following tables compare general and technical information for a number of
online analytical processing
In computing, online analytical processing (OLAP) (), is an approach to quickly answer multi-dimensional analytical (MDA) queries. The term ''OLAP'' was created as a slight modification of the traditional database term online transaction proces ...
(OLAP) servers. Please see the individual products articles for further information.
General information
Data storage modes
APIs and query languages
APIs and query languages OLAP servers support.
OLAP distinctive features
A list of OLAP features that are not supported by all vendors. All vendors support features such as parent-child, multilevel hierarchy, drilldown.
System limits
Security
Operating systems
The OLAP servers can run on the following
operating system
An operating system (OS) is system software that manages computer hardware and software resources, and provides common daemon (computing), services for computer programs.
Time-sharing operating systems scheduler (computing), schedule tasks for ...
s:
Note (1):The server availability depends on
Java Virtual Machine
A Java virtual machine (JVM) is a virtual machine that enables a computer to run Java programs as well as programs written in other languages that are also compiled to Java bytecode. The JVM is detailed by a specification that formally descr ...
not on the
operating system
An operating system (OS) is system software that manages computer hardware and software resources, and provides common daemon (computing), services for computer programs.
Time-sharing operating systems scheduler (computing), schedule tasks for ...
Support information
See also
*
Cubes
A cube or regular hexahedron is a three-dimensional space, three-dimensional solid object in geometry, which is bounded by six congruent square (geometry), square faces, a type of polyhedron. It has twelve congruent edges and eight vertices. It i ...
(light-weight open-source OLAP server)
*
ClickHouse
ClickHouse is an open-source column-oriented DBMS (columnar database management system) for online analytical processing (OLAP) that allows users to generate analytical reports using SQL queries in real-time. ClickHouse Inc. is headquartered in ...
*
Apache Pinot
*
Apache Druid
Apache Doris*
Oracle Essbase
*
Oracle Retail Predictive Application Server (RPAS), a retail specific MOLAP/OLAP server using Berkeley DB for persistence
*
Palo (OLAP database)
StarRocks
References
{{DEFAULTSORT:Comparison Of Olap Servers
OLAP Servers
Data management
Data warehousing products