DB-EnginesExtremeDB: the mission critical dbmsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Alibaba Cloud ApsaraDB for PolarDB vs. CrateDB vs. Google Cloud Bigtable vs. mSQL vs. MySQL

System Properties Comparison Alibaba Cloud ApsaraDB for PolarDB vs. CrateDB vs. Google Cloud Bigtable vs. mSQL vs. MySQL

Editorial information provided by DB-Engines
NameAlibaba Cloud ApsaraDB for PolarDB  Xexclude from comparisonCrateDB  Xexclude from comparisonGoogle Cloud Bigtable  Xexclude from comparisonmSQL infoMini SQL  Xexclude from comparisonMySQL  Xexclude from comparison
DescriptionA cloud-native relational database compatible with MySQL, PostgreSQL, and Oracle. Designed for business critical applications.Distributed Date Store based on LuceneGoogle's NoSQL Big Data database service. It's the same database that powers many core Google services, including Search, Analytics, Maps, and Gmail.mSQL (Mini SQL) is a simple and lightweight RDBMSWidely used open source RDBMS
Primary database modelRelational DBMSRelational DBMS
Search engine
Key-value store
Wide column store
Relational DBMSRelational DBMS infoKey/Value like access via memcached API
Secondary database modelsDocument store
Time Series DBMS
Document store
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.52
Rank#237  Overall
#113  Relational DBMS
Score0.97
Rank#178  Overall
#86  Relational DBMS
#13  Search engines
Score4.26
Rank#86  Overall
#14  Key-value stores
#6  Wide column stores
Score1.72
Rank#136  Overall
#66  Relational DBMS
Score1202.10
Rank#2  Overall
#2  Relational DBMS
Websitewww.alibabacloud.com/­product/­polardbcrate.iocloud.google.com/­bigtablehughestech.com.au/­products/­msqlwww.mysql.com
Technical documentationwww.alibabacloud.com/­help/­doc-detail/­58764.htmcrate.io/­docscloud.google.com/­bigtable/­docsdev.mysql.com/­doc
DeveloperAlibabaCrateGoogleHughes TechnologiesOracle infosince 2010, originally MySQL AB, then Sun
Initial release2013201519941995
Current release4.4, October 20218.0.29, April 2022
License infoCommercial or Open SourcecommercialOpen Sourcecommercialcommercial infofree licenses can be providedOpen Source infoGPL version 2. Commercial licenses with extended functionallity are available
Cloud-based only infoOnly available as a cloud serviceyesnoyesnono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
ScaleGrid for MySQL: Fully managed MySQL hosting on AWS, Azure and DigitalOcean with high availability and SSH access on the #1 multi-cloud DBaaS.
Implementation languageJavaCC and C++
Server operating systemshostedAll OS with a Java 7 (and higher) VMhostedAIX
HP-UX
Linux
OS X
Solaris SPARC/x86
Windows
FreeBSD
Linux
OS X
Solaris
Windows
Data schemeyesFlexible Schema (defined schema, partial schema, schema free)schema-freeyesyes
Typing infopredefined data types such as float or dateyesyesnoyesyes
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.yesnononoyes
Secondary indexesyesyesnoyesyes
SQL infoSupport of SQLyesyes, but no triggers and constraintsnoA subset of ANSI SQL is implemented infono subqueries, aggregate functions, views, foreign keys, triggersyes infowith proprietary extensions
APIs and other access methodsJDBC
ODBC
ADO.NET infocommunity maintained client
JDBC
MQTT (Message Queue Telemetry Transport)
PostgreSQL wire protocol
Prometheus Remote Read/Write
RESTful HTTP API
gRPC (using protocol buffers) API
HappyBase (Python library)
HBase compatible API (Java)
JDBC
ODBC
ADO.NET
JDBC
ODBC
Proprietary native API
Supported programming languagesJava
Python
Erlang
Go infocommunity maintained client
Java
JavaScript (Node.js) infocommunity maintained client
Perl infocommunity maintained client
PHP
Python
Ruby infocommunity maintained client
Scala infocommunity maintained client
C#
C++
Go
Java
JavaScript (Node.js)
Python
C
C++
Delphi
Java
Perl
PHP
Tcl
Ada
C
C#
C++
D
Delphi
Eiffel
Erlang
Haskell
Java
JavaScript (Node.js)
Objective-C
OCaml
Perl
PHP
Python
Ruby
Scheme
Tcl
Server-side scripts infoStored proceduresyesuser defined functionsnonoyes infoproprietary syntax
Triggersyesnononoyes
Partitioning methods infoMethods for storing different data on different nodesSharding infoImplicit feature of the cloud serviceShardingShardingnonehorizontal partitioning, sharding with MySQL Cluster or MySQL Fabric
Replication methods infoMethods for redundantly storing data on multiple nodesyes infoImplicit feature of the cloud serviceselectable replication factorInternal replication in Colossus, and regional replication between two clusters in different zonesnoneMulti-source replication
Source-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonoyesnono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyEventual Consistency
Read Your Own Writes Consistency infofor primary key lookups
Immediate consistency (for a single cluster), Eventual consistency (for two or more replicated clusters)noneImmediate Consistency
Foreign keys infoReferential integrityyesnononoyes infonot for MyISAM storage engine
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDno infounique row identifiers can be used for implementing an optimistic concurrency control strategyAtomic single-row operationsnoACID infonot for MyISAM storage engine
Concurrency infoSupport for concurrent manipulation of datayesyesyesnoyes infotable locks or row locks depending on storage engine
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.yesnononoyes
User concepts infoAccess controlfine grained access rights according to SQL-standardrights management via user accountsAccess rights for users, groups and roles based on Google Cloud Identity and Access Management (IAM)noUsers with fine-grained authorization concept infono user groups or roles
More information provided by the system vendor
Alibaba Cloud ApsaraDB for PolarDBCrateDBGoogle Cloud BigtablemSQL infoMini SQLMySQL
Specific characteristicsApsaraDB for PolarDB is a cloud-native relational database 100% compatible with MySQL...
» more
CrateDB is an open source distributed SQL database that spreads data and processing...
» more
Competitive advantagesWebinar: Top Scientists Live: Tech Secrets to Double 11's Success Revealed. White...
» more
CrateDB is typically used in operational analytics applications, particularly those...
» more
Typical application scenariosCreating a Robust Cloud-Based Database for Fintech, E-Commerce and Gaming. Learn...
» more
CrateDB is ideal for integrating and analyzing streams of data--often machine-generated--in...
» more
Key customersCrateDB customers include McAfee, Qualtrics , Nokia, NBC Golfnow , Digital Domain...
» more
Market metricsThe CrateDB open source project was started in 2014. CrateDB was the winner of TechCrunch...
» more
Licensing and pricing modelsSpecification and pricing. You can use either of the following billing methods to...
» more
CrateDB pricing CrateDB Community Edition is open source and free to use under the...
» 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 partiesNavicat for MySQL is the ideal solution for MySQL/MariaDB administration and development.
» more

