DB-EngineseXtremeDB: Active Replication Fabric for Reliable IoT Database ManagementEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Amazon Redshift vs. Blazegraph vs. FoundationDB vs. mSQL

System Properties Comparison Amazon Redshift vs. Blazegraph vs. FoundationDB vs. mSQL

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAmazon Redshift  Xexclude from comparisonBlazegraph  Xexclude from comparisonFoundationDB  Xexclude from comparisonmSQL infoMini SQL  Xexclude from comparison
Amazon has acquired Blazegraph's domain and (probably) product. It is said that Amazon Neptune is based on Blazegraph.Created as commercial project in 2013, FoundationDB has been acquired by Apple in March 2015 and was withdrawn from the market. As a consequence, the product was removed from the DB-Engines ranking. In April 2018, Apple open-sourced FoundationDB and it therefore reappears in the ranking.
DescriptionLarge scale data warehouse service for use with business intelligence toolsHigh-performance graph database supporting Semantic Web (RDF/SPARQL) and Graph Database (tinkerpop3, blueprints, vertex-centric) APIs with scale-out and High Availability.Ordered key-value store. Core features are complimented by layers.mSQL (Mini SQL) is a simple and lightweight RDBMS
Primary database modelRelational DBMSGraph DBMS
RDF store
Document store infosupported via specific layer
Key-value store
Relational DBMS infosupported via specific SQL-layer
Relational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score23.01
Rank#30  Overall
#17  Relational DBMS
Score0.81
Rank#182  Overall
#15  Graph DBMS
#8  RDF stores
Score1.05
Rank#165  Overall
#24  Document stores
#30  Key-value stores
#81  Relational DBMS
Score1.71
Rank#132  Overall
#65  Relational DBMS
Websiteaws.amazon.com/­redshiftblazegraph.comwww.foundationdb.orgwww.hughes.com.au/­products/­msql
Technical documentationdocs.aws.amazon.com/­redshiftwiki.blazegraph.comapple.github.io/­foundationdb
DeveloperAmazon (based on PostgreSQL)BlazegraphFoundationDBHughes Technologies
Initial release2012200620131994
Current release2.1.5, March 20196.2.11, November 20194.2, April 2019
License infoCommercial or Open SourcecommercialOpen Source infoextended commercial license availableOpen Source infoApache 2.0commercial infofree licenses can be provided
Cloud-based only infoOnly available as a cloud serviceyesnonono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageCJavaC++C
Server operating systemshostedLinux
OS X
Windows
Linux
OS X
Windows
AIX
HP-UX
Linux
OS X
Solaris SPARC/x86
Windows
Data schemeyesschema-freeschema-free infosome layers support schemasyes
Typing infopredefined data types such as float or dateyesyes infoRDF literal typesno infosome layers support typingyes
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
Secondary indexesrestrictedyesnoyes
SQL infoSupport of SQLyes infodoes not fully support an SQL-standardSPARQL is used as query languagesupported in specific SQL layer onlyA subset of ANSI SQL is implemented infono subqueries, aggregate functions, views, foreign keys, triggers
APIs and other access methodsJDBC
ODBC
Java API
RESTful HTTP API
SPARQL QUERY
SPARQL UPDATE
TinkerPop 3
JDBC
ODBC
Supported programming languagesAll languages supporting JDBC/ODBC.Net
C
C++
Java
JavaScript
PHP
Python
Ruby
.Net
C
C++
Go
Java
JavaScript infoNode.js
PHP
Python
Ruby
Swift
C
C++
Delphi
Java
Perl
PHP
Tcl
Server-side scripts infoStored proceduresuser defined functions infoin Pythonyesin SQL-layer onlyno
Triggersnononono
Partitioning methods infoMethods for storing different data on different nodesShardingShardingShardingnone
Replication methods infoMethods for redundantly storing data on multiple nodesyesyesyesnone
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate Consistency or Eventual Consistency depending on configurationLinearizable consistencynone
Foreign keys infoReferential integrityyes infoinformational only, not enforced by the systemyes infoRelationships in Graphsin SQL-layer onlyno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACIDACIDno
Concurrency infoSupport for concurrent manipulation of datayesyesyesno
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.yesno
User concepts infoAccess controlfine grained access rights according to SQL-standardSecurity and Authentication via Web Application Container (Tomcat, Jetty)nono
More information provided by the system vendor
Amazon RedshiftBlazegraphFoundationDBmSQL infoMini SQL
News

