What is ApsaraDB for SelectDB?
ApsaraDB for SelectDB is a fully managed real-time analytical database on Alibaba Cloud, built on SelectDB and fully compatible with Apache Doris. It delivers sub-second queries across massive datasets, supports tens of thousands of concurrent point queries, and separates compute from storage to reduce costs.
Why ApsaraDB for SelectDB
ApsaraDB for SelectDB addresses these common analytical workload challenges:
-
Query latency under load: Dashboards slow down as concurrent users grow, and 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: Coupled compute and storage in your data warehouse makes it expensive to retain large historical datasets.
-
Integration friction: Maintaining separate data warehouses and data lakes adds ETL complexity and latency.
Key capabilities
| Capability | Details |
|---|---|
| Performance | Ranks first in query performance and second in write performance on ClickBench, a global analytical database benchmark. Delivers sub-second query responses 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 for better 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 visual O&M console, and distributed cluster management is fully automated. |
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 responses, and highly available cluster deployments—delivering 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 needs. 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 BI reports, ad hoc analysis, and incremental data processing for ETL and ELT pipelines—eliminating 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 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.