×
OLAP

New Features of PolarDB-X HTAP: Clustered Columnar Index (CCI)

This article introduces the Clustered Columnar Index Features of PolarDB-X HTAP.

Revolutionize Analytics with Alibaba Cloud’s Hologres

This article explores the benefits, features, and real-world scenarios that make Hologres a game-changer in the realm of interactive analytics.

Open Source PolarDB Uses postgresql_hll to Accelerate UV Sliding Analysis and Real-time Recommendations

This article describes how open source PolarDB uses postgresql_hll to to achieve efficient UV (Unique Visitor) sliding analysis and real-time recommendation for filtered read lists.

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.

Learning about Distributed Systems – Part 25: Kylin in a New Way

Part 25 of this series introduces Apache Kylin and its concept of “space for time.”

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.

รู้จักกับ PolarDB หนึ่งใน Database ที่อยู่เบื้องหลัง Double 11 Festival

PolarDB เป็น หนึ่งใน Database ที่มีบทบาทสำคัญในเหตุการณ์ Double 11 Global Festival อันโด่งดัง ของ Alibaba Group

A Comparison of Data Modeling Methods for Big Data

Organizations need to invest in appropriate data models to draw insights from them. This article gives an overview of data modeling methods and introduces Alibaba Cloud’s Big Data modeling practices.

ApsaraDB for ClickHouse Part1 - Introduction to ClickHouse

In this part of the ClickHouse video tutorial, we will introduce the background and features of the ClickHouse, as well as the features of Column-oriented database and some use cases.

Quick Path to Build OLTP (RDS MySQL) & OLAP (AnalyticDB MySQL) Cluster with Data Synchronization Channel

This tutorial shows you how to build OLTP (RDS MySQL) & OLAP (AnalyticDB MySQL) cluster with data synchronization channel quickly.

Cloud Forward Episode 4: Cloud-Native Database - PolarDB | HTAP (In-Memory Column Index)

HTAP can help cut down your O&M, and PolarDB's In-Memory Column Index feature allows you to meet OLTP and OLAP requirements with one system.

How to Build a Blazing-Fast Data Lake Analytics Engine

This article reveals the key technologies of the data lake analytics engine in detail and uses StarRocks to help users understand the architecture of the system.

How to Build a Cloud-Native Open-Source Big Data Platform | The Application Practice of Weimiao

This article shares the application practice of Weimiao based on the big data ecosystem of Alibaba Cloud.

Source Code Analysis of ClickHouse Keeper

This article analyzes the source code of the open-source version of ClickHouse v21.8.10.19-lts.

The Open-Source Real-Time Data Warehouse Solution Based on EMR OLAP - ClickHouse Transaction Implementation

This article describes the solution of an open-source real-time data warehouse based on EMR OLAP.

Crowd Selection and Data Service Practices Based on MaxCompute & Hologres

This article describes how to use MaxCompute to add tags to a large number of people and carry out analysis and modeling through Hologres.

Secret Weapon | How AnalyticDB Strongly Supports Double 11

This article discusses the benefits of AnalyticDB for MySQL and how it helped during Double 11.

Detailed Explanation of Query Rewriting Based on Materialized Views

This article describes the definition of materialized view for databases and ways to rewrite queries based on it.

Use Flink Hudi to Build a Streaming Data Lake

This article introduces the optimization and evolution of Flink Hudi's original mini-batch-based incremental computing model through stream computing.