Database Kernel

About Database Kernel | PolarDB IMCI Streamlines Complex Subqueries

This article explains the key technology of subquery unnesting in In-memory column index (IMCI).

About Database Kernel: Why Do We Need to Evolve to PolarDB for MySQL 8.0.2?

This article provides a detailed overview of the evolution of PolarDB for MySQL from its initial development to its current state.

About Database Kernel | PolarDB X-Engine: Building a Cost-Effective Transaction Storage Engine

This article introduces the performance impact of using OSS as the underlying storage medium for X-Engine and discusses its suitability for different query scenarios.

About Database Kernel | How to Analyze Semi-Structured Data Efficiently Through PolarDB IMCI

This article describes traditional database and data warehouse solutions and delves into the technical aspects of PolarDB's IMCI columnar JSON.

About Database Kernel | PolarDB Query Optimization: Predicate Pushdown

This article describes the definition of predicate pushdown and why databases should perform predicate pushdown.

About Database Kernel | PolarDB Optimizer Query Transformation: IN-List Transformation

This article focuses on the IN-list transformation of PolarDB, which showcases the query rewriting capabilities of PolarDB.

About Database Kernel | Deep Analysis on the Optimization and Evolution of PolarDB DDL Locks

This article provides an overview of the experience and progress in end-to-end Metadata Lock (MDL) lock management in Alibaba Cloud PolarDB.

About Database Kernel | PolarDB Optimizer Query Transformation - Join Condition Pushdown

This article introduces the concept of join condition pushdown of query transformation in database optimization.

About Database Kernel | PolarDB Optimizer Query Transformation - Join Elimination

This article describes a heuristic query transformation implemented by PolarDB called join elimination.

About Database Kernel | PolarDB Optimizer Query Transformation - Window Functions

This article introduces a method that utilizes the capabilities of window aggregate functions to decorrelate subqueries.

About Database Kernel | Learn about PolarDB IMCI Optimization Techniques

This article describes the query pruning technology of PolarDB IMCI.

About Database Kernel | What Happens to Distributed Databases When Two Machines Are Hung Up?

This article aims to answer one question – what happens to distributed databases when two machines are hung up? – (with examples).

About Database Kernel | How Does PolarDB HTAP Implement IMCI Query Optimization?

This article uses the join reorder of Polar DB MySQL In-Memory Column Index (IMCI) to describe the query optimization process of PolarDB HTAP.

About Database Kernel | Accelerate HTAP Long Tail Requests and Analyze PolarDB IMCI Row-Column Fusion

This article describes the design of the basic components of the row-column fusion execution architecture of PolarDB.