RT.Warehouse DBMS

Main article: Database Management System (DMS)

RT.Warehouse - import-independent assembly Greenplum - massive-parallel DBMS for building analytical data storage facilities.

2022: Features, Capabilities and Features

RT.Warehouse is a DBMS that is well adapted for OLAP load profiles and big data operations - allows you to combine petabytes of information into a single storage and build end-to-end analytics, quickly processing queries to data arrays. This is achieved by the fact that RT.Warehouse distributes information across multiple servers (segments). This distribution also guarantees the reliability of data storage - if one segment fails, the data will not be lost and will be available for analysis.

RT.Warehouse is integrated with RT.ClusterManager - this allows you to easily and flexibly scale the data warehouse infrastructure: you can add new servers and segments through a visual interface in one click.

Key features and capabilities of RT.Warehouse as of July 2022:

• 1. High data download and upload performance. RT.Warehouse uses PXF technologies and JPF disk - both nodes and data download and upload channels are scaled. Data is not loaded through the wizard, but onto a straight line into segments - loading is carried out into many segments in parallel.
• 2. Connect to external sources to run analytical queries without overloading data in the vault. Integration with Oracle, Postgres, MS SQL, MySQL, MongoDB, SAP HANA, Hadoop, S3 and others is supported.
• 3. High security of sensitive data storage. Technologies for data encryption using PGP keys, server-to-client connections via SSL, data transfer between DBMS components via SSL are implemented.
• 4. Flexible access options. The role model allows you to implement dynamically changing access delimitation rules.

Features:

• Import-independent product registered in the register of domestic software. Use of a secure repository with source code and support for domestic operating systems;
• Automation of service functions: installation, configuration of the cluster, monitoring and resolution of incidents (mechanisms for administration and problem solving);
• Support in 24x7 mode. Geographically distributed support team and set of technical and operational documentation in Russian;
• Flexibility of use. The product is available in two options: cloud and on-premieses;
• Short cycle of delivering changes (bugfix, securitybugfix and newfeatures) and releasing new versions of RT.Warehouse by automating build and testing versions.

RT.Warehouse is an import-independent solution for building an enterprise data warehouse, BI analytics and Data Science. The product can be used in conjunction with RT.ClusterManager.