DBMS > Apache Phoenix vs. Blazegraph vs. Microsoft Azure Cosmos DB vs. Oracle vs. PostgreSQL

System Properties Comparison Apache Phoenix vs. Blazegraph vs. Microsoft Azure Cosmos DB vs. Oracle vs. PostgreSQL

Editorial information provided by DB-Engines

Name

Amazon has acquired Blazegraph's domain and (probably) product. It is said that Amazon Neptune is based on Blazegraph.

Description

A scale-out RDBMS with evolutionary schema built on Apache HBase

High-performance graph database supporting Semantic Web (RDF/SPARQL) and Graph Database (tinkerpop3, blueprints, vertex-centric) APIs with scale-out and High Availability.

Globally distributed, horizontally scalable, multi-model database service

Widely used RDBMS

Widely used open source RDBMS

Developed as objectoriented DBMS (Postgres), gradually enhanced with 'standards' like SQL

Primary database model

Relational DBMS

Graph DBMS
RDF store

Document store
Graph DBMS
Key-value store
Wide column store

Relational DBMS

with object oriented extensions, e.g.: user defined types/functions and inheritance. Handling of key/value pairs with hstore module.

Secondary database models

Spatial DBMS

Document store
Graph DBMS

with Oracle Spatial and Graph
RDF store

with Oracle Spatial and Graph
Spatial DBMS

with Oracle Spatial and Graph
Vector DBMS

since Oracle 23

Document store
Graph DBMS

with Apache Age
Spatial DBMS
Vector DBMS

with pgvector extension

DB-Engines Ranking measures the popularity of database management systems
Trend Chart

Score	2.06
Rank	#123	Overall
	#58	Relational DBMS

Score	0.81
Rank	#213	Overall
	#19	Graph DBMS
	#8	RDF stores

Score	27.71
Rank	#27	Overall
	#4	Document stores
	#2	Graph DBMS
	#3	Key-value stores
	#3	Wide column stores

Score	1244.08
Rank	#1	Overall
	#1	Relational DBMS

Score	636.25
Rank	#4	Overall
	#4	Relational DBMS

Website

phoenix.apache.org

blazegraph.com

azure.microsoft.com/services/cosmos-db

www.oracle.com/database

www.postgresql.org

Technical documentation

phoenix.apache.org

wiki.blazegraph.com

learn.microsoft.com/azure/cosmos-db

docs.oracle.com/en/database

www.postgresql.org/docs

Developer

Apache Software Foundation

Blazegraph

Microsoft

Oracle

PostgreSQL Global Development Group

www.postgresql.org/developer

Initial release

2014

2006

2014

1980

1989

1989: Postgres, 1996: PostgreSQL

Current release

5.0-HBase2, July 2018 and 4.15-HBase1, December 2019

2.1.5, March 2019

23c, September 2023

16.3, May 2024

License

Commercial or Open Source

Open Source

Apache Version 2.0

Open Source

extended commercial license available

commercial

restricted free version is available

Open Source

BSD

Cloud-based only

Only available as a cloud service

yes

DBaaS offerings (sponsored links)

Database as a Service

Providers of DBaaS offerings, please contact us to be listed.

PostgreSQL Flex @ STACKIT offers managed PostgreSQL Instances with adjustable CPU, RAM, storage amount and speed and several extensions available, in enterprise grade to perfectly match all application requirements. All 100% GDPR-compliant.
Aiven for PostgreSQL: Fully managed PostgreSQL for developers with 70+ extensions and flexible orchestration tools.

Implementation language

Java

C and C++

Server operating systems

Linux
Unix
Windows

Linux
OS X
Windows

hosted

AIX
HP-UX
Linux
OS X
Solaris
Windows
z/OS

FreeBSD
HP-UX
Linux
NetBSD
OpenBSD
OS X
Solaris
Unix
Windows

Data scheme

yes

late-bound, schema-on-read capabilities

schema-free

yes

Schemaless in JSON and XML columns

yes

Typing

predefined data types such as float or date

yes

RDF literal types

yes

JSON types

yes

XML support

Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.

yes

specific XML-type available, but no XML query functionality.

Secondary indexes

yes

All properties auto-indexed by default

yes

SQL

Support of SQL

yes