Arctype: A fast, beautiful database GUI for developers and teams. Download it for free today.
» more

Percona: Database problems? Not on your watch.
Databases run better with Percona.
» more

CData: Connect to Big Data & NoSQL through standard Drivers.
» more

SQLFlow: Provides a visual representation of the overall flow of data. Automated SQL data lineage analysis across Databases, ETL, Business Intelligence, Cloud and Hadoop environments by parsing SQL Script and stored procedure.
» more

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

More resources
Alibaba Cloud ApsaraDB for PolarDBCrateDBGoogle Cloud BigtablemSQL infoMini SQLMySQL
DB-Engines blog posts

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

MariaDB strengthens its position in the open source RDBMS market
5 April 2018, Matthias Gelbmann

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

show all

Recent citations in the news

Alibaba Cloud vs AWS | Cloud Provider Comparison | ITBE
6 October 2021, IT Business Edge

Alibaba Cloud reports 50% revenue year-over-year growth and named a Leader in CDM by Gartner
19 January 2022, DataCenterNews Asia

An introduction to Alibaba cloud offerings
28 September 2020, TechTarget

provided by Google News

CrateDB 4.5 takes distributed SQL database open source
24 March 2021, TechTarget

Crate.io raises $10M to grow its database platform
15 June 2021, VentureBeat

Crate.io Expands CrateDB Cloud with the Launch of CrateDB Edge
15 April 2021, GlobeNewswire

Crate.io extends database service offering to Google Cloud
13 April 2022, VentureBeat

CrateDB Tackles Machine Analytics with Scale-Out SQL Database
14 December 2016, Datanami

provided by Google News

Google Needs Another Database To Attack Oracle, DB2, And SQL Server Directly
16 May 2022, The Next Platform

Database as a Service (DBaaS) Provider Market 2022 Segments Analysis by Top Key Players :IBM, Zoho Creator, Ninox, AWS, Oracle, MongoDB Atlas, Beats, Azure, Aiven, Kintone, Fusioo, Google Cloud Bigtable, SAP, DataStax, Caspio – The Daily Vale
24 May 2022, The Daily Vale

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

Google's Data Cloud Summit Serves Up Incremental New Capabilities
25 April 2022, Forbes

Google Cloud Improves SLA for Bigtable and Adds New Security Features
19 June 2021, InfoQ.com

provided by Google News

How to Optimize Your Database Storage in MySQL
23 May 2022, HackRead

How to set up a MySQL database in Linux
25 April 2022, TechTarget

Steps to Install MySQL on Ubuntu 22.04 LTS Jammy Linux
14 May 2022, Linux Shout

Akamai launches managed database offering for MySQL, PostgreSQL, Redis and MongoDB
25 April 2022, SiliconANGLE News

Using PHP, how do I copy selected records from one mysql database to another on different hosts (thus different connections)
17 May 2022, SitePoint

provided by Google News

Job opportunities

Database Architect
Aptos, Atlanta, GA

Data Pipeline Engineer III, Search Engineering
Mailchimp, Oakland, CA

Senior Cloud Operations Engineer
Aptos, Atlanta, GA

Data Warehouse Architect with Snowflake
Data Warehouse Architect, California City, CA

Data Engineer
HTC Global Services, Inc., Dearborn, MI

Data Platform Engineer
JPMorgan Chase Bank, N.A., Plano, TX

Google Cloud Data Engineer
Slalom Consulting, Boise, ID

Data Architect - Teradata
Miracle Software Systems, Illinois

Financial Systems Integration Specialist
Intel, Hillsboro, OR

MySQL Database Developer
Agama Solutions, San Francisco, CA

Mid-Level PHP/MySQL Programmer/Developer
ApplicantPro, Remote

MySQL Database Migration Specialist Using Laravel
Chiro Cat, Remote

A&R Representative
OtterTune, Remote

MySQL Developer
Computers for Kids, Inc., Boise, ID

jobs by Indeed



Share this page

Featured Products

Redis logo

The world’s most loved real‑time data platform.
Try free

The definitive guide for Cassandra

Imagine What You Could Do if Scalability Wasn‘t a Problem!
Download the Cassandra e-book for 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!

Vertica logo

Vertica Accelerator. The fastest analytics and machine learning, delivered as SaaS, with automated setup, administration, and management. Free trial.

Present your product here