DB-EnginesExtremeDB: mitigate connectivity issues in a DBMSEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > CockroachDB vs. Google Cloud Bigtable vs. OpenTSDB vs. SAP SQL Anywhere

System Properties Comparison CockroachDB vs. Google Cloud Bigtable vs. OpenTSDB vs. SAP SQL Anywhere

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameCockroachDB  Xexclude from comparisonGoogle Cloud Bigtable  Xexclude from comparisonOpenTSDB  Xexclude from comparisonSAP SQL Anywhere infoformerly called Adaptive Server Anywhere  Xexclude from comparison
DescriptionCockroachDB 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.Google's NoSQL Big Data database service. It's the same database that powers many core Google services, including Search, Analytics, Maps, and Gmail.Scalable Time Series DBMS based on HBaseRDBMS database and synchronization technologies for server, desktop, remote office, and mobile environments
Primary database modelRelational DBMSKey-value store
Wide column store
Time Series DBMSRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score6.15
Rank#55  Overall
#33  Relational DBMS
Score3.26
Rank#92  Overall
#13  Key-value stores
#8  Wide column stores
Score1.68
Rank#146  Overall
#12  Time Series DBMS
Score4.25
Rank#79  Overall
#43  Relational DBMS
Websitewww.cockroachlabs.comcloud.google.com/­bigtableopentsdb.netwww.sap.com/­products/­technology-platform/­sql-anywhere.html
Technical documentationwww.cockroachlabs.com/­docscloud.google.com/­bigtable/­docsopentsdb.net/­docs/­build/­html/­index.htmlhelp.sap.com/­docs/­SAP_SQL_Anywhere
DeveloperCockroach LabsGooglecurrently maintained by Yahoo and other contributorsSAP infoformerly Sybase
Initial release2015201520111992
Current release23.1.1, May 202317, July 2015
License infoCommercial or Open SourceOpen Source infoApache 2.0, commercial license availablecommercialOpen Source infoLGPLcommercial
Cloud-based only infoOnly available as a cloud servicenoyesnono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageGoJava
Server operating systemsLinux
macOS
Windows
hostedLinux
Windows
AIX
HP-UX
Linux
OS X
Solaris
Windows
Data schemedynamic schemaschema-freeschema-freeyes
Typing infopredefined data types such as float or dateyesnonumeric data for metrics, strings for tagsyes
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.nononoyes
Secondary indexesyesnonoyes
SQL infoSupport of SQLyes, wire compatible with PostgreSQLnonoyes
APIs and other access methodsJDBCgRPC (using protocol buffers) API
HappyBase (Python library)
HBase compatible API (Java)
HTTP API
Telnet API
ADO.NET
HTTP API
JDBC
ODBC
Supported programming languagesC#
C++
Clojure
Go
Java
JavaScript (Node.js)
PHP
Python
Ruby
Rust
C#
C++
Go
Java
JavaScript (Node.js)
Python
Erlang
Go
Java
Python
R
Ruby
C
C#
C++
Delphi
Java
JavaScript (Node.js)
Perl
PHP
Python
Ruby
Server-side scripts infoStored proceduresnononoyes, in C/C++, Java, .Net or Perl
Triggersnononoyes
Partitioning methods infoMethods for storing different data on different nodeshorizontal 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 RAFTShardingSharding infobased on HBasenone
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replication using RAFTInternal replication in Colossus, and regional replication between two clusters in different zonesselectable replication factor infobased on HBaseSource-replica replication infoDatabase mirroring
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyesnono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate consistency (for a single cluster), Eventual consistency (for two or more replicated clusters)Immediate Consistency infobased on HBaseImmediate Consistency
Foreign keys infoReferential integrityyesnonoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDAtomic single-row operationsnoACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.nononoyes
User concepts infoAccess controlRole-based access controlAccess rights for users, groups and roles based on Google Cloud Identity and Access Management (IAM)nofine grained access rights according to SQL-standard

More information provided by the system vendor

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
CockroachDBGoogle Cloud BigtableOpenTSDBSAP SQL Anywhere infoformerly called Adaptive Server Anywhere
DB-Engines blog posts

Time Series DBMS are the database category with the fastest increase in popularity
4 July 2016, Matthias Gelbmann

show all

Recent citations in the news

CockroachDB 23.2 Enhances Enterprise Architectures with Improved Postgres Compatibility and Built-in Resilience
18 January 2024, PR Newswire

CockroachDB tempts legacy databases to crawl into the cloud age
29 January 2024, The Register

How to Unlock Real-Time Data Streams with CockroachDB and Amazon MSK | Amazon Web Services
6 November 2023, AWS Blog

How DoorDash Migrated from Aurora Postgres to CockroachDB
5 December 2023, The New Stack

Cockroach Entices High-End Legacy Workloads with v23.2
18 January 2024, Datanami

provided by Google News

Google expands BigQuery with Gemini, brings vector support to cloud databases
29 February 2024, VentureBeat

Google Introduces Autoscaling for Cloud Bigtable for Optimizing Costs
31 January 2022, InfoQ.com

Review: Google Bigtable scales with ease
7 September 2016, InfoWorld

Google scales up Cloud Bigtable NoSQL database
27 January 2022, TechTarget

Google Cloud makes it cheaper to run smaller workloads on Bigtable
7 April 2020, TechCrunch

provided by Google News

Comparing Different Time-Series Databases
10 February 2022, hackernoon.com

Brain Monitoring with Kafka, OpenTSDB, and Grafana
5 August 2016, KDnuggets

MapR to help admins peer into dense Hadoop clusters
28 June 2016, SiliconANGLE News

Comparing InfluxDB, TimescaleDB, and QuestDB Timeseries Databases
30 June 2021, Towards Data Science

A real-time processing revival – O'Reilly
1 April 2015, oreilly.com

provided by Google News

SAP vulnerabilities Let Attacker Inject OS Commands—Patch Now!
11 July 2023, CybersecurityNews

SAP Again Named a Leader in 2021 Gartner® Magic Quadrant™ for Cloud Database Management Systems
16 December 2021, SAP News

Rimini Street expands support beyond SAP and Oracle
11 June 2022, InsideSAP

SAP Products & Services Data Portfolio
2 July 2021, Datamation

SAP launches HANA cloud platform, partners with Siemens, Intel
6 May 2015, Channel Daily News

provided by Google News



Share this page

Featured Products

RaimaDB logo

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

Neo4j logo

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

SingleStore logo

Build AI apps with Vectors on SQL and JSON with milliseconds response times.
Try it today.

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

Milvus logo

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

Present your product here