SPARQL is used as query language

SQL-like query language

yes

with proprietary extensions

yes

standard with numerous extensions

APIs and other access methods

JDBC

Java API
RESTful HTTP API
SPARQL QUERY
SPARQL UPDATE
TinkerPop 3

DocumentDB API
Graph API (Gremlin)
MongoDB API
RESTful HTTP API
Table API

JDBC
ODBC
ODP.NET
Oracle Call Interface (OCI)

ADO.NET
JDBC
native C library
ODBC
streaming API for large objects

Supported programming languages

C
C#
C++
Go
Groovy
Java
PHP
Python
Scala

.Net
C
C++
Java
JavaScript
PHP
Python
Ruby

.Net
C#
Java
JavaScript
JavaScript (Node.js)
MongoDB client drivers written for various programming languages
Python

C
C#
C++
Clojure
Cobol
Delphi
Eiffel
Erlang
Fortran
Groovy
Haskell
Java
JavaScript
Lisp
Objective C
OCaml
Perl
PHP
Python
R
Ruby
Scala
Tcl
Visual Basic

.Net
C
C++
Delphi
Java

JDBC
JavaScript (Node.js)
Perl
PHP
Python
Tcl

Server-side scripts

Stored procedures

user defined functions

yes

JavaScript

PL/SQL

also stored procedures in Java possible

user defined functions

realized in proprietary language PL/pgSQL or with common languages like Perl, Python, Tcl etc.

Triggers

JavaScript

yes

Partitioning methods

Methods for storing different data on different nodes

Sharding

Implicit feature of the cloud service

Sharding, horizontal partitioning

partitioning by range, list and (since PostgreSQL 11) by hash

Replication methods

Methods for redundantly storing data on multiple nodes

Multi-source replication
Source-replica replication

yes

Implicit feature of the cloud service

Multi-source replication
Source-replica replication

Source-replica replication

other methods possible by using 3rd party extensions

MapReduce

Offers an API for user-defined Map/Reduce methods

Hadoop integration

with Hadoop integration

Integration with Hadoop/HDInsight on Azure*

can be realized in PL/SQL

Consistency concepts

Methods to ensure consistency in a distributed system

Immediate Consistency or Eventual Consistency

Immediate Consistency or Eventual Consistency depending on configuration

Bounded Staleness
Consistent Prefix
Eventual Consistency
Immediate Consistency

Consistency level configurable on request level
Session Consistency

Immediate Consistency

Foreign keys

Referential integrity

yes

Relationships in Graphs

yes

Transaction concepts

Support to ensure data integrity after non-atomic manipulations of data

ACID

Multi-item ACID transactions with snapshot isolation within a partition

ACID

isolation level can be parameterized

ACID

Concurrency

Support for concurrent manipulation of data

yes

Durability

Support for making data persistent

yes

In-memory capabilities

Is there an option to define some or all structures to be held in-memory only.

yes

Version 12c introduced the new option 'Oracle Database In-Memory'

User concepts

Access control

Access Control Lists (using HBase ACL) for RBAC, integration with Apache Ranger for RBAC & ABAC, multi-tenancy

Security and Authentication via Web Application Container (Tomcat, Jetty)

Access rights can be defined down to the item level

fine grained access rights according to SQL-standard

More information provided by the system vendor

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 parties

CData: Connect to Big Data & NoSQL through standard Drivers.
» more

Devart ODBC driver for Oracle accesses Oracle databases from ODBC-compliant reporting, analytics, BI, and ETL tools on both 32 and 64-bit Windows, macOS, and Linux.
» more

Navicat for Oracle improves the efficiency and productivity of Oracle developers and administrators with a streamlined working environment.
» more

Navicat Monitor is a safe, simple and agentless remote server monitoring tool for PostgreSQL and many other database management systems.
» more

Timescale: Calling all PostgreSQL users – the 2023 State of PostgreSQL survey is now open! Share your favorite extensions, preferred frameworks, community experiences, and more. Take the survey today!
» more

SharePlex is the reliable and affordable data replication solution for PostgreSQL migrations, high availability and more.
» more

pgDash: In-Depth PostgreSQL Monitoring.
» more

Aiven for PostgreSQL: Fully managed PostgreSQL for developers with 70+ extensions and flexible orchestration tools.
» more

