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 Phoenix vs. Datastax Enterprise vs. OrientDB vs. SQLite vs. Stardog

System Properties Comparison Apache Phoenix vs. Datastax Enterprise vs. OrientDB vs. SQLite vs. Stardog

Editorial information provided by DB-Engines
NameApache Phoenix  Xexclude from comparisonDatastax Enterprise  Xexclude from comparisonOrientDB  Xexclude from comparisonSQLite  Xexclude from comparisonStardog  Xexclude from comparison
DescriptionA scale-out RDBMS with evolutionary schema built on Apache HBaseDataStax Enterprise (DSE) is the always-on, scalable data platform built on Apache Cassandra and designed for hybrid Cloud. DSE integrates graph, search, analytics, administration, developer tooling, and monitoring into a unified platform.Multi-model DBMS (Document, Graph, Key/Value)Widely used embeddable, in-process RDBMSEnterprise Knowledge Graph platform and graph DBMS with high availability, high performance reasoning, and virtualization
Primary database modelRelational DBMSWide column storeDocument store
Graph DBMS
Key-value store
Relational DBMSGraph DBMS
RDF store
Secondary database modelsDocument store
Graph DBMS
Spatial DBMS
Search engine
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score3.06
Rank#97  Overall
#51  Relational DBMS
Score8.95
Rank#51  Overall
#4  Wide column stores
Score4.24
Rank#82  Overall
#13  Document stores
#5  Graph DBMS
#12  Key-value stores
Score128.65
Rank#9  Overall
#6  Relational DBMS
Score1.70
Rank#135  Overall
#12  Graph DBMS
#6  RDF stores
Websitephoenix.apache.orgwww.datastax.com/­products/­datastax-enterpriseorientdb.orgwww.sqlite.orgwww.stardog.com
Technical documentationphoenix.apache.orgdocs.datastax.comwww.orientdb.com/­docs/­last/­index.htmlwww.sqlite.org/­docs.htmldocs.stardog.com
DeveloperApache Software FoundationDataStaxOrientDB LTD; CallidusCloud; SAPDwayne Richard HippStardog-Union
Initial release20142011201020002010
Current release5.0-HBase2, July 2018 and 4.15-HBase1, December 20196.8, April 20203.1.9, February 20213.36.0  (18 June 2021), June 20217.3.0, May 2020
License infoCommercial or Open SourceOpen Source infoApache Version 2.0commercialOpen Source infoApache version 2Open 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 servicenonononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaJavaJavaCJava
Server operating systemsLinux
Unix
Windows
Linux
OS X
All OS with a Java JDK (>= JDK 6)server-lessLinux
macOS
Windows
Data schemeyes infolate-bound, schema-on-read capabilitiesschema-freeschema-free infoSchema can be enforced for whole record ("schema-full") or for some fields only ("schema-hybrid")yes infodynamic column typesschema-free and OWL/RDFS-schema support
Typing infopredefined data types such as float or dateyesyesyesyes 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 indexesyesyesyesyesyes infosupports real-time indexing in full-text and geospatial
SQL infoSupport of SQLyesSQL-like DML and DDL statements (CQL); Spark SQLSQL-like query language, no joinsyes infoSQL-92 is not fully supportedYes, compatible with all major SQL variants through dedicated BI/SQL Server
APIs and other access methodsJDBCProprietary protocol infoCQL (Cassandra Query Language)
TinkerPop Gremlin infowith DSE Graph
Tinkerpop technology stack with Blueprints, Gremlin, Pipes
Java API
RESTful HTTP/JSON API
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 languagesC
C#
C++
Go
Groovy
Java
PHP
Python
Scala
C
C#
C++
Java
JavaScript (Node.js)
PHP
Python
Ruby
.Net
C
C#
C++
Clojure
Java
JavaScript
JavaScript (Node.js)
PHP
Python
Ruby
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 functionsnoJava, Javascriptnouser defined functions and aggregates, HTTP Server extensions in Java
TriggersnoyesHooksyesyes infovia event handlers
Partitioning methods infoMethods for storing different data on different nodesShardingSharding infono "single point of failure"Shardingnonenone
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replication
Source-replica replication
configurable replication factor, datacenter aware, advanced replication for edge computingMulti-source replicationnoneMulti-source replication in HA-Cluster
MapReduce infoOffers an API for user-defined Map/Reduce methodsHadoop integrationyesno infocould be achieved with distributed queriesnono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate Consistency or Eventual ConsistencyImmediate Consistency
Tunable Consistency infoconsistency level can be individually decided with each write operation
Immediate Consistency in HA-Cluster
Foreign keys infoReferential integritynonoyes inforelationship in graphsyesyes inforelationships in graphs
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDno infoAtomicity and isolation are supported for single operationsACIDACIDACID
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.yesyesyesyes
User concepts infoAccess controlAccess Control Lists (using HBase ACL) for RBAC, integration with Apache Ranger for RBAC & ABAC, multi-tenancyAccess rights for users can be defined per objectAccess rights for users and roles; record level security configurablenoAccess rights for users and roles
More information provided by the system vendor
Apache PhoenixDatastax EnterpriseOrientDBSQLiteStardog
Specific characteristicsDataStax Enterprise is scale-out data infrastructure for enterprises that need to...
» more
Stardog is an Enterprise Knowledge Graph platform, uniquely combining graph storage...
» more
Competitive advantagesSupporting the following application requirements: Zero downtime - Built on Apache...
» more
Stardog provides a full featureset to aid in data integration for your complex data....
» more
Typical application scenariosApplications that must be massively and linearly scalable with 100% uptime and able...
» more
Stardog is frequently used for: Anti-money laundering & fraud monitoring Customer...
» more
Key customersCapital One, Cisco, Comcast, eBay, McDonald's, Microsoft, Safeway, Sony, UBS, and...
» more
Bosch, Dow Jones, Elsevier, Ericsson, Morgan Stanley, NASA, NIH, Nokia, Salesforce,...
» more
Market metricsAmong the Forbes 100 Most Innovative Companies, DataStax is trusted by 5 of the top...
» more
Stardog's technology is based on ground-breaking research by our founders cited 10,000+...
» more
Licensing and pricing modelsAnnual subscription
» more
A fully-featured 60-day Trial license is available for those testing Stardog; contact...
» 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 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 PhoenixDatastax EnterpriseOrientDBSQLiteStardog
DB-Engines blog posts

