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 Impala vs. Cloudflare Workers KV vs. SQLite vs. Stardog

System Properties Comparison Apache Doris vs. Apache Impala vs. Cloudflare Workers KV vs. SQLite vs. Stardog

Editorial information provided by DB-Engines
NameApache Doris  Xexclude from comparisonApache Impala  Xexclude from comparisonCloudflare Workers KV  Xexclude from comparisonSQLite  Xexclude from comparisonStardog  Xexclude from comparison
DescriptionAn MPP-based analytics DBMS embracing the MySQL protocolAnalytic DBMS for HadoopA global, low-latency, key-value store for applications on Cloudflare with exceptionally high read volumes and low-latency.Widely used embeddable, in-process RDBMSEnterprise Knowledge Graph platform and graph DBMS with high availability, high performance reasoning, and virtualization
Primary database modelRelational DBMSRelational DBMSKey-value storeRelational DBMSGraph DBMS
RDF store
Secondary database modelsDocument store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.57
Rank#244  Overall
#113  Relational DBMS
Score13.77
Rank#40  Overall
#24  Relational DBMS
Score0.32
Rank#283  Overall
#40  Key-value stores
Score114.32
Rank#10  Overall
#7  Relational DBMS
Score2.02
Rank#123  Overall
#11  Graph DBMS
#6  RDF stores
Websitedoris.apache.org
github.com/­apache/­doris
impala.apache.orgwww.cloudflare.com/­developer-platform/­workers-kvwww.sqlite.orgwww.stardog.com
Technical documentationgithub.com/­apache/­doris/­wikiimpala.apache.org/­impala-docs.htmldevelopers.cloudflare.com/­kv/­apiwww.sqlite.org/­docs.htmldocs.stardog.com
DeveloperApache Software Foundation, originally contributed from BaiduApache Software Foundation infoApache top-level project, originally developed by ClouderaCloudflareDwayne Richard HippStardog-Union
Initial release20172013201820002010
Current release1.2.2, February 20234.1.0, June 20223.45.3  (15 April 2024), April 20247.3.0, May 2020
License infoCommercial or Open SourceOpen Source infoApache Version 2.0Open Source infoApache Version 2commercialOpen Source infoPublic Domaincommercial info60-day fully-featured trial license; 1-year fully-featured non-commercial use license for academics/students
Cloud-based only infoOnly available as a cloud servicenonoyesnono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaC++CJava
Server operating systemsLinuxLinuxhostedserver-lessLinux
macOS
Windows
Data schemeyesyesschema-freeyes infodynamic column typesschema-free and OWL/RDFS-schema support
Typing infopredefined data types such as float or dateyesyesnoyes infonot rigid because of 'dynamic typing' concept.yes
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.nonononono infoImport/export of XML data possible
Secondary indexesyesyesnoyesyes infosupports real-time indexing in full-text and geospatial
SQL infoSupport of SQLyesSQL-like DML and DDL statementsnoyes infoSQL-92 is not fully supportedYes, compatible with all major SQL variants through dedicated BI/SQL Server
APIs and other access methodsJDBC
MySQL client
JDBC
ODBC
HTTP REST
Proprietary protocol
ADO.NET infoinofficial driver
JDBC infoinofficial driver
ODBC infoinofficial driver
GraphQL query language
HTTP API
Jena RDF API
OWL
RDF4J API
Sesame REST HTTP Protocol
SNARL
SPARQL
Spring Data
Stardog Studio
TinkerPop 3
Supported programming languagesJavaAll languages supporting JDBC/ODBCC
C++
Dart
JavaScript
Kotlin
Python
Rust
Scala
Actionscript
Ada
Basic
C
C#
C++
D
Delphi
Forth
Fortran
Haskell
Java
JavaScript
Lisp
Lua
MatLab
Objective-C
OCaml
Perl
PHP
PL/SQL
Python
R
Ruby
Scala
Scheme
Smalltalk
Tcl
.Net
Clojure
Groovy
Java
JavaScript
Python
Ruby
Server-side scripts infoStored proceduresuser defined functionsyes infouser defined functions and integration of map-reducenonouser defined functions and aggregates, HTTP Server extensions in Java
Triggersnononoyesyes infovia event handlers
Partitioning methods infoMethods for storing different data on different nodeshorizontal partitioningShardingnonenone
Replication methods infoMethods for redundantly storing data on multiple nodesnoneselectable replication factoryesnoneMulti-source replication in HA-Cluster
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyes infoquery execution via MapReducenonono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyEventual ConsistencyEventual ConsistencyImmediate Consistency in HA-Cluster
Foreign keys infoReferential integritynononoyesyes inforelationships in graphs
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanonoACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes infovia file-system locksyes
Durability infoSupport for making data persistentyesyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.nononoyesyes
User concepts infoAccess controlfine grained access rights according to SQL-standardAccess rights for users, groups and roles infobased on Apache Sentry and KerberosnoAccess rights for users and roles

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 partiesNavicat for SQLite is a powerful and comprehensive SQLite GUI that provides a complete set of functions for database management and development.
» more

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

