×
Structured Query Language

Introducing SLS Materialized Views: Accelerate Large-Scale Log Queries by 100x and Cut Resource Use by 90%

This article introduces SLS Materialized Views, which speed up log queries by 100x and cut resource use by 90% via pre-computation and auto query rewriting.

Evolution of Processing: SPL One-Click Acceleration for Log-to-Metric Conversion

This article introduces SPL's one-click acceleration for converting logs to metrics, enhancing performance, observability, and data processing efficiency.

Evolution of Text-to-SQL Technology - An Analysis of Alibaba Cloud OpenSearch-SQL

This article mainly introduces the latest development and technical details of Alibaba Cloud OpenSearch in Text-to-SQL tasks.

The Principle of SQL Optimizer

All well-known open-source products (such as MySQL, Spark, and Presto) have optimizers. This article explains the principle of SQL optimizers with an easy-to-understand approach.

Relational Algebra and SQL Syntax – Part 1

Part 1 of this series introduces the theoretical basis and focuses on various high-end SQL operations.

Relational Algebra and SQL Syntax – Part 2

Part 2 of this series focuses on various SQL syntaxes.

Design and Practice of Self-Developed SQL Parser

This article introduces the parser technology and its current situation in the industry, including problems, design and practice, and performance improvements.