ApsaraDB for SelectDB is a fully managed real-time analytical database service on Alibaba Cloud, built on SelectDB and 100% compatible with Apache Doris. It handles sub-second queries across massive datasets, supports tens of thousands of concurrent point queries, and uses a compute-storage separation architecture to reduce costs—without the overhead of managing infrastructure.
Why ApsaraDB for SelectDB
ApsaraDB for SelectDB addresses the following challenges:
Query latency under load: Dashboards slow down as concurrent users grow, or complex analytical queries take too long to return results.
Scaling complexity: Adding capacity to your analytical layer is disruptive and requires manual intervention.
High storage costs: Your data warehouse couples compute and storage, making it expensive to retain large historical datasets.
Integration friction: Maintaining separate data warehouses and data lakes adds ETL complexity and increases latency.
Key capabilities
| Capability | Details |
|---|---|
| Performance | Ranks first in query performance and second in write performance on ClickBench, a global benchmark for analytical databases. Responds to queries within sub-seconds and handles tens of thousands of concurrent point queries. |
| Elasticity | Scale clusters up or down within minutes. Supports auto scaling and on-demand start and stop to improve resource utilization. Use subscription billing for steady workloads or pay-as-you-go for short-term or variable workloads. Storage is billed by default based on actual data stored. |
| Ease of use | Deploy in a few clicks. Compatible with the MySQL protocol and standard SQL—no new query language to learn. Provides a visualized and simple interface for O&M. Distributed cluster management is handled automatically. |
Use cases
Online reporting with high concurrency
Build real-time report systems that stay fast under heavy user load. ApsaraDB for SelectDB supports real-time data ingestion, sub-second query response, and deployment in highly available clusters—giving end users a consistent experience regardless of traffic spikes.
User profiling and behavior analysis
Build a customer data platform (CDP) that keeps up with rapid schema changes. Add columns within milliseconds or use dynamic tables to adapt to evolving business requirements. Built-in behavior analysis functions reduce development effort, and orthogonal bitmap operations group users within seconds for real-time profiling.
Modern data lakehouses
Unify your data warehouse and data lake on a single platform. ApsaraDB for SelectDB supports high-performance business intelligence (BI) reports, ad hoc analysis, and incremental data processing for extract, transform, and load (ETL) and extract, load, and transform (ELT) pipelines—eliminating the need to maintain separate systems for each workload.
Log storage and analysis
Integrate ApsaraDB for SelectDB with your existing log infrastructure to query logs in real time, reduce log storage costs, and process large log volumes efficiently. The compute-storage separation architecture makes it practical to retain more log history without proportionally increasing costs.