DB-EnginesExtremeDB for everyone with an RTOSEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Aerospike vs. Apache Impala vs. GraphDB vs. Microsoft SQL Server vs. ScyllaDB

System Properties Comparison Aerospike vs. Apache Impala vs. GraphDB vs. Microsoft SQL Server vs. ScyllaDB

Editorial information provided by DB-Engines
NameAerospike infopreviously called Citrusleaf  Xexclude from comparisonApache Impala  Xexclude from comparisonGraphDB infoformer name: OWLIM  Xexclude from comparisonMicrosoft SQL Server  Xexclude from comparisonScyllaDB  Xexclude from comparison
DescriptionFlash-optimized In-memory NoSQL DatabaseAnalytic DBMS for HadoopEnterprise-ready RDF and graph database with efficient reasoning, cluster and external index synchronization support. It supports also SQL JDBC access to Knowledge Graph and GraphQL over SPARQL.Microsofts flagship relational DBMSCassandra and DynamoDB compatible wide column store
Primary database modelDocument store
Graph DBMS infoleveraging Apache Tinkerpop
Key-value store
Spatial DBMS
Vector DBMS
Relational DBMSGraph DBMS
RDF store
Relational DBMSWide column store
Secondary database modelsDocument storeDocument store
Graph DBMS
Spatial DBMS
Key-value store
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
#2  Vector DBMS
Score12.45
Rank#40  Overall
#24  Relational DBMS
Score3.25
Rank#91  Overall
#7  Graph DBMS
#4  RDF stores
Score821.56
Rank#3  Overall
#3  Relational DBMS
Score4.08
Rank#76  Overall
#5  Wide column stores
Websiteaerospike.comimpala.apache.orgwww.ontotext.comwww.microsoft.com/­en-us/­sql-serverwww.scylladb.com
Technical documentationdocs.aerospike.comimpala.apache.org/­impala-docs.htmlgraphdb.ontotext.com/­documentationlearn.microsoft.com/­en-US/­sql/­sql-serverdocs.scylladb.com
Social network pagesLinkedInTwitterYouTubeFacebookLinkedInTwitterYouTubeGitHubMedium
DeveloperAerospikeApache Software Foundation infoApache top-level project, originally developed by ClouderaOntotextMicrosoftScyllaDB
Initial release20122013200019892015
Current release7.1, May 20244.1.0, June 202210.4, October 2023SQL Server 2022, November 2022ScyllaDB Open Source 5.4.1, January 2024
License infoCommercial or Open SourceOpen Source infoApache and AGPL Licenses; open sourced in June 2014; commercial Enterprise Edition availableOpen Source infoApache Version 2commercial infoSome plugins of GraphDB Workbench are open sourcedcommercial inforestricted free version is availableOpen Source infoOpen Source (AGPL), commercial license available
Cloud-based only infoOnly available as a cloud servicenonononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
SQLServer Flex @ STACKIT offers a managed version of SQL Server with adjustable CPU, RAM, storage amount and speed, in enterprise grade to perfectly match all application requirements. All services are 100% GDPR-compliant.Scylla Cloud: Create real-time applications that run at global scale with Scylla Cloud, the industry’s most powerful NoSQL DBaaS
Implementation languageCC++JavaC++C++
Server operating systemsLinuxLinuxAll OS with a Java VM
Linux
OS X
Windows
Linux
Windows
Linux
Data schemeschema-freeyesschema-free and OWL/RDFS-schema support; RDF shapesyesschema-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 indexesyesyesyes, supports real-time synchronization and indexing in SOLR/Elastic search/Lucene and GeoSPARQL geometry data indexesyesyes infocluster global secondary indices
SQL infoSupport of SQLnoSQL-like DML and DDL statementsstored SPARQL accessed as SQL using Apache Calcite through JDBC/ODBCyesSQL-like DML and DDL statements (CQL)
APIs and other access methodsJDBC
Proprietary protocol
TinkerPop Gremlin
JDBC
ODBC
GeoSPARQL
GraphQL
GraphQL Federation
Java API
JDBC
RDF4J API
RDFS
RIO
Sail API
Sesame REST HTTP Protocol
SPARQL 1.1
ADO.NET
JDBC
ODBC
OLE DB
Tabular Data Stream (TDS)
Proprietary protocol (CQL) infocompatible with CQL (Cassandra Query Language, an SQL-like language)
RESTful HTTP API (DynamoDB compatible)
Thrift
Supported programming languages.Net
C
C#
C++
Erlang
Go
Java
JavaScript (Node.js)
Lua
Perl
PHP
Python
Ruby
All languages supporting JDBC/ODBC.Net
C#
Clojure
Java
JavaScript (Node.js)
PHP
Python
Ruby
Scala
C#
C++
Delphi
Go
Java
JavaScript (Node.js)
PHP
Python
R
Ruby
Visual Basic
For CQL interface: C#, C++, Clojure, Erlang, Go, Haskell, Java, JavaScript, Node.js, Perl, PHP, Python, Ruby, Rust, Scala
For DynamoDB interface: .Net, ColdFusion, Erlang, Groovy, Java, JavaScript, Perl, PHP, Python, Ruby
Server-side scripts infoStored proceduresuser defined functions infowith Luayes infouser defined functions and integration of map-reducewell-defined plugin interfaces; JavaScript server-side extensibilityTransact SQL, .NET languages, R, Python and (with SQL Server 2019) Javayes, Lua
Triggersnononoyesno
Partitioning methods infoMethods for storing different data on different nodesShardingShardingnonetables can be distributed across several files (horizontal partitioning); sharding through federationSharding
Replication methods infoMethods for redundantly storing data on multiple nodesselectable replication factorselectable replication factorMulti-source replicationyes, but depending on the SQL-Server Editionselectable replication factor infoRepresentation of geographical distribution of servers is possible
MapReduce infoOffers an API for user-defined Map/Reduce methodsyes infoAerospike Aggregation Framework is similar to Map/Reduceyes infoquery execution via MapReducenonono
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency in cross-datacenter configuration and Immediate Consistency in local cluster configurationEventual ConsistencyImmediate Consistency, Eventual consistency (configurable in cluster mode per master or individual client request)Immediate ConsistencyEventual Consistency
Tunable Consistency infocan be individually decided for each write operation
Foreign keys infoReferential integritynonoyes infoConstraint checkingyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataAtomic execution of operationsnoACIDACIDno infoAtomicity and isolation are supported for single operations
Concurrency infoSupport for concurrent manipulation of datayesyesyesyesyes
Durability infoSupport for making data persistentyesyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesnoyesyes infoin-memory tables
User concepts infoAccess controlAccess rights for users and roles infowith Enterprise Edition onlyAccess rights for users, groups and roles infobased on Apache Sentry and KerberosDefault Basic authentication through RDF4J client, or via Java when run with cURL, default token-based in the Workbench or via Rest API, optional access through OpenID or Kerberos single sign-on.fine grained access rights according to SQL-standardAccess rights for users can be defined per object
More information provided by the system vendor
Aerospike infopreviously called CitrusleafApache ImpalaGraphDB infoformer name: OWLIMMicrosoft SQL ServerScyllaDB
Specific characteristicsAerospike is an enterprise-class, NoSQL database solution delivering predictable...
» more
Ontotext GraphDB is a semantic database engine that allows organizations to build...
» more
ScyllaDB is engineered to deliver predictable performance at scale. It’s adopted...
» more
Competitive advantagesOptimized for use with SSDs (solid-state hard drives) Scales horizontally and vertically...
» more
GraphDB allows you to link text and data in big knowledge graphs. It’s easy to experiment...
» more
Highly-performant (efficiently utilizes full resources of a node and network; millions...
» more
Typical application scenariosAerospike excels in mission-critical applications that have mixed read/write workloads...
» more
Metadata enrichment and management, linked data publishing, semantic inferencing...
» more
ScyllaDB is ideal for applications that require high throughput and low latency at...
» more
Key customersNielsen, Williams-Sonoma, Inmobi, AppNexus, Telco (confidential), Financial Services...
» more
​ GraphDB provides a platform for building next-generation AI and Knowledge Graph...
» more
Discord, Epic Games, Expedia, Zillow, Comcast, Disney+ Hotstar, Samsung, ShareChat,...
» more
Market metricsAerospike's combination of speed, scalability, and reliability delivers 10x performance...
» more
GraphDB is the most utilized semantic triplestore for mission-critical enterprise...
» more
ScyllaDB typically offers ~75% total cost of ownership savings, with ~5X higher throughput...
» more
Licensing and pricing modelsSubscription-based Enterprise Edition and free, open-source Community Edition
» more
GraphDB Free is a non-commercial version and is free to use. GraphDB Enterprise edition...
» more
ScyllaDB Open Source - free open source software (AGPL) ScyllaDB Enterprise - subscription-based...
» 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

Riding the Databricks Wave with Hybrid Knowledge Graphs
6 June 2024

Matching Skills and Candidates with Graph RAG
31 May 2024

A Triple Store RAG Retriever
29 May 2024

Integrating GraphDB with Relational Database Systems
23 May 2024

Understanding the Graph Center of Excellence
17 May 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
3rd partiesNavicat Monitor is a safe, simple and agentless remote server monitoring tool for SQL Server and many other database management systems.
» more

Navicat for SQL Server gives you a fully graphical approach to database management and development.
» more

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

More resources
Aerospike infopreviously called CitrusleafApache ImpalaGraphDB infoformer name: OWLIMMicrosoft SQL ServerScyllaDB
DB-Engines blog posts

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

show all

MySQL is the DBMS of the Year 2019
3 January 2020, Matthias Gelbmann, Paul Andlinger

The struggle for the hegemony in Oracle's database empire
2 May 2017, Paul Andlinger

Microsoft SQL Server is the DBMS of the Year
4 January 2017, Matthias Gelbmann, Paul Andlinger

show all

Recent citations in the news

The real-time data imperative: Examining demands in the gen AI era
12 June 2024, SiliconANGLE News

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, AWS, Google, Glean, and Other Industry Leaders Speaking at Real-time Data Summit 2024
5 June 2024, Datanami

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

provided by Google News

Apache Impala becomes Top-Level Project
28 November 2017, SDTimes.com

Cloudera Bringing Impala to AWS Cloud
28 November 2017, Datanami

Apache Doris just 'graduated': Why care about this SQL data warehouse
24 June 2022, InfoWorld

Hudi: Uber Engineering’s Incremental Processing Framework on Apache Hadoop
12 March 2017, Uber

Updates & Upserts in Hadoop Ecosystem with Apache Kudu
27 October 2017, KDnuggets

provided by Google News

Ontotext's GraphDB Solution is Now Available on the Microsoft Azure Marketplace
16 January 2024, PR Newswire

Ontotext Announces Latest Major Release, GraphDB 10
5 July 2022, Datanami

Ontotext Platform 3.0 for Enterprise Knowledge Graphs Released
18 December 2019, KDnuggets

It's just semantics: Bulgarian software dev Ontotext squeezes out GraphDB 9.1
15 January 2020, The Register

Ontotext's GraphDB 8.10 Makes Knowledge Graph Experience Faster and Richer
13 June 2019, Markets Insider

provided by Google News

Upgrade Amazon RDS for SQL Server 2014 to a newer supported version using the AWS CLI | Amazon Web Services
11 June 2024, AWS Blog

SQL Server on Linux: What You Need to Know
30 May 2024, ITPro Today

SQL Server 2014 end of support: Keep your customers secure
28 March 2024, microsoft.com

Mastering the SQL Server command-line interface
30 May 2024, SitePoint

The Essential Guide to SQL Server 2014 Series: Scalability
1 June 2024, ITPro Today

provided by Google News

Sleeping at Scale - Delivering 10k Timers per Second per Node with Rust, Tokio, Kafka, and Scylla
26 April 2024, InfoQ.com

ScyllaDB on AWS is a NoSQL Database Built for Gigabyte-to-Petabyte Scale | Amazon Web Services
6 January 2023, AWS Blog

Scylla Eyes Cassandra's NoSQL Workloads
13 February 2018, Datanami

ScyllaDB Database Review | eWeek
21 August 2018, eWeek

Scylla review: Apache Cassandra supercharged
18 December 2019, InfoWorld

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