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

DBMS > GraphDB vs. Impala vs. Microsoft Azure SQL Database vs. mSQL

System Properties Comparison GraphDB vs. Impala vs. Microsoft Azure SQL Database vs. mSQL

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameGraphDB infoformer name: OWLIM  Xexclude from comparisonImpala  Xexclude from comparisonMicrosoft Azure SQL Database infoformerly SQL Azure  Xexclude from comparisonmSQL infoMini SQL  Xexclude from comparison
DescriptionEnterprise RDF and graph database with efficient reasoning, cluster and external index synchronization supportAnalytic DBMS for HadoopDatabase as a Service offering with high compatibility to Microsoft SQL ServermSQL (Mini SQL) is a simple and lightweight RDBMS
Primary database modelGraph DBMS
RDF store
Relational DBMSRelational DBMSRelational DBMS
Secondary database modelsDocument storeDocument store
Graph DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score1.14
Rank#137  Overall
#8  Graph DBMS
#5  RDF stores
Score16.03
Rank#36  Overall
#22  Relational DBMS
Score28.20
Rank#25  Overall
#14  Relational DBMS
Score1.48
Rank#128  Overall
#64  Relational DBMS
Websitegraphdb.ontotext.comwww.cloudera.com/­products/­open-source/­apache-hadoop/­impala.htmlazure.microsoft.com/­en-us/­services/­sql-databasewww.hughes.com.au/­products/­msql
Technical documentationgraphdb.ontotext.com/­documentationwww.cloudera.com/­documentation/­enterprise/­latest/­topics/­impala.htmldocs.microsoft.com/­en-us/­azure/­sql-database
DeveloperOntotextClouderaMicrosoftHughes Technologies
Initial release2000201320101994
Current release8.8, January 20193.3.0, August 2019V124.2, April 2019
License infoCommercial or Open Sourcecommercial infolimited edition freeOpen Source infoApache Version 2commercialcommercial infofree licenses can be provided
Cloud-based only infoOnly available as a cloud serviceno infoNamed S4, Ontotext provides a semantic graph database based on GraphDB in the cloud.noyesno
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaC++C++C
Server operating systemsAll OS with a Java VM
Linux
OS X
Windows
LinuxhostedAIX
HP-UX
Linux
OS X
Solaris SPARC/x86
Windows
Data schemeschema-free and OWL/RDFS-schema supportyesyesyes
Typing infopredefined data types such as float or dateyesyesyesyes
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.nonoyesno
Secondary indexesyes, supports real-time synchronization and indexing in SOLR/Elastic search/Lucene and GeoSPARQL geometry data indexesyesyesyes
SQL infoSupport of SQLSPARQL is used as query languageSQL-like DML and DDL statementsyesA subset of ANSI SQL is implemented infono subqueries, aggregate functions, views, foreign keys, triggers
APIs and other access methodsGeoSPARQL
Java API
RDF4J API
RIO
Sail API
Sesame REST HTTP Protocol
SPARQL 1.1
JDBC
ODBC
ADO.NET
JDBC
ODBC
JDBC
ODBC
Supported programming languages.Net
C#
Clojure
Java
JavaScript (Node.js)
PHP
Python
Ruby
Scala
All languages supporting JDBC/ODBC.Net
C#
Java
JavaScript (Node.js)
PHP
Python
Ruby
C
C++
Delphi
Java
Perl
PHP
Tcl
Server-side scripts infoStored proceduresJava Server Pluginyes infouser defined functions and integration of map-reduceTransact SQLno
Triggersnonoyesno
Partitioning methods infoMethods for storing different data on different nodesnoneShardingnone
Replication methods infoMethods for redundantly storing data on multiple nodesMaster-master replicationselectable replication factoryes, with always 3 replicas availablenone
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyes infoquery execution via MapReducenono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate Consistency, Eventual consistency (configurable in cluster mode per master or individual client request)Eventual ConsistencyImmediate Consistencynone
Foreign keys infoReferential integrityyes infoConstraint checkingnoyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDnoACIDno
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.nono
User concepts infoAccess controlyesAccess rights for users, groups and roles infobased on Apache Sentry and Kerberosfine grained access rights according to SQL-standardno
More information provided by the system vendor
GraphDB infoformer name: OWLIMImpalaMicrosoft Azure SQL Database infoformerly SQL AzuremSQL infoMini SQL
Specific characteristicsGraphDB Enterprise is a high-performance semantic repository created by Ontotext....
» more
Competitive advantagesGraphDB allows you to link text and data in big knowledge graphs. It’s easy to experiment...
» more
Typical application scenariosMetadata enrichment and management, linked open data publishing, semantic inferencing...
» more
Key customersBBC, Press Association, Financial Times, DK, Euromoney, The British Museum, Getty...
» more
Market metricsGraphDB is the most utilized semantic triplestore for mission-critical enterprise...
» more
Licensing and pricing modelsGraphDB-Free is free to use. SE and Enterprise are licensed per CPU-Core used. Perpetual...
» more
News

