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

DBMS > Aerospike vs. AllegroGraph vs. Microsoft Azure SQL Data Warehouse

System Properties Comparison Aerospike vs. AllegroGraph vs. Microsoft Azure SQL Data Warehouse

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAerospike infopreviously called Citrusleaf  Xexclude from comparisonAllegroGraph  Xexclude from comparisonMicrosoft Azure SQL Data Warehouse  Xexclude from comparison
DescriptionFlash-optimized In-memory NoSQL DatabaseHigh performance, persistent RDF store with additional support for Graph DBMSElastic, large scale data warehouse service leveraging the broad eco-system of SQL Server
Primary database modelKey-value storeDocument store infowith version 6.5
Graph DBMS
RDF store
Relational DBMS
Secondary database modelsDocument store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score6.70
Rank#57  Overall
#8  Key-value stores
Score1.01
Rank#167  Overall
#25  Document stores
#14  Graph DBMS
#7  RDF stores
Score8.79
Rank#46  Overall
#28  Relational DBMS
Websitewww.aerospike.comallegrograph.comazure.microsoft.com/­services/­sql-data-warehouse
Technical documentationwww.aerospike.com/­docsfranz.com/­agraph/­support/­documentation/­current/­agraph-introduction.htmldocs.microsoft.com/­azure/­sql-data-warehouse
DeveloperAerospikeFranz Inc.Microsoft
Initial release201220042016
Current release4.8.0.3, January 20207.0.0, April 2020
License infoCommercial or Open SourceOpen Source infoApache and AGPL Licenses; open sourced in June 2014; commercial Enterprise Edition availablecommercial infoLimited community edition freecommercial
Cloud-based only infoOnly available as a cloud servicenonoyes
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageCC++
Server operating systemsLinuxLinux
OS X
Windows
hosted
Data schemeschema-freeyes infoRDF schemasyes
Typing infopredefined data types such as float or dateyesyesyes
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.nono infobulk load of XML files possibleno
Secondary indexesyesyesyes
SQL infoSupport of SQLnoSPARQL is used as query languageyes
APIs and other access methodsJDBC
Proprietary protocol
RESTful HTTP API
SPARQL
ADO.NET
JDBC
ODBC
Supported programming languages.Net
C
C#
C++
Erlang
Go
Java
JavaScript (Node.js)
Lua
Perl
PHP
Python
Ruby
C#
Clojure
Java
Lisp
Perl
Python
Ruby
Scala
C#
Java
PHP
Server-side scripts infoStored proceduresuser defined functions infowith Luayes infoJavaScript or Common LispTransact SQL
Triggersnoyesno
Partitioning methods infoMethods for storing different data on different nodesShardingwith FederationSharding, horizontal partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesselectable replication factorMulti-source replication
Source-replica replication
yes
MapReduce infoOffers an API for user-defined Map/Reduce methodsyes infoAerospike Aggregation Framework is similar to Map/Reducenono
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency in cross-datacenter configuration and Immediate Consistency in local cluster configurationImmediate Consistency or Eventual Consistency depending on configurationImmediate Consistency
Foreign keys infoReferential integritynonoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataAtomic execution of operationsACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyes
Durability infoSupport for making data persistentyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesno
User concepts infoAccess controlAccess rights for users and roles infowith Enterprise Edition onlyUsers with fine-grained authorization concept, user roles and pluggable authenticationyes
More information provided by the system vendor
Aerospike infopreviously called CitrusleafAllegroGraphMicrosoft Azure SQL Data Warehouse
Specific characteristicsAerospike is an enterprise-class, NoSQL database solution delivering predictable...
» more
Knowledge Graph Platform Leader FedShard - Designed for Entity-Event Knowledge Graph...
» more
Competitive advantagesOptimized for use with SSDs (solid-state hard drives) Scales horizontally and vertically...
» more
AllegroGraph is uniquely suited to support adhoc queries through SPARQL, Prolog and...
» 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

Connected Data London – The Future of AI in the Enterprise
3 September 2020

