Abstract
Aim: The aim of this work is to construct a system of interrelated procedures that are used in the formation of data warehouses for information systems in smart cities.
Objectives: Currently, the number of IoT devices integrated into the systems of information technology support of the processes taking place in supply networks of resources of Smart City, is constantly growing. While functioning, extensive sets of various types of information are generated. Using a single database, it is not possible to store data sets collected for multiple resource networks on a large city scale.
Methods: This work is devoted to the research and improvement of processes of formation of data hypercubes, which are an informational model of functioning of urban resource networks on the basis of data coming from systems of IoT devices. Methods of information modeling and construction of data hypercubes were used in research, taking into account the high dynamics and rapidity of resource supply processes.
Results: In this study, mainly the data hypercubes were constructed on the basis of the proposed improved methods that work based on messages received from real-functioning systems of IoT devices in urban resource networks. The use of this technology in the framework of information and technological support of the processes in urban resource networks provides an opportunity for detailed analysis of the current state of material resources of the city, and identifies trends in their changes and states by comparing data belonging to different time periods and different by origin collections.
Conclusion: The basic characteristics of the data warehouse, which provides information about urban resource networks, are analyzed. The analysis and construction of data hypercubes prototypes on urban resource networks were carried out. Classification and parameterization of many categories and attributes were carried out to describe processes in urban resource networks, which allowed, using the OLAP information technology based on hypercubes, to develop information technology of complex multidimensional data analysis, obtained using IoT devices that characterize the flow of processes in the urban resource networks. The obtained results propose the procedures of formation of data hypercubes, containing information about the progress of urban resource networks, used in the development of real information systems that collect data using IoT devices. The information technology of process support in urban resource networks is developed for use in different types of resource networks in the presence of several providers.
Keywords: Hypercube, data warehouse, IoT device, resource network, smart city, dimension.