DB-EngineseXtremeDB: Active Replication Fabric for Reliable IoT Database ManagementEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > ClickHouse vs. Kinetica vs. OmniSci vs. SAP SQL Anywhere

System Properties Comparison ClickHouse vs. Kinetica vs. OmniSci vs. SAP SQL Anywhere

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameClickHouse  Xexclude from comparisonKinetica  Xexclude from comparisonOmniSci infoFormerly named 'MapD', rebranded to 'OmniSci' in September 2018  Xexclude from comparisonSAP SQL Anywhere infoformerly called Adaptive Server Anywhere  Xexclude from comparison
DescriptionColumn-oriented Relational DBMS powering YandexGPU-accelerated database for real-time analysis of large and streaming datasetsA high performance, in-memory, column-oriented RDBMS, designed to run on GPUsRDBMS database and synchronization technologies for server, desktop, remote office, and mobile environments
Primary database modelRelational DBMSRelational DBMSRelational DBMSRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score6.60
Rank#58  Overall
#32  Relational DBMS
Score0.75
Rank#193  Overall
#95  Relational DBMS
Score2.34
Rank#117  Overall
#56  Relational DBMS
Score6.79
Rank#54  Overall
#31  Relational DBMS
Websiteclickhouse.techwww.kinetica.comwww.omnisci.comwww.sap.com/­products/­sql-anywhere.html
Technical documentationclickhouse.tech/­docswww.kinetica.com/­docsdocs.omnisci.comhelp.sap.com/­sql-anywhere
DeveloperYandex LLCKineticaMapD Technologies, Inc.SAP infoformerly Sybase
Initial release2016201220161992
Current releasev20.3.17.173, August 20206.0V417, July 2015
License infoCommercial or Open SourceOpen Source infoApache 2.0commercialOpen Source infoApache Version 2; enterprise edition availablecommercial
Cloud-based only infoOnly available as a cloud servicenononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC++C, C++C++ and CUDA
Server operating systemsFreeBSD
Linux
macOS
LinuxLinuxAIX
HP-UX
Linux
OS X
Solaris
Windows
Data schemeyesyesyesyes
Typing infopredefined data types such as float or dateyesyesyesyes
XML support infoSome form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.nononoyes
Secondary indexesnoyesnoyes
SQL infoSupport of SQLClose to ANSI SQLSQL-like DML and DDL statementsyesyes
APIs and other access methodsHTTP REST
JDBC
ODBC
Proprietary protocol
JDBC
ODBC
RESTful HTTP API
JDBC
ODBC
Thrift
ADO.NET
HTTP API
JDBC
ODBC
Supported programming languagesC# info3rd party library
C++
Elixir info3rd party library
Go info3rd party library
Java info3rd party library
JavaScript (Node.js) info3rd party library
Kotlin info3rd party library
Nim info3rd party library
Perl info3rd party library
PHP info3rd party library
Python info3rd party library
R info3rd party library
Ruby info3rd party library
Scala info3rd party library
C++
Java
JavaScript (Node.js)
Python
All languages supporting JDBC/ODBC/Thrift
Python
C
C#
C++
Delphi
Java
JavaScript (Node.js)
Perl
PHP
Python
Ruby
Server-side scripts infoStored proceduresnouser defined functionsnoyes, in C/C++, Java, .Net or Perl
Triggersnoyes infotriggers when inserted values for one or more columns fall within a specified rangenoyes
Partitioning methods infoMethods for storing different data on different nodesShardingSharding infoRound robinnone
Replication methods infoMethods for redundantly storing data on multiple nodesSource-replica replicationMulti-source replicationSource-replica replication infoDatabase mirroring
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate Consistency or Eventual Consistency depending on configurationImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynoyesnoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanononoACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyes infoGPU vRAM or System RAMyesyes
User concepts infoAccess controlAccess rights for users and rolesAccess rights for users and roles on table levelfine grained access rights according to SQL-standardfine grained access rights according to SQL-standard

More information provided by the system vendor

We invite representatives of system vendors to contact us for updating and extending the system information,
and for displaying vendor-provided information such as key customers, competitive advantages and market metrics.

Related products and services

We invite representatives of vendors of related products to contact us for presenting information about their offerings here.

More resources
ClickHouseKineticaOmniSci infoFormerly named 'MapD', rebranded to 'OmniSci' in September 2018SAP SQL Anywhere infoformerly called Adaptive Server Anywhere
Recent citations in the news

How Snowflake raised $3bn in a record software IPO
15 September 2020, The Economist

From Russia with OLAP: Percona uses ClickHouse analytics
10 October 2019, ComputerWeekly.com

ClickHouse - from website clicks to ultra-fast analytics solution -
27 April 2020, Enterprise Times

ClickHouse Experiencing Explosive Growth in EU, US and Asia in Q1 2018
23 April 2018, PR Newswire

Snowflake May Melt Before Your Eyes
18 September 2020, Seeking Alpha

provided by Google News

The Kinetica Streaming Data Warehouse Eliminates Legacy Analytics Latency with Simultaneous Streaming and Data Analysis
3 September 2020, Business Wire

Global GPU Database Market To Touch Highest Milestone In Terms of Overall Growth By 2026
24 September 2020, The Daily Chronicle

Kinetica Streaming Data Warehouse Update Designed for Petabyte-Scale Data Sets
15 September 2020, TDWI

GPU database market to Witness Comprehensive Growth by COVID-19 Crisis 2018 - 2026
23 September 2020, The Market Records

Impact of Covid-19 on GPU Database Market Comprehensive Growth 2020-2026 with Top key vendor Nvidia, Jedox, Bl
24 September 2020, openPR

provided by Google News

The Next Database Platform (Full Recording Available)
1 September 2020, The Next Platform

Global GPU Database Market To Touch Highest Milestone In Terms of Overall Growth By 2026
24 September 2020, The Daily Chronicle

GPU database market to Witness Comprehensive Growth by COVID-19 Crisis 2018 - 2026
23 September 2020, The Market Records

The GPU Database Evolves Into An Analytics Platform
27 May 2020, The Next Platform

OmniSci 'Hitting Its Stride,' CEO Says
25 October 2019, Datanami

provided by Google News

SAP SQL Anywhere
13 October 2016, TechTarget

SAP gives SQL Anywhere a new IoT injection
16 July 2015, Computerworld

Best Database Management Software 2020
14 July 2020, Datamation

Rimini Street expands support beyond SAP and Oracle
9 June 2017, Inside SAP Magazine

SAP IoT products: How do they work with ERP and big data?
28 December 2015, TechTarget

provided by Google News

Job opportunities

MySQL Consultant
Percona, Remote

Sr. Timestream Specialist SA
Amazon Web Services, Inc., New York, NY

Systems Engineer - Database
Cloudflare, Austin, TX

DevOps Engineer
Yotascale, San Francisco Bay Area, CA

Senior Software Engineer at Databento
Databento, Boston, MA

SVP, Product Management
Tru Optik Data Corp, Stamford, CT

jobs by Indeed




Share this page

Featured Products

Vertica logo

The fastest unified analytical warehouse at extreme scale with in-database Machine Learning. Try Vertica for free with no time limit.

Datastax Astra logo

Cassandra made easy in the cloud. Build cloud-native applications faster with CQL, REST and GraphQL APIs.
Try for Free.

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Neo4j logo

Get your free copy of the new O'Reilly book Graph Algorithms with 20+ examples for
machine learning, graph analytics and more.

Couchbase logo

SQL + JSON + NoSQL.
Power, flexibility & scale.
All open source.
Get started now.

Present your product here