TENSOR MODEL OF INTEGRATED DATA STORAGE OF ENTERPRISE INFORMATION SYSTEMS
Abstract
The paper presents a tensor model of the enterprise's integrated data storage. Problem analysis of databases integration represented in different formats is conducted. Tensor models of databases currently known are considered. The principle of constructing a tensor model of an integrated relational database in the form of a multidimensional matrix is proposed, where the relation is considered as an invariant. A testing example of the proposed model for building an integrated relational database is described. A method for storing multidimensional and two-dimensional matrices in the relational database is proposed, where the SQL query is used for the multiplication of a multi-dimensional matrix by a two-dimensional matrix.
A comparative analysis of the speed for the proposed method and the method based on the analysis of system tables is carried out using test sets of random data.
The usage of the tensor representation of the information system's databases allows obtaining a compact mathematical description, and the binary coding of the relational model entities allows simplifying the programmatic access to the integrated data storage. Experimentally confirmed that the sample contains more than 15 000 records, the tensor representation of the data storage allows shortening the time of execution from 25 % to 11 500 %.
A comparative analysis of the speed for the proposed method and the method based on the analysis of system tables is carried out using test sets of random data.
The usage of the tensor representation of the information system's databases allows obtaining a compact mathematical description, and the binary coding of the relational model entities allows simplifying the programmatic access to the integrated data storage. Experimentally confirmed that the sample contains more than 15 000 records, the tensor representation of the data storage allows shortening the time of execution from 25 % to 11 500 %.
About the Authors
E. E. Bizyanov
Donbas State Technical University, Alchevsk, Luhansk People's Republic
Russian Federation
e-mail: bpeelecs@gmail.com
Russian Federation
e-mail: bpeelecs@gmail.com
N. N. Kononenko
Donbas State Technical University, Alchevsk, Luhansk People's Republic
Russian Federation
e-mail: nikolay.kononenko.1986@gmail.com
Russian Federation
e-mail: nikolay.kononenko.1986@gmail.com
References
1. Заблодский Н. Н., Бизянов Е. Е., Зайцев И. С. Современная концепция построения информационной системы управления крупным металлургическим предприятием // Сб. науч. тр. Донбасс. гос. тех. ун-та. 2008. № 27. С. 186–191.
2. Плеханов С. В. Интеграция разнородных баз данных на основе многомерных моделей данных: на примере интеграции геоинформационной системы с информационными системами предприятия : дис. ... канд. тех. наук. Уфа, 2006. 199 с.
3. Кресов А. А., Уваров В. В. Принципы интеграции данных в сфере недропользова-ния // Вестник кибернетики. 2011. № 10. С. 83–89.
4. Подробий А. Н. Проблемы интеграции данных на современном предприятии // Вестн. Ульянов. гос. тех. ун-та. 2012. № 1. С. 64–66.
5. White C. Data Integration: Using ETL, EAI, and EII Tools to Create an Integrated En-terprise. BI Research TDWI Webcast, 2005. 34 p.
6. Дейт К. Дж. Введение в системы баз данных. 8-е изд. М. : ИД Вильямс, 2005. 1328 с.
7. Попова Н. А. Построение модели данных с применением тензорной методологии // Современные проблемы науки и образования. 2013. № 5. URL: http://www.science-education.ru (дата обращения: 07.06.2018).
8. Арменский А. Е. Тензорные методы построения информационных систем. М. : Наука, 1989. 152 с.
9. Kim M.. TensorDB and Tensor-Relational Model (TRM) for Efficient Tensor-Relational Operations : A Diss. Presented in Partial Fulfillment of the Requirement for the Degree Doctor of Philosophy. Arizona State University. 2014. 221 p.
10. Крон Г. Тензорный анализ сетей / пер. с англ. ; под ред. Л. Т. Кузина, П. Г. Кузне-цова. М. : Сов. радио, 1978. 720 с.
11. Соколов Н. П. Пространственные матрицы и их приложен. М. : Гос. изд. физ.-мат. лит-ры, 1960. 300 с.
12. Кепещук Д. Б. Разработка модели обмена данными в гетерогенных распределен-ных базах данных // Вестник Тюмен. гос. ун-та. 2006. № 7. С. 81–86.
Review
For citations:
Bizyanov E.E., Kononenko N.N. TENSOR MODEL OF INTEGRATED DATA STORAGE OF ENTERPRISE INFORMATION SYSTEMS. Proceedings in Cybernetics. 2018;(4 (32)):149-158. (In Russ.)
Views:
221
Email this article 