DB-EnginesExtremeDB: mitigate connectivity issues in a DBMSEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Amazon Aurora vs. Apache Impala vs. ArangoDB vs. Kdb vs. Microsoft SQL Server

System Properties Comparison Amazon Aurora vs. Apache Impala vs. ArangoDB vs. Kdb vs. Microsoft SQL Server

Editorial information provided by DB-Engines
NameAmazon Aurora  Xexclude from comparisonApache Impala  Xexclude from comparisonArangoDB  Xexclude from comparisonKdb  Xexclude from comparisonMicrosoft SQL Server  Xexclude from comparison
DescriptionMySQL and PostgreSQL compatible cloud service by AmazonAnalytic DBMS for HadoopNative multi-model DBMS for graph, document, key/value and search. All in one engine and accessible with one query language.High performance Time Series DBMSMicrosofts flagship relational DBMS
Primary database modelRelational DBMSRelational DBMSDocument store
Graph DBMS
Key-value store
Search engine
Time Series DBMS
Vector DBMS
Relational DBMS
Secondary database modelsDocument storeDocument storeRelational DBMSDocument store
Graph DBMS
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score7.91
Rank#50  Overall
#32  Relational DBMS
Score13.77
Rank#40  Overall
#24  Relational DBMS
Score3.32
Rank#90  Overall
#15  Document stores
#5  Graph DBMS
#12  Key-value stores
#10  Search engines
Score7.55
Rank#53  Overall
#3  Time Series DBMS
#1  Vector DBMS
Score824.29
Rank#3  Overall
#3  Relational DBMS
Websiteaws.amazon.com/­rds/­auroraimpala.apache.orgarangodb.comkx.comwww.microsoft.com/­en-us/­sql-server
Technical documentationdocs.aws.amazon.com/­AmazonRDS/­latest/­AuroraUserGuide/­CHAP_Aurora.htmlimpala.apache.org/­impala-docs.htmldocs.arangodb.comcode.kx.comlearn.microsoft.com/­en-US/­sql/­sql-server
Social network pagesLinkedInTwitterFacebookYouTubeInstagram
DeveloperAmazonApache Software Foundation infoApache top-level project, originally developed by ClouderaArangoDB Inc.Kx Systems, a division of First Derivatives plcMicrosoft
Initial release2015201320122000 infokdb was released 2000, kdb+ in 20031989
Current release4.1.0, June 20223.11.5, November 20233.6, May 2018SQL Server 2022, November 2022
License infoCommercial or Open SourcecommercialOpen Source infoApache Version 2Open Source infoApache Version 2; Commercial license (Enterprise) availablecommercial infofree 32-bit versioncommercial inforestricted free version is available
Cloud-based only infoOnly available as a cloud serviceyesnononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
ArangoDB Cloud –The Managed Cloud Service of ArangoDB. Provides fully managed, and monitored cluster deployments of any size, with enterprise-grade security. Get started for free and continue for as little as $0,21/hour.
Implementation languageC++C++qC++
Server operating systemshostedLinuxLinux
OS X
Windows
Linux
OS X
Solaris
Windows
Linux
Windows
Data schemeyesyesschema-free infoautomatically recognizes schema within a collectionyesyes
Typing infopredefined data types such as float or dateyesyesyes infostring, double, boolean, list, hashyesyes
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.yesnoyesyes
Secondary indexesyesyesyesyes infotable attribute 'grouped'yes
SQL infoSupport of SQLyesSQL-like DML and DDL statementsnoSQL-like query language (q)yes
APIs and other access methodsADO.NET
JDBC
ODBC
JDBC
ODBC
AQL
Foxx Framework
Graph API (Gremlin)
GraphQL query language
HTTP API
Java & SpringData
JSON style queries
VelocyPack/VelocyStream
HTTP API
JDBC
Jupyter
Kafka
ODBC
WebSocket
ADO.NET
JDBC
ODBC
OLE DB
Tabular Data Stream (TDS)
Supported programming languagesAda
C
C#
C++
D
Delphi
Eiffel
Erlang
Haskell
Java
JavaScript (Node.js)
Objective-C
OCaml
Perl
PHP
Python
Ruby
Scheme
Tcl
All languages supporting JDBC/ODBCC#
C++
Clojure
Elixir
Go
Java
JavaScript (Node.js)
PHP
Python
R
Rust
C
C#
C++
Go
J
Java
JavaScript
Lua
MatLab
Perl
PHP
Python
R
Scala
C#
C++
Delphi
Go
Java
JavaScript (Node.js)
PHP
Python
R
Ruby
Visual Basic
Server-side scripts infoStored proceduresyesyes infouser defined functions and integration of map-reduceJavaScriptuser defined functionsTransact SQL, .NET languages, R, Python and (with SQL Server 2019) Java
Triggersyesnonoyes infowith viewsyes
Partitioning methods infoMethods for storing different data on different nodeshorizontal partitioningShardingSharding infosince version 2.0horizontal partitioningtables can be distributed across several files (horizontal partitioning); sharding through federation
Replication methods infoMethods for redundantly storing data on multiple nodesSource-replica replicationselectable replication factorSource-replica replication with configurable replication factorSource-replica replicationyes, but depending on the SQL-Server Edition
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyes infoquery execution via MapReduceno infocan be done with stored procedures in JavaScriptno infosimilar paradigm used for internal processingno
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyEventual ConsistencyEventual Consistency infoconfigurable per collection or per write
Immediate Consistency
OneShard (highly available, fault-tolerant deployment mode with ACID semantics)
Immediate ConsistencyImmediate Consistency
Foreign keys infoReferential integrityyesnoyes inforelationships in graphsyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDnoACIDnoACID
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
User concepts infoAccess controlfine grained access rights according to SQL-standardAccess rights for users, groups and roles infobased on Apache Sentry and Kerberosyesrights management via user accountsfine grained access rights according to SQL-standard
More information provided by the system vendor
Amazon AuroraApache ImpalaArangoDBKdbMicrosoft SQL Server
Specific characteristicsGraph and Beyond. With more than 11,000 stargazers on GitHub, ArangoDB is the leading...
» more
Integrated columnar database & programming system for streaming, real time and historical...
» more
Competitive advantagesConsolidation: As a native multi-model database, can be used as a full blown document...
» more
provides seamless scalability; runs on industry standard server platforms; is top-ranked...
» more
Typical application scenariosNative multi-model in ArangoDB is being used for a broad range of projects across...
» more
tick database streaming sensor data massive intelligence applications oil and gas...
» more
Key customersCisco, Barclays, Refinitive, Siemens Mentor, Kabbage, Liaison, Douglas, MakeMyTrip,...
» more
Goldman Sachs Morgan Stanley Merrill Lynch J.P. Morgan Deutsche Bank IEX Securities...
» more
Market metricsArangoDB is the leading native multi-model database with over 11,000 stargazers on...
» more
kdb+ performance and reliability proven by our customers in critical infrastructure...
» more
Licensing and pricing modelsVery permissive Apache 2 License for Community Edition & commercial licenses are...
» more
upon request
» 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 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
Amazon AuroraApache ImpalaArangoDBKdbMicrosoft SQL Server
DB-Engines blog posts

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

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

