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

DBMS > ClickHouse vs. Fauna vs. Kingbase vs. Oracle Berkeley DB vs. SwayDB

System Properties Comparison ClickHouse vs. Fauna vs. Kingbase vs. Oracle Berkeley DB vs. SwayDB

Editorial information provided by DB-Engines
NameClickHouse  Xexclude from comparisonFauna infopreviously named FaunaDB  Xexclude from comparisonKingbase  Xexclude from comparisonOracle Berkeley DB  Xexclude from comparisonSwayDB  Xexclude from comparison
DescriptionColumn-oriented Relational DBMS powering YandexFauna provides a web-native interface, with support for GraphQL and custom business logic that integrates seamlessly with the rest of the serverless ecosystem. The underlying globally distributed storage and compute platform is fast, consistent, and reliable, with a modern security infrastructure.An enterprise-class RDBMS compatible with PostgreSQL and Oracle and widely used in China.Widely used in-process key-value storeAn embeddable, non-blocking, type-safe key-value store for single or multiple disks and in-memory storage
Primary database modelRelational DBMSDocument store
Graph DBMS
Relational DBMS
Time Series DBMS
Relational DBMSKey-value store infosupports sorted and unsorted key sets
Native XML DBMS infoin the Oracle Berkeley DB XML version
Key-value store
Secondary database modelsTime Series DBMSDocument store
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score13.45
Rank#44  Overall
#28  Relational DBMS
Score1.56
Rank#146  Overall
#25  Document stores
#11  Graph DBMS
#71  Relational DBMS
#10  Time Series DBMS
Score0.39
Rank#263  Overall
#122  Relational DBMS
Score2.98
Rank#106  Overall
#19  Key-value stores
#3  Native XML DBMS
Score0.01
Rank#356  Overall
#57  Key-value stores
Websiteclickhouse.techfauna.comwww.kingbase.com.cnwww.oracle.com/­technetwork/­database/­database-technologies/­berkeleydb/­overview/­index.htmlswaydb.io
Technical documentationclickhouse.tech/­docsdocs.fauna.combbs.kingbase.com.cn/­chess_wenku-index.htmldocs.oracle.com/­cd/­E17076_05/­html/­index.html
DeveloperClickhouse Inc.Fauna, Inc.BeiJing KINGBASE Information technologies inc.Oracle infooriginally developed by Sleepycat, which was acquired by OracleSimer Plaha
Initial release20162014199919942018
Current releasev22.8.5.29-lts, September 2022V8.0, August 202118.1.40, May 2020
License infoCommercial or Open SourceOpen Source infoApache 2.0commercialcommercialOpen Source infocommercial license availableOpen Source infoGNU Affero GPL V3.0
Cloud-based only infoOnly available as a cloud servicenoyesnonono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC++ScalaC and JavaC, Java, C++ (depending on the Berkeley DB edition)Scala
Server operating systemsFreeBSD
Linux
macOS
hostedLinux
Windows
AIX
Android
FreeBSD
iOS
Linux
OS X
Solaris
VxWorks
Windows
Data schemeyesschema-freeyesschema-freeschema-free
Typing infopredefined data types such as float or dateyesnoyesnono
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.nonoyesyes infoonly with the Berkeley DB XML editionno
Secondary indexesyes, when using the MergeTree engineyesyesyesno
SQL infoSupport of SQLClose to ANSI SQLnoStandard with numerous extensionsyes infoSQL interfaced based on SQLite is availableno
APIs and other access methodsHTTP REST
JDBC
ODBC
Proprietary protocol
RESTful HTTP APIADO.NET
gokb
JDBC
kdbndp
ODBC
PDI
PDO
Pro*C
psycopg2
QT
Supported programming languagesC# 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
C#
Go
Java
JavaScript
Python
Ruby
Scala
Swift
.Net
C
C++
Go
Java
JavaScript (Node.js)
Perl
PHP
Python
.Net infoFigaro is a .Net framework assembly that extends Berkeley DB XML into an embeddable database engine for .NET
others infoThird-party libraries to manipulate Berkeley DB files are available for many languages
C
C#
C++
Java
JavaScript (Node.js) info3rd party binding
Perl
Python
Tcl
Java
Kotlin
Scala
Server-side scripts infoStored proceduresnouser defined functionsuser defined functionsnono
Triggersnonoyesyes infoonly for the SQL APIno
Partitioning methods infoMethods for storing different data on different nodeshorizontal partitioning infoconsistent hashinghorizontal partitioning (by range, list and hash) and vertical partitioningnonenone
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replicationyesSource-replica replicationnone
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonononono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynoyesyesnono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoACIDACIDACIDAtomic execution of operations
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
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.yesnoyesyes
User concepts infoAccess controlAccess rights for users and rolesIdentity management, authentication, and access controlfine grained access rights according to SQL-standardnono
More information provided by the system vendor
ClickHouseFauna infopreviously named FaunaDBKingbaseOracle Berkeley DBSwayDB
Specific characteristicsAn enterprise-class RDBMS compatible with PostgreSQL and Oracle. It has the following...
» more
Competitive advantagesComplete database management platform with Integrated Development Environment Tool,...
» more
Typical application scenariosNew applications for transactional and mixed workloads that need to integrate with...
» more
Key customersThe main customers are: China National Petroleum Corporation China Petrochemical...
» more
Market metricsAt present, the main market is in China, but expansion to the international market...
» more
Licensing and pricing modelsBusiness license. Various sales modes: for example, sales by set, sales by CPU quantity,...
» 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

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

