THE USE OF DATA WAREHOUSES ON THE EXAMPLE OF THE APPLICATION PROCESSING SYSTEM IN GOVERNMENT AGENCIES

Abstract

This article highlights the issue of the importance of information, the need to ensure its proper storage and use. Nowadays, the question of the importance of studying the functioning of data storage facilities in one of the most common design models – Data Flow Diagram, and data storage (DS or DW) in the whole. A study of abstract devices of this information security model was carried out: types, features and types of data storage, which are used in information systems (relational, multidimensional, and hybrid repositories), from the point of view of using models for presenting data; appearance of warehouses and building rules; Letter identifiers of storages “D”, “C”, “M” and “T” with the help of which the type of storages is determined; features of the numerical part of the identifiers for decompositions of the first and second tier processes; mechanisms that support data retention for their intermediate processing in information systems. Transition of properties and characteristics from physical to logical representation, rationalization of data warehouses by considering the features of the logical model. In the course of the work, the peculiarities of the construction of the DFD and the reflection of the interrelationships in all the component diagrams, defined in the general rules that are valid for the two, were considered. The highlighted issues concern the elements of the diagrams, which can be freely exploited within the borders of Ukraine, as well as the elemental content of the different types of diagrams in the diagrams. The unique functionality of domestic DFD diagrams allows to use a sufficient, albeit limited, elemental structure for construction. Depending on the actual possibilities, the diagrams of the Ukrainian manufacturer are somewhat simplified and imperfect according to modern technologies, but these factors do not diminish the importance and necessity of adequate data protection at the highest level. Therefore, in this work, the main most informative moments of the use of this or that type of storage, the demand for DS, in the field, are highlighted, possible advantages and disadvantages of using physical data storage facilities and features of virtual operation.