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

DBMS > Druid vs. Oracle vs. Postgres-XL

System Properties Comparison Druid vs. Oracle vs. Postgres-XL

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameDruid  Xexclude from comparisonOracle  Xexclude from comparisonPostgres-XL  Xexclude from comparison
DescriptionOpen-source analytics data store designed for OLAP queries on timeseries dataWidely used RDBMSBased on PostgreSQL enhanced with MPP and write-scale-out cluster features
Primary database modelRelational DBMS
Time Series DBMS
Relational DBMSRelational DBMS
Secondary database modelsDocument store
Graph DBMS infowith Oracle Spatial and Graph
RDF store infowith Oracle Spatial and Graph
Document store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score1.79
Rank#117  Overall
#58  Relational DBMS
#7  Time Series DBMS
Score1336.07
Rank#1  Overall
#1  Relational DBMS
Score0.42
Rank#217  Overall
#103  Relational DBMS
Websitedruid.iowww.oracle.com/­databasewww.postgres-xl.org
Technical documentationdruid.io/­docs/­latest/­design/­index.htmldocs.oracle.com/­en/­databasewww.postgres-xl.org/­documentation
DeveloperMetamarkets Group and contributorsOracle
Initial release201219802014 infosince 2012, originally named StormDB
Current release19c, February 201910 R1, October 2018
License infoCommercial or Open SourceOpen Source infoApache license v2commercial inforestricted free version is availableOpen Source infoMozilla public license
Cloud-based only infoOnly available as a cloud servicenonono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaC and C++C
Server operating systemsLinux
OS X
Unix
AIX
HP-UX
Linux
OS X
Solaris
Windows
z/OS
Linux
macOS
Data schemeyes infoschema-less columns are supportedyes infoSchemaless in JSON and XML columnsyes
Typing infopredefined data types such as float or dateyesyesyes
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.noyesyes infoXML type, but no XML query functionality
Secondary indexesyesyesyes
SQL infoSupport of SQLSQL support via Apache Calcite adapteryes infowith proprietary extensionsyes infodistributed, parallel query execution
APIs and other access methodsJSON over HTTPJDBC
ODBC
ODP.NET
Oracle Call Interface (OCI)
ADO.NET
JDBC
native C library
ODBC
streaming API for large objects
Supported programming languagesClojure
JavaScript
PHP
Python
R
Ruby
Scala
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
Erlang
Java
JavaScript (Node.js)
Perl
PHP
Python
Tcl
Server-side scripts infoStored proceduresnoPL/SQL infoalso stored procedures in Java possibleuser defined functions
Triggersnoyesyes
Partitioning methods infoMethods for storing different data on different nodesShardinghorizontal partitioning infowith the optional Oracle Partitioninghorizontal partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesyes, via HDFS, S3 or other storage enginesMaster-master replication
Master-slave replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnono infocan be realized in PL/SQLno
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynoyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoACID infoisolation level can be parameterizedACID infoMVCC
Concurrency infoSupport for concurrent manipulation of datayesyesyes
Durability infoSupport for making data persistentyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyes infoVersion 12c introduced the new option 'Oracle Database In-Memory'no
User concepts infoAccess controlno infoavailable via extensionsfine grained access rights according to SQL-standardfine grained access rights according to SQL-standard
More information provided by the system vendor
DruidOraclePostgres-XL
Specific characteristicsOracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is a multi-model...
» more
Licensing and pricing modelsOracle Database Cloud Services Customers can choose from a wide range of database...
» 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
3rd partiesDBHawk: a web-based Oracle database management and self-service BI software.
» more

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

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

Dremio is like magic for Oracle accelerating your analytical queries up to 1,000x.
» more

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

More resources
DruidOraclePostgres-XL
DB-Engines blog posts

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)

MySQL, PostgreSQL and Redis are the winners of the March ranking
2 March 2016, Paul Andlinger

show all

Recent citations in the news

What's Behind Lyft's Choices in Big Data Tech
10 May 2019, Datanami

Imply launches with $2M to commercialize the Druid open-source data store
19 October 2015, VentureBeat

Hadoop Creator Yahoo Finds It's Not Enough, Turns to Druid
30 July 2015, ADT Magazine

Yahoo Casts Real-Time OLAP Queries with Druid
4 August 2015, Datanami

Azure HDInsight Brings Next Generation Hadoop 3.0 and Enterprise Security to the Cloud
24 September 2018, HPCwire

provided by Google News

What A Free Oracle Database Means To These 4 Developers
28 October 2019, Forbes

Software’s Accelerating Data Needs May Benefit From Intel’s High-Optane Push
12 November 2019, Forbes

Amazon kisses last Oracle database goodbye, completes years-long migration
15 October 2019, CIO Dive

Rimini Street Announces Global Availability of Application Management Services for Oracle Database and Applications
8 November 2019, MarTech Series

What A Free Oracle Database Means To These Four Developers
31 October 2019, Techwire.net

provided by Google News

Building a scalable PostgreSQL solution
14 April 2019, Packt Hub

Interview with Frank Huerta and Mason Sharp on PostGres-XL
13 May 2014, opensource.com

When PostgreSQL Doesn't Scale Well Enough
18 April 2016, DZone News

PostgreSQL vs. Hadoop
20 August 2016, DZone News

provided by Google News

Job opportunities

Sr. Systems Analyst
UST Global, San Jose, CA

Senior Big Data Engineer
Experian, Costa Mesa, CA

Hyperion Planning Consultant / Architect
Decision Support Technology, Connecticut

Hyperion HFM Consultant / Architect - HFM (Hyperion Financial Management)
Decision Support Technology, Connecticut

Oracle Essbase Consultant / Architect
Decision Support Technology, Connecticut

Hyperion FDM / FQDM Consultant / Architect - FDM (Financial Data Management)
Decision Support Technology, Connecticut

Sr Database Administrator
United Biosource Corporation, Overland Park, KS

jobs by Indeed




Share this page

Featured Products

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.


Datastax logo

Build data-driven applications that set the standard for performance, availability,
& scale with DataStax.
Learn more.

Redis logo

Hosted, serverless DBaaS
in 3 steps.

30MB Free!
Start now.

RavenDB logo

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

Present your product here