Intellectual information technologies in the tasks of perfection of the hydrometeorological systems

Authors

  • Мария Романовна Валентюк Sevastopol National Technical University Universitetskaia str., 33, Sevastopol, Ukraine, 99000, Ukraine

DOI:

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

Keywords:

OLAP-cube, hypercube, multidimensional depositories, hydrometeorological industry

Abstract

In spite of the large accumulated volume of information in hydrometeorological industry and also necessity of multidimensional analysis of these data, scientific work connected with the use of modern technologies of intellectual analysis for the increase of speed of analysis of hydrometeorological data was not conducted until now. The reason for it might be lack of any competition in this branch of science. The article deals with the technology of on-line analytical processing (OLAP) of the hydrometeorological data consisting in creation of a two-level subsystem of storage which is used for the first time. The article presents schemes of operational and analytical databases with the description of requirements to them, and also describes the modules providing synchronization of data between these databases. Possibility of creation of OLAP library of cubes on various measurements after the analysis of selections of the data necessary for employees of hydrometeorological branch for the analysis and forecasting is suggested.

Author Biography

Мария Романовна Валентюк, Sevastopol National Technical University Universitetskaia str., 33, Sevastopol, Ukraine, 99000

Assistant

Information System Department

References

  1. Иванова, А. Аналитическая обработка данных [Текст] / А. Иванова // Журнал BYTE Россия. – 2006. – №2 (90). – С. 46-49.
  2. Введение в OLAP [Электронный ресурс] / Российский ежемесячный компьютерный журнал КомпьютерПресс. – Режим доступа : WWW/ URL : http://www.compress.ru/article.aspx?id=10348&iid=425 – 10.03.2012 г. – Загл. с экрана.
  3. Учебник по службам SSIS [Электронный ресурс] / Библиотека Microsoft Developer Network. – Режим доступа : WWW/ URL : http://msdn.microsoft.com/ru-ru/library/ms169917%28v=sql.105%29.aspx – 16.03.2012 г. – Загл. с экрана.
  4. Создаем OLAP куб [Электронный ресурс] / Сайт Хабрахабр компании «Тематические медиа». – Режим доступа : WWW/ URL : http://habrahabr.ru/post/67731/ – 05.04.2012 г. – Загл. с экрана.
  5. Башмаков, А.И. Интеллектуальные информационные технологии [Текст]: учеб, пособие /А.И. Башмаков, И.А. Башмаков. – М. : Изд-во МГТУ им. Н.Э.Баумана, 2005. – 304 с.
  6. Create OLAP cube for SQL Server 2005 Analysis Services [Электронный ресурс] / Сайт blrf.net. – Режим доступа : www/ URL : http://www.blrf.net/blog/74/microsoft/create-olap-cube-for-sql-server-2005-analysis-services/ – 14.04.2012 г. – Загл. с экрана.
  7. Creating and Manipulating Multidimensional Tables with Locational Data Using OLAP Cubes [Электронный ресурс] / Сайт Directions Magazine. – Режим доступа : www/ URL : http://www.directionsmag.com/articles/creating-and-manipulating-multidimensional-tables-with-locational-data-usin/123565 – 06.04.2012 г. – Загл. с экрана.
  8. Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 [Электронный ресурс] / Сайт Safari Books Online . – Режим доступа : www/ URL : http://my.safaribooksonline.com/book/databases/microsoft-sql-server/9780735625808 – 07.04.2012 г. – Загл. с экрана.
  9. Полубояров, В. В. Использование MS SQL Server Analysis Services 2008 для построения хранилищ данных [Текст] / В. В. Полубояров. — М. : Интуит, 2010. — 487 с
  10. Некоторые соображения о роли и месте технологии OLAP [Электронный ресурс] / Сайт Olap.ru . – Режим доступа : www/ URL : http://www.olap.ru/basic/think.asp – 07.04.2012 г. – Загл. с экрана.
  11. Ivanova, A. (2006). Analytical data processing. BYTE Russia Journal, 2(90), 46-49.
  12. Introduction in OLAP. (2012). Retrieved March 10, 2012, from http://www.compress.ru/article.aspx?id=10348&iid=425.
  13. The textbook on services SSIS. (2012). Retrieved March 16, 2012, from http://msdn.microsoft.com/ru-ru/library/ms169917%28v=sql.105%29.aspx.
  14. We create OLAP cube. (2012). Retrieved April 05, 2012, from http://habrahabr.ru/post/67731/.
  15. Bashmakov, A.I., Bashmakov, I.A. (2005). Intellectual information technologies. Moscow, Russia. Bauman MSTU.
  16. Create OLAP cube for SQL Server 2005 Analysis Services. (2012). Retrieved April 14, 2012, from http://www.blrf.net/blog/74/microsoft/create-olap-cube-for-sql-server-2005-analysis-services/.
  17. Creating and Manipulating Multidimensional Tables with Locational Data Using OLAP Cubes. (2012). Retrieved April 06, 2012, from http://www.directionsmag.com/articles/creating-and-manipulating-multidimensional-tables-with-locational-data-usin/123565.
  18. Smart Business Intelligence Solutions with Microsoft SQL Server 2008 (2012). Retrieved April 07, 2012, from http://my.safaribooksonline.com/book/databases/microsoft-sql-server/9780735625808.
  19. Poluboiarov, V. V. (2010). Creating data depositories using MS SQL Server Analysis Services 2008. Moscow, Russia. Intuit.
  20. Some considering about a role and place of OLAP technology. (2012). Retrieved April 07, 2012, from http://www.olap.ru/basic/think.asp.

Downloads

Published

2013-06-19

How to Cite

Валентюк, М. Р. (2013). Intellectual information technologies in the tasks of perfection of the hydrometeorological systems. Eastern-European Journal of Enterprise Technologies, 3(9(63), 50–54. https://doi.org/10.15587/1729-4061.2013.14850

Issue

Vol. 3 No. 9(63) (2013): INFORMATION AND CONTROLLING SYSTEM

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.