DB-EnginesEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by Redgate Software

DBMS > ClickHouse vs. Faircom EDGE vs. Fauna vs. Oracle NoSQL vs. Weaviate

System Properties Comparison ClickHouse vs. Faircom EDGE vs. Fauna vs. Oracle NoSQL vs. Weaviate

Editorial information provided by DB-Engines
NameClickHouse  Xexclude from comparisonFaircom EDGE infoformerly c-treeEDGE  Xexclude from comparisonFauna infopreviously named FaunaDB  Xexclude from comparisonOracle NoSQL  Xexclude from comparisonWeaviate  Xexclude from comparison
DescriptionA high-performance, column-oriented SQL DBMS for online analytical processing (OLAP) that uses all available system resources to their full potential to process each analytical query as fast as possible. It is available as both an open-source software and a cloud offering.FairCom EDGE is an Industry 4.0 solution built to integrate, collect, aggregate and synchronize mission-critical data in edge computing environmentsFauna 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.A multi-model, scalable, distributed NoSQL database, designed to provide highly reliable, flexible, and available data management across a configurable set of storage nodesAn AI-native realtime vector database engine that integrates scalable machine learning models.
Primary database modelRelational DBMSKey-value store
Relational DBMS
Document store
Graph DBMS
Relational DBMS
Time Series DBMS
Document store
Key-value store
Relational DBMS
Vector DBMS
Secondary database modelsTime Series DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score16.25
Rank#37  Overall
#22  Relational DBMS
Score0.02
Rank#366  Overall
#55  Key-value stores
#155  Relational DBMS
Score1.50
Rank#147  Overall
#26  Document stores
#13  Graph DBMS
#67  Relational DBMS
#13  Time Series DBMS
Score3.27
Rank#83  Overall
#15  Document stores
#11  Key-value stores
#45  Relational DBMS
Score1.65
Rank#138  Overall
#9  Vector DBMS
Websiteclickhouse.comwww.faircom.com/­products/­faircom-edgefauna.comwww.oracle.com/­database/­nosql/­technologies/­nosqlgithub.com/­weaviate/­weaviate
weaviate.io
Technical documentationclickhouse.com/­docsdocs.faircom.com/­docs/­en/­UUID-23d4f1fd-d213-f6d5-b92e-9b7475baa14e.htmldocs.fauna.comdocs.oracle.com/­en/­database/­other-databases/­nosql-database/­index.htmlweaviate.io/­developers/­weaviate
DeveloperClickhouse Inc.FairCom CorporationFauna, Inc.OracleWeaviate B.V.
Initial release20161979201420112019
Current releasev24.6.2.17-stable, July 2024V3, October 202024.1, May 20241.19, May 2023
License infoCommercial or Open SourceOpen Source infoApache 2.0commercial infoRestricted, free version availablecommercialOpen Source infoProprietary for Enterprise Edition (Oracle Database EE license has Oracle NoSQL database EE covered: details)Open Source infocommercial license available with Weaviate Enterprise
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.
  • DoubleCloud: Fully managed ClickHouse alongside best-in-class managed open-source services to build analytics at scale.
  • ClickHouse Cloud: Get the performance you love from open source ClickHouse in a serverless offering that takes care of the details so you can spend more time getting insight out of the fastest database on earth.
Implementation languageC++ANSI C, C++ScalaJavaGo
Server operating systemsFreeBSD
Linux
macOS
Android
Linux infoARM, x86
Raspbian
Windows
hostedLinux
Solaris SPARC/x86
Data schemeyesFlexible Schema (defined schema, partial schema, schema free)schema-freeSupport Fixed schema and Schema-less deployment with the ability to interoperate between them.yes, maps to GraphQL interface
Typing infopredefined data types such as float or dateyesyes, ANSI Standard SQL Typesnooptionalyes infostring, int, float, geo point, date, cross reference, fuzzy references
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.noyesnonono
Secondary indexesyesyesyesyesyes infoall data objects are indexed in a semantic vector space (the Contextionary), all primitive fields are indexed
SQL infoSupport of SQLClose to ANSI SQL (SQL/JSON + extensions)yes infoANSI SQL queriesnoSQL-like DML and DDL statementsGraphQL is used as query language
APIs and other access methodsgRPC
HTTP REST
JDBC
MySQL wire protocol
ODBC
PostgreSQL wire protocol
Proprietary protocol
ADO.NET
Direct SQL
IoT Microservice layer
JDBC
MQTT (Message Queue Telemetry Transport)
ODBC
RESTful HTTP API
RESTful HTTP APIRESTful HTTP APIGraphQL query language
RESTful HTTP/JSON API
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
Rust
Scala info3rd party library
C
C#
C++
Java
JavaScript
PHP
Python
VB.Net
C#
Go
Java
JavaScript
Python
Ruby
Scala
Swift
C
C#
Go
Java
JavaScript (Node.js)
Python
JavaScript / TypeScript
Python
Server-side scripts infoStored proceduresyesyes info.Net, JavaScript, C/C++user defined functionsnono
Triggersnoyesnonono
Partitioning methods infoMethods for storing different data on different nodeskey based and customFile partitioning infoCustomizable business rules for partitioninghorizontal partitioning infoconsistent hashingShardingSharding
Replication methods infoMethods for redundantly storing data on multiple nodesAsynchronous and synchronous physical replication; geographically distributed replicas; support for object storages.yes infoSynchronous and asynchronous realtime replication based on transaction logsMulti-source replicationElectable source-replica replication per shard. Support distributed global deployment with Multi-region table featureyes
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononowith Hadoop integrationno
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate Consistency
Tunable Consistency
Immediate ConsistencyEventual Consistency
Immediate Consistency infodepending on configuration
Eventual Consistency
Foreign keys infoReferential integritynoyes infowhen using SQLyesnono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoACIDACIDconfigurable infoACID within a storage node (=shard)no
Concurrency infoSupport for concurrent manipulation of datayesyes infoacross SQL and NoSQLyesyesyes
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.yesyesnoyes infooff heap cacheyes
User concepts infoAccess controlAccess rights for users and roles. Column and row based policies. Quotas and resource limits. Pluggable authentication with LDAP and Kerberos. Password based, X.509 certificate, and SSH key authentication.Fine grained user, group and file access rights managed across SQL (per ANSI standard) and NoSQL.Identity management, authentication, and access controlAccess rights for users and rolesAPI Keys
OpenID Connect Discovery
More information provided by the system vendor
ClickHouseFaircom EDGE infoformerly c-treeEDGEFauna infopreviously named FaunaDBOracle NoSQLWeaviate
Specific characteristicsWeaviate is an open source vector database that is robust, scalable, cloud-native,...
» more
Competitive advantagesFlexible deployment - Free, open source or fully-managed cloud vector database service...
» more
Typical application scenariosAs a database supporting the development of generative AI and semantic search applications...
» more
Key customersAll companies that have data. ​
» more
Market metricsAs of mid 2023: Over 2 million open source downloads 3500+ Weaviate Slack community...
» more
Licensing and pricing modelsWeaviate is open-source, and free to use. Weaviate is also available as a fully managed...
» 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 partiesDoubleCloud: Fully managed ClickHouse alongside best-in-class managed open-source services to build analytics at scale.
» more

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

