DB-EnginesInfluxDB: Focus on building software with an easy-to-use serverless, scalable time series platformEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Apache Doris vs. Apache Druid vs. Google BigQuery

System Properties Comparison Apache Doris vs. Apache Druid vs. Google BigQuery

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameApache Doris  Xexclude from comparisonApache Druid  Xexclude from comparisonGoogle BigQuery  Xexclude from comparison
DescriptionAn MPP-based analytics DBMS embracing the MySQL protocolOpen-source analytics data store designed for sub-second OLAP queries on high dimensionality and high cardinality dataLarge scale data warehouse service with append-only tables
Primary database modelRelational DBMSRelational DBMS
Time Series DBMS
Relational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.27
Rank#273  Overall
#127  Relational DBMS
Score2.94
Rank#104  Overall
#54  Relational DBMS
#6  Time Series DBMS
Score49.07
Rank#23  Overall
#15  Relational DBMS
Websitedoris.apache.org
github.com/­apache/­doris
druid.apache.orgcloud.google.com/­bigquery
Technical documentationgithub.com/­apache/­doris/­wikidruid.apache.org/­docs/­latest/­designcloud.google.com/­bigquery/­docs
DeveloperApache Software Foundation, originally contributed from BaiduApache Software Foundation and contributorsGoogle
Initial release201720122010
Current release0.14, May 20210.22.1, December 2021
License infoCommercial or Open SourceOpen Source infoApache Version 2.0Open Source infoApache license v2commercial
Cloud-based only infoOnly available as a cloud servicenonoyes
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaJava
Server operating systemsLinuxLinux
OS X
Unix
hosted
Data schemeyesyes infoschema-less columns are supportedyes
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.nonono
Secondary indexesyesyesno
SQL infoSupport of SQLyesSQL for queryingyes
APIs and other access methodsJDBC
MySQL client
JDBC
RESTful HTTP/JSON API
RESTful HTTP/JSON API
Supported programming languagesJavaClojure
JavaScript
PHP
Python
R
Ruby
Scala
.Net
Java
JavaScript
Objective-C
PHP
Python
Ruby
Server-side scripts infoStored proceduresuser defined functionsnouser defined functions infoin JavaScript
Triggersnonono
Partitioning methods infoMethods for storing different data on different nodeshorizontal partitioningSharding infomanual/auto, time-basednone
Replication methods infoMethods for redundantly storing data on multiple nodesnoneyes, via HDFS, S3 or other storage engines
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynonono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanono infoSince BigQuery is designed for querying data
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.nonono
User concepts infoAccess controlfine grained access rights according to SQL-standardRBAC using LDAP or Druid internals for users and groups for read/write by datasource and systemAccess privileges (owner, writer, reader) on dataset, table or view level infoGoogle Cloud Identity & Access Management (IAM)

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 partiesSQLFlow: Provides a visual representation of the overall flow of data. Automated SQL data lineage analysis across Databases, ETL, Business Intelligence, Cloud and Hadoop environments by parsing SQL Script and stored procedure.
» more

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

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

More resources
Apache DorisApache DruidGoogle BigQuery
DB-Engines blog posts