DB-EnginesExtremeDB: the first and only COTS deterministic embedded database management system for mission- and safety-critical hard real-time applicationsEnglish
Deutsch
Informationen zu relationalen und NoSQL DatenbankmanagementsystemenEin Service von solid IT

DBMS > CockroachDB vs. Microsoft Azure SQL Database vs. SingleStore

Vergleich der Systemeigenschaften CockroachDB vs. Microsoft Azure SQL Database vs. SingleStore

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

Redaktionelle Informationen bereitgestellt von DB-Engines
NameCockroachDB  Xaus Vergleich ausschliessenMicrosoft Azure SQL Database infofrüher SQL Azure  Xaus Vergleich ausschliessenSingleStore infoformer name was MemSQL  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.Relationaler Datenbankdienst aus der Cloud mit großer Kompatibilität zum Microsoft SQL ServerMySQL 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 type
Primäres DatenbankmodellRelational DBMSRelational DBMSRelational DBMS
Sekundäre DatenbankmodelleDocument Store
Graph DBMS
Spatial DBMS
Document Store
Spatial DBMS
Time Series DBMS
DB-Engines Ranking infomisst die Popularität von Datenbankmanagement- systemenranking trend
Trend Chart
Punkte6,97
Rang#58  Overall
#32  Relational DBMS
Punkte86,32
Rang#14  Overall
#9  Relational DBMS
Punkte6,66
Rang#59  Overall
#33  Relational DBMS
Websitewww.cockroachlabs.comazure.microsoft.com/­en-us/­services/­sql-databasewww.singlestore.com
Technische Dokumentationwww.cockroachlabs.com/­docsdocs.microsoft.com/­en-us/­azure/­azure-sqldocs.singlestore.com
EntwicklerCockroach LabsMicrosoftSingleStore Inc.
Erscheinungsjahr201520102013
Aktuelle Version21.1.2, Juni 2021V127.6, November 2021
Lizenz infoCommercial or Open SourceOpen Source infoApache 2.0, commercial license availablekommerziellkommerziell infofree developer edition available
Ausschließlich ein Cloud-Service infoNur als Cloud-Service verfügbarneinjanein
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 capabilities
ImplementierungsspracheGoC++C++, Go
Server BetriebssystemeLinux
macOS
Windows
gehostetLinux info64 bit version required
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, XSLTneinjanein
Sekundärindizesjajaja
SQL infoSupport of SQLyes, wire compatible with PostgreSQLjayes infobut no triggers and foreign keys
APIs und andere ZugriffskonzepteJDBCADO.NET
JDBC
ODBC
Cluster Management API infoas HTTP Rest and CLI
HTTP API
JDBC
ODBC
Unterstützte ProgrammiersprachenC#
C++
Clojure
Go
Java
JavaScript (Node.js)
PHP
Python
Ruby
Rust
.Net
C#
Java
JavaScript (Node.js)
PHP
Python
Ruby
Bash
C
C#
Java
JavaScript (Node.js)
Python
Server-seitige Scripts infoStored ProceduresneinTransact SQLja
Triggersneinjanein
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 partitioning
Replikationsmechanismen infoMethoden zum redundanten Speichern von Daten auf mehreren KnotenMulti-source replication using RAFTja, immer mindestens 3 Replikas vorhandenSource-Replica Replikation infostores two copies of each physical data partition on two separate nodes
MapReduce infoBietet ein API für Map/Reduce Operationenneinneinnein infocan define user-defined aggregate functions for map-reduce-style calculations
Konsistenzkonzept infoMethoden zur Sicherstellung der Konsistenz in einem verteilten SystemImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Fremdschlüssel inforeferenzielle Integritätjajanein
Transaktionskonzept infoUnterstützung zur Sicherstellung der Datenintegrität bei nicht-atomaren DatenmanipulationenACIDACIDACID
Concurrency infoUnterstützung von gleichzeitig ausgeführten Datenmanipulationenjajayes, multi-version concurrency control (MVCC)
Durability infoDauerhafte Speicherung der Datenjajaja infoAll updates are persistent, including those to disk-based columnstores and memory-based row stores. Transaction commits are supported via write-ahead log.
In-Memory Unterstützung infoGibt es Möglichkeiten einige oder alle Strukturen nur im Hauptspeicher zu haltenneinja
Berechtigungskonzept infoZugriffskontrolleRole-based access controlBenutzer mit feingranularem Berechtigungskonzept entsprechend SQL-StandardFine grained access control via users, groups and roles
Weitere Informationen bereitgestellt vom Systemhersteller
CockroachDBMicrosoft Azure SQL Database infofrüher SQL AzureSingleStore infoformer name was MemSQL
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
Competitive advantages- EFFORTLESS SCALE: Scale your applications, not operational complexity. CockroachDB...
» mehr
SingleStore’s competitive advantages include: Easy and Simplified Architecture with...
» 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
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
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
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

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

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

