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

DBMS > Amazon Redshift vs. Blazegraph vs. FoundationDB vs. MonetDB vs. PostgreSQL

System Properties Comparison Amazon Redshift vs. Blazegraph vs. FoundationDB vs. MonetDB vs. PostgreSQL

Editorial information provided by DB-Engines
NameAmazon Redshift  Xexclude from comparisonBlazegraph  Xexclude from comparisonFoundationDB  Xexclude from comparisonMonetDB  Xexclude from comparisonPostgreSQL  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.A relational database management system that stores data in columnsWidely used open source RDBMS infoDeveloped as objectoriented DBMS (Postgres), gradually enhanced with 'standards' like SQL
Primary database modelRelational DBMSGraph DBMS
RDF store
Document store infosupported via specific layer
Key-value store
Relational DBMS infosupported via specific SQL-layer
Relational DBMSRelational DBMS infowith object oriented extensions, e.g.: user defined types/functions and inheritance. Handling of key/value pairs with hstore module.
Secondary database modelsDocument storeDocument store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score21.24
Rank#29  Overall
#17  Relational DBMS
Score0.67
Rank#189  Overall
#15  Graph DBMS
#8  RDF stores
Score0.91
Rank#160  Overall
#24  Document stores
#29  Key-value stores
#78  Relational DBMS
Score1.77
Rank#123  Overall
#61  Relational DBMS
Score522.99
Rank#4  Overall
#4  Relational DBMS
Websiteaws.amazon.com/­redshiftblazegraph.comwww.foundationdb.orgwww.monetdb.orgwww.postgresql.org
Technical documentationdocs.aws.amazon.com/­redshiftwiki.blazegraph.comapple.github.io/­foundationdbwww.monetdb.org/­Documentationwww.postgresql.org/­docs/­manuals
DeveloperAmazon (based on PostgreSQL)BlazegraphFoundationDBMonetDB BVPostgreSQL Global Development Group infowww.postgresql.org/­developer
Initial release20122006201320041989 info1989: Postgres, 1996: PostgreSQL
Current release2.1.5, March 20196.2.11, November 2019Nov2019-SP1, December 201912.3, May 2020
License infoCommercial or Open SourcecommercialOpen Source infoextended commercial license availableOpen Source infoApache 2.0Open Source infoMozilla Public License 2.0Open Source infoBSD
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.
  • Azure Database for PostgreSQL: A fully managed, scalable PostgreSQL relational database with high availability and security built in at no extra cost
  • ScaleGrid: Fully managed PostgreSQL hosting with high availability, dedicated servers, and superuser control on the #1 multi-cloud Amazon RDS alternative.
