ApsaraDB for ClickHouse

ApsaraDB for ClickHouse is a distributed column-oriented database service that provides real-time analysis. ApsaraDB for ClickHouse is high-performance and easy to use. ApsaraDB for ClickHouse meets various enterprise requirements. It is widely used in traffic analysis, marketing analysis, behavior analysis, crowd division, customer profiles, agile BI, data marts, network monitoring, distributed services, and link monitoring.

Recommended Specs

15% OFF

Single-Replica Edition Single-Replica, Low Cost, and High Performance

A High-Performance Cloud-Native ClickHouse Service

Scenarios

  • Analyzes more than 100 million log records
  • Solves the write bottlenecks and stability issues of open-source Elasticsearch
  • Supports user selection, real-time marketing, behavior analysis, and customer profiles

Specs

CPU 8 Cores or Up | 2 Nodes or Up | Single Replica

Buy Now

15% OFF

High-Availability Edition Double-Replica, DR Support, and High Availability

A High-Performance Cloud-Native ClickHouse Service

Scenarios

  • Analyzes more than 100 million log records
  • Solves the write bottlenecks and stability issues of open-source Elasticsearch
  • Supports vertical and horizontal scaling of nodes

Specs

CPU 8 Cores or Up | 2 Nodes or Up | Double Replica

Buy Now

Benefits

Lower Cost and Better Performance

Supports efficient SIMD instruction sets and a vectored execution engine. Improves query performance over 100 to 1000 times compared with traditional databases. Supports column-level high compression rate.

Enterprise-Level Management

Supports balancing and scaling during data redistribution, multi-tenant resource isolation, online database management, development task orchestration, and comprehensive data integration.

Ease of Use

Allows you to configure clusters, replicas, parameters, network security settings, and O&M systems with ease.

Comprehensive O&M and Technical Support

Provides monitoring and diagnosis systems for disks, CPU, memory, IOPS, database connections, read and write volume, TPS, ZooKeeper, and slow SQL queries. Provides technical support in real-time.

Features

Real-Time Analysis Based on Data Lakehouse Architecture

Provides compatible and open source services, optimized kernel, and professional technical support

Tiered Hot and Cold Data Storage

Supports data management based on hot storage usage and TTL, and automatic data movement based on specified policies. This reduces storage costs.

Integration with OSS and MaxCompute

Supports data imports from OSS and MaxCompute external tables and analyzes data based on the Data Lake architecture at low costs

Resource Queue

Supports creating multiple resource queues and binding users to the queues. Allows you to isolate resources based on users and define query priorities. Supports dynamic resource optimization of multiple queues

Comprehensive and Efficient Data Integration

Supports data imports from multiple sources to build a real-time data warehouse

Real-Time Computing Services

Supports real-time data writing from Flink, Spark, and Kafka

Big Data Services

Supports data synchronization from big data services, such as DataWorks and Data Management, and Directed Acyclic Graph (DAG)-based task scheduling

Database Services

Supports synchronizing database data using MaterializeMySQL, MySQL external tables, DataWorks, and Data Transmission Service

Easy-to-Use and Cloud-Native Features

Provides comprehensive O&M features to reduce costs

Auto Scaling

Supports cluster auto scaling to ensure balanced data distribution

Monitoring Alert

Provides monitoring and diagnosis systems for disks, CPU, memory, IOPS, database connections, read and write volume, TPS, ZooKeeper, and slow SQL queries. Provides technical support in real-time

Online Database Management

Supports online account management, network management, cluster parameter configuration, slow query management, and data dictionary management

Typical Scenario

Quantitative Backtesting Analysis Based on Massive Historical Market Data

Financial companies engaged in quantitative trading typically use quantitative trading strategies and algorithms for investment. High-quality algorithms and high-quality quantitative backtesting are crucial for business profitability. Therefore, quantitative traders usually use the latest trading algorithms to test and review historical time-series data to determine profitability, a process known as backtesting. The complexity of the backtest model determines the number of parameters provided, such as initial capital, risk capital (%), portfolio size, commissions, average bid-ask spread, and benchmarks (e.g., S&P 500 index), helping traders evaluate the effectiveness of the latest trading strategies. Additionally, traders use current algorithms to backtest funds based on real-time trading conditions, track volatility, and predict future returns.

Solution Advantages

  • Efficient Real-Time Analysis Performance

    Wide table query performance of ApsaraDB for ClickHouse is about 900 times that of MySQL and 10 times that of ElasticSearch.

  • Flexibility

    MPP architecture of ApsaraDB for ClickHouse provides 50-200MB/s data writing capability per node, with linear scalability by adding nodes.

  • Rich Functions

    ApsaraDB for ClickHouse offers 150+ built-in functions for high-precision calculations with time-series data using time window functions, facilitating time-series data aggregation analysis.

  • Low Cost

    ApsaraDB for ClickHouse features cold-hot data tiered storage capability, allowing data archiving to low-cost storage, reducing storage costs by over 85%.

Recommendations

Customer Profile Analysis

Performs multi-dimensional analysis on user behaviors based on logs. Supports real-time business monitoring and real-time operations using screens

The Benefits of Our Solution

  • Efficient Analysis

    Provides efficient analysis capabilities. Queries for 100 billion log entries are completed within 30 seconds. 95% of the queries for 100 million log entries are completed within 5 seconds.

  • Comprehensive Data Integration

    Supports data imports from multiple big data services

  • Efficient Writing

    Provides high throughput and supports writing 10 billion log entries per hour during peak periods

User Selection and Precision Marketing

Analyzes historical data and cleans real-time user behavior data. Allows you to select required users for marketing based on the historical tags and real-time tags to increase daily active users (DAU).

The Benefits of Our Solution

  • Efficient Analysis

    Improves aggregation analysis performance 5 to 10 times over compared to traditional log analysis solutions. Queries for 100 million log entries are completed within milliseconds.

  • Efficient and Stable Writing

    Prevents OOM problems when writing a large amount of log data compared with Elasticsearch. Provides a write speed of 50 to 200 MB/s

Advertising Evaluation and User Profiles

Performs multi-dimensional analysis on a large amount of user data, identifies users for advertising, and evaluates advertising costs. Creates user profiles, evaluates advertising accuracy, and estimates expected profits.

The Benefits of Our Solution

  • Efficient Analysis

    Performs online analysis to identify users for advertising. Queries for 100 million data records in wide tables are completed within seconds.

phone Contact Us