show all

The Weight of Relational Databases: Time for Multi-Model?
29 August 2017, Luca Olivari (guest author)

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

Handle tables without primary keys while creating Amazon Aurora PostgreSQL zero-ETL integrations with Amazon ...
18 April 2024, AWS Blog

Join the preview of Amazon Aurora Limitless Database | Amazon Web Services
27 November 2023, AWS Blog

New – Amazon Aurora Optimized Reads for Aurora PostgreSQL with up to 8x query latency improvement for I/O ...
8 November 2023, AWS Blog

Knowledge Bases for Amazon Bedrock now supports Amazon Aurora PostgreSQL and Cohere embedding models ...
12 February 2024, AWS Blog

Improve the performance of generative AI workloads on Amazon Aurora with Optimized Reads and pgvector | Amazon ...
9 February 2024, AWS Blog

provided by Google News

Cloudera creates observability tool to help enterprises manage cloud costs
6 June 2023, SiliconANGLE 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

provided by Google News

ArangoDB Announces Release of ArangoDB 3.11 for Search, Graph and Analytics - High-Performance Computing ...
30 May 2023, insideHPC

How to Build Knowledge Graph Enhanced Chatbot with ChatGPT and ArangoDB
30 June 2023, DataDrivenInvestor

ArangoDB brings yet more money into graph database market with $27.8M round
6 October 2021, SiliconANGLE News

ArangoDB expands scope of graph database platform
6 October 2022, TechTarget

Graph, machine learning, hype, and beyond: ArangoDB open source multi-model database releases version 3.7
27 August 2020, ZDNet

provided by Google News

Turbocharging the Engine: KX Unleashes AI-First Transformation with kdb+
28 February 2024, Business Wire

Introducing Amazon FinSpace with Managed kdb Insights, a fully managed analytics engine, commonly used by capital ...
18 May 2023, AWS Blog

KX ANNOUNCES KDB INSIGHTS AS FULLY MANAGED SERVICE ON AMAZON FINSPACE
18 May 2023, PR Newswire

McLaren Applied and KX partner to enhance ATLAS software analytics capabilities
9 August 2023, Professional Motorsport World

KX Brings the Power and Performance of kdb+ to Python Developers with PyKX
7 June 2023, Datanami

provided by Google News

Why migrate Windows Server and SQL Server to Azure: ROI, innovation, and free offers
25 April 2024, Microsoft

SolarWinds Enhances Plan Explorer to Help Database Pros Improve Operations, Performance, and Business Outcomes
30 April 2024, Business Wire

RDS Custom for SQL Server supports SQL Server Developer Edition
17 November 2023, AWS Blog

How to Know When It's Time for a Microsoft SQL Server Upgrade
31 October 2023, BizTech Magazine

Deploying a highly available Microsoft SQL Server database on Oracle Cloud Infrastructure (OCI) using AlwaysON ...
9 October 2023, Oracle

provided by Google News



Share this page

Featured Products

RaimaDB logo

RaimaDB, embedded database for mission-critical applications. When performance, footprint and reliability matters.
Try RaimaDB for free.

AllegroGraph logo

Graph Database Leader for AI Knowledge Graph Applications - The Most Secure Graph Database Available.
Free Download

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