Method for forming multi-dimensional data in the information financial and economic system at the enterprise of state space corporation “Roscosmos”
- Авторлар: Kartamyshev A.S.1, Chernysh B.A.2, Murygin A.V.2
-
Мекемелер:
- JSC Academician M. F. Reshetnev Information Satellite Systems
- Reshetnev Siberian State University of Science and Technology
- Шығарылым: Том 22, № 4 (2021)
- Беттер: 589-599
- Бөлім: Section 1. Computer Science, Computer Engineering and Management
- URL: https://journals.eco-vector.com/2712-8970/article/view/562932
- DOI: https://doi.org/10.31772/2712-8970-2021-22-4-589-599
- ID: 562932
Дәйексөз келтіру
Аннотация
The construction of detailed accounting that allows to generate complex analytical reporting is an indispensable 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 creating 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, reliability 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 schemas, or to apply specialized solutions based on the use of structures and techniques optimized for performing OLAP operations in traditional RDBMSs. This article discusses an approach to the formation of multidimensional data in an automated management system for economic tasks, as an effective alternative to complex and expensive BI solutions. Unlike many commercial systems, the ASU FEZ does not store redundant data (for example, operational 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 powerful 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 information from a fixed set of normalized tables of a relational database is considered. Examples of SQL queries and outputs are provided. The advantages of using the system in operational, management and accounting at an enterprise, which increase its operational efficiency, are summarized.
Авторлар туралы
Alexandr Kartamyshev
JSC Academician M. F. Reshetnev Information Satellite Systems
Хат алмасуға жауапты Автор.
Email: kartam@issreshetnev.ru
начальник группы автоматизации задач управления в Обществе
Ресей, 52, Lenin St., Zheleznogorsk, Krasnoyarsk region, 662972Boris Chernysh
Reshetnev Siberian State University of Science and Technology
Email: borisblack@mail.ru
postgraduate student
Ресей, 31, Krasnoyarskii rabochii prospekt, Krasnoyarsk, 660037Alexandr Murygin
Reshetnev Siberian State University of Science and Technology
Email: avm514@mail.ru
Dr. Sc., Professor
Ресей, 31, Krasnoyarskii rabochii prospekt, Krasnoyarsk, 660037Әдебиет тізімі
- 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.).
Қосымша файлдар
![](/img/style/loading.gif)