More resources
ClickHouseFauna infopreviously named FaunaDBKingbaseOracle Berkeley DBSwayDB
Recent citations in the news

Aiven improves access to open source data technologies with new ClickHouse offering
14 September 2022, VentureBeat

Data Management News for the Week of September 16; Updates from Kensu, Oracle, Syniti, and More
15 September 2022, Solutions Review

Multiple Flaws Uncovered in ClickHouse OLAP Database System for Big Data
16 March 2022, The Hacker News

Data analytics startup StarTree secures cash to expand its Apache Pinot-powered platform
29 August 2022, TechCrunch

Two Sizes Fit Most: PostgreSQL and ClickHouse
13 April 2022, thenewstack.io

provided by Google News

FaunaDB: An Introduction
8 April 2022, Built In

Fauna Adds Industry's First Real Time Streaming to its Serverless-Native Database
8 March 2022, Business Wire

Fauna Aims to Simplify Data Management for Developers
27 May 2022, thenewstack.io

CaliPopGen: A genetic and life history database for the fauna and flora of California | Scientific Data
5 July 2022, Nature.com

How Is AURN Data Used?
13 September 2022, International Environmental Technology

provided by Google News

Oracle switches Berkeley DB license
5 July 2013, InfoWorld

Oracle acquisitions timeline: From soup to nuts, PeopleSoft to Sigma
28 March 2022, TechTarget

Recognition For NoSQL Pioneers
5 July 2021, iProgrammer

Fedora Looking To Transition The RPM Database From Berkeley DB To SQLite
16 March 2020, Phoronix

ACM recognizes far-reaching technical achievements with special awards
26 May 2021, EurekAlert

provided by Google News

Job opportunities

Database Engineer
Jump Trading, Chicago, IL

Senior Data Engineer
Synack, New York, NY

Linux Database Administrator
Validity, Broomfield, CO

Senior Data Engineer - Vice President
Deutsche Bank, Cary, NC

Co-Op 2023 Software Engineer
Klaviyo, Boston, MA

Fish Biologist
US Geological Survey, Kearneysville, WV

Environmental Scientist Junior-Mid level
Tetra Tech, Jacksonville, FL

Early-Career Natural Resources Scientist
Geosyntec Consultants, Inc., Austin, TX

ROW Field Biologist
ACRT, Inc., Vermont

Director, Sedgwick Reserve
University of California, Santa Barbara, Santa Barbara, CA

jobs by Indeed



Share this page

Featured Products

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Redis logo

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

Neo4j logo

Neo4j NODES 2022
Free online conference for developers and data scientists.
November 16/17 2022.
Register now for free!

Vertica logo

Vertica Accelerator. The fastest analytics and machine learning, delivered as SaaS, with automated setup, administration, and management. Free trial.

The definitive guide for Cassandra

Imagine What You Could Do if Scalability Wasn‘t a Problem!
Download the Cassandra e-book for free!

Present your product here