by MEA LLC
Русский+7 (495) 980-61-84
Data Mart Management System (abbr. DMMS) is designed for scheduled storage and execution of user SQL queries to DB, maintain the DBMS tabular results.
The system allows to apply restrictions on the received data both prior and after calculations;
OverviewFAQThe DMMS system is designed for construction and management of data marts.
Main features:
 |
Exceptions Exceptions are intended for data filtering, both prior and after data mart calculations. The system allows data excepting in certain period (holidays, emergency) by specified parameters, for example:
|
 |
Correction Correction subsystem is designed for editing data mart calculation results. It is used by operating departments and allows:
|
 |
Confirmations This subsystem is designed for confirmation of data mart calculation results by the operating departments. This mechanism is applied when calculated data marts are used in other data mart calculations. |
 |
Threshold values This subsystem is designed for verification of conformance of calculated values to the set threshold conditions. This mechanism, together with «Notifications» module, allows informing the user that the indicator he is interested in is out of the threshold value. |
 |
Grouping of data marts Data marts grouping subsystem is designed for the unification of data marts in order to simplify operations of the same type on them, for example: blocking, launch of execution, refreshment/recalculation. |
 |
Distributed execution Subsystem is designed for distributed execution of preliminary calculations and aggregation of raw data on remote servers. This allows reducing central server load and transmitted data volume. |
 |
Notifications Subsystem is designed to inform user about the events which took place. User can receive notifications in the following ways:
|