Arenadata DB
Arenadata DB (ADB) is a distributed analytical data storage built on the open-source massively parallel Greenplum DBMS and designed to store and process large amounts of structured and semi-structured data (up to tens of petabytes).
TOP-10 popular articles
Partitioning is a way to increase query performance by logical dividing large tables (such as fact tables) into smaller, more manageable parts called partitions. Due to partitioning query optimizers can read the limited number of table rows (based on predicate conditions) instead of scanning all the table contents each time.
Distribution is one of the most important concepts underlying ADB. It means storing table rows on different segments of the cluster. The more uniform the distribution of the data between segments is — the higher the whole cluster performance is. All segments should contain approximately equal portions of data.
Currently, you can work with ADBM via the Arenadata DB Control (ADB Control) web interface.
ADB 6 release notes. Learn about new features, improvements, bug fixes, etc.
Learn how to install ADB ClickHouse Connector.
Arenadata DB Backup Manager (ADBM) is a fault-tolerant system for ADB binary backups management, which is built on the base of pgBackRest.
Spill files (also known as work files) are created on disks if there is not enough memory to store temporary data when executing data queries. This temporary data may include JOIN hashes, sorting results, redistributed tables, etc.
Schema is a logical union of objects within a single database. In comparison with databases, schemas are not rigidly separated: users can access multiple schemas at a time (if they have the necessary privileges).
Server configuration parameters (also known as Global User Configuration, GUC) allow ADB administrators to manage the DBMS state and configuration. Many of these parameters have the same names and behaviors as in PostgreSQL.
This article describes the parameters that can be configured for ADB services via ADCM.