DB-EnginesExtremeDB: the first and only COTS deterministic embedded database management system for mission- and safety-critical hard real-time applicationsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Apache Druid vs. Derby vs. Quasardb vs. TypeDB

System Properties Comparison Apache Druid vs. Derby vs. Quasardb vs. TypeDB

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameApache Druid  Xexclude from comparisonDerby infooften called Apache Derby, originally IBM Cloudscape; contained in the Java SDK as JavaDB  Xexclude from comparisonQuasardb  Xexclude from comparisonTypeDB infoformerly named Grakn  Xexclude from comparison
DescriptionOpen-source analytics data store designed for sub-second OLAP queries on high dimensionality and high cardinality dataFull-featured RDBMS with a small footprint, either embedded into a Java application or used as a database server.Distributed, high-performance timeseries databaseTypeDB is a strongly-typed database with a rich and logical type system and TypeQL as its query language
Primary database modelRelational DBMS
Time Series DBMS
Relational DBMSTime Series DBMSGraph DBMS
Relational DBMS infoOften described as a 'hyper-relational' database, since it implements the 'Entity-Relationship Paradigm' to manage complex data structures and ontologies.
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score3.44
Rank#93  Overall
#49  Relational DBMS
#6  Time Series DBMS
Score4.97
Rank#74  Overall
#41  Relational DBMS
Score0.15
Rank#297  Overall
#27  Time Series DBMS
Score0.76
Rank#198  Overall
#18  Graph DBMS
#95  Relational DBMS
Websitedruid.apache.orgdb.apache.org/­derbyquasardb.netvaticle.com
Technical documentationdruid.apache.org/­docs/­latest/­designdb.apache.org/­derby/­manuals/­index.htmldoc.quasardb.netdocs.vaticle.com
DeveloperApache Software Foundation and contributorsApache Software FoundationquasardbVaticle (formerly Grakn Labs)
Initial release2012199720092016
Current release0.22.1, December 202110.15.2.0, March 20203.1, January 20192.5, October 2021
License infoCommercial or Open SourceOpen Source infoApache license v2Open Source infoApache version 2commercial infoFree community edition, Non-profit organizations and non-commercial usage are eligible for free licensesOpen Source infoGPL Version 3, commercial licenses available
Cloud-based only infoOnly available as a cloud servicenononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaJavaC++Java
Server operating systemsLinux
OS X
Unix
All OS with a Java VMBSD
Linux
OS X
Windows
Linux
OS X
Windows
Data schemeyes infoschema-less columns are supportedyesschema-freeyes
Typing infopredefined data types such as float or dateyesyesyes infointeger and binaryyes
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.noyesnono
Secondary indexesyesyesyes infowith tagsyes
SQL infoSupport of SQLSQL for queryingyesSQL-like query languageno
APIs and other access methodsJDBC
RESTful HTTP/JSON API
JDBCHTTP APIgRPC protocol
TypeDB Console (shell)
TypeDB Studio (Visualisation software- previously TypeDB Workbase)
Supported programming languagesClojure
JavaScript
PHP
Python
R
Ruby
Scala
Java.Net
C
C#
C++
Go
Java
JavaScript (Node.js)
PHP
Python
R
All JVM based languages
Groovy
Java
JavaScript (Node.js)
Python
Scala
Server-side scripts infoStored proceduresnoJava Stored Proceduresnono
Triggersnoyesnono
Partitioning methods infoMethods for storing different data on different nodesSharding infomanual/auto, time-basednoneSharding infoconsistent hashingSharding infoby using Cassandra
Replication methods infoMethods for redundantly storing data on multiple nodesyes, via HDFS, S3 or other storage enginesSource-replica replicationSource-replica replication with selectable replication factorMulti-source replication infoby using Cassandra
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonowith Hadoop integrationyes infoby using Apache Kafka and Apache Zookeeper
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynoyesnono infosubstituted by the relationship feature
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoACIDACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyesyesyes infoby using LevelDByes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyesyes infoTransient modeno
User concepts infoAccess controlRBAC using LDAP or Druid internals for users and groups for read/write by datasource and systemfine grained access rights according to SQL-standardCryptographically strong user authentication and audit trailyes infoat REST API level; other APIs in progress
More information provided by the system vendor
Apache DruidDerby infooften called Apache Derby, originally IBM Cloudscape; contained in the Java SDK as JavaDBQuasardbTypeDB infoformerly named Grakn
Specific characteristicsHigh-performance , high-speed, fully integrated timeseries database Seamlessly combines...
» more
Meet TypeDB (and TypeQL ) TypeDB is a strongly-typed database with a rich and logical...
» more
Competitive advantagesHigh performance in a cost-effective small package Real-time results for even large...
» more
Entity-Relationship Model TypeDB allows you to model your domain using the well-known...
» more
Typical application scenariosTick database Predictive maintenance Pre-deal checks Large scale monitoring
» more
Life sciences : TypeDB makes working with biological data much easier and accelerates...
» more
Key customersLarge EU investment banks US based hedge funds Orolia Tellmeplus
» more
Market metricsHas been running in very demanding production environments since 2013 Rapid adoption...
» more
Licensing and pricing modelsCommunity edition limited to 2 nodes and 16 GiB of storage per node available for...
» more
AGPL and Commercial . The commercial license is priced based on cluster resources...
» more

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
Apache DruidDerby infooften called Apache Derby, originally IBM Cloudscape; contained in the Java SDK as JavaDBQuasardbTypeDB infoformerly named Grakn
Recent citations in the news

The Rise of a New Analytics Hero in 2022
10 January 2022, socPub

Rise of Analytics Heroes and Other Trends to Watch Out for in 2022
6 January 2022, CXOToday.com

Log4j Vulnerabilites Scanner: Where to Get Tool to Detect Serious Threat
23 December 2021, iTech Post

Imply to Debut Accreditation Program for Apache Druid® Basics, Giving Developers the Foundation for Building Modern Analytics Applications
27 October 2021, Business Wire

Why are your IT people so miserable? Log4j2itis
29 December 2021, Computerworld

provided by Google News

DB2 9.5 and the IBM Data Studio - Part 2
5 November 2007, Database Journal

Six free databases with commercial-quality features
3 December 2012, Network World

JDBC in Java: 5 facts to know before you begin
30 May 2019, TheServerSide.com

The Ultimate Open Source Database List Profiling 16 Software Tools
30 May 2019, Solutions Review

Spicing Up Your Web Services with XSLT
10 February 2009, Database Journal

provided by Google News

QuestDB gets $12M Series A funding amid growing interest in time-series databases
3 November 2021, SiliconANGLE News

Real-time analytics database startup Imply raises $70M in Series C funding
16 June 2021, SiliconANGLE News

Amazon Timestream time series database generally available
2 October 2020, TechTarget

Gartner Names Three 2020 Cool Vendors in Data Management
30 October 2020, Solutions Review

provided by Google News

Job opportunities

Software Engineer All Seniority Levels
f5, San Jose, CA

Tech Lead, Experience Data Platform
TikTok, Mountain View, CA

Data Engineer
Capgemini, Bristol, CT

Software Engineer - All levels - Data Platforms
f5, San Jose, CA

eCom Back End Engineer
PepsiCo, New York, NY

jobs by Indeed



Share this page

Featured Products

Datastax Astra logo

Build cloud-native apps fast with Astra, the open-source, multi-cloud stack for
modern data apps.
Get started with 80GB free.

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Couchbase logo

The modern database for enterprise applications. Build fast. Scale Big. Save more.
Get started today.

AllegroGraph logo

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

Present your product here