More resources
ClickHouseFaircom EDGE infoformerly c-treeEDGEFauna infopreviously named FaunaDBOracle NoSQLWeaviate
DB-Engines blog posts

Weaviate, an ANN Database with CRUD support
2 February 2021,  Etienne Dilocker, SeMI Technologies (sponsor) 

show all

Recent citations in the news

Real-time database startup ClickHouse acquires PeerDB to expand its Postgres support
30 July 2024, TechCrunch

Azur Games migrates all game analytics data to ClickHouse Cloud on AWS
16 July 2024, AWS Blog

A 1000x Faster Database Solution: ClickHouse’s Aaron Katz
17 October 2024, The Software Report

A Beginner’s Guide to ClickHouse Database
13 September 2024, KDnuggets

ClickHouse Acquires PeerDB to Boost Real-time Analytics with Postgres CDC Integration
30 July 2024, Business Wire

provided by Google News

Data Technology Company FairCom Expands The Edge with 2 New Releases of its Edge Computing Products
19 April 2023, Business Wire

Brokers, Protocols, Platform Move Manufacturing Data
26 July 2023, EE Times

Winners of the 2021 IoT Evolution Product of the Year Awards Announced
6 July 2021, IoT Evolution World

How To Collect, Store, and Query IoT Data With MQTT + SQL
16 June 2022, IoT For All

Trend-Setting Products in Data and Information Management for 2023
8 December 2022, Database Trends and Applications

provided by Google News

Fauna Adds Declarative Tool to Update Namesake Database
1 July 2024, DevOps.com

Utah Natural Heritage Program
12 June 2024, Utah Division of Wildlife Resources

Slicing the Gordian Knot: A leap to real-time systems of truth
3 February 2024, SiliconANGLE News

Through comparative genomics, becoming tough as nails – or squirrels
30 January 2024, BioWorld Online

First Sydney fauna bridge debuts alongside connectivity database
7 September 2024, Transport for NSW

provided by Google News

Cloud database comparison: AWS, Microsoft, Google and Oracle
24 July 2024, TechTarget

What Is NoSQL Database?
2 October 2018, blogs.oracle.com

Explore Oracle Database Solutions for Maximum Efficiency
4 September 2018, oracle.com

Larry Ellison Just Embraced the Enemy. Or Did He?
1 October 2012, WIRED

Oracle Cloud Infrastructure Attains Expanded FedRAMP Authorization
7 February 2024, StockTitan

provided by Google News

Vector database startup Weaviate debuts ‘AI workbench’ and flexible storage tiers
30 July 2024, SiliconANGLE News

Weaviate Achieves Amazon Web Services GenAI Competency Status
8 July 2024, GlobeNewswire

StructuredRAG Released by Weaviate: A Comprehensive Benchmark to Evaluate Large Language Models’ Ability to Generate Reliable JSON Outputs for Complex AI Systems
26 August 2024, MarkTechPost

Build enterprise-ready generative AI solutions with Cohere foundation models in Amazon Bedrock and Weaviate vector database on AWS Marketplace
24 January 2024, AWS Blog

Weaviate Raises $50 Million Series B Funding to Meet Soaring Demand for AI Native Vector Database Technology
21 April 2023, PR Newswire

provided by Google News



Share this page

Featured Products

SingleStore logo

The data platform to build your intelligent applications.
Try it free.

Milvus logo

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

Neo4j logo

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

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

RaimaDB logo

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

Present your product here