DB-EnginesCrateDB bannerEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > ClickHouse vs. Kinetica vs. MarkLogic vs. SAP HANA vs. SAP SQL Anywhere

System Properties Comparison ClickHouse vs. Kinetica vs. MarkLogic vs. SAP HANA vs. SAP SQL Anywhere

Editorial information provided by DB-Engines
NameClickHouse  Xexclude from comparisonKinetica  Xexclude from comparisonMarkLogic  Xexclude from comparisonSAP HANA  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 datasetsOperational and transactional Enterprise NoSQL databaseIn-memory, column based data store. Available as appliance or cloud serviceRDBMS database and synchronization technologies for server, desktop, remote office, and mobile environments
Primary database modelRelational DBMSRelational DBMSDocument store
Native XML DBMS
RDF store infoas of version 7
Search engine
Relational DBMSRelational DBMS
Secondary database modelsDocument store
Graph DBMS infowith SAP Hana, Enterprise Edition
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score3.70
Rank#78  Overall
#41  Relational DBMS
Score0.57
Rank#198  Overall
#96  Relational DBMS
Score12.36
Rank#38  Overall
#6  Document stores
#1  Native XML DBMS
#1  RDF stores
#4  Search engines
Score54.69
Rank#19  Overall
#12  Relational DBMS
Score5.79
Rank#56  Overall
#32  Relational DBMS
Websiteclickhouse.yandexwww.kinetica.comwww.marklogic.comwww.sap.com/­products/­hana.htmlwww.sap.com/­products/­sql-anywhere.html
Technical documentationclickhouse.yandex/­docswww.kinetica.com/­docsdocs.marklogic.comhelp.sap.com/­hanahelp.sap.com/­sql-anywhere
DeveloperYandex LLCKineticaMarkLogic Corp.SAPSAP infoformerly Sybase
Initial release20162012200120101992
Current releasev19.13.3.26, August 20196.09.0, 20172.0 SPS04, April 201917, July 2015
License infoCommercial or Open SourceOpen Source infoApache 2.0commercialcommercial inforestricted free version is availablecommercialcommercial
Cloud-based only infoOnly available as a cloud servicenononono infoalso available as a cloud based serviceno
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC, C++C++
Server operating systemsLinuxLinux
OS X
Windows
Appliance or cloud-serviceAIX
HP-UX
Linux
OS X
Solaris
Windows
Data schemeyesschema-free infoSchema can be enforcedyesyes
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.noyesnoyes
Secondary indexesyesyesyesyes
SQL infoSupport of SQLSQL-like DML and DDL statementsyes infoSQL92yesyes
APIs and other access methodsJDBC
ODBC
RESTful HTTP API
Java API
Node.js Client API
ODBC
proprietary Optic API infoProprietary Query API, introduced with version 9
RESTful HTTP API
SPARQL
WebDAV
XDBC
XQuery
XSLT
JDBC
ODBC
ADO.NET
HTTP API
JDBC
ODBC
Supported programming languagesC++
Java
JavaScript (Node.js)
Python
C
C#
C++
Java
JavaScript (Node.js)
Perl
PHP
Python
Ruby
C
C#
C++
Delphi
Java
JavaScript (Node.js)
Perl
PHP
Python
Ruby
Server-side scripts infoStored proceduresuser defined functionsyes infovia XQuery or JavaScriptSQLScript, Ryes, in C/C++, Java, .Net or Perl
Triggersyes infotriggers when inserted values for one or more columns fall within a specified rangeyesyesyes
Partitioning methods infoMethods for storing different data on different nodesShardingShardingyesnone
Replication methods infoMethods for redundantly storing data on multiple nodesMaster-slave replicationyesyesMaster-slave replication infoDatabase mirroring
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyes infovia Hadoop Connector, HDFS Direct Access and in-database MapReduce jobsnono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate Consistency or Eventual Consistency depending on configurationImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integrityyesnoyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoACID infocan act as a resource manager in an XA/JTA transactionACIDACID
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.yes infoGPU vRAM or System RAMyes, with Range Indexesyesyes
User concepts infoAccess controlAccess rights for users and roles on table levelRole-based access control at the document and subdocument levelsyesfine grained access rights according to SQL-standard
More information provided by the system vendor
ClickHouseKineticaMarkLogicSAP HANASAP SQL Anywhere infoformerly called Adaptive Server Anywhere
Specific characteristicsThe MarkLogic Multi-Model Database provides the simplest way to integrate data from...
» more
Competitive advantagesThe main benefit of MarkLogic is simplicity. By making things simpler, MarkLogic...
» more
Typical application scenariosMarkLogic’s main use case is the Operational Data Hub . A Data Hub is useful for...
» more
Key customersMarkLogic has proven results managing mission-critical data with over 1,000 global...
» more
Market metricsMarkLogic is well known within the Fortune 1000, with a strong presence in financial...
» more
Licensing and pricing modelsMarkLogic provides a variety of licenses and cloud services: MarkLogic Data Hub Service...
» more

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
3rd partiesCData: Connect to Big Data & NoSQL through standard Drivers.
» more

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

