Arenadata QuickMarts
Arenadata QuickMarts (ADQM) is a cluster column-oriented DBMS built on ClickHouse. ADQM generates various online analytical reports based on vast amounts of information stored in flat marts. ADQM is much faster than traditional DBMS.
For effective administration of ADQM databases, it is recommended to use ADQM Control — a related product that provides extensive functionality for monitoring and analyzing the state of DBMS at the level of tables, columns, user queries, and cluster hosts.
TOP-10 popular articles
Sharding is a database design principle that suggests locating parts of the same table on different shards. A shard is a cluster node that can consist of one or more replicas. Replicas are servers that duplicate data within a shard. SELECT and INSERT queries can be sent to any replica of a shard, there is no dedicated master.
Learn about the minimum hardware requirements for servers of an ADQM cluster.
This article provides examples that demonstrate how to perform the basic operations with ADQM/ClickHouse tables using the clickhouse-client console client.
Indexing is a technique to improve database performance. Indexes are special data structures that allow a database server to quickly find requested rows by values of a key column (or column set) without a full table scan.
This article describes the parameters that can be configured for ADQM services via ADCM.
ADQM writes general and error text logs that can be useful for analyzing the causes of different errors. Additionally, you can enable logs of other types (for example, collect information about query execution, dependent views, threads, stack traces) that will be saved to special system tables in ADQM.
Learn about the minimum software requirements for servers of an ADQM cluster.
A window function performs a calculation across a set of rows: all rows in a query are divided into groups (windows), and each group has its own aggregates. It does not return a single output row as an aggregate function. A window function adds an aggregated value to each row of the selection result in a separate column.
Chproxy is an HTTP proxy that you can use for balancing the load and distributing access to an ADQM database.
ADQM comes with the adqm-clickhouse-copier package, which is installed by default on all hosts with the ADQMDB service during ADQM installation. This package provides the functionality of clickhouse-copier allowing you to copy large amounts of data between clusters of different topologies and reshard data.