Blazegraph 2.1.4 Release
29 August 2016

Blazegraph 2.1.2 Release
18 June 2016

Blazegraph 2.1.1 Release!
9 June 2016

Blazegraph 2.1.0 Release!
8 April 2016

Blazegraph 2.0.0 Release!
22 December 2015

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 RedshiftBlazegraphFoundationDBmSQL infoMini SQL
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

Increased popularity for consuming DBMS services out of the cloud
2 October 2015, Paul Andlinger

show all

Recent citations in the news

Best practices using AWS SCT and AWS Snowball to migrate from Teradata to Amazon Redshift
24 September 2020, idk.dev

Using the Amazon Redshift Data API to interact with Amazon Redshift clusters
17 September 2020, idk.dev

Top 10 performance tuning techniques for Amazon Redshift
28 August 2020, idk.dev

Amazon Introduces Data API for Redshift
11 September 2020, ProgrammableWeb

Fast and predictable performance with serverless compilation using Amazon Redshift
4 September 2020, idk.dev

provided by Google News

Global GPU Database Market To Touch Highest Milestone In Terms of Overall Growth By 2026
24 September 2020, The Daily Chronicle

Graph Database Market 2020 | What Is The Estimated Market Size In The Upcoming Years?
23 September 2020, The Daily Chronicle

Graph database Market Is Set To Experience Revolutionary Growth By 2025 | IBM, Microsoft, oracle, AWS, neo4j, tibco software
23 September 2020, The Daily Chronicle

Graph Database Market Growing at a CAGR 22.2% | Key Player IBM, Oracle, Microsoft, AWS, Neo4j - Press Release
21 September 2020, Digital Journal

Impact Of Covid-19 on Graph Database Market 2020 Industry Challenges, Business Overview and Forecast Research Study 2026
24 September 2020, The Daily Chronicle

provided by Google News

Senior Database Reliability Engineer - FoundationDB — Cognite
9 September 2020, builtinaustin.com

Does Snowflake mean the end of open source?
23 September 2020, IDG Connect

Apple Acquires Durable Database Company FoundationDB
24 March 2015, TechCrunch

Apple’s FoundationDB open sources the database layer behind CloudKit
14 January 2019, 9to5Mac

FoundationDB's Record Layer Supports Relational Database Semantics, Schema Management and Indexing
10 February 2019, InfoQ.com

provided by Google News

20 Years of PHP
19 July 2016, Laravel News

Writing a Web Service in Perl
8 May 2020, PCQuest

TransWare Offers New Translation Tools and Services for ARIS® 7.x, 9.x Full translation to Microsoft Visio® 2010, 2013 and 2016 and Many Other Modeling Tools
12 October 2015, PR Web

PHP at 20: From pet project to powerhouse
11 June 2015, InfoWorld

Higher Education PS rules out ghost students before PAC – Zambia
29 November 2018, diggers.news

provided by Google News

Job opportunities

ETL Developer
The Green Technology Group, LLC, United States

Data Analyst
ShootProof, Atlanta, GA

Sr. Software Development Engineer - AWS, Amazon Redshift
Amazon.com Services LLC, East Palo Alto, CA

Partner Development Analyst
TrueCar, Inc., Santa Monica, CA

Amazon Redshift Development Manager
Amazon.com Services LLC, Arlington, VA

Data Engineer II - Scientific Computing
Mount Sinai, New York, NY

Data Infrastructure Engineer
kraken, United States

Senior Software Engineer - Streaming
Epic Games, Bellevue, WA

Software Engineer - Platform Integration
ANDURIL INDUSTRIES, Irvine, CA

Senior Systems Engineer
Branch, Washington State

Senior Systems Engineer
Branch, Illinois

Journeyman Engineer
KBR, Lexington Park, MD

Senior Engineer
KBR, Lexington Park, MD

jobs by Indeed




Share this page

Featured Products

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

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.

Couchbase logo

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

Neo4j logo

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

Present your product here