Using Microsoft Power BI with AllegroGraph
19 August 2020

Franz Inc. Named an AI 50 Company by KMWorld
18 August 2020

Knowledge graphs enhance customer experience through speed and accuracy
10 July 2020

AllegroGraph Named to 100 Companies That Matter Most in Data
22 June 2020

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 CitrusleafAllegroGraphMicrosoft Azure SQL Data Warehouse
DB-Engines blog posts

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

show all

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

Azure SQL Data Warehouse, the hub for a trusted and performance optimized cloud data warehouse
1 November 2017,  Arnaud Comet, Microsoft (sponsor) 

show all

Conferences and events

Enterprise Knowledge Graphs, Connected-Data.London
Webinar, 23 September 2020

Recent citations in the news

Aerospike Connect improves integrations with NoSQL database
18 September 2020, TechTarget

New Aerospike Connect Product Line Makes Aerospike Database 5 Plug-Compatible with Enterprise-wide Data Stores
15 September 2020, Business Wire

Aerospike Connect Adds More Integrations to Aerospike Database 5
15 September 2020, Database Trends and Applications

Aerospike Gives Legacy Infrastructure a Real-Time Boost
15 September 2020, Datanami

Tag: Aerospike
17 September 2020, The Daily Chronicle

provided by Google News

Little Known Artificial Intelligence Secrets: What Unsupervised Learning Really Means
22 August 2020, insideBIGDATA

Franz Inc. to Present at The Global Graph Summit and Data Day Texas 2020
10 January 2020, PR Web

Franz's AllegroGraph 7 Powers First Distributed Semantic Knowledge Graph Solution with Federated-Sharding
29 April 2020, PR Web

AllegroGraph Named to 100 Companies That Matter Most in Data
23 June 2020, PR Web

AllegroGraph v7 Powers First Distributed Semantic Knowledge Graph Solution with Federated-Sharding
26 May 2020, Business Wire

provided by Google News

Azure SQL Edge: Industry Use Cases & Customer Success - Microsoft
3 September 2020, Channel 9

Explosive Snowflake IPO advances cloud data warehouse fortunes
16 September 2020, TechTarget

Snowflake IPO shows strength of cloud data warehouse
26 August 2020, TechTarget

Microsoft Now Developing Its Own Hadoop
26 August 2020, Datanami

Azure Synapse Analytics combines data warehouse, lake and pipelines
4 November 2019, ZDNet

provided by Google News

Job opportunities

Database Engineer 3
PayPal, Scottsdale, AZ

Sr. Software Test Engineer, Open VisaNet
Visa, Foster City, CA

Database Engineer 3
PayPal, Austin, TX

.NET Software Engineer
Amobee, Baltimore, MD

SPS Technical Expert - NAM, NSW
NSW Nokia Software, Dallas, TX

Entry Level/Junior Software Engineer
BAE Systems, San Diego, CA

MBSE (Systems Modeler)
Gryphon Technologies, Arlington, VA

Database Administrator - TS/SCI (340)
Zapata Technology, Columbia, MD

Software Engineer (Back End Developer)
WTI Solutions, Herndon, VA

Java Engineer
OraApps Inc, Philadelphia, PA

Data Engineer
Applied Information Sciences, Chevy Chase, MD

Data Warehouse Architect - CA
LIBERTY Dental Plan, Irvine, CA

Azure Data Engineer - Full Time
Cognizant Technology Solutions, Parsippany, NJ

Sr. Software Engineer
Microsoft, Charlotte, NC

Azure Data Modeler
Medline Industries Inc, Northfield, IL

jobs by Indeed




Share this page

Featured Products

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Neo4j logo

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

Couchbase logo

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

Vertica logo

The fastest unified analytical warehouse at extreme scale with in-database Machine Learning. Try Vertica for free with no time limit.

Datastax Astra logo

Cassandra made easy in the cloud. Build cloud-native applications faster with CQL, REST and GraphQL APIs.
Try for Free.

Present your product here