Ontotext’s Graph Database Helps Create EU-Wide Company Business Graph
23 January 2020

A Graphful of Investment Opportunities
10 January 2020

Ontotext’s Most Popular Blog Posts for 2019
30 December 2019

A New Hope: The Rise of the Knowledge Graph
6 December 2019

The New Improved and Open GraphDB
7 November 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

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

More resources
GraphDB infoformer name: OWLIMImpalaMicrosoft Azure SQL Database infoformerly SQL AzuremSQL 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

Conferences and events

Designing Semantic Technology Proof-of-Concept
Online Training, 13:00 – 18:00 UTC, 12 December 2019 (finished)

Ontotext Platform – the Fast Track from an RDF Model to a Knowledge Graph
Online Training, 4pm GMT, 17 December 2019 (finished)

Recent citations in the news

It's just semantics: Bulgarian software dev Ontotext squeezes out GraphDB 9.1
15 January 2020, The Register

GraphDB Goes Open Source
27 January 2020, iProgrammer

GraphDB 9.1 - the Database to Support High-quality Knowledge Graphs
13 January 2020, PRNewswire

Ontotext GraphDB Named Innovator in Bloor's Graph Database Market Research
11 February 2019, PRNewswire

Ontotext's GraphDB 8.10 Makes Knowledge Graph Experience Faster and Richer
13 June 2019, Yahoo Finance

provided by Google News

Significance of Developing Analytics Capabilities to Gain Competitive Edge
29 January 2020, Analytics Insight

Cloudera says Impala is faster than Hive, which isn't saying much
13 January 2014, GigaOM

Cloudera's a data warehouse player now
28 August 2018, ZDNet

Cloudera Boosts Hadoop App Development On Impala
10 November 2014, InformationWeek

Cloudera’s Impala brings Hadoop to SQL and BI
25 October 2012, ZDNet

provided by Google News

Deployment options for Azure SQL Database | Data Exposed - Microsoft
9 January 2020, Channel 9

Running Database Console Commands (DBCCs) on Azure SQL Database
20 January 2020, Database Journal

Overview of Azure SQL Database Serverless
30 December 2019, Database Journal

It's just SQL: Collations in Azure SQL Database Managed Instance - Microsoft
2 January 2020, Channel 9

SentryOne Invests in Channel Presence in the US and EMEA
28 January 2020, Yahoo Finance

provided by Google News

A Memorial to the Grandfather of Headphone Enthusiasm
15 March 2016, InnerFidelity

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

Writing a Web Service in Perl
13 July 2018, PCQuest

provided by Google News

Job opportunities

Cloud Admin
Avani Technology Solutions Inc, Orange, CA

Lead
Brillio, Santa Clara, CA

Principal Database Engineer
Surescripts, LLC, Minneapolis, MN

Architect, GeForce NOW - Cloud
NVIDIA, Santa Clara, CA

Principal Architect - Data
Scripps Health, San Diego, CA

SQL Server Database Administrator
City of Philadelphia, Philadelphia, PA

Senior Database Engineer (Azure/SQL)
MasterCard, Arlington, VA

SQL Database Administrator
Plante Moran, Southfield, MI

Database Administrator, 3
Sutter Health, Mather, CA

Database Architect
International SOS, Trevose, PA

Senior Analyst, IT - Commercial, Revenue Management
Hawaiian Airlines, Honolulu, HI

jobs by Indeed




Share this page

Featured Products

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.

Neo4j logo

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

RavenDB logo

Setup a fully managed RavenDB Cloud Database in minutes. Enjoy hosting, management, backups all in one place.
Grab a Free Instance

MariaDB logo

How do MariaDB, Oracle MySQL and EnterpriseDB compare?
Get the white paper to
learn more.

Present your product here