ApsaraDB for SelectDB is a fully managed service of the next-generation real-time data warehouse SelectDB on Alibaba Cloud. ApsaraDB for SelectDB is 100% compatible with Apache Doris. You can conveniently purchase the SelectDB service on Alibaba Cloud to meet your requirements for analyzing large amounts of data.
Benefits
Cost-effectiveness
High performance: ApsaraDB for SelectDB can respond to queries in large amounts of data within sub-seconds, handle tens of thousands of concurrent point queries, and perform complex analysis with high throughput. ApsaraDB for SelectDB ranks first in terms of query performance and second in terms of write efficiency in ClickBench, which is a global benchmark for analytical databases.
Low cost: ApsaraDB for SelectDB uses a compute-storage separation architecture, which significantly reduces storage costs. ApsaraDB for SelectDB also provides the auto scaling and on-demand start and stop capabilities to improve the utilization of computing resources and reduce costs.
Flexibility and elasticity
You can purchase computing and cache resources by using the subscription billing method for long-term and stable business. You can purchase computing and cache resources by using the pay-as-you-go billing method for short-term business that frequently changes. By default, you are charged for storage resources based on the actual amount of data that you store.
You can change the configurations of clusters and scale clusters within minutes.
Ease of use
ApsaraDB for SelectDB is an out-of-the-box service that can be deployed with a few clicks.
ApsaraDB for SelectDB is compatible with the MySQL protocol. You can use ApsaraDB for SelectDB by using the standard SQL syntax.
ApsaraDB for SelectDB provides a visualized and simple interface for O&M.
ApsaraDB for SelectDB supports automatic management of distributed clusters.
Scenarios
Online report systems that support large concurrent access
You can use ApsaraDB for SelectDB to build an online report system that supports large concurrent access. ApsaraDB for SelectDB allows you to provide a real-time, fast, stable, and highly available report service. ApsaraDB for SelectDB supports real-time data writes, responds to queries within sub-seconds, handles a large number of concurrent point queries, and supports service deployment in highly available clusters.
User profiling and behavior analysis
You can use ApsaraDB for SelectDB to build a customer data platform (CDP). ApsaraDB for SelectDB allows you to add columns to a table within milliseconds or use dynamic tables to flexibly respond to business changes. ApsaraDB for SelectDB supports various behavior analysis functions, which simplify development and improve efficiency. ApsaraDB for SelectDB also supports orthogonal bitmaps to group users within seconds for user profiling.
Modern data lakehouses
ApsaraDB for SelectDB integrates data warehouses and data lakes into a single platform, which can be used to provide high-performance business intelligence (BI) reports, ad hoc analysis, and incremental data processing for extract, transform, and load (ETL) or extract, load, and transform (ELT).
Log storage and analysis
You can integrate ApsaraDB for SelectDB with a log system. This allows you to query logs in real time, store logs in a cost-effective way, and efficiently process logs. This reduces the overall costs of an enterprise log system and improves the performance and reliability of the log system.