×
Relational Database

Open Source PolarDB Uses parray_gin to Implement Efficient Fuzzy Searches for Elements in Arrays and JSON

This article focuses on how the open-source version of PolarDB utilizes parray_gin to implement efficient fuzzy searches for elements in arrays and JSON.

Open Source PolarDB Uses duckdb_fdw to Support Parquet and Efficient OLAP

This article describes how open source PolarDB uses duckdb_fdw to support parquet, a columnar storage file format, and efficient OLAP.

Introducing Alibaba Cloud ApsaraDB for MyBase - An IaaS Relational Database

This article introduces Alibaba Cloud ApsaraDB for MyBase, which is an IaaS relational database service.

Breaking the Limits of Relational Database in Cloud Native Era

Learn how Alibaba Cloud deep dive into its next-generation database and overcome limits of relational database in cloud native era.

How Does the IMCI of PolarDB for MySQL Achieve Ultimate TopK Query Performance?

This article introduces how the IMCI feature of the cloud-native relational database PolarDB addresses such challenges and ultimately outperforms ClickHouse.

Seven Papers from Alibaba Cloud Database Selected by VLDB

This short article discusses some of the seven papers from Alibaba Cloud included at VLDB 2022.

How to Set up and Configure Alibaba Cloud ApsaraDB for PolarDB

This article explains how to set up and configure Alibaba Cloud ApsaraDB for PolarDB.

How to Create a MySQL Backup and Migrate a Database to Alibaba Cloud

The article covers two methods to create a MySQL backup and transfer a database to Alibaba Cloud: using the mysqldump utility and dbForge Studio for MySQL.

Setup EMR Yarn authentication using Active Directory with Apache Knox

A guide to configure integration between Alibaba Cloud EMR with Active Directory.

MariaDB vs. MongoDB – Which One Should I Choose?

This article explains the differences between MariaDB and MongoDB.

架站教學:建立雲端資料庫

手把手教學如何使用阿里雲架設與託管網站系列,本文為第六則雲端資料庫。

Alibaba Cloud ApsaraDB RDS for SQL Server Champions Fully Managed Databases in the Emerging Chinese Cloud Market

This blog highlights the benefits of ApsaraDB for RDS on SQL Server and builds on the features set to show the strength of the Alibaba Cloud platform

Running Microsoft SQL Server in an Alibaba Cloud ECS Instance

This article explains how to run a Microsoft SQL Server in an Alibaba Cloud ECS instance.

Build a Personalized Recommendation System on Alibaba Cloud in Three Steps

This article explains how to build a personalized recommendation system by illustrating a news recommendation system using AnalyticDB for PostgreSQL.

Query Performance Optimization – Runtime Filter

In this blog, we'll introduce Runtime Filters and discuss how it can help improve query performance of the Join operation for databases.

How to Return MySQL Data in JSON Format With PHP On Ubuntu 20.04 Server

In this guide, you'll set up a simple MySQL database and then use some PHP functions to retrieve and convert data in JSON format.

Query Optimization Technology for Correlated Subqueries

This article describes what correlated subqueries are and how to rewrite correlated subqueries as SQL queries in common semantics.

Fast and Cost-effective MySQL Analysis Solution Based on Alibaba Cloud DLA

This article discusses the data analysis challenges related to MySQL databases and explores how the Alibaba Cloud Data Lake Analytics platform can help.

Lonch Group Cuts O&M Costs by 50% by Migrating to Alibaba Cloud

This article explains how Alibaba Cloud helped a pharmaceutical company cut its direct database cost and O&M cost by migrating its core ERP system and databases to the cloud.

How Can We Combine PostgreSQL and MySQL to Make the Whole Greater than the Sum of the Parts? (Part 2)

In this blog series, we'll show you how to combine both ApsaraDB RDS for PostgreSQL and MySQL to enhance business value.