Implementation languageCJavaC++CC
Server operating systemshostedLinux
OS X
Windows
Linux
OS X
Windows
FreeBSD
Linux
OS X
Solaris
Windows
FreeBSD
HP-UX
Linux
NetBSD
OpenBSD
OS X
Solaris
Unix
Windows
Data schemeyesschema-freeschema-free infosome layers support schemasyesyes
Typing infopredefined data types such as float or dateyesyes infoRDF literal typesno infosome layers support typingyesyes
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.noyes infospecific XML-type available, but no XML query functionality.
Secondary indexesrestrictedyesnoyesyes
SQL infoSupport of SQLyes infodoes not fully support an SQL-standardSPARQL is used as query languagesupported in specific SQL layer onlyyes infoSQL 2003 with some extensionsyes infostandard with numerous extensions
APIs and other access methodsJDBC
ODBC
Java API
RESTful HTTP API
SPARQL QUERY
SPARQL UPDATE
TinkerPop 3
JDBC
native C library infoMAPI library (MonetDB application programming interface)
ODBC
ADO.NET
JDBC
native C library
ODBC
streaming API for large objects
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++
Java
JavaScript (Node.js)
Perl
PHP
Python
R
Ruby
.Net
C
C++
Delphi
Java infoJDBC
JavaScript (Node.js)
Perl
PHP
Python
Tcl
Server-side scripts infoStored proceduresuser defined functions infoin Pythonyesin SQL-layer onlyyes, in SQL, C, Ruser defined functions inforealized in proprietary language PL/pgSQL or with common languages like Perl, Python, Tcl etc.
Triggersnononoyesyes
Partitioning methods infoMethods for storing different data on different nodesShardingShardingShardingSharding via remote tablespartitioning by range, list and (since PostgreSQL 11) by hash
Replication methods infoMethods for redundantly storing data on multiple nodesyesyesyesnone infoMaster-slave replication available in experimental statusMaster-slave replication infoother methods possible by using 3rd party extensions
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonononono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate Consistency or Eventual Consistency depending on configurationLinearizable consistencyImmediate Consistency
Foreign keys infoReferential integrityyes infoinformational only, not enforced by the systemyes infoRelationships in Graphsin SQL-layer onlyyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACIDACIDACIDACID
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.yesno
User concepts infoAccess controlfine grained access rights according to SQL-standardSecurity and Authentication via Web Application Container (Tomcat, Jetty)nofine grained access rights according to SQL-standardfine grained access rights according to SQL-standard
More information provided by the system vendor
Amazon RedshiftBlazegraphFoundationDBMonetDBPostgreSQL
Specific characteristicsColumn-store In-memory optimized GeoSpatial support JSON document support
» more
Competitive advantagesScalable architecture - vertical data organization and in-memory optimization guarantee...
» more
Typical application scenariosAnalytical database, Data warehouse, OLAP Data mining Scientific database
» more
Key customersNumascale , Spinque , SecurActive , CHS , NOZHUP
» more
Licensing and pricing modelsFree and open-source software, Mozilla Public License 2.0 Commercial support available
» more
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

Optimistic Concurrency Control in MonetDB
3 January 2020

Limit memory usage of MonetDB on Linux with CGROUPS
9 May 2019

SQL:2003 merge statements now supported in MonetDB
8 March 2019

Extended SQL:2011 Window Functions in MonetDB
26 February 2019

Updatable MERGE TABLEs with partition predicates
26 February 2019

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
Azure Database for PostgreSQL provides fully managed, enterprise-ready community PostgreSQL database as a service
» more

SQLPro for PostgreSQL: A simple but powerful PostgreSQL database client available on iPhone and iPad as well as macOS.
» more

2ndQuadrant: Mission Critical Databases.
» more

pgDash: In-Depth PostgreSQL Monitoring.
» more

Navicat for PostgreSQL is an easy-to-use graphical tool for PostgreSQL database development.
» more

General SQL Parser: Instantly adding parsing, decoding, analysis and rewrite SQL processing capability to your products.
» more

CYBERTEC: your professional partner for PostgreSQL services and Data Science based on PostgreSQL since 2000. With offices in Austria, Uruguay, Estonia and Switzerland, CYBERTEC operates worldwide!
» more

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

More resources
Amazon RedshiftBlazegraphFoundationDBMonetDBPostgreSQL
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

PostgreSQL is the DBMS of the Year 2018
2 January 2019, Paul Andlinger, Matthias Gelbmann

PostgreSQL is the DBMS of the Year 2017
2 January 2018, Paul Andlinger, Matthias Gelbmann

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

show all

Conferences and events

PostgreSQL Online Trainings
Online Training Courses, 4 May 2020 - 11 December 2020

Recent citations in the news

AWS Overhauls Redshift, Amid Latency Complaints
4 June 2020, Computer Business Review

Migrating your Netezza data warehouse to Amazon Redshift
28 May 2020, idk.dev

Monitor and optimize queries on the new Amazon Redshift console
8 May 2020, idk.dev

Monitor and control the storage space of a schema with quotas with Amazon Redshift
3 June 2020, idk.dev

Slack’s new integration deal with AWS could also be about tweaking Microsoft
5 June 2020, TechCrunch

provided by Google News

GPU Database Market Opportunity Analysis and Industry Forecast 2028 | Kinetica, OmniSci,SQream , Neo4j ,...
4 June 2020, Azizsalon News

Rising Opportunities in GPU Database Market | • Neo4j • Anaconda • NVIDIA • Blazegraph • OmniSci
29 May 2020, Cole of Duty

