The development of secured consolidated information resource of activity analysis of the poultry industry in ukraine

Authors

DOI:

https://doi.org/10.15587/2312-8372.2019.187755

Keywords:

secure consolidated information resource, data warehouse model, ER model, database, poultry market of Ukraine

Abstract

The object of research is the process of consolidating business information. The paper considers the creation and use of a powerful component of the business analytics system – a consolidated information resource that improves the understanding of the business process, analyzes activities and improves the process of managerial decision-making in the poultry market of Ukraine.

Methods and tools that are used in the process of building an information resource are substantiated. In particular, analysis and comparison methods are used to select a database management system, data warehouse model, and programming language. Also in the research process, a synthesis method is used to substantiate the requirements for the subject of study and a modeling method to create an ER model. As well as methods of induction and deduction – to form conclusions and a method of expert evaluation – to determine the economic feasibility of developing a consolidated information resource.

A goal tree is formed to create a consolidated information resource. An entity-relationship diagram is developed. And to systematize the information received and analyze it in detail, a database is designed. This process is implemented using DBMS (database management system) MS SQL and JavaScript. It is used as a means of accumulating data and a tool for analyzing the activities of both a single producer in the poultry market and the entire poultry industry together. Based on the results of the study, it is possible to prove the economic and functional feasibility of introducing and using a consolidated information resource. Since the proposed development significantly increases the level of leadership awareness of the performance indicators of both individual enterprises and the industry as a whole, for making high-quality and informed management decisions.

The introduction and use of a secure consolidated information resource significantly reduces the time to receive and process the necessary information and makes this process safe. In addition, this consolidated information resource has a high level of commercial potential and opportunities for further improvement, taking into account the influence of the rapidly changing external and internal environment of its functioning.

Author Biographies

Anzhelika Azarova, Vinnytsia National Technical University, 95, Khmelnytske shose str., Vinnitsa, Ukraine, 21021

PhD, Professor

Department of Management and Security of Information Systems

Anatoliy Shiyan, Vinnytsia National Technical University, 95, Khmelnytske shose str., Vinnitsa, Ukraine, 21021

PhD, Associate Professor, Professor

Department of Management and Security of Information Systems

Yulia Mironova, Vinnytsia National Technical University, 95, Khmelnytske shose str., Vinnitsa, Ukraine, 21021

PhD, Associate Professor

Department of Management and Security of Information Systems

Liudmyla Shturma, Vinnytsia National Technical University, 95, Khmelnytske shose str., Vinnitsa, Ukraine, 21021

Department of Management and Security of Information Systems

References

  1. Vinichenko, I. I., Makhovskyi, D. V. (2015). Stan ta perspektyvy rozvytku ptakhivnychykh pidpryiemstv v Ukraini. Ahrosvit, 24, 3–6.
  2. Kunanets, N. E., Pasichnyk, V. V. (2010). Vstup do spetsialnosti «Konsolidovana informatsiia». Lviv: Lvivska politekhnika, 196.
  3. Matviienko, O. V. (2010). Funktsii informatsiinykh analitykiv u protsesi pidhotovky pryiniattia upravlinskykh rishen. Naukovi pratsi Natsionalnoi biblioteky Ukrainy im. V. I. Vernadskoho, 5, 350.
  4. Berko, A. Yu. (2013). Systemy upravlinnia bazamy danykh ta znan. Lviv: Mahnoliia-2006, 680.
  5. Lobok, O. P. (2013). Orhanizatsiia baz danykh ta znan. Teoretychni osnovy proektuvannia, realizatsii ta vykorystannia baz danykh. Kyiv: NUKhT, 262.
  6. Mulesa, O. Yu. (2015). Osnovy movy zapytiv SQL. Uzhhorod: Uzhhorodskyi NU, 48.
  7. Gulden, M. (2019). Bootstrapping Hibernate 5 with Spring. Baeldung. Available at: https://www.baeldung.com/hibernate-5-spring
  8. Derzhavna sluzhba statystyky Ukrainy (2018). Available at: http://ukrstat.gov.ua/
  9. Ishchenko, Yu. B. (2013) Ptakhivnytstvo Ukrainy: analitychnyi ohliad. Kharkiv, 74.
  10. Prokopenko, O. R. (2018). Tvarynnytstvo Ukrainy v 2017 rotsi. Statystychnyi zbirnyk. Kyiv: Derzhavna sluzhba statystyky Ukrainy, 165.

Downloads

Published

2019-11-21

How to Cite

Azarova, A., Shiyan, A., Mironova, Y., & Shturma, L. (2019). The development of secured consolidated information resource of activity analysis of the poultry industry in ukraine. Technology Audit and Production Reserves, 6(2(50), 14–18. https://doi.org/10.15587/2312-8372.2019.187755

Issue

Vol. 6 No. 2(50) (2019): Information and control systems

Section

Reports on research projects

License

Copyright (c) 2019 Anzhelika Azarova, Anatoliy Shiyan, Yulia Mironova, Liudmyla Shturma

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.