Method for forming multi-dimensional data in the information financial and economic system at the enterprise of state space corporation “Roscosmos”
Автор: Kartamyshev A.S., Chernysh B.A., Murygin A.V.
Журнал: Siberian Aerospace Journal @vestnik-sibsau-en
Рубрика: Informatics, computer technology and management
Статья в выпуске: 4 vol.22, 2021 года.
Бесплатный доступ
The construction of detailed accounting that allows to generate complex analytical reporting is an in-dispensable requirement of a modern financial system. For enterprises of the State Space Corporation “Roskosmos” with custom-made and small-scale production, operating in the conditions of Federal Law No. 275, characterized by a large amount of R&D and a high degree of uncertainty in the process of creat-ing products, this task is a system-forming one. The reporting should contain consistent data in any area of management and accounting at any given time. Along with this, system must provide the flexibility, reliabil-ity and performance inherent in transactional databases. To build information support that satisfies the specified conditions, it is required either to separate OLTP and OLAP data schemes, or to apply special-ized solutions based on the use of structures and techniques optimized for performing OLAP operations in traditional RDBMSs. This article considers the approach to form the multidimensional data in an automat-ed management system for economic tasks, as an effective alternative to complex and expensive BI solu-tions. Unlike many commercial systems, the ASU FEZ does not store redundant data (for example, opera-tional accounting registers in the 1C: Enterprise platform) required to build analytical accounting. The underlying data structures and methods of their processing allow for all types of accounting and have pow-erful tools for constructing analytical reporting. The article proposes algorithms for the operation of the system using the example of building simple OLAP cubes used in real tasks of automating financial and economic activities in ISS JSC for one of the Purchase subsystems. The formalization of these problems is carried out, the mathematical apparatus for constructing multidimensional data models based on infor-mation from a fixed set of normalized tables of a relational database is considered.The examples of SQL queries and outputs are provided. The advantages of using the system in operational management and accounting at the enterprise increasing its operational efficiency are summarized.
Database, OLTP, OLAP, analytical processing, multidimensional representation, relational schema, normalization, normal form, automation system
Короткий адрес: https://sciup.org/148329591
IDR: 148329591 | DOI: 10.31772/2712-8970-2021-22-4-589-599
Список литературы Method for forming multi-dimensional data in the information financial and economic system at the enterprise of state space corporation “Roscosmos”
- Vychugzhanina T. V., Dolgova I. A. [Using data warehouses and OLAP-technology in modern ERP-systems]. Informacionnye tekhnologii v modelirovanii i upravlenii: podhody, metody, resheniya. Penza, 2017 (In Russ.).
- Avrunev O. E., Stasyshin V. M. Modeli baz dannykh [Database models]. Novosibirsk, Novosibirsk state technical university Publ., 2018 (In Russ.).
- Kompaniya “Abis Soft”. Primenenie OLAP-tekhnologiy dlya uchetnykh sistem na platforme 1S [Abis Soft company. Using of OLAP technologies for accounting systems on the 1C platform]. Available at: https://www.cfin.ru/itm/olap/1c.shtml (accessed: 11.02 2021).
- Goncharova Y. A., Andreeva N. M. [Reading data from the 1C: Enterprise 8.1 periodic information register using the methods of the infobase tabular model]. Aktual’nye problemy aviacii i kosmonavtiki. 2012, No. 1, P. 393–394 (In Russ.).
- Kartamyshev A. S., Vilkov Y. V. [Innovation in aerospace enterprise control. Integrated information control system of the enterprise JSC “ISS”]. Aktual’nye voprosy proektirovaniya avtomaticheskih kosmicheskih apparatov dlya fundamental’nyh i prikladnyh nauchnyh issledovaniy, Anapa, 2017 (In Russ.).
- Ulman J. Osnovy sistem baz dannykh [Principles of Database Systems]. Moscow, Finance and statistics Publ., 1983, 334 p.
- Maier D. The Theory of Relational Databases. Rockville, Computer Science Press, 1983.
- Zykin S. V., Mosin S. V., Poluyanov A. N. [Technology of separate generation of multidimensional data]. Vestnik Donskogo gosudarstvennogo tekhnicheskogo universiteta. 2016, No. 2(85), P. 121–128 (In Russ.).
- Lechtenborger J., Vossen G. Multidimensional normal forms for data warehouse design. Information Systems Frontiers. 2003, No. 28, P. 415–434.
- Lehner W., Albrecht J., Wedekind H. Normal forms for multidimensional databases. Proceedings of the Tenth International Conference on Scientific and Statistical Database Management. 1998, P. 63–72.
- Mazon J., Trujillo J., Lechtenborger J. Reconciling requirement-driven data warehouses with data sources via multidimensional normal forms. Data & Knowledge Engineering. 2007, No. 3 (63), P. 725–751.
- Zykin S. V. Formation of Hypercube Representation of Relational Database. Programming and Computer Software. 2006, No. 6 (32), P. 348–354.
- Zykin S. V. Dynamic contexts of relational-type database. Informatics and Applications. 2014, No. 1 (8), P. 77–88.
- Redreev P. G. [Construction of Hierarchies in Multidimensional Data Models]. Izvestiya Saratovskogo universiteta. 2009, No. 4, P. 7–12 (In Russ.).
