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 > Aerospike vs. Apache Druid vs. H2GIS vs. Microsoft Azure SQL Database vs. TinkerGraph

System Properties Comparison Aerospike vs. Apache Druid vs. H2GIS vs. Microsoft Azure SQL Database vs. TinkerGraph

Editorial information provided by DB-Engines
NameAerospike infopreviously called Citrusleaf  Xexclude from comparisonApache Druid  Xexclude from comparisonH2GIS  Xexclude from comparisonMicrosoft Azure SQL Database infoformerly SQL Azure  Xexclude from comparisonTinkerGraph  Xexclude from comparison
DescriptionFlash-optimized In-memory NoSQL DatabaseOpen-source analytics data store designed for sub-second OLAP queries on high dimensionality and high cardinality dataSpatial extension of H2Database as a Service offering with high compatibility to Microsoft SQL ServerA lightweight, in-memory graph engine that serves as a reference implementation of the TinkerPop3 API
Primary database modelDocument store
Graph DBMS infoleveraging Apache Tinkerpop
Key-value store
Spatial DBMS
Relational DBMS
Time Series DBMS
Spatial DBMSRelational DBMSGraph DBMS
Secondary database modelsRelational DBMSDocument store
Graph DBMS
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score5.51
Rank#60  Overall
#10  Document stores
#3  Graph DBMS
#6  Key-value stores
#2  Spatial DBMS
Score3.25
Rank#90  Overall
#47  Relational DBMS
#7  Time Series DBMS
Score0.08
Rank#368  Overall
#7  Spatial DBMS
Score76.78
Rank#16  Overall
#11  Relational DBMS
Score0.13
Rank#345  Overall
#35  Graph DBMS
Websiteaerospike.comdruid.apache.orgwww.h2gis.orgazure.microsoft.com/­en-us/­products/­azure-sql/­databasetinkerpop.apache.org/­docs/­current/­reference/­#tinkergraph-gremlin
Technical documentationdocs.aerospike.comdruid.apache.org/­docs/­latest/­designwww.h2gis.org/­docs/­homedocs.microsoft.com/­en-us/­azure/­azure-sql
Social network pagesLinkedInTwitterYouTubeFacebook
DeveloperAerospikeApache Software Foundation and contributorsCNRSMicrosoft
Initial release20122012201320102009
Current release7.0, November 202329.0.1, April 2024V12
License infoCommercial or Open SourceOpen Source infoApache and AGPL Licenses; open sourced in June 2014; commercial Enterprise Edition availableOpen Source infoApache license v2Open Source infoLGPL 3.0commercialOpen Source infoApache 2.0
Cloud-based only infoOnly available as a cloud servicenononoyesno
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageCJavaJavaC++Java
Server operating systemsLinuxLinux
OS X
Unix
hosted
Data schemeschema-freeyes infoschema-less columns are supportedyesyesschema-free
Typing infopredefined data types such as float or dateyesyesyesyesyes
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.nononoyesno
Secondary indexesyesyesyesyesno
SQL infoSupport of SQLnoSQL for queryingyesyesno
APIs and other access methodsJDBC
Proprietary protocol
TinkerPop Gremlin
JDBC
RESTful HTTP/JSON API
ADO.NET
JDBC
ODBC
TinkerPop 3
Supported programming languages.Net
C
C#
C++
Erlang
Go
Java
JavaScript (Node.js)
Lua
Perl
PHP
Python
Ruby
Clojure
JavaScript
PHP
Python
R
Ruby
Scala
Java.Net
C#
Java
JavaScript (Node.js)
PHP
Python
Ruby
Groovy
Java
Server-side scripts infoStored proceduresuser defined functions infowith Luanoyes infobased on H2Transact SQLno
Triggersnonoyesyesno
Partitioning methods infoMethods for storing different data on different nodesShardingSharding infomanual/auto, time-basednonenone
Replication methods infoMethods for redundantly storing data on multiple nodesselectable replication factoryes, via HDFS, S3 or other storage enginesyes infobased on H2yes, with always 3 replicas availablenone
MapReduce infoOffers an API for user-defined Map/Reduce methodsyes infoAerospike Aggregation Framework is similar to Map/Reducenononono
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency in cross-datacenter configuration and Immediate Consistency in local cluster configurationImmediate ConsistencyImmediate ConsistencyImmediate Consistencynone
Foreign keys infoReferential integritynonoyesyesyes infoRelationships in graphs
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataAtomic execution of operationsnoACIDACIDno
Concurrency infoSupport for concurrent manipulation of datayesyesyes, multi-version concurrency control (MVCC)yesno
Durability infoSupport for making data persistentyesyesyesyesoptional
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesnoyesyes
User concepts infoAccess controlAccess rights for users and roles infowith Enterprise Edition onlyRBAC using LDAP or Druid internals for users and groups for read/write by datasource and systemyes infobased on H2fine grained access rights according to SQL-standardno
More information provided by the system vendor
Aerospike infopreviously called CitrusleafApache DruidH2GISMicrosoft Azure SQL Database infoformerly SQL AzureTinkerGraph
Specific characteristicsAerospike is an enterprise-class, NoSQL database solution delivering predictable...
» more
Competitive advantagesOptimized for use with SSDs (solid-state hard drives) Scales horizontally and vertically...
» more
Typical application scenariosAerospike excels in mission-critical applications that have mixed read/write workloads...
» more
Key customersNielsen, Williams-Sonoma, Inmobi, AppNexus, Telco (confidential), Financial Services...
» more
Market metricsAerospike's combination of speed, scalability, and reliability delivers 10x performance...
» more
Licensing and pricing modelsSubscription-based Enterprise Edition and free, open-source Community Edition
» more
News

