Translation of Queries in the Algebra of Multidimensional Matrices into a Relational Data Model
Abstract
The relational data model has become an important part of the mathematical and manufacturing field. It deserves this attention in view of the optimal and fast work with large databases, which simplifies work with logistics, calculation of large mathematical blocks, and a strict table formation system simplifies the protection, storage and management of information. However, this model has problems with the lack of standard query construction tools, the complexity of describing hierarchical and network relationships, and the difficulty of understanding the data structure due to the appearance of a large number of tables as a result of logical design. To solve these issues, it was decided to turn to a model that specializes in these problems. The need for these actions lies in the fact that the expression in a multidimensional matrix model is much simpler than in a relational one. The interaction of these systems and the automation of the translation algorithm for mass data processing of algebraic query expressions is the result of this article. The implementation of this algorithm describes the operations of addition and multiplication of computational data tables. These actions will simplify and systematize the process of creating queries for the needs of users and speed up work with applications based on relational systems. Also, for clarity, an example is provided that shows the translation process.
This work is licensed under a Creative Commons Attribution 4.0 International License.
Publication policy of the journal is based on traditional ethical principles of the Russian scientific periodicals and is built in terms of ethical norms of editors and publishers work stated in Code of Conduct and Best Practice Guidelines for Journal Editors and Code of Conduct for Journal Publishers, developed by the Committee on Publication Ethics (COPE). In the course of publishing editorial board of the journal is led by international rules for copyright protection, statutory regulations of the Russian Federation as well as international standards of publishing.
Authors publishing articles in this journal agree to the following: They retain copyright and grant the journal right of first publication of the work, which is automatically licensed under the Creative Commons Attribution License (CC BY license). Users can use, reuse and build upon the material published in this journal provided that such uses are fully attributed.
