Development and investigation of denormalized data model in computerized system for ionosphere parameters monitoring

Authors

  • Володимир Євгенович Сокол National Technical University «Kharkiv Polytechnic Institute», Frunze 21, Kharkiv, 61002, Ukraine
  • Микола Вячеславович Ткачук National Technical University «Kharkiv Polytechnic Institute», Frunze 21, Kharkiv, 61002, Ukraine
  • Андрій Геннадійович Шаповалов National Technical University «Kharkiv Polytechnic Institute», Frunze 21, Kharkiv, 61002, Ukraine

DOI:

https://doi.org/10.15587/1729-4061.2013.16383

Keywords:

data model, renormalizations, monitoring system, ionosphere parameters

Abstract

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

Author Biographies

Володимир Євгенович Сокол, National Technical University «Kharkiv Polytechnic Institute», Frunze 21, Kharkiv, 61002

Senior Lecturer, PhD

Department of computer-aided management systems

Микола Вячеславович Ткачук, National Technical University «Kharkiv Polytechnic Institute», Frunze 21, Kharkiv, 61002

Professor, Dr. techn. science

Department of computer-aided management systems

Андрій Геннадійович Шаповалов, National Technical University «Kharkiv Polytechnic Institute», Frunze 21, Kharkiv, 61002

Department of computer-aided management systems

References

  1. Інститут іоносфери НАН та МОНМС України [Електронний ресурс] — Режим доступу: WWW/ URL: http://www.iion.org.ua/ — 15.07.2013 р.
  2. Альперт, Я. Л. Распространение электромагнитных волн и ионосфера [Текст] / Я. Л. Альперт. — М. : "Наука", 1972. — 564с.
  3. Проект Madrigal [Електронний ресурс] — Режим доступу: WWW/ URL: http://www.openmadrigal.org/ — 15.07.2013 р.
  4. Програма CEDAR [Електронний ресурс] / Національний науковий фонд США. — Режим доступу: WWW/ URL: http://www.nsf.gov/pubs/2005/nsf05554/nsf05554.htm — 15.07.2013 р.
  5. Богомаз, А. В. Этапы обработки данных радара некогерентного рассеяния [Текст] / А. В. Богомаз // Конференция молодых учёных «Дистанционное радиозондирование ионосферы (ИОН-2012)». — Харьков, Украина, 18 – 20 апреля 2012 г.
  6. Коннолли, Т. Базы данных. Проектирование, реализация и сопровождение. Теория и практика [Текст] / Т. Коннолли. — М. : Издательский дом "Вильямс", 2003. — 1440 с.
  7. Корнеев, В. В. Базы данных. Интеллектуальная обработка информации. / В. В. Корнеев, А. Ф. Гараев. — М. : Издательство "Нолидж", 2000 — 450 с.
  8. Энсор, Д. Oracle. Проектирование баз данных / Д. Энсор, Й. Стивенсон. — М. : Издательство "ЛОРИ", 2003 — 624c.
  9. NetBeans IDE [Електронний ресурс] — Режим доступу: WWW/ URL: https://netbeans.org/features/index.html/ — 15.07.2013 р.
  10. EMS SQL Manager [Електронний ресурс] — Режим доступу: WWW/ URL: http://www.sqlmanager.net/products/mysql/manager/ — 15.07.2013 р.
  11. Institute of Ionosphere NAS and MESYS Ukraine. Available: http://www.iion.org.ua/. Last accessed 15.07.2013.
  12. Alpert, Y. (1972). Propagation of electromagnetic waves and the ionosphere. M: "Science", 564p.
  13. Project Madrigal. Available: // http://www.openmadrigal.org/. Last accessed 15.07.2013.
  14. CEDAR program. Available: http://www.nsf.gov/pubs/2005/nsf05554/nsf05554.htm. Last accessed 15.07.2013.
  15. Bogomaz, A. (2012). Data processing steps Incoherent Scatter Radar. Conference of Young Scientists "Remote probing of the ionosphere (ION 2012)". Kharkov, Ukraine, 18 – 20 April 2012.
  16. Connolly, T.(2003). Database. Design, implementation and maintenance. Theory and practice. M.: Publishing House "Williams", 1440p.
  17. Korneev, V. (2000). Database. Intelligent processing of information. M.: Publishing House "Knowledge", 450 p.
  18. Ensor, D. (2003). Oracle. Database design. M.: Publishing House "LORI", 624p.
  19. NetBeans IDE. Available: https://netbeans.org/features/index.html/. Last accessed 15.07.2013.
  20. EMS SQL Manager Available: http://www.sqlmanager.net/products/mysql/manager/. Last accessed 15.07.2013.

Downloads

Published

2013-08-15

How to Cite

Сокол, В. Є., Ткачук, М. В., & Шаповалов, А. Г. (2013). Development and investigation of denormalized data model in computerized system for ionosphere parameters monitoring. Eastern-European Journal of Enterprise Technologies, 4(9(64), 4–7. https://doi.org/10.15587/1729-4061.2013.16383

Issue

Vol. 4 No. 9(64) (2013): Information and control systems

Section

Information and controlling system

License

Copyright (c) 2014 Володимир Євгенович Сокол, Микола Вячеславович Ткачук, Андрій Геннадійович Шаповалов

Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.

The consolidation and conditions for the transfer of copyright (identification of authorship) is carried out in the License Agreement. In particular, the authors reserve the right to the authorship of their manuscript and transfer the first publication of this work to the journal under the terms of the Creative Commons CC BY license. At the same time, they have the right to conclude on their own additional agreements concerning the non-exclusive distribution of the work in the form in which it was published by this journal, but provided that the link to the first publication of the article in this journal is preserved.

A license agreement is a document in which the author warrants that he/she owns all copyright for the work (manuscript, article, etc.).
The authors, signing the License Agreement with TECHNOLOGY CENTER PC, have all rights to the further use of their work, provided that they link to our edition in which the work was published.
According to the terms of the License Agreement, the Publisher TECHNOLOGY CENTER PC does not take away your copyrights and receives permission from the authors to use and dissemination of the publication through the world's scientific resources (own electronic resources, scientometric databases, repositories, libraries, etc.).
In the absence of a signed License Agreement or in the absence of this agreement of identifiers allowing to identify the identity of the author, the editors have no right to work with the manuscript.
It is important to remember that there is another type of agreement between authors and publishers – when copyright is transferred from the authors to the publisher. In this case, the authors lose ownership of their work and may not use it in any way.