GPU Database Market 2027| Neo4j • Anaconda • NVIDIA • Blazegraph • OmniSci • Fuzzy Logix • BlazingDB • SQream
31 May 2020, Cole of Duty

Global Graph Database Market interpreted by a new report
5 June 2020, WhaTech Technology and Markets News

GPU Database Market Size, Analysis, Top Key Vendors, Industry Growth, Opportunity and Forecast By 2027
2 June 2020, 3rd Watch News

provided by Google News

FoundationDB, a very interesting NoSQL database owned by Apple, is now an open-source project
19 April 2018, GeekWire

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

FoundationDB opens Apple's database sauce • DEVCLASS
15 January 2019, DevClass

provided by Google News

MonetDB Solutions secures investment from ServiceNow — CWI Amsterdam
1 October 2019, Centrum Wiskunde & Informatica (CWI)

Stefan Manegold wins 2020 SIGMOD Contributions Award — CWI Amsterdam
29 May 2020, Centrum Wiskunde & Informatica (CWI)

RDBMS Software Market 2020 Global analysis, opportunities and forecast to 2026 | By Top Leading Vendors like Microsoft, Oracle, PostgreSQL Global Development Group, SQLite, IBM, SolarWinds IT Operations Management, Cubrid, TmaxSoft, CA Technologies, ThinkSQL, FrontBase, MonetDB, VoltDB, and More?
4 June 2020, Jewish Life News

CWI's 25th spin-off develops software of the future
18 May 2020, Centrum Wiskunde & Informatica (CWI)

RDBMS Software Market 2020: Qualitative Analysis of the Leading Players and Competitive Industry Scenario
12 May 2020, Cole of Duty

provided by Google News

PostgreSQL: Businesses choose open source for digital transformation
12 May 2020, TechHQ

Common administrator responsibilities on Amazon RDS and Amazon Aurora for PostgreSQL databases
18 May 2020, idk.dev

Best practices for Amazon RDS for PostgreSQL cross-Region read replicas
26 May 2020, idk.dev

Multi-tenant data isolation with PostgreSQL Row Level Security
18 May 2020, idk.dev

Migrating PostgreSQL from on-premises or Amazon EC2 to Amazon RDS using logical replication
27 May 2020, idk.dev

provided by Google News

Job opportunities

Oracle Database Administrator
Akshaya Inc, Mountain View, CA

Manager, Software Development - Redshift
Amazon.com Services LLC, Seattle, WA

AWS Database Services SDE, Amazon Redshift
Amazon.com Services LLC, Seattle, WA

Business Intelligence Analyst
Kochava, Sandpoint, ID

Data Scientist
Kochava, Sandpoint, ID

Semantic Java Developer - Scientific Computing
Mount Sinai, New York, NY

Software Engineer - SecDB Architecture
Goldman Sachs, New York, NY

Software Engineer - Platform Integration
ANDURIL INDUSTRIES, Irvine, CA

Data Scientist
Lucas Systems, Inc., Wexford, PA

Data Scientist
Lucas Systems, Wexford, PA

Senior Software Engineer - Streaming
Epic Games, Bellevue, WA

Data Scientist
Cerebri AI, Austin, TX

Director, Quality Engineering - Performance
ServiceNow, San Diego, CA

Staff Quality Engineer
ServiceNow, San Diego, CA

Staff Quality Engineer
ServiceNow, Santa Clara, CA

PostgreSQL DBA
Remote, Warrendale, PA

Remote Full Stack Software Engineer - Rails/Elixir
One Click Contractors, Carmel, IN

Associate Analyst
Change.org, San Francisco, CA

Data Technician (Full- or Part-Time)
Thasos Group, New York, NY

GIS Technician
City of Casa Grande, Casa Grande, AZ

jobs by Indeed




Share this page

Featured Products

AllegroGraph logo

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

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.

Datastax Luna logo

Simple, subscription-based support for open source
Apache Cassandra™ from the Cassandra experts.
Learn more.

Couchbase logo

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

Present your product here