Data Warehouse

It is quite common for a modern organization not to use one data storage system, but instead to rely on many databases and specialized software. This leads to a situation in which it is difficult to find a single source of data for supporting the decision-making process. The information is scattered, disembodied, contains erroneous and non-validated data, and various sources contain duplicate information.

It is extremely difficult to create a unified data storage system containing all the data necessary for analysis. Besides, the analysis requires specific methods of data storage and access. For the analytical treatment, it is best to use specialized systems designed for such tasks — data warehouses. The analytical platform Loginom has a built-in data warehouse — Loginom Warehouse. It is a convenient source for supporting the decision-making process:

• Data consolidation. Loginom Warehouse resolves the problem of consolidating data from diverse sources; it provides a single unified source of information, and ensures completeness and consistency of the data. The warehouse enables the user to receive data covering the whole history of the company independently of the data collection systems used.
• Use of business terminology. In order to receive data from Loginom Warehouse, the analyst uses familiar business terminology such as sales, procurement, and profit. The analyst can extract any information without the help of IT experts, just by using the mouse. The system itself will generate the database request and output the information requested by the expert in a form suitable for further analysis.
• Fast data processing. Loginom Warehouse contains optimization mechanisms which take into account the specifics of the analytical treatment and considerably speed up the data output. The system performs all the necessary operations automatically in the background.
• Cross-platform operation. Loginom Warehouse can be based on any of the three DBMS: Oracle, MS SQL or Firebird. Changing the platform has absolutely no effect on the analyst’s work; the system interacts with all databases in exactly the same way. The opportunity to choose the database allows the cost of the system to be minimized, performance to be optimized and the most familiar database management systems to be used. By combining different platforms. the users can develop centralized, hierarchical and regional data warehouses and showcases.

Loginom Warehouse is part of the analytical platform and is integrated with the rest of the modules. Using other Loginom modules, the users can clean and preprocess data, calculate the desired values, and enhance the data with information from other sources before loading it into the warehouse.