×
SQL

PostgreSQL Convergence Filtering Optimization for Segment SQL with Multiple Range Conditions

This article discusses convergence conditions when there are multiple range conditions (with examples).

Databricks Data Insight Open Course - An Introduction to Delta Lake (Commercial Edition)

This part of the Databricks Data Insight Open Course article series introduces Delta Lake Basics (Commercial Edition).

An Interpretation of the Source Code of OceanBase (5): Life of Tenant

This article explains information related to the multi-tenant architecture of OceanBase.

An Interpretation of the Source Code of OceanBase (3): Life of Partition

This article introduces the storage layer of OceanBase and the life of a partition.

An Interpretation of OceanBase Database Source Code (1): Module Structure

This article introduces the overall architecture and module composition of the OceanBase database code and the functions of each module.

An Interpretation of the Source Code of OceanBase (2): Life of SQL

This article focuses on the main path of an execution process of SQL in OceanBase, including the process of receiving, processing, and feedback to the client.

OceanBase Rewriting Series: Subquery Promotion

Part 2 of the OceanBase Rewriting Series focuses on the strategy of rewriting subqueries in existential determination predicates into SEMI/ANTI JOIN.

OceanBase Rewriting Series: An Overview of the OceanBase Query Rewriting Practices

Part 1 of the OceanBase Rewriting Series focuses on OceanBase query rewriting practices.

A Method for MaxCompute-UNION Data Type Alignment

This short article discusses conversion issues in UNION and problem-solving tactics.

How PostgreSQL Returns a Dynamic Number of Columns: Row-Column Convert

This article reviews some scenarios where users want an SQL statement to return a dynamic number of columns, including examples.

ProjectName Automatically Completed under ODPS SQL Development and Production Environment of DataWorks

This article discusses a specific scenario where you can use the DataWorks process parameters feature without frequently modifying the project name.

How to Write a High-Performance SQL Join: Implementation and Best Practices of Joins

This article aims to sort the usage and internal implementation of joins.

Senior Technical Experts from Alibaba Discuss Data Warehouse Tuning – Part 2

Part 2 of this 2-part series explains data warehouse AnalyticDB through different usage scenarios and discusses popular FAQs.

Use Command Line on the Terminal to Implement Visualized Analysis of Logs

This article describes how to use the MySQL protocol for visualized analysis of logs.

How to Configure Alibaba Cloud Hybrid Backup Recovery to Backup Objects from OSS Buckets

This article explains how to configure Alibaba Cloud Hybrid Backup Recovery (HBR) to backup objects from OSS buckets.

Query Resolution of MySQL 8.0 Optimizer

This article introduces how MySQL 8.0 optimizer turns a simple string into an execution sequence the database executor can return the data to the client.

Query Transformation of MySQL 8.0 Optimizer

This article introduces the complex transformation process of subqueries, partitioned tables, and JOIN operations.

An Introduction and Best Practice of DataWorks Data Quality

Part 8 of this 10-part series introduces DataWorks Data Quality and its best practices.

How to Run a SQL Server on ApsaraDB for RDS

This article explains how to run a SQL Server on ApsaraDB for RDS.

DataWorks Data Modeling - A Package of Data Model Management Solutions

Part 4 of this 10-part series thoroughly explains DataWorks data modeling.