As activities within enterprises become more universal and complicated and the general market grows, new tasks and problems appear, with their resolution increasingly depending on a source of well-organized, reliable, consistent, and valid information at any moment of time. Also, the necessity is evident to ensure information protection and comprehensive integration of multi-type legacy IT subsystems within an enterprise's information system.
     Red Soft offers a solution to create an integrated information environment through usage of data warehouse, which:

• Joins legacy special-purpose IT subsystems into a single information field;
• Ensures easy scalability as volumes of information increase and the business structure expands;
• Accumulates and stores information from all integrated IT subsystems over a long period (5 to 10 years or more);
• Validates integrity and accuracy of data submitted for storage from source solutions;
• Updates stored data for any time in the past;
• Provides on-line access to stored data through a single universal procedure, regardless of its initial format, source, etc.;
• Generates any reports on-line, against any set of stored data, in terms that a given user is accustomed to;
• Ensures security of information systems.

     Based on Red Soft's data and facts warehouse (Red Warehouse) technological stack, it is designed to:

• Generate a single information field of the enterprise;
• Auto-generate management reports;
• Provide external counterparts with required information;
• Integrate into systems and software complexes of the enterprise;
• Make multiple data entry redundant;
• Ensure data coherence and comparability in systems running in the enterprise.

     The Warehouse is designed based on DBMS Red Database, which is being certified by Federal Service for Technical and Export Control as compliant with the requirements on protection of information from unauthorized access for automated systems of Class 1Г (Rus), set forth in relevant Guidelines. In prospect, we plan certification against Class 1В (Rus) and above.
     Red Warehouse runs as a two-way information gate with its internal logic, application tier, the capability to transfer and exchange data, reports generators, etc.
     There is a replicator to import / export data. The module downloads information into the warehouse from multiple sources for further analytical processing. Also, the Replicator enables data consolidation and publishes it for external systems, which ensures coherence and consistency of information within such systems.
     Also, the Replicator can generate "Data Marts" - data slices stored in individual databases with apparently limited access to information on various systems and/or subdivisions within the enterprise.
     Facilities for dynamic multi-dimentional analysis offer additional power to differentiation of authorizations. Differentiation of rights is defined at the level of OLAP cubes, hierarchies of dimensions, ranges of data detail levels within hierarchies.
Facts warehouse.
     From the technological point of view, a facts warehouse is the single centralized transactional database that clients can access in the reading mode through major standard access protocols: ODBC, JDBC, ADO.NET. Various subsystems within such solution obtain information from common data (such as main master data) from the facts warehouse, which ensures the integrated nature of the information field.
Data warehouse.
     The data warehouse in a Red Soft's solution is a database designed to generate reports. The data warehouse is filled from the facts warehouse by materializing views. The data warehouse ensures the following capabilities:

• Store aggregated and detailed data for reporting
• Perform visual design and materialization of OLAP structures
• Tools for statutory reporting
  • HTML reports for Web
  • Reports in the MS Excel format
  • Reports in PDF or RTF for forms where high quality of printing is essential
• Tools for non-statutory reporting
  • Visual navigation in OLAP data
  • Relational access to warehoused data (ODBC, JDBC, ADO.NET) for users to generate reports with MS Office and others user tools
• Scalability achieved through loose coupling of clusters of components within the solution.

The technological strategy for Red Warehouse can be interpreted as follows:

• A central warehouse of facts is established with detailed informational presentation of the enterprise;
• The facts warehouse is filled with individual facts and arrays through the system of load gates from bridged systems of the enterprise;
• The facts warehouse provides information to various software complexes installed in the enterprise and is the main tool integrating the systems;
• Information is transmitted between Red Warehouse components in the batch mode, with delivery guaranteed;
• Red Soft Corporation's special developments are used for architecture purposes, as well as modern open source products, such as:
  • Firebird – relational DBMS;
  • Mondrian - XMLA/MDX server;
  • JasperReports – tool generating statutory reports;
  • Jrubik – tool for OLAP data navigation.