DB-EnginesInfluxDB: Focus on building software with an easy-to-use serverless, scalable time series platformEnglish
Deutsch
Informationen zu relationalen und NoSQL DatenbankmanagementsystemenEin Service von solid IT

DBMS > ClickHouse vs. NCache vs. Oracle vs. Oracle Rdb vs. ScyllaDB

Vergleich der Systemeigenschaften ClickHouse vs. NCache vs. Oracle vs. Oracle Rdb vs. ScyllaDB

Redaktionelle Informationen bereitgestellt von DB-Engines
NameClickHouse  Xaus Vergleich ausschliessenNCache  Xaus Vergleich ausschliessenOracle  Xaus Vergleich ausschliessenOracle Rdb  Xaus Vergleich ausschliessenScyllaDB  Xaus Vergleich ausschliessen
KurzbeschreibungA 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.Open-Source and Enterprise in-memory Key-Value StoreWeit verbreitetes, allgemein einsetzbares RDBMSCassandra and DynamoDB compatible wide column store
Primäres DatenbankmodellRelational DBMSKey-Value StoreRelational DBMSRelational DBMSWide Column Store
Sekundäre DatenbankmodelleTime Series DBMSDocument Store
Suchmaschine infoUsing distributed Lucene
Document Store
Graph DBMS infowith Oracle Spatial and Graph
RDF Store infowith Oracle Spatial and Graph
Spatial DBMS infowith Oracle Spatial and Graph
Vektor DBMS infosince Oracle 23
Key-Value Store
DB-Engines Ranking infomisst die Popularität von Datenbankmanagement- systemenranking trend
Trend Chart
Punkte15,55
Rang#38  Overall
#23  Relational DBMS
Punkte0,96
Rang#195  Overall
#29  Key-Value Stores
Punkte1244,08
Rang#1  Overall
#1  Relational DBMS
Punkte1,14
Rang#178  Overall
#80  Relational DBMS
Punkte4,08
Rang#76  Overall
#5  Wide Column Stores
Websiteclickhouse.comwww.alachisoft.com/­ncachewww.oracle.com/­databasewww.oracle.com/­database/­technologies/­related/­rdb.htmlwww.scylladb.com
Technische Dokumentationclickhouse.com/­docswww.alachisoft.com/­resources/­docsdocs.oracle.com/­en/­databasewww.oracle.com/­database/­technologies/­related/­rdb-doc.htmldocs.scylladb.com
EntwicklerClickhouse Inc.AlachisoftOracleOracle, originally developed by Digital Equipment Corporation (DEC)ScyllaDB
Erscheinungsjahr20162005198019842015
Aktuelle Versionv24.4.1.2088-stable, Mai 20245.3.3, April 202423c, September 20237.4.1.1, 2021ScyllaDB Open Source 5.4.1, Jaenner 2024
Lizenz infoCommercial or Open SourceOpen Source infoApache 2.0Open Source infoEnterprise Edition availablekommerziell infoeingeschränkte kostenlose Version verfügbarkommerziellOpen Source infoOpen Source (AGPL), commercial license available
Ausschließlich ein Cloud-Service infoNur als Cloud-Service verfügbarneinneinneinneinnein
DBaaS Angebote (gesponserte 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.
  • Aiven for Clickhouse: Managed cloud data warehousing with high-speed analytics.
  • 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.
Scylla Cloud: Create real-time applications that run at global scale with Scylla Cloud, the industry’s most powerful NoSQL DBaaS
ImplementierungsspracheC++C#, .NET, .NET Core, JavaC und C++C++
Server BetriebssystemeFreeBSD
Linux
macOS
Linux
Windows
AIX
HP-UX
Linux
OS X
Solaris
Windows
z/OS
HP Open VMSLinux
Datenschemajaschemafreija infoSchemaless in JSON and XML columnsFlexible Schema (defined schema, partial schema, schema free)schemafrei
Typisierung infovordefinierte Datentypen, z.B. float oder datejateilweise infoSupported data types are Lists, Queues, Hashsets, Dictionary and Counterjajaja
XML Unterstützung infoVerarbeitung von Daten in XML Format, beispielsweise Speicherung von XML-Strukturen und/oder Unterstützung von XPath, XQuery, XSLTneinneinjaneinnein
Sekundärindizesyesjajajaja infocluster global secondary indices
SQL infoSupport of SQLClose to ANSI SQL (SQL/JSON + extensions)SQL-like query syntax and LINQ for searching the cache. Cache Synchronization with SQL Server using SQL dependency.ja infomit proprietären ErweiterungenjaSQL-like DML and DDL statements (CQL)
APIs und andere ZugriffskonzeptegRPC
HTTP REST
JDBC
MySQL wire protocol
ODBC
PostgreSQL wire protocol
Proprietäres Protokoll
IDistributedCache
JCache
LINQ
Proprietäres native API
JDBC
ODBC
ODP.NET
Oracle Call Interface (OCI)
Proprietäres Protokoll infocompatible with CQL (Cassandra Query Language, an SQL-like language)
RESTful HTTP API (DynamoDB compatible)
Thrift
Unterstützte ProgrammiersprachenC# 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
.Net
.Net Core
C#
Java
JavaScript (Node.js)
Python
Scala
C
C#
C++
Clojure
Cobol
Delphi
Eiffel
Erlang
Fortran
Groovy
Haskell
Java
JavaScript
Lisp
Objective C
OCaml
Perl
PHP
Python
R
Ruby
Scala
Tcl
Visual Basic
For CQL interface: C#, C++, Clojure, Erlang, Go, Haskell, Java, JavaScript, Node.js, Perl, PHP, Python, Ruby, Rust, Scala
For DynamoDB interface: .Net, ColdFusion, Erlang, Groovy, Java, JavaScript, Perl, PHP, Python, Ruby
Server-seitige Scripts infoStored Proceduresjanein infoUnterstützung für stored procedures mit SQL-Server CLRPL/SQL infoauch Java stored procedures möglichyes, Lua
Triggersneinja infoNotificationsjanein
Partitionierungsmechanismen infoMethoden zum Speichern von unterschiedlichen Daten auf unterschiedlichen Knotenkey based and customjaSharding, horizontal partitioningSharding
Replikationsmechanismen infoMethoden zum redundanten Speichern von Daten auf mehreren KnotenAsynchronous and synchronous physical replication; geographically distributed replicas; support for object storages.ja, mit wählbarer KonsistenzMulti-Source Replikation
Source-Replica Replikation
frei wählbarer Replikationsfaktor infoRepresentation of geographical distribution of servers is possible
MapReduce infoBietet ein API für Map/Reduce Operationenneinjanein infokann in PL/SQL realisiert werdenneinnein
Konsistenzkonzept infoMethoden zur Sicherstellung der Konsistenz in einem verteilten SystemImmediate ConsistencyEventual Consistency
Immediate Consistency
Strong Eventual Consistency over WAN with Conflict Resolution using Bridge Topology
Immediate ConsistencyImmediate ConsistencyEventual Consistency
Tunable Consistency infocan be individually decided for each write operation
Fremdschlüssel inforeferenzielle Integritätneinneinjajanein
Transaktionskonzept infoUnterstützung zur Sicherstellung der Datenintegrität bei nicht-atomaren Datenmanipulationenneinoptimistic Locking und pessimistic LockingACID infomit parameterisierbarem isolation levelyes, on a single nodenein infoAtomicity and isolation are supported for single operations
Concurrency infoUnterstützung von gleichzeitig ausgeführten Datenmanipulationenjajajajaja
Durability infoDauerhafte Speicherung der Datenjajajajaja
In-Memory Unterstützung infoGibt es Möglichkeiten einige oder alle Strukturen nur im Hauptspeicher zu haltenjajaja infoVersion 12c introduced the new option 'Oracle Database In-Memory'neinja infoin-memory tables
Berechtigungskonzept infoZugriffskontrolleAccess 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.Authentifizierung für Zugriff auf Cache mittels Active Directory/LDAP (Rollen: user, administrator)Benutzer mit feingranularem Berechtigungskonzept entsprechend SQL-StandardAccess rights for users can be defined per object
Weitere Informationen bereitgestellt vom Systemhersteller
ClickHouseNCacheOracleOracle RdbScyllaDB
Specific characteristicsNCache has been the market leader in .NET Distributed Caching since 2005 . NCache...
» mehr
ScyllaDB is engineered to deliver predictable performance at scale. It’s adopted...
» mehr
Competitive advantagesNCache is 100% .NET/ .NET Core based which fully supports ASP.NET Core Sessions ,...
» mehr
Highly-performant (efficiently utilizes full resources of a node and network; millions...
» mehr
Typical application scenariosNCache enables industries like retail, finance, banking IoT, travel, ecommerce, healthcare...
» mehr
ScyllaDB is ideal for applications that require high throughput and low latency at...
» mehr
Key customersBank of America, Citi, Natures Way, Charter Spectrum, Barclays, Henry Schein, GBM,...
» mehr
Discord, Epic Games, Expedia, Zillow, Comcast, Disney+ Hotstar, Samsung, ShareChat,...
» mehr
Market metricsMarket Leader in .NET Distributed Caching since 2005.
» mehr
ScyllaDB typically offers ~75% total cost of ownership savings, with ~5X higher throughput...
» mehr
Licensing and pricing modelsNCache Open Source is free on an as-is basis without any support. NCache Enterprise...
» mehr
ScyllaDB Open Source - free open source software (AGPL) ScyllaDB Enterprise - subscription-based...
» mehr

Wir laden Vertreter der Systemhersteller ein uns zu kontaktieren, um die Systeminformationen zu aktualisieren und zu ergänzen,
sowie um Herstellerinformationen wie Schlüsselkunden, Vorteile gegenüber Konkurrenten und Marktmetriken anzuzeigen.

Zugehörige Produkte und Dienstleistungen
DrittanbieterDoubleCloud: Fully managed ClickHouse alongside best-in-class managed open-source services to build analytics at scale.
» mehr

Aiven for Clickhouse: Managed cloud data warehousing with high-speed analytics.
» mehr
Devart ODBC driver for Oracle accesses Oracle databases from ODBC-compliant reporting, analytics, BI, and ETL tools on both 32 and 64-bit Windows, macOS, and Linux.
» mehr

Navicat for Oracle improves the efficiency and productivity of Oracle developers and administrators with a streamlined working environment.
» mehr

Wir laden Vertreter von Anbietern von zugehörigen Produkten ein uns zu kontaktieren, um hier Informationen über ihre Angebote zu präsentieren.

Weitere Ressourcen
ClickHouseNCacheOracleOracle RdbScyllaDB
DB-Engines Blog Posts

MySQL is the DBMS of the Year 2019
3. Januar 2020, Matthias Gelbmann, Paul Andlinger

The struggle for the hegemony in Oracle's database empire
2. Mai 2017, Paul Andlinger

Architecting eCommerce Platforms for Zero Downtime on Black Friday and Beyond
25. November 2016, Tony Branson (guest author)

alle anzeigen

Konferenzen, Veranstaltungen und Webinare

Oracle Cloud World
Las Vegas, 9.-12. September 2024

Erwähnungen in aktuellen Nachrichten

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

ClickHouse Cloud & Amazon S3 Express One Zone: Making a blazing fast analytical database even faster | Amazon ...
28. November 2023, AWS Blog

Intel Xeon 6766E/6780E Sierra Forest vs. Ampere Altra Performance & Power Efficiency Review
5. Juni 2024, Phoronix

A 1000x Faster Database Solution: ClickHouse’s Aaron Katz
1. November 2023, GrowthCap

From Open Source to SaaS: the Journey of ClickHouse
16. Januar 2024, InfoQ.com

bereitgestellt von Google News

How to use NCache in ASP.Net Core
25. Februar 2019, InfoWorld

Custom Response Caching Using NCache in ASP.NET Core
22. April 2020, InfoQ.com

bereitgestellt von Google News

Oracle And Google Partner To Deliver Multicloud Offering To Enterprises
13. Juni 2024, Forbes

Oracle to colocate database services and network interconnect in Google data centers
12. Juni 2024, DatacenterDynamics

Blog Theme - Details
14. Juni 2024, Oracle

Oracle and Google Cloud Announce a Groundbreaking Multicloud Partnership
11. Juni 2024, PR Newswire

Panasonic Information Systems Selects Oracle Cloud Infrastructure to Drive Modernization of Internal Systems Across ...
13. Juni 2024, PR Newswire

bereitgestellt von Google News

Oracle Adds New AI-Enabling Features To MySQL HeatWave
23. März 2023, Forbes

Should we all consolidate databases for the storage benefits? Reg vultures deploy DevOps, zoos, haircuts
18. September 2020, The Register

2013 Data Science Salary Survey
4. Mai 2013, oreilly.com

bereitgestellt von Google News

Sleeping at Scale - Delivering 10k Timers per Second per Node with Rust, Tokio, Kafka, and Scylla
26. April 2024, InfoQ.com

ScyllaDB on AWS is a NoSQL Database Built for Gigabyte-to-Petabyte Scale | Amazon Web Services
6. Januar 2023, AWS Blog

Scylla Eyes Cassandra's NoSQL Workloads
13. Februar 2018, Datanami

ScyllaDB Database Review | eWeek
21. August 2018, eWeek

Scylla review: Apache Cassandra supercharged
18. Dezember 2019, InfoWorld

bereitgestellt von Google News



Teilen sie diese Seite mit ihrem Netzwerk

Featured Products

Neo4j logo

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

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus 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

Präsentieren Sie hier Ihr Produkt