DB-EnginesInfluxDB: Focus on building software with an easy-to-use serverless, scalable time series platformEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Amazon SimpleDB vs. ClickHouse vs. SAP HANA vs. Virtuoso

System Properties Comparison Amazon SimpleDB vs. ClickHouse vs. SAP HANA vs. Virtuoso

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAmazon SimpleDB  Xexclude from comparisonClickHouse  Xexclude from comparisonSAP HANA  Xexclude from comparisonVirtuoso  Xexclude from comparison
DescriptionHosted simple database service by Amazon, with the data stored in the Amazon Cloud. infoThere is an unrelated product called SimpleDB developed by Edward ScioreColumn-oriented Relational DBMS powering YandexIn-memory, column based data store. Available as appliance or cloud serviceVirtuoso is a multi-model hybrid-RDBMS that supports management of data represented as relational tables and/or property graphs
Primary database modelKey-value storeRelational DBMSRelational DBMSDocument store
Graph DBMS
Native XML DBMS
Relational DBMS
RDF store
Search engine
Secondary database modelsTime Series DBMSDocument store
Graph DBMS infowith SAP Hana, Enterprise Edition
Spatial DBMS
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score2.11
Rank#123  Overall
#24  Key-value stores
Score12.32
Rank#46  Overall
#30  Relational DBMS
Score55.09
Rank#21  Overall
#13  Relational DBMS
Score6.01
Rank#71  Overall
#11  Document stores
#3  Graph DBMS
#2  Native XML DBMS
#39  Relational DBMS
#2  RDF stores
#9  Search engines
Websiteaws.amazon.com/­simpledbclickhouse.techwww.sap.com/­products/­hana.htmlvirtuoso.openlinksw.com
Technical documentationdocs.aws.amazon.com/­simpledbclickhouse.tech/­docshelp.sap.com/­hanadocs.openlinksw.com/­virtuoso
DeveloperAmazonClickhouse Inc.SAPOpenLink Software
Initial release2007201620101998
Current releasev22.4.5.9-stable, May 20222.0 SPS05 (June 26, 2020), June 202008.03.3316, March 2020
License infoCommercial or Open SourcecommercialOpen Source infoApache 2.0commercialOpen Source infoGPLv2, extended commercial license available
Cloud-based only infoOnly available as a cloud serviceyesnono 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
Server operating systemshostedFreeBSD
Linux
macOS
Appliance or cloud-serviceAIX
FreeBSD
HP-UX
Linux
OS X
Solaris
Windows
Data schemeschema-freeyesyesyes infoSQL - Standard relational schema
RDF - Quad (S, P, O, G) or Triple (S, P, O)
XML - DTD, XML Schema
DAV - freeform filesystem objects, plus User Defined Types a/k/a Dynamic Extension Type
Typing infopredefined data types such as float or datenoyesyesyes
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.nonoyes
Secondary indexesyes infoAll columns are indexed automaticallynoyesyes
SQL infoSupport of SQLnoClose to ANSI SQLyesyes infoSQL-92, SQL-200x, SQL-3, SQLX
APIs and other access methodsRESTful HTTP APIHTTP REST
JDBC
ODBC
Proprietary protocol
JDBC
ODBC
ADO.NET
GeoSPARQL
HTTP API
JDBC
Jena RDF API
ODBC
OLE DB
RDF4J API
RESTful HTTP API
Sesame REST HTTP Protocol
SOAP webservices
SPARQL 1.1
WebDAV
XPath
XQuery
XSLT
Supported programming languages.Net
C
C++
Erlang
Java
PHP
Python
Ruby
Scala
C# 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
.Net
C
C#
C++
Java
JavaScript
Perl
PHP
Python
Ruby
Visual Basic
Server-side scripts infoStored proceduresnonoSQLScript, Ryes infoVirtuoso PL
Triggersnonoyesyes
Partitioning methods infoMethods for storing different data on different nodesnone infoSharding must be implemented in the applicationyesyes
Replication methods infoMethods for redundantly storing data on multiple nodesyesyesChain, star, and bi-directional replication
Multi-source replication
Source-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononoyes
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency
Immediate Consistency infocan be specified for read operations
Immediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynonoyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datano infoConcurrent data updates can be detected by the applicationnoACIDACID
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.yesyesyes
User concepts infoAccess controlAccess rights for users and roles can be defined via the AWS Identity and Access Management (IAM)Access rights for users and rolesyesFine-grained Attribute-Based Access Control (ABAC) in addition to typical coarse-grained Role-Based Access Control (RBAC) according to SQL-standard. Pluggable authentication with supported standards (LDAP, Active Directory, Kerberos)
More information provided by the system vendor
Amazon SimpleDBClickHouseSAP HANAVirtuoso
Specific characteristicsVirtuoso is a modern multi-model RDBMS for managing data represented as tabular relations...
» more
Competitive advantagesPerformance & Scale — as exemplified by DBpedia and the LOD Cloud it spawned, i.e.,...
» more
Typical application scenariosUsed for — Analytics/BI Conceptual Data Virtualization Enterprise Knowledge Graphs...
» more
Key customersBroad use across enterprises and governments including — European Union (EU) US Government...
» more
Market metricsLargest installed-base ​of Multi-Model RDBMS for AI-friendly Knowledge Graphs Platform...
» more
Licensing and pricing modelsAvailable in both Commercial Enterprise and Open Source (GPL v2) Editions Feature...
» 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
Amazon SimpleDBClickHouseSAP HANAVirtuoso
DB-Engines blog posts

