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;OverviewFAQ
The DMMS system is designed for construction and management of data marts.
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 subsystem is designed for editing data mart calculation results.
It is used by operating departments and allows:
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.
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.
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.
Subsystem is designed to inform user about the events which took place.
User can receive notifications in the following ways:
The system allows:
What browser can be used to open up the DMMS Web interface?
It is possible to run application in any browser.
What format is the export in?
It is possible to export data to HTML, XML, XLS.
What are the Hardware requirements for DMMS?
Necessary software component:
Recommended HW configuration:
Can you customize DMMS for us?
The DMMS open architecture allows customize it easily and quickly. And the system's flexibility allows its real time customization.