Weitere Ressourcen
CockroachDBMicrosoft Azure SQL Database infofrüher SQL AzureSingleStore infoformer name was MemSQL
DB-Engines Blog Posts

PostgreSQL is the DBMS of the Year 2020
4. Januar 2021, Paul Andlinger, Matthias Gelbmann

Cloud-based DBMS's popularity grows at high rates
12. Dezember 2019, Paul Andlinger

The popularity of cloud-based DBMSs has increased tenfold in four years
7. Februar 2017, Matthias Gelbmann

alle anzeigen

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 database creator Cockroach Labs raises $278M
16. Dezember 2021, VentureBeat

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

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

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

Introducing CockroachDB 21.2: Survive and Thrive in a Distributed World
16. November 2021, PRNewswire

bereitgestellt von Google News

Data 2022 outlook, part one: Will data clouds get easier? Will streaming get off its own island?
3. Januar 2022, ZDNet

Understanding Dirty Reads: What NOLOCK Does to Your Queries
21. Januar 2022, Redmondmag.com

Microsoft builds distributed ledger for Azure SQL database
26. Mai 2021, TechTarget

Microsoft's cloud-connected on-prem database: SQL Server 2022 rolls out in private preview
2. November 2021, ZDNet

How To Automate Tasks in Azure SQL Database
22. Januar 2021, Redmondmag.com

bereitgestellt von Google News

Real-time database platform SingleStore raises $80M more, now at a $940M valuation
8. September 2021, TechCrunch

What's Next: Managing Data in Cloud Native Environments – The New Stack
18. Januar 2022, thenewstack.io

Database startup SingleStore raises $80M
8. September 2021, VentureBeat

SingleStore says it's the world's first database to support analytical and transactional workloads
23. Juni 2021, SiliconANGLE News

What's Changed: 2021 Gartner Magic Quadrant for Cloud Database Management Systems
13. Januar 2022, Solutions Review

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

Recruiting Coordinator
Cockroach Labs, New York, NY

Sales Development Representative
Cockroach Labs, Dutch, WV

Azure SQL Database Administrator
General Motors, Austin, TX

Azure Data Engineer
Samay Consulting, Inc, Remote

Advisor Azure SQL Database Administrator (DBA)
Gainwell Technologies, Texas

Azure SQL Database Administrator - Managed Services
3Cloud, Illinois

ETL Developer
BOTG Solutions Pvt. Ltd, Austin, TX

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

Software Engineer, University Graduate
SingleStore, Seattle, WA

Software Engineer, University Graduate
SingleStore, San Francisco, CA

Distributed Database Administrator, Core Technology Infrastructure
Bank of America, Charlotte, NC

Software Engineer, University Graduate
SingleStore, Raleigh, NC

jobs by Indeed



Teilen sie diese Seite mit ihrem Netzwerk

Featured Products

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

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

Couchbase logo

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

AllegroGraph logo

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

Neo4j logo

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

Präsentieren Sie hier Ihr Produkt