Cloudera's HBase PaaS offering now supports Complex Transactions
11 August 2021,  Krishna Maheshwari (sponsor) 

show all

Graph DBMS increased their popularity by 500% within the last 2 years
3 March 2015, Paul Andlinger

Graph DBMSs are gaining in popularity faster than any other database category
21 January 2014, Matthias Gelbmann

show all

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

show all

Recent citations in the news

Apache Phoenix Now HBase 2.0 Compatible
20 July 2018, iProgrammer

HPE gobbles up Ampool to add SQL grunt to Ezmeral
9 July 2021, The Register

Developing Python Applications Against Apache Phoenix (HBase)
30 September 2016, DZone News

Cloudera adds operational database to cloud service
17 September 2020, ZDNet

The Apache Software Foundation Announces the 10th Anniversary of Apache® HBase
13 May 2020, GlobeNewswire

provided by Google News

DataStax Q2 Marked by Strong Growth with Leading Enterprises Including Barracuda Networks and Priceline
31 August 2021, Business Wire

DataStax Adds Multi-Region Flexibility to Its Serverless Cloud Database
15 September 2021, Cloud Wars

DataStax Shows Strong Momentum with New Customers, Partners and Products
26 May 2021, Business Wire

DataStax Collaborates With IBM to Help Enterprises Accelerate Modern, Multi-Cloud Data Applications
23 March 2021, Business Wire

Turning the Bank Upside Down: How Data Speed Will Define Winning Financial Institutions
30 August 2021, CIO

provided by Google News

Optical Wavelength Services Market Size, Growth And Analysis By Leading Keyplayers : Oracle, International Business Machines Corporation, Neo TechnologyInc., OrientDB, Franz Inc. – Stillwater Current
17 September 2021, Stillwater Current

NoSQL Databases Software Market In-Depth Analysis | Key Players- Amazon, Arango DB, Azure Cosmos DB, Couchbase – Stillwater Current
20 September 2021, Stillwater Current

Graph Database Market 2021 Global Business Opportunities ? IBM, Microsoft, Oracle, AWS, Neo4j, Orientdb, Terad
31 August 2021, openPR

Graph Database Market Revenue, Growth Factors, Trends, Key Companies, Forecast To 2027
20 September 2021, The Manomet Current

New Tom Sawyer Perspectives 10.0 Release Changes Architecture, Strengthens Performance
14 September 2021, EIN News

provided by Google News

SQLite On The Web: Absurd-sql
24 August 2021, Hackaday

Database Reconstruction from Noisy Volumes: A Cache Side-Channel Attack on SQLite
8 September 2021, SemiEngineering

SQLite Extraction of Oracle Tables Tools, Methods and Pitfalls
20 July 2021, Linux Journal

FmPro Migrator 9.37 Adds New MySQL to FileMaker Pro Conversion Feature prMac
16 September 2021, prMac

SQLite Vulnerability May Be Putting Your Applications at Risk
8 July 2021, Security Boulevard

provided by Google News

Job opportunities

Senior Solutions Consultant
Cloudera, Newark, NJ

Backend Engineer II, Data, Video Analytics
Vimeo, Chelsea, NY

Sr. Engineer, Data
Vimeo, New York, NY

Principal Engineer, Data
Vimeo, New York, NY

Database Administrator II (TS/SCI with Poly Required)
Fluor Corporation, Denver, CO

Astra Enterprise Success Leader (Remote US)
DataStax, San Francisco Bay Area, CA

Senior Database Administrator - Cassandra / DataStax
Uline, Pleasant Prairie, WI

Full Stack Developer III
FedEx Services, Collierville, TN

Director, Enterprise Applications
TuSimple, San Diego, CA

Database Administrator
Verizon, Alpharetta, GA

Jr. QA Analyst Trainee
SQA², Los Alamitos, CA

Junior Xamarin Mobile Developer
MultiTracks, Austin, TX

ASSOCIATE DATA SCIENTIST
NYC DEPARTMENT OF CITY PLANNING, Manhattan, NY

HED PLANNER
NYC DEPARTMENT OF CITY PLANNING, Manhattan, NY

Desktop and System Support Technician, Senior
Linamar Corp, Fletcher, NC

jobs by Indeed



Share this page

Featured Products

Couchbase logo

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

Neo4j logo

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

AllegroGraph logo

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

Datastax Astra logo

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

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Present your product here