DB-EnginesExtremeDB: the mission critical dbmsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Apache Phoenix vs. ClickHouse vs. RDF4J

System Properties Comparison Apache Phoenix vs. ClickHouse vs. RDF4J

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameApache Phoenix  Xexclude from comparisonClickHouse  Xexclude from comparisonRDF4J infoformerly known as Sesame  Xexclude from comparison
DescriptionA scale-out RDBMS with evolutionary schema built on Apache HBaseColumn-oriented Relational DBMS powering YandexRDF4J is a Java framework for processing RDF data, supporting both memory-based and a disk-based storage.
Primary database modelRelational DBMSRelational DBMSRDF store
Secondary database modelsTime Series DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score2.79
Rank#123  Overall
#63  Relational DBMS
Score15.19
Rank#39  Overall
#24  Relational DBMS
Score1.02
Rank#226  Overall
#9  RDF stores
Websitephoenix.apache.orgclickhouse.comrdf4j.org
Technical documentationphoenix.apache.orgclickhouse.com/­docsrdf4j.org/­documentation
DeveloperApache Software FoundationClickhouse Inc.Since 2016 officially forked into an Eclipse project, former developer was Aduna Software.
Initial release201420162004
Current release5.0-HBase2, July 2018 and 4.15-HBase1, December 2019v23.7.4.5-stable, August 2023
License infoCommercial or Open SourceOpen Source infoApache Version 2.0Open Source infoApache 2.0Open Source infoEclipse Distribution License (EDL), v1.0.
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++Java
Server operating systemsLinux
Unix
Windows
FreeBSD
Linux
macOS
Linux
OS X
Unix
Windows
Data schemeyes infolate-bound, schema-on-read capabilitiesyesyes infoRDF Schemas
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.nono
Secondary indexesyesyes, when using the MergeTree engineyes
SQL infoSupport of SQLyesClose to ANSI SQLno
APIs and other access methodsJDBCHTTP REST
JDBC
ODBC
Proprietary protocol
Java API
RIO infoRDF Input/Output
Sail API
SeRQL infoSesame RDF Query Language
Sesame REST HTTP Protocol
SPARQL
Supported programming languagesC
C#
C++
Go
Groovy
Java
PHP
Python
Scala
C# info3rd party library
C++
Elixir info3rd party library
Go info3rd party library
Java info3rd party library
JavaScript (Node.js) info3rd party library
Kotlin info3rd party library
Nim info3rd party library
Perl info3rd party library
PHP info3rd party library
Python info3rd party library
R info3rd party library
Ruby info3rd party library
Scala info3rd party library
Java
PHP
Python
Server-side scripts infoStored proceduresuser defined functionsnoyes
Triggersnonoyes
Partitioning methods infoMethods for storing different data on different nodesShardingnone
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replication
Source-replica replication
none
MapReduce infoOffers an API for user-defined Map/Reduce methodsHadoop integrationnono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate Consistency or Eventual ConsistencyImmediate Consistency
Foreign keys infoReferential integritynono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDnoACID infoIsolation support depends on the API used
Concurrency infoSupport for concurrent manipulation of datayesyesyes
Durability infoSupport for making data persistentyesyesyes infoin-memory storage is supported as well
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyes
User concepts infoAccess controlAccess Control Lists (using HBase ACL) for RBAC, integration with Apache Ranger for RBAC & ABAC, multi-tenancyAccess rights for users and rolesno

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

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

More resources
Apache PhoenixClickHouseRDF4J infoformerly known as Sesame
DB-Engines blog posts

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

show all

Recent citations in the news

What Is HBase? (Definition, Uses, Benefits, Features)
22 December 2022, Built In

Apache Phoenix Now HBase 2.0 Compatible
20 July 2018, iProgrammer

性能提升3-4倍!贝壳基于Flink + OceanBase的实时维表服务_ ...
31 August 2023, CSDN

Sundeck Announces the Public Availability of Its Query Engineering ...
31 May 2023, AccessWire

Coming in HDP 2.5: Incremental Backup and Restore for Apache ...
26 July 2016, DZone

provided by Google News

Timeplus Open Sources its Powerful Streaming Analytics Engine for ...
21 September 2023, Longview News-Journal

ChistaDATA: Revolutionizing Real-Time Analytics and Data ...
22 September 2023, CXOToday.com

Why Clickhouse Should Be Your Next Database
6 July 2023, The New Stack

What is Derived Data? (and Do You Already Have Any?)
25 August 2023, InfoQ.com

Change Data Capture for Real-Time Access to Backend Databases
5 September 2023, The New Stack

provided by Google News

Exploring Intelligent Graph and PathQL - DataScienceCentral.com
21 February 2022, Data Science Central

Ontotext's GraphDB 10 Brings Modern Data Architectures to the ...
5 July 2022, PR Newswire

Intara FAQs
16 November 2022, Jane's

GraphDB 9.8 Brings Text Mining and Kafka Connectivity
2 June 2021, PR Newswire

SPARQL, le SQL du Web, et Linked Data Fragment : le point sur le ...
1 January 2017, LinuxFr.org

provided by Google News

Job opportunities

Senior Solution Architect (2694)
SMX, Remote

Senior Full Stack Software Developer in Test
Amiseq, Milpitas, CA

Senior Solutions Architect - Public Sector
Cloudera, McLean, VA

SMB Account Executive
ClickHouse, Remote

Big Data Engineer-Associate–Vice President
Deutsche Bank, Cary, NC

IT Business Systems Manager
ClickHouse, Remote

Senior Analyst, Sales Strategy and Operations
ClickHouse, Remote

Tech Lead, Cloud Data Engine
TikTok, Seattle, WA

Ontologist
Johns Hopkins Applied Physics Laboratory (APL), Laurel, MD

jobs by Indeed



Share this page

Featured Products

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL 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.

Redis logo

The world’s most loved real‑time data platform.
Try free

AllegroGraph logo

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

Present your product here