The popularity of cloud-based DBMSs has increased tenfold in four years
7 February 2017, Matthias Gelbmann

Amazon - the rising star in the DBMS market
3 August 2015, Matthias Gelbmann

show all

Recent citations in the news

Amazon Simple Database Service (SimpleDB)
21 March 2022, TechTarget

Why AWS Keeps It Simple
13 December 2021, Datanami

Amazon DynamoDB Serves Trillions Of Requests Per Month While Counterpart SimpleDB Is No Longer A Listed Product On AWS
13 November 2013, TechCrunch

Amazon Goes Back to the Future With 'NoSQL' Database
19 January 2012, WIRED

provided by Google News

Real-time database startup Imply reaches unicorn status with $100M infusion
17 May 2022, TechCrunch

Two Sizes Fit Most: PostgreSQL and ClickHouse – The New Stack
13 April 2022, thenewstack.io

ClickHouse Raises $250M Series B To Scale Groundbreaking OLAP Database Management System Globally
28 October 2021, Business Wire

Speedy Column-Store ClickHouse Spins Out from Yandex, Raises $50M
24 September 2021, Datanami

Multiple Flaws Uncovered in ClickHouse OLAP Database System for Big Data
16 March 2022, The Hacker News

provided by Google News

ERP Transitions Loom for SAP on IBM i Customers
23 May 2022, IT Jungle

Application Development Software Market Top Players Movements 2022 – 2028 | GitLab, GitHub, SAP HANA Cloud Platform, Google Cloud Platform, Axure RP, etc – The Daily Vale
23 May 2022, The Daily Vale

SAP ‘optimistic’ about S/4 Hana in APAC
11 May 2022, ComputerWeekly.com

SAP HANA® Certifies EBizCharge Payment for SAP Business One HANA 10 Cloud - Benzinga
12 May 2022, Benzinga

On-Prem Versus Cloud
23 May 2022, e3zine.com

provided by Google News

Job opportunities

Platform & Systems Architect - Remote
TTEC, Englewood, CO

Software Development Engineer II
Amazon.com Services LLC, Austin, TX

Senior Data Architect (remote)
LinQuest Corporation, Beavercreek, OH

Senior Partner Development Manager, Telecommunications, Media, and Technology
Amazon Web Services, Inc., Los Angeles, CA

Sr. Global Alliance Manager, DevOps
Amazon Web Services, Inc., Austin, TX

Java Engineer (Mid-level)
Ad.net, Remote

Full Stack Developer
Digilant, Remote

Database Performance Architect
IBM, San Jose, CA

Product Manager
NXLog, Remote

Senior Data Engineer - Vice President
Deutsche Bank, Cary, NC

SAP BW HANA Analyst
NVIDIA, Santa Clara, CA

SAP S/4 Hana ABAP Developer (100% REMOTE)
Kairos Technologies, Remote

SAP S4 Hana Fashion consultant
Emonics LLC, San Francisco, CA

SAP SD S4 HANA Consultant
SHGT, Remote

SAP Basis/HANA Lead
Cogent IBS, Remote

jobs by Indeed



Share this page

Featured Products

Vertica logo

Vertica Accelerator. The fastest analytics and machine learning, delivered as SaaS, with automated setup, administration, and management. Free trial.

Datastax Astra logo

Build cloud-native apps fast with Astra, the open-source, multi-cloud stack for
modern data apps.
Get started with 80GB free.

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Redis logo

The world’s most loved real‑time data platform.
Try free

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

Present your product here