Development and investigation of denormalized data model in computerized system for ionosphere parameters monitoring
Володимир Євгенович Сокол, Микола Вячеславович Ткачук, А. Г. Шаповалов · 2013
The considered problem domain is the data processing in computerized system of ionosphere parameters monitoring (CSIPM). The existing data structures are analyzed and their specific features are investigated. To improve the efficiency of corresponding database (DB) the denormalized data model is developed which takes into account the specific algorithms of the data processing in CSIPM. The performed test cases specify that this approach increases a performance of data processing in 1.7 - 2.1 times respectively. In further work it is planned to extend the current data model with the existing information about the ionosphere state such as the number of ions, electrons, etc., and with some additional information on the radar at the different points in its operation, since it is important for study of the ionosphere over a period of time. It is also planned to analyze the query performance by increasing the size of the database to a value of 80 Gb, which corresponds to the actual amount of data that have been accumulated in ASMPI for the whole period of its operation