Exploring Alibaba Cloud`s diverse Database Ofering
Tags: alibabacloud, cloud, database
Published: 2023-09-08 10:01:49

>**Note:** ✋ This post was originally published on my blog [wiki-cloud.co](https://wiki-cloud.co/en/2023/09/exploring-alibabacloud-diverse-database-ofering/)

In today's world of technology, the data is the engine that drives innovation and business growth. Efficient data management is essential for any organization, and Alibaba Cloud has been positioned as one of the leaders in providing cloud database solutions according to the latest Magic Quadrant™ of Gartner®.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/m36mjr4gxdysu3l1havz.png)

In this article, we'll explore Alibaba Cloud's diverse and robust database offering, ranging from relational databases to NoSQL databases and distributed data management systems. We'll discover how these solutions can drive operational efficiency, scalability, and data security.

**Database Services Portfolio**

Alibaba Cloud has a wide range of database services for both relational and NoSQL (Not Only SQL) databases.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/1bztn1odk3i2qe53u90j.png)

**<u>Cloud Database Dedicated Cluster (CDDC)</u>**

Autonomous and controllable database service cluster on Alibaba Cloud.

| Service        | Description |
|----------------|-------------|
|![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/jzk8iwfa7qxhl13m4fbk.png)[ApsaraDB for MyBase](https://www.alibabacloud.com/product/cddc?spm=a3c0i.247269.9942033750.1.76b26959bupNLm) **New** | A highly cost-effective cloud database service on a dedicated cluster that provides over-provisioning, hybrid deployment, resource scheduling, and more authority. ApsaraDB for MyBase currently supports MySQL, PostgreSQL and SQL Server databases. It provides dedicated cloud resources, supports over-commitment of resources and autonomous operations and maintenance, and allows users to grant account permissions on databases and operating systems. You can purchase multiple hosts to form a cluster, and deploy different types of database instances in the cluster to achieve hybrid deployment. This can help you meet diverse business needs and increase resource utilization.|

**<u>Online Transaction Processing (OLTP)</u>**

Comprehensive relational transactional database products on Alibaba Cloud.

| Service                | Description |
|------------------------|-------------|
|![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/5nq5wu5uhdnvvnfqen5a.png)[PolarDB](https://www.alibabacloud.com/product/polardb?spm=a3c0i.247269.9942033750.2.76b26959bupNLm)              | Alibaba Cloud PolarDB is a cloud-native relational database service that decouples computing resources from storage resources and uses integrated software and hardware to provide secure and reliable services with high performance, auto scaling capabilities within seconds, and a large storage capacity. PolarDB is 100% compatible with MySQL and PostgreSQL and is highly compatible with the Oracle syntax.PolarDB provides three editions with different engines: PolarDB for MySQL, PolarDB for PostgreSQL, and PolarDB for Xscale.         |
|![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/qg239yfl5oaz7cqeckq8.png)[ApsaraDB RDS for MySQL](https://www.alibabacloud.com/product/apsaradb-for-rds-mysql?spm=a3c0i.247269.9942033750.3.76b26959bupNLm)          | ApsaraDB for MySQL is a database management service provided by Alibaba Cloud that enables businesses to efficiently host and manage MySQL databases, one of the most popular options in the world of relational databases, in the cloud. This service has been designed to simplify the management and deployment of MySQL databases, freeing companies from the responsibility of managing the underlying infrastructure. It currently supports versions 5.5, 5.6, 5.7, and 8.0.         |
|![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/gxyuog6bord8br7b8kdd.png)[ApsaraDB RDS for PostgreSQL](https://www.alibabacloud.com/product/apsaradb-for-rds-postgresql?spm=a3c0i.247269.9942033750.4.76b26959bupNLm)  | ApsaraDB for PostgreSQL is a fully managed relational database service that offers high availability, scalability, and security. It is based on PostgreSQL, an open source relational database that is known for its performance, scalability, and flexibility.         |
|![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/hy3k95c8gtw1dli0imrc.png)[ApsaraDB RDS for SQL Server](https://www.alibabacloud.com/product/apsaradb-for-rds-sql-server?spm=a3c0i.247269.9942033750.5.76b26959bupNLm)  | ApsaraDB for SQL Server is a database management service provided by Alibaba Cloud that enables enterprises to efficiently host and manage Microsoft SQL Server databases in the cloud. ApsaraDB for SQL Server offers high availability, scalability, and strong security measures, making it a reliable solution for applications and services that rely on SQL Server in a cloud environment.         |
|![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/uf6aelrf9gcoobkwo99l.png)[ApsaraDB RDS for MariaDB](https://www.alibabacloud.com/products/apsaradb-for-rds-mariadb?spm=a3c0i.247269.9942033750.6.76b26959bupNLm)  | ApsaraDB RDS for MariaDB is fully compatible with the open source MariaDB, supports Oracle syntax, and is designed with multiple enterprise database features. It uses multiple storage engines, including MySQL InnoDB, to meet different business requirements.         |
|![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/j3j0vebnx5e5nnvfgina.png)[PolarDB for Xscale](https://www.alibabacloud.com/product/polardb-x?spm=a3c0i.247269.9942033750.7.76b26959bupNLm)  | PolarDB-X is a cloud-native distributed database developed by Alibaba Cloud. It is compatible with the MySQL syntax and provides scale-out capabilities, financial-grade high availability, and hybrid transaction/analytical processing (HTAP) functionality. It distributes business workloads to multiple compute and storage nodes and is designed to address database challenges such as ultra-high concurrency, massive data storage, and large table performance bottlenecks.         |

**<u>No SQL</u>**

Semi-structure or non-structured databases built for superior performance.

| Service                | Description |
|------------------------|-------------|
|![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/k6xzc9gvy7he04ej18cs.png)[ApsaraDB for Redis](https://www.alibabacloud.com/product/apsaradb-for-redis?spm=a3c0i.247269.9942033750.8.76b26959bupNLm)              | ApsaraDB for Redis includes the community version of Redis and the enterprise version of Tair (fully compatible with Redis), which supports primary-secondary, clustering and read-write separation architectures, low latency, high throughput and elastic scalability, and provides services in real-time.         |
|![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/l3vib5lrghi98iaf8xsv.png)[Tair](https://www.alibabacloud.com/product/tair?spm=a3c0i.247269.9942033750.9.6dfb6959NuMY5M) **New**              | Tair is a Redis-compatible in-memory database service that provides a variety of data structures and enterprise-level capabilities such as Global Distributed Cache, data flashback, and Transparent Data Encryption (TDE).         |
|![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/4ij8ob4oakemhdvs2a8i.png)[ApsaraDB for MongoDB](https://www.alibabacloud.com/product/apsaradb-for-mongodb?spm=a3c0i.247269.9942033750.10.76b26959bupNLm)              | ApsaraDB for MongoDB is a fully managed, non-relational database service that offers high availability, scalability, and security. It is based on MongoDB, a non-relational database that uses JSON documents to store data. It currently supports the ReplicaSet and Sharding architectures and can be quickly deployed in just a few steps. ApsaraDB for MongoDB’s highly available service includes automatic monitoring, backup, and disaster tolerance capabilities. This frees you from time-consuming database management tasks and lets you focus on your applications and core business.         |
|![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/ce8t196qag8s0dugq8bt.png)[ApsaraDB for HBase](https://www.alibabacloud.com/product/hbase?spm=a3c0i.247269.9942033750.11.76b26959bupNLm)              | ApsaraDB for HBase is a highly optimized NoSQL database (enterprise edition is available as [Lindorm](https://www.alibabacloud.com/blog/lindorm-alibaba-clouds-newest-cloud-native-multi-model-database_596269)) that is completely compatible with the community edition of HBase. Thanks to this compatibility and integration with Spark, Phoenix, and Solr, ApsaraDB for HBase is easy to use and offers superior stability and cost performance. ApsaraDB for HBase can easily support high throughput and high concurrency scenarios, providing support for real-time volumetric data storage, full-text indexing, lightweight SQL queries, as well as time space and series queries.         |
|![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/7s30mpezhk3imeycne96.png)[InfluxDB®](https://www.alibabacloud.com/product/hitsdb_influxdb?spm=a3c0i.247269.9942033750.12.76b26959bupNLm)              | TSDB for InfluxDB® is a cost-effective online time series database service that offers high availability and auto scaling. TSDB for InfluxDB® is widely adopted in diverse scenarios. For example, you can use TSDB for InfluxDB® to monitor industrial production processes for security concerns, Internet infrastructure, and containers. You can also use TSDB for InfluxDB® to monitor and analyze business operations, remotely monitor IoT devices in real time, assess production quality, and perform fault backtracking.         |
|![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/ddj18y8ae8z0s985iht8.png)[Lindorm](https://www.alibabacloud.com/product/lindorm?spm=a3c0i.247269.9942033750.13.76b26959bupNLm) **New**              | Lindorm is an elastic cloud-native database service that supports multiple data models. It is capable of processing various types of data and is compatible with multiple database engine, such as Apache HBase®, Apache Cassandra®, and OpenTSDB.         |

**<u>Online Analytical Processing (OLAP)</u>**

World leading cloud data warehouse and data lake services built for extreme fast analytics.

| Service                | Description |
|------------------------|-------------|
|![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/q48myfn3za5smx4fw0o3.png)[AnalyticDB for MySQL](https://www.alibabacloud.com/products/analyticdb-for-mysql?spm=a3c0i.247269.9942033750.14.76b26959bupNLm)              | AnalyticDB for MySQL is a high-performance data warehousing service that is secure, stable, and easy to use. It allows you to easily create online statistical reports, multidimensional analysis solutions, and real-time data warehouses. AnalyticDB for MySQL uses a distributed computing architecture that enables it to use the elastic scaling capability of the cloud to compute tens of billions of data records in real time. AnalyticDB for MySQL stores data based on relational models and can use SQL to flexibly compute and analyze data. It provides various visualization and ETL tools to make enterprise data processing easier.         |
|![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/75wpd27oezb3pbjjsypb.png)[AnalyticDB for PostgreSQL](https://www.alibabacloud.com/product/hybriddb-postgresql?spm=a3c0i.247269.9942033750.15.76b26959bupNLm)           |ApsaraDB AnalyticDB for PostgreSQL is an online MPP (Massively Parallel Processing) data warehousing service based on the open source Greenplum Database. ApsaraDB AnalyticDB for PostgreSQL provides online expansion and performance monitoring service to free your team from complicated MPP cluster operations and management (O&M).         |
|![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/khovwf3nkjtmh9b8ncnu.png)[AnalyticDB for ClickHouse](https://www.alibabacloud.com/product/clickhouse?spm=a3c0i.247269.9942033750.16.76b26959bupNLm) **New**             | ApsaraDB for ClickHouse is a distributed column-oriented database service that provides real-time analysis. It is widely used in traffic analysis, marketing analysis, behavior analysis, crowd division, customer profiles, agile BI, data marts, network monitoring, distributed services, and link monitoring.         |

**<u>Database Management Tools</u>**

The highway and utilities for database ecosystem on cloud.

| Service                | Description |
|------------------------|-------------|
|![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/rcvqzju3up9aqbqmutsz.png)[Data Transmission Service (DTS)](https://www.alibabacloud.com/product/data-transmission-service?spm=a3c0i.247269.9942033750.17.76b26959bupNLm)              | Data Transmission Service (DTS) helps you migrate data between data storage types, such as relational database, NoSQL, and OLAP. The service supports homogeneous migrations as well as heterogeneous migration between different data storage types. DTS also can be used for continuous data replication with high availability. In addition, DTS can help you subscribe to the change data function of ApsaraDB for RDS. With DTS, you can easily implement scenarios such as data migration, remote real time data backup, real time data integration and cache refresh.        |
|![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/3c379h4565ooaq56bmhz.png)[Database Backup (DBS)](https://www.alibabacloud.com/products/database-backup?spm=a3c0i.247269.9942033750.18.76b26959bupNLm)              | Database Backup (DBS) is a secure and cost-efficient solution for continuous data protection. The service offers strong protection for data stored in multiple environments, such as enterprise data centers, hybrid clouds, public clouds, and third-party cloud vendors.         |
|![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/0bo8j3to0ngo7xz0yom6.png)[Data Management (DMS)](https://www.alibabacloud.com/product/data-management-service?spm=a3c0i.247269.9942033750.19.76b26959bupNLm)              | DMS supports unified management of multiple databases including relational databases such as MySQL, SQL Server, PostgreSQL, PolarDB, DRDS, OceanBase, Oracle and etc., data warehouse related databases such as AnalyticDB, Data Lake Analytics, ClickHouse and other OLAP databases, and NoSQL databases such as MongoDB, Redis and others. It is a comprehensive data management service covering data management, structure management, user authorization, security auditing, trend analysis, and data tracing. DMS provides an easy-to-use portal for the centralized management of databases and servers to ensure more secure data, more efficient management and clearer data value.         |
|![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/5kb9tkgnawhzj94q6ub1.png)[Database Autonomy Service (DAS)](https://www.alibabacloud.com/product/das?spm=a3c0i.247269.9942033750.20.76b26959bupNLm)              | Database Autonomy Service (DAS) is a cloud service that implements self-perception, self-repair, self-optimization, self-O&M, and self-security of databases based on machine learning and expert experience. DAS eliminates the complexity of database management and service failures caused by manual operations, and ensures the stability, security, and efficiency of database services.         |

**Conclusión**

Alibaba Cloud's database offering is diverse and adaptable to a wide range of business needs. Whether you need a highly available relational database, a scalable NoSQL database, or distributed data management systems, Alibaba Cloud has a solution that can help drive efficiency and innovation in your organization. By leveraging these cutting-edge technologies, businesses can be future-proofed and get the most out of their data assets. In future articles I will go into detail on each of the Alibaba Cloud database services.

I hope this information is useful.

Best Regards,

**Follow me:**

> 👉[Wiki Cloud](http://wiki-cloud.co/) | 👉[Twitter](https://twitter.com/johnbulla) | 👉[LinkedIn](https://www.linkedin.com/in/johnbulla) | 👉[Youtube](https://www.youtube.com/user/johnbulla)