Aerospike, AWS, Google, Glean, and other Industry Leaders Speaking at Real-time Data Summit 2024
5 June 2024

Aerospike a Winner in 2024 Business Sustainability Awards
22 May 2024

New Aerospike Release Lets Enterprises Consolidate Expensive Legacy Cache And Database Platforms
15 May 2024

Aerospike Recognized by Independent Research Firm Among Notable Vendors in Vector Databases Report
7 May 2024

Aerospike Closes $109M in Growth Capital from Sumeru Equity Partners
4 April 2024

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
Aerospike infopreviously called CitrusleafApache DruidH2GISMicrosoft Azure SQL Database infoformerly SQL AzureTinkerGraph
DB-Engines blog posts

Evaluating Hbase and Aerospike Solutions for Real-time System of Record
17 March 2020,  Srini Srinivasan, Aerospike (sponsor) 

show all

PostgreSQL is the DBMS of the Year 2020
4 January 2021, Paul Andlinger, Matthias Gelbmann

Cloud-based DBMS's popularity grows at high rates
12 December 2019, Paul Andlinger

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

show all

Recent citations in the news

Aerospike, AWS, Google, Glean, and Other Industry Leaders Speaking at Real-time Data Summit 2024
5 June 2024, Datanami

Aerospike raises $109M for its real-time database platform to capitalize on the AI boom
4 April 2024, TechCrunch

Aerospike Raises $109M For Accelerated Database Development, Market Expansion
4 April 2024, CRN

Aerospike to invest tens of millions in Israeli operations, double local workforce
4 June 2024, CTech

Aerospike In-Memory noSQL Database Powers Snapdeal
31 May 2024, Data Center Knowledge

provided by Google News

Apache Druid Wins Best Big Data Product in the 2023 BigDATAwire Readers' Choice Awards
26 January 2024, Datanami

'Lucifer' Botnet Turns Up the Heat on Apache Hadoop Servers
21 February 2024, Dark Reading

New DDoS malware Attacking Apache big-data stack, Hadoop, & Druid Servers
26 February 2024, GBHackers

Apache Druid Takes Its Place In The Pantheon Of Databases
16 June 2022, The Next Platform

How to connect DataGrip to Apache Druid | by Zisis Flokas
18 October 2021, Towards Data Science

provided by Google News

Copilot in Azure SQL Database in Private Preview
27 March 2024, InfoQ.com

Microsoft unveils Copilot for Azure SQL Database
27 March 2024, InfoWorld

Azure SQL Database migration to OCI - resources estimation and migration approach
11 January 2024, blogs.oracle.com

Public Preview: New Azure SQL Database skills introduced to Microsoft Copilot in Azure | Azure updates
21 May 2024, azure.microsoft.com

Azure SQL Database takes Saturday off on US east coast following network power failure
18 September 2023, The Register

provided by Google News

Unit testing Apache TinkerPop transactions: From TinkerGraph to Amazon Neptune | Amazon Web Services
3 June 2024, AWS Blog

Why developers like Apache TinkerPop, an open source framework for graph computing | Amazon Web Services
27 September 2021, AWS Blog

InfiniteGraph Gets Support for Common Graph Database Language and More
21 February 2012, SiliconANGLE News

Introducing Gremlin query hints for Amazon Neptune
26 February 2019, AWS Blog

provided by Google News



Share this page

Featured Products

Neo4j logo

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

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus for Free

Datastax Astra logo

Bring all your data to Generative AI applications with vector search enabled by the most scalable
vector database available.
Try for Free

Present your product here