Redgate webinars: A series of key topics for new PostgreSQL users.
» more

Instaclustr: Fully Hosted & Managed PostgreSQL
» more

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

CYBERTEC is your professional partner in PostgreSQL topics for over 20 years. As our main aim is to be your single-source all-in-one IT service provider, we offer a wide range of products and services. Visit our website for more details.
» more

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

More resources

DB-Engines blog posts

Cloudera's HBase PaaS offering now supports Complex Transactions
11 August 2021, Krishna Maheshwari (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

Architecting eCommerce Platforms for Zero Downtime on Black Friday and Beyond
25 November 2016, Tony Branson (guest author)

show all

PostgreSQL is the DBMS of the Year 2023
2 January 2024, Matthias Gelbmann, Paul Andlinger

Snowflake is the DBMS of the Year 2022, defending the title from last year
3 January 2023, Matthias Gelbmann, Paul Andlinger

Snowflake is the DBMS of the Year 2021
3 January 2022, Paul Andlinger, Matthias Gelbmann

show all

Conferences, events and webinars

more DBMS events

Oracle Cloud World
Las Vegas, 9-12 September 2024

Recent citations in the news

Supercharge SQL on Your Data in Apache HBase with Apache Phoenix | Amazon Web Services
2 June 2016, AWS Blog

Azure #HDInsight Apache Phoenix now supports Zeppelin
16 August 2018, Microsoft

Bridge the SQL-NoSQL gap with Apache Phoenix
4 February 2016, InfoWorld

Apache Calcite, FreeMarker, Gora, Phoenix, and Solr updated
27 March 2017, SDTimes.com

Azure HDInsight Analytics Platform Now Supports Apache Hadoop 3.0
18 April 2019, eWeek

provided by Google News

Back to the future: Does graph database success hang on query language?
5 March 2018, ZDNet

Video: Blazegraph Accelerates Graph Computing with GPUs - High-Performance Computing News Analysis
20 December 2015, insideHPC

Harnessing GPUs Delivers a Big Speedup for Graph Analytics
15 December 2015, Datanami

This AI Paper Introduces A Comprehensive RDF Dataset With Over 26 Billion Triples Covering Scholarly Data Across All Scientific Disciplines
19 August 2023, MarkTechPost

Representation Learning on RDF* and LPG Knowledge Graphs
24 September 2020, Towards Data Science

provided by Google News

Start your AI journey with Microsoft Azure Cosmos DB—compete for $10K
9 May 2024, Microsoft

Public Preview: DiskANN vector indexing and search in Azure Cosmos DB NoSQL | Azure updates
21 May 2024, Microsoft

Public preview: Change partition key of a container in Azure Cosmos DB (NoSQL API) | Azure updates
27 March 2024, Microsoft

Building Planet-Scale .NET Apps with Azure Cosmos DB
4 June 2024, Visual Studio Magazine

Public Preview: vCore-based Azure Cosmos DB for MongoDB cross-region disaster recovery (DR) | Azure updates
21 May 2024, Microsoft

provided by Google News

Oracle And Google Partner To Deliver Multicloud Offering To Enterprises
13 June 2024, Forbes

Oracle to colocate database services and network interconnect in Google data centers
12 June 2024, DatacenterDynamics

Oracle and Google Cloud Announce a Groundbreaking Multicloud Partnership
11 June 2024, PR Newswire

Panasonic Information Systems Selects Oracle Cloud Infrastructure to Drive Modernization of Internal Systems Across ...
13 June 2024, PR Newswire

Announcing Oracle Database 23ai : General Availability
2 May 2024, Oracle

provided by Google News

PostgreSQL is Now Faster than Pinecone, 75% Cheaper, with New Open Source Extensions
11 June 2024, PR Newswire

Timescale unveils high-performance AI vector database extensions for PostgreSQL
11 June 2024, SiliconANGLE News

PostgreSQL Tutorial: Definition, Commands, & Features
4 June 2024, Simplilearn

Raise the bar on AI-powered app development with Azure Database for PostgreSQL
5 June 2024, Microsoft

How to implement a better like, views, comment counters in PostgreSQL?
28 May 2024, SitePoint

provided by Google News

Share this page