More resources
Apache DorisApache ImpalaCloudflare Workers KVSQLiteStardog
DB-Engines blog posts

Big gains for Relational Database Management Systems in DB-Engines Ranking
2 February 2016, Matthias Gelbmann

show all

Recent citations in the news

Data Analytics: Apache Doris' Impact in Reporting, Tagging, and Data Lake Operations
8 January 2024, hackernoon.com

How to Digest 15 Billion Logs Per Day and Keep Big Queries Within 1 Second
1 September 2023, KDnuggets

Migrating from ClickHouse to Apache Doris: Boosting OLAP Performance
9 October 2023, hackernoon.com

Apache Doris just 'graduated': Why care about this SQL data warehouse
24 June 2022, InfoWorld

Apache Doris Analytical Database Graduates from Apache Incubator
20 June 2022, Datanami

provided by Google News

Apache Impala 4 Supports Operator Multi-Threading
29 July 2021, iProgrammer

Apache Impala becomes Top-Level Project
28 November 2017, SDTimes.com

Cloudera Bringing Impala to AWS Cloud
28 November 2017, Datanami

Apache Doris just 'graduated': Why care about this SQL data warehouse
24 June 2022, InfoWorld

Hudi: Uber Engineering’s Incremental Processing Framework on Apache Hadoop
12 March 2017, Uber

provided by Google News

Cloudflare updates Workers platform with Python support, event notifications, and improved local development ...
3 April 2024, DevClass

Cloudflare dashboard, API service feeling poorly due to datacenter power snafu
2 November 2023, The Register

Cloudflare recovers from service outage after power failure at core North American data center
3 November 2023, DatacenterDynamics

Cloudflare is (still) struggling with another outage - here's what to know
3 November 2023, ZDNet

How to Build a Scalable URL Shortener With Cloudflare Workers and KV Under 10 Minutes
21 August 2022, hackernoon.com

provided by Google News

How to work with Dapper and SQLite in ASP.NET Core
10 May 2024, InfoWorld

Limbo Is An SQLite-Compatible OLTP DBMS Leveraging IO_uring & Rust
9 May 2024, Phoronix

SQLite's new support for binary JSON is similar but different from a PostgreSQL feature • DEVCLASS
16 January 2024, DevClass

Universal API Access from Postgres and SQLite
27 February 2024, O'Reilly Media

How To Speed Up SQL Queries Using Indexes [Python Edition]
10 August 2023, KDnuggets

provided by Google News



Share this page

Featured Products

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus for Free

SingleStore logo

The database to transact, analyze and contextualize your data in real time.
Try it today.

Datastax Astra logo

Bring all your data to Generative AI applications with vector search enabled by the most scalable
vector database available.
Try for Free

Neo4j logo

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

RaimaDB logo

RaimaDB, embedded database for mission-critical applications. When performance, footprint and reliability matters.
Try RaimaDB for free.

Present your product here