More resources
ClickHouseKineticaMarkLogicSAP HANASAP SQL Anywhere infoformerly called Adaptive Server Anywhere
Recent citations in the news

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

Time Series Databases, the Future of Monitoring and Logging
3 December 2019, Security Boulevard

Data Monoliths Go Cloud-Native with Kubernetes
31 October 2019, DevOps.com

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

Percona Announces Enhanced Version of Award-Winning Open Source Database Monitoring and Management Platform, For Faster Performance Issue Resolution
1 October 2019, GlobeNewswire

provided by Google News

Lucrative Opportunities in GPU Database Market 2027 - Emerging
24 January 2020, openPR

The insideBIGDATA IMPACT 50 List for Q1 2020
14 January 2020, insideBIGDATA

GPU Database – Know Factors Driving the Market to Record Growth | Kinetica, Omnisci, Sqream
22 January 2020, The Market Journal

GPU Database Market 2020 to 2023 Booming Trends, Share, Growth Challenges, Key Players, Industry Segments & Competitors Analysis
3 January 2020, MENAFN.COM

Kinetica Active Analytics Platform Releases Out-of-Box Support for NVIDIA RAPIDS, Delivering Massive Performance Boost to Predictive Data Analytics
5 November 2019, Business Wire

provided by Google News

Data Warehouse as a Service Market to See Strong Investment Opportunity | MarkLogic Corporation, MemSQL Inc., LUX Fund Technology & Solutions, Inc and More
29 January 2020, Science of Change

Leading companies in big data: Top private companies named
29 January 2020, Verdict

Global Graph Database Market Development And Trends Forecasts Report 2020-2026
29 January 2020, Jewish Life News

MarkLogic developers achieve boosted speed and agility with the Red Hat Universal Base Image for Containers
22 October 2019, SDTimes.com

Schiphol Airport Selects MarkLogic for Operational Flight Database
24 September 2019, Business Wire

provided by Google News

SAP HANA and S4HANA Market Ongoing Trends, Development Status and Forecast to 2025
28 January 2020, openPR

Linux Bonus Pack Makes SAP Hana Movers Happy
14 January 2020, E3zine.com

Enterprise Strategy Group Highlights Impact, Value of Actifio GO for SAP HANA on Google Cloud Platform
2 January 2020, PRNewswire

SAP Q4 2019: SAP hits €8 billion revenue mark as cloud bookings surge
28 January 2020, ZDNet

SAP Cloud Growth, Margin Focus and S/4HANA Adoption Power 2019 Results
28 January 2020, PRNewswire

provided by Google News

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

SAP SQL Anywhere
13 October 2016, TechTarget

SAP BAPI (Business Application Programming Interface)
2 April 2018, TechTarget

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

IoT Cloud Solutions Provide Enterprises Affordable Access to High-Speed Data Networks: SAP Labs
13 February 2018, DATAQUEST

provided by Google News

Job opportunities

Staff Software Engineer
Conviva, Foster City, CA

Senior Principal CDN Software Engineer, VIPER
Comcast, Denver, CO

Systems Engineer - Database
Cloudflare, Austin, TX

Senior MySQL Database Administrator
Impact, Santa Barbara, CA

Infrastructure Engineer
AppLovin, Palo Alto, CA

Business Development Director (Government/Public Sector)
Kinetica DB, Arlington, VA

Customer Success Operations Lead
Kinetica DB, San Francisco, CA

Software Engineer in Test
Kinetica DB, Arlington, VA

Machine Learning Engineer, AAG Engineering
Bain & Company Inc, Los Angeles, CA

Senior Data Engineer
General Dynamics Information Technology, New Jersey

Marklogic Developer
Frontend Arts, Cincinnati, OH

Marklogic Analyst (Contract)
Broadridge, Brentwood, NY

Publishing Analyst
ASTM International, Conshohocken, PA

NoSQL DBA Developer With MarkLogic
Avani Technology Solutions Inc, Chicago, IL

DAL - Data & Analytics (DA)
Daugherty Business Solutions, Dallas, TX

SAP Functional Specialist
Liberty Mutual Insurance, Portsmouth, NH

SAP HANA and S/4 Embedded Analytics
IBM, United States

SAP-HANA
Celandyne Software Solutions, United States

Security Consultant - SAP Governance, Risk and Compliance (GRC)
IBM, United States

SAP S/4 HANA Data Specialist
W.L. Gore, Elkton, MD

Database Administrator
ECR Software Corporation, Boone, NC

jobs by Indeed




Share this page

Featured Products

RavenDB logo

Setup a fully managed RavenDB Cloud Database in minutes. Enjoy hosting, management, backups all in one place.
Grab a Free Instance

Neo4j logo

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

MariaDB logo

How do MariaDB, Oracle MySQL and EnterpriseDB compare?
Get the white paper to
learn more.

Couchbase logo

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

Datastax Luna logo

Simple, subscription-based support for open source
Apache Cassandra™ from the Cassandra experts.
Learn more.

Present your product here