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 > CockroachDB vs. SingleStore vs. TiDB

Vergleich der Systemeigenschaften CockroachDB vs. SingleStore vs. TiDB

Bitte wählen Sie ein weiteres System aus, um es in den Vergleich aufzunehmen.

Redaktionelle Informationen bereitgestellt von DB-Engines
NameCockroachDB  Xaus Vergleich ausschliessenSingleStore infoformer name was MemSQL  Xaus Vergleich ausschliessenTiDB  Xaus Vergleich ausschliessen
KurzbeschreibungCockroachDB is a distributed database architected for modern cloud applications. It is wire compatible with PostgreSQL and backed by a Key-Value Store, which is either RocksDB or a purpose-built derivative, called Pebble.MySQL wire-compliant distributed RDBMS that combines an in-memory row-oriented and a disc-based column-oriented storage with patented universal storage to handle transactional and analytical workloads in one single table typeTiDB is an open source distributed Hybrid Transactional/Analytical Processing (HTAP) database that supports MySQL and Spark SQL syntaxes.
Primäres DatenbankmodellRelational DBMSRelational DBMSRelational DBMS
Sekundäre DatenbankmodelleDocument Store
Spatial DBMS
Time Series DBMS
Document Store
DB-Engines Ranking infomisst die Popularität von Datenbankmanagement- systemenranking trend
Trend Chart
Punkte6,97
Rang#58  Overall
#32  Relational DBMS
Punkte6,66
Rang#59  Overall
#33  Relational DBMS
Punkte3,26
Rang#95  Overall
#51  Relational DBMS
Websitewww.cockroachlabs.comwww.singlestore.compingcap.com
Technische Dokumentationwww.cockroachlabs.com/­docsdocs.singlestore.comdocs.pingcap.com/­tidb/­stable
EntwicklerCockroach LabsSingleStore Inc.PingCAP, Inc.
Erscheinungsjahr201520132016
Aktuelle Version21.1.2, Juni 20217.6, November 20215.0.1, April 2021
Lizenz infoCommercial or Open SourceOpen Source infoApache 2.0, commercial license availablekommerziell infofree developer edition availableOpen Source infoApache 2.0
Ausschließlich ein Cloud-Service infoNur als Cloud-Service verfügbarneinneinnein
DBaaS Angebote (gesponserte Links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
CockroachCloud: Get your applications to market faster with a fully managed CockroachDB instance. Leave the daily maintenance, security, and operations of your database to us, and spend more time building apps and running your business.SingleStore Managed Service: The world's fastest, modern cloud database for both operational (OLTP) and analytical (OLAP) workloads. Available instantly with multi-cloud and hybrid-cloud capabilitiesTiDB Cloud: Fully-managed TiDB Service. Bring everything great about TiDB to the cloud.
ImplementierungsspracheGoC++, GoGo, Rust
Server BetriebssystemeLinux
macOS
Windows
Linux info64 bit version requiredLinux
Datenschemadynamic schemajaja
Typisierung infovordefinierte Datentypen, z.B. float oder datejajaja
XML Unterstützung infoVerarbeitung von Daten in XML Format, beispielsweise Speicherung von XML-Strukturen und/oder Unterstützung von XPath, XQuery, XSLTneinneinnein
Sekundärindizesjajaja
SQL infoSupport of SQLyes, wire compatible with PostgreSQLyes infobut no triggers and foreign keysja
APIs und andere ZugriffskonzepteJDBCCluster Management API infoas HTTP Rest and CLI
HTTP API
JDBC
ODBC
JDBC
ODBC
Proprietäres Protokoll
Unterstützte ProgrammiersprachenC#
C++
Clojure
Go
Java
JavaScript (Node.js)
PHP
Python
Ruby
Rust
Bash
C
C#
Java
JavaScript (Node.js)
Python
Ada
C
C#
C++
D
Delphi
Eiffel
Erlang
Haskell
Java
JavaScript (Node.js)
Objective-C
OCaml
Perl
PHP
Python
Ruby
Scheme
Tcl
Server-seitige Scripts infoStored Proceduresneinjanein
Triggersneinneinnein
Partitionierungsmechanismen infoMethoden zum Speichern von unterschiedlichen Daten auf unterschiedlichen Knotenhorizontal partitioning (by key range) infoall tables are translated to an ordered KV store and then broken down into 64MB ranges, which are then used as replicas in RAFTSharding infohash partitioninghorizontal partitioning (by key range)
Replikationsmechanismen infoMethoden zum redundanten Speichern von Daten auf mehreren KnotenMulti-source replication using RAFTSource-Replica Replikation infostores two copies of each physical data partition on two separate nodesUsing Raft consensus algorithm to ensure data replication with strong consistency among multiple replicas.
MapReduce infoBietet ein API für Map/Reduce Operationenneinnein infocan define user-defined aggregate functions for map-reduce-style calculationsja infowith TiSpark Connector
Konsistenzkonzept infoMethoden zur Sicherstellung der Konsistenz in einem verteilten SystemImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Fremdschlüssel inforeferenzielle Integritätjaneinnein infocurrently only supported in syntax
Transaktionskonzept infoUnterstützung zur Sicherstellung der Datenintegrität bei nicht-atomaren DatenmanipulationenACIDACIDACID
Concurrency infoUnterstützung von gleichzeitig ausgeführten Datenmanipulationenjayes, multi-version concurrency control (MVCC)ja
Durability infoDauerhafte Speicherung der Datenjaja infoAll updates are persistent, including those to disk-based columnstores and memory-based row stores. Transaction commits are supported via write-ahead log.ja
In-Memory Unterstützung infoGibt es Möglichkeiten einige oder alle Strukturen nur im Hauptspeicher zu haltenneinjanein
Berechtigungskonzept infoZugriffskontrolleRole-based access controlFine grained access control via users, groups and rolesUsers with fine-grained authorization concept. No user groups or roles.
Weitere Informationen bereitgestellt vom Systemhersteller
CockroachDBSingleStore infoformer name was MemSQLTiDB
Specific characteristicsCockroachDB is a cloud-native, distributed SQL database architected for modern applications....
» mehr
SingleStore offers a fully-managed , distributed, highly-scalable SQL database designed...
» mehr
TiDB is an open-source NewSQL database built by PingCAP. TiDB supports Hybrid Transactional...
» mehr
Competitive advantages- EFFORTLESS SCALE: Scale your applications, not operational complexity. CockroachDB...
» mehr
SingleStore’s competitive advantages include: Easy and Simplified Architecture with...
» mehr
In the current database landscape, infrastructure engineers often have to use one...
» mehr
Typical application scenariosSystem of record (financial ledger, inventory management, transaction record), identity...
» mehr
Driving Fast Analytics: SingleStore delivers the fastest and most scalable reporting...
» mehr
TiDB is designed to support both OLTP and OLAP scenarios. You can use TiDB , the...
» mehr
Key customersComcast, eBay, DoorDash, Mythical Games, Norfolk Southern, LUSH, Bose, Shipt, MyDoc,...
» mehr
IEX Cloud : Improves Financial Data Distribution Speed 15x with Singlestore DB Comcast,...
» mehr
Shopee (E-commerce) BookMyShow.com (E-commerce) Yiguo.com (E-commerce) JD Cloud &...
» mehr
Market metrics6.7K+ long-running clusters 2.2K+ CockroachDB Self-Hosted clusters 10.5K+ CockroachDB...
» mehr
Customers in various industries worldwide including US and International Industry...
» mehr
25K+ GitHub Stars for TiDB, and 8K+ GitHub Stars for TiKV 1.6K+ members in TiDB Community...
» mehr
Licensing and pricing models- Apache 2.0 for core features released up to and including the 19.1 release - Time-limited...
» mehr
F ree Tier and Enterprise Edition
» mehr
Open Source Apache 2.0 with either commercial licensing or fully-hosted DB-as-a-service...
» mehr

Zugehörige Produkte und Dienstleistungen

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

Weitere Ressourcen
CockroachDBSingleStore infoformer name was MemSQLTiDB
Konferenzen und Veranstaltungen

Distributed SQL Architecture: A Primer on Rowstore and Columnstore Databases
Webinar, 10am PST, 1. Februar 2022

Databases and DevOps. TechTalk with Joe Karlsson (SingleStore) and Rizel Scarlett (GitHub)
Webinar, 9 am PST, 9. Februar 2022

Migrating from PostgreSQL to Drive 20-100x Faster Performance
Webinar, 10am PST, 15. Februar 2022

Erwähnungen in aktuellen Nachrichten

CockroachDB Strengthens Change Data Capture
24. Januar 2022, iProgrammer

Cockroach Labs Wants to Take on AWS
13. Januar 2022, Bloomberg

CockroachDB database creator Cockroach Labs raises $278M
16. Dezember 2021, VentureBeat

CockroachDB, the database that just won't die
15. Juli 2021, TechCrunch

Cockroach Labs Announces CockroachDB Serverless
19. Oktober 2021, InfoQ.com

bereitgestellt von Google News

PingCAP Introduces its New Developer Tier to Boost Application Innovation with TiDB Cloud
9. November 2021, PRNewswire

PingCAP announces Public Preview of TiDB Cloud USA - English
10. Mai 2021, PRNewswire

PingCap TiDB 5.3 Supports Both High Volume Transaction Processing and Real-Time Analytics
4. Januar 2022, Database Trends and Applications

SD Times Open-Source Project of the Week: TiDB
5. November 2021, SDTimes.com

PingCAP Enhances Support for Data Intensive Applications with TiDB 5.3
7. Dezember 2021, PRNewswire

bereitgestellt von Google News

Jobangebote

Human Resources Generalist
Cockroach Labs, New York, NY

Workplace Facilities Lead
Cockroach Labs, New York, NY

HR Business Partner, Revenue & Marketing
Cockroach Labs, United States

Vice President - Microservices
JPMorgan Chase Bank, N.A., Plano, TX

Recruiting Coordinator
Cockroach Labs, New York, NY

Applied ML Engineer
MindsDB, Houston, TX

Software Engineer, Managed Service
SingleStore, North Carolina

Software Engineer, Database Engine
SingleStore, Research Triangle Park, NC

Database Performance Engineer
SingleStore, Oregon

Software Engineer, University Graduate
SingleStore, San Francisco, CA

Software Engineer, Storage and Caching
Pinterest, United States

Senior HR Business Partner, North America
PingCAP, Remote

Sales Account Executive- Remote
PingCAP, Remote

Senior Recruiter, North America Business
PingCAP, Remote

Engineering Manager, Cash App Pay
Cash App, Ontario, CA

jobs by Indeed



Teilen sie diese Seite mit ihrem Netzwerk

Featured Products

AllegroGraph logo

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

Couchbase logo

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

Datastax Astra logo

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

Neo4j logo

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

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Präsentieren Sie hier Ihr Produkt