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
This article describes the parameters that can be configured for ADQM services via ADCM.
The JOIN clause combines columns from two tables into a new table. A set of data rows in a resulting table depends on the JOIN type and the specified join conditions.
Learn about the minimum hardware requirements for servers of an ADQM cluster.
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 software requirements for servers of an ADQM cluster.
This article discusses a typical ADQM cluster — three shards, each one consists of two replicas (in other words, a distributed cluster of 3 nodes with a replication factor of 2).
A materialized view calculates intermediate aggregate states for data from a source table according to the SELECT query, which is specified in the view definition, and saves the results to its internal table or to a separate target table.
A dictionary is a key/value data store that is fully or partially stored in the RAM of the ADQM server and can be used as a reference to substitute data values by keys in the final sample.
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 how to resolve an issue with an unsupported encryption type that may occur when you install ADQM on a RED OS host and try to kerberize a cluster using Active Directory.