Arenadata QuickMarts

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.

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.

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.

An aggregate function computes a single result from a set of input values. For example, you can calculate the sum, average, maximum, or minimum over a set of rows.

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.

This article describes the parameters that can be configured for ADQM services via ADCM.

Learn about the minimum hardware requirements for servers of an ADQM cluster.

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.

A projection is an additional hidden table that stores data from a source table in an alternative form to be optimal for executing some type of queries.

This article describes how to create an ADQM cluster via the ADCM interface.