Английская Википедия:Comparison of OLAP servers
Материал из Онлайн справочника
Перейти к навигацииПерейти к поиску
The following tables compare general and technical information for a number of online analytical processing (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.
Data processing, management and performance related features:
Data modeling features:
System limits
OLAP server | # cubes | # measures | # dimensions | # dimensions in cube | # hierarchies in dimension | # levels in hierarchy | # dimension members |
---|---|---|---|---|---|---|---|
Apache Doris | Unrestricted | Unrestricted | Unrestricted | Unrestricted | Unrestricted | Unrestricted | Unrestricted |
Apache Druid | UnrestrictedШаблон:Efn | Unrestricted | Unrestricted | Unrestricted | Unrestricted | Unrestricted | Unrestricted |
Apache Kylin | Unrestricted | Unrestricted | Unrestricted | Unrestricted | Unrestricted | Unrestricted | Unrestricted |
Apache Pinot | Unrestricted | Unrestricted | Unrestricted | Unrestricted | Unrestricted | Unrestricted | Unrestricted |
ClickHouse | Unrestricted | Unrestricted | Unrestricted | Unrestricted | Unrestricted | Unrestricted | Unrestricted |
Essbase[39] | Unrestricted | Unrestricted | Unrestricted | 255 | 255 | ? | 20,000,000 (ASO), 1,000,000 (BSO) |
IBM Cognos TM1 | UnrestrictedШаблон:Efn | Unrestricted | UnrestrictedШаблон:Efn | 256 | UnrestrictedШаблон:Efn | Unrestricted | Unrestricted |
icCube | 2,147,483,647 | 2,147,483,647 | 2,147,483,647 | 2,147,483,647 | 2,147,483,647 | 2,147,483,647 | 2,147,483,647 |
Jedox OLAP Server | <math>2^{32}</math> (32 bits) | <math>2^{32}</math> | <math>2^{32}</math> (32 bits) | 250 | <math>2^{32}</math> | <math>2^{32}</math> | <math>2^{32}</math> |
Kyvos | Unrestricted | Unrestricted | Unrestricted | Unrestricted | Unrestricted | Unrestricted | Unrestricted |
Microsoft Analysis Services[40] | 2,147,483,647 | 2,147,483,647 | 2,147,483,647 | 2,147,483,647 (max. number of dimensions in a database) | 2,147,483,647 | 2,147,483,647 | 2,147,483,647 (xOLAP)
Unrestricted (In-memory) |
MicroStrategy Intelligence Server | UnrestrictedШаблон:Efn | UnrestrictedШаблон:Efn | UnrestrictedШаблон:Efn | ? | UnrestrictedШаблон:Efn | UnrestrictedШаблон:Efn | UnrestrictedШаблон:Efn |
SAS OLAP Server[41] | UnrestrictedШаблон:Efn | 1024 | 128 | ? | 128 | 19 | 4,294,967,296 |
StarRocks | Unrestricted | Unrestricted | Unrestricted | Unrestricted | Unrestricted | Unrestricted | Unrestricted |
Security
Operating systems
The OLAP servers can run on the following operating systems:
Note (1):The server availability depends on Java Virtual Machine not on the operating system
Support information
OLAP server | Issue Tracking System | Roadmap | Source code |
---|---|---|---|
Apache Doris | Apache Doris– Github Issues | Apache Doris Roadmap | Шаблон:Yes |
Apache Druid | Druid – Github Issues | Шаблон:Yes | |
Apache Kylin | Jira | Apache Kylin Roadmap | Шаблон:Yes |
Apache Pinot | Apache Pinot – Github Issues | Шаблон:Yes | |
ClickHouse | ClickHouse – Github Issues | ClickHouse Roadmap | Шаблон:Yes |
Essbase | myOracle Support | [6] | Шаблон:No |
IBM Cognos TM1 | IBM Service Request | Шаблон:No | |
icCube | YouTrack | Шаблон:No | |
Jedox OLAP Server | Mantis | Available upon request | Шаблон:Yes |
Kyvos | Zendesk | Available upon request | Шаблон:No |
Microsoft Analysis Services | Connect | - | Шаблон:No |
MicroStrategy Intelligence Server | MicroStrategy Resource Center | - | Шаблон:No |
Mondrian OLAP server | Jira | [7] | Шаблон:Yes |
Oracle Database OLAP Option | myOracle Support | Шаблон:No | |
SAP NetWeaver BW | OSS | [8] | Шаблон:No |
SAS OLAP Server | Support | Шаблон:No | |
StarRocks | StarRocks– Github Issues | StarRocks Roadmap | Шаблон:Yes |
See also
- Cubes (light-weight open-source OLAP server)
- ClickHouse
- Apache Pinot
- Apache Druid
- Apache Doris
- icCube
- Oracle Essbase
- Oracle Retail Predictive Application Server (RPAS), a retail specific MOLAP/OLAP server using Berkeley DB for persistence
- Palo (OLAP database)
- StarRocks
References
- ↑ Шаблон:Cite web
- ↑ Шаблон:Cite web
- ↑ Шаблон:Cite web
- ↑ Шаблон:Cite web
- ↑ Шаблон:Cite web
- ↑ Шаблон:Cite web
- ↑ Шаблон:Cite web
- ↑ Шаблон:Cite web
- ↑ Шаблон:Cite web
- ↑ Шаблон:Cite web
- ↑ Шаблон:Cite web
- ↑ Шаблон:Cite web
- ↑ Шаблон:Cite web
- ↑ Шаблон:Cite web
- ↑ Шаблон:Cite web
- ↑ Шаблон:Cite web
- ↑ Шаблон:Cite web
- ↑ Шаблон:Cite web
- ↑ Шаблон:Cite web
- ↑ Шаблон:Cite web
- ↑ Шаблон:Cite web
- ↑ Шаблон:Cite web
- ↑ Шаблон:Cite web
- ↑ Шаблон:Cite web
- ↑ Шаблон:Cite web
- ↑ Шаблон:Cite web
- ↑ Шаблон:Cite web
- ↑ 28,0 28,1 Шаблон:Cite web
- ↑ Шаблон:Cite web
- ↑ Шаблон:Cite web
- ↑ Шаблон:Cite web
- ↑ Шаблон:Cite web
- ↑ Шаблон:Cite web
- ↑ Шаблон:Cite web
- ↑ Шаблон:Cite web
- ↑ Шаблон:Cite web
- ↑ Шаблон:Cite web
- ↑ Шаблон:Cite web
- ↑ Шаблон:Cite web
- ↑ Шаблон:Cite web
- ↑ Шаблон:Cite web
- ↑ Шаблон:Cite web
- ↑ Шаблон:Cite web