INFORMATION AND ANALYTICAL SYSTEM FOR ACCOUNTING OF EXPERT PROCEEDINGS IN DEPARTMENTS OF THE EXPERT SERVICE OF THE MINISTRY OF INTERNAL AFFAIRS OF UKRAINE
DOI:
https://doi.org/10.24025/2306-4412.2.2021.241061Keywords:
information and analytical system, data analysis, statistics, analytics, software development, databases, web, PHP, PostgreSQLAbstract
This paper considers the experience of modelling, development and implementation of new software, such as information and analytical system, for examination in government forensics centres. The authors have made analysis of current requirements to software which can be used in government structures. The list of basic requirements and most important principles of software development has been made. After analysing business processes in forensics centres the authors have made the list of needed functions and facilities for future software. One of problems consists in the choice of basic technology for software development. The authors have analysed the most popular technologies and chosen web-oriented architecture – clients will be connecting to software using browser for see graphical user interface, same as to regular website. All business logic of software will be provided at server side. During the development, the authors have paid special attention to the issue of information protection. Cybersecurity is one of the main requirements for software, which can be used in divisions of the Ministry of Internal Affairs of Ukraine. "Zero Trust" model has been chosen as the main model security for future software. This means that internal algorithms must scan and filter any incoming data in few levels. The system must have autonomic system of reacting to attacks. As key technologies the PostgreSQL as database management system, NGINX as web-server software, PHP programming language for creating server-side software and HTML/CSS/Java Script for making graphical user interface have been chosen. Based on security requirements, no third-party libraries or frameworks were used in the development. Directly for the implementation of the server part of the system, the authors have chosen a slightly modified MVC model and implemented the principle of absolute modularity of the system. After the development, the information and analytical system has been successfully implemented in the activities of all divisions of the Expert Service of the Ministry of Internal Affairs of Ukraine. Currently, the system is actively used for automated reporting and generation of statistical and analytical data on certain activities of the service.
References
The Ministry of Internal Affairs of Ukraine. (2009, Oct. 12). Order No. 436, On approval of the Regulations on the Integrated Information Search System of the Internal Affairs Bodies of Ukraine. [Online]. Available: https://zakon.rada.gov.ua/laws/ show/z1256-09/conv#Text [in Ukrainian].
The Cabinet of Ministers of Ukraine. (2018, Nov. 14). Resolution No. 1024, On approval of the Regulation on the unified information system of the Ministry of Internal Affairs and the list of its priority information resources. [Online]. Available: https://zakon.rada.gov.ua/laws/show/1024-2018-%D0%BF/conv#Text [in Ukrainian].
Draft of the Cybersecurity Strategy of Ukraine (2021–2025). [Online]. Available: https://www.rnbo.gov.ua/files/2021/ STRATEGIYA%20KYBERBEZPEKI/ proekt%20strategii_kyberbezpeki_Ukr.pdf [in Ukrainian].
Yu. V. Tryus, H. O. Zaspa, O. S. Kozhemiakin, and A. V. Ashyrova, "Information and analytical system for educational activities support of structural divisions of higher education institutions", Visnyk Cherkaskogo derzhavnogo tehnologichnogo universitetu, no. 4, pp. 27-38, 2020 [in Ukrainian].
N. V. Bugas, and O. O. Kovalenko, "Information system as a condition for effective management decisions, Efektyvna ekonomika, no. 12, 2016. [Online]. Available: http://www.economy.nayka.com.ua/?op=1&z=5313 [in Ukrainian].
M. Kleppmann, Highly Loaded Applications. Programming, Scaling, Support. St. Petersburg, Russia: Piter, 2018. ISBN: 978-5-4461-0512-0 [in Russian].
D. DeJonghe, NGINX Cookbook: Advanced Recipes for High Performance Load Balancing. CA, USA: O’Reilly Media, 2019. ISBN: 978-1-491-96893-2.
L. Campbell, and Ch. Majors, Databases. Reliability Engineering. St. Petersburg, Russia: Piter, 2020 [in Russian]. ISBN 978-5-4461-1310-1.
D. Grus, Data Science. Data Science from Scratch: 2nd Ed. St. Petersburg, Russia: BHV-Petegburg, 2021 [in Russian]. ISBN: 978-5-9775-6731-2.
J. Garbis, and J. Chapman, Zero Trust Security: An Enterprise Guide. Boston, MA, USA: Apress. ISBN-13: 978-1-4842-6701-1.
D. Johnson, D. Deogun, and D. Sawano, Secure by Design. St. Petersburg, Russia: Piter, 2021 [in Russian]. ISBN 978-5-4461-1507-5.
B. Novikov, E. Gorshkova, and N. Grafeeva, Database Technology Fundamentals: A tutorial. Moscow, Russia: DMK Press, 2020. [in Russian].ISBN 978-5-97060-841-8.
D. Boswell, and T. Foucher, Readable code or programming as art. St. Petersburg, Russia: Piter, 2012 [in Russian]. ISBN: 978-5-459-01188-3.
G. Schönig, PostgreSQL 11. Mastering of Development. Transl. from Eng. by A. A. Slinkin. Moscow, Russia: DMK Press, 2019 [in Russian]. ISBN: 978-5-97060-671-1.
H. Dombrovskaya, B. Novikov, and A. Bailliekova, PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries. Chicago, IL, USA: Apress, 2021. ISBN: 978-1-4842-6884-1.
PostgreSQL 11.12 Documentation. [Online]. Available: https://www.postgresql.org/docs/ 11/index.html
E. Gamma, R. Helm, R. Johnson, and J. Vlissides, Object-Oriented Design Patterns. St. Petersburg, Russia: Piter, 2020 [in Russian]. ISBN 978-5-4461-1595-2.
C. Pitt, Pro PHP 8 MVC: Model View Controller Architecture-Driven Application Development. Cape Town, South Africa: Apress, 2021.ISBN: 978-1-4842-6956-5.
M. Zandstra, PHP 8 Objects, Patterns, and Practice: Mastering OO Enhancements, Design Patterns, and Essential Development Tools. Brighton, UK: Apress, 2021. ISBN: 978-1-4842-6790-5.
PHP documentation. [Online]. Available: https://www.php.net/manual/ru/
K. Tatroe, and P. Macintyre, Creating dynamic websites in PHP. 4th Int. Ed. St. Petersburg, Russia: Piter, 2021 [in Russian].ISBN: 978-5-4461-1488-7.
Downloads
Published
How to Cite
Issue
Section
URN
License
Copyright (c) 2021 Роман Пташкін, Артем Гончаров, Олександр Гавриш
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.
The authors who publish in this journal agree to the following terms:The authors reserve the right to authorship of their work and give the journal the right to first publish this work under the terms of the Creative Commons Attribution License CC BY-NC, which allows other persons to freely distribute published work with a mandatory reference to authors of the original work and the first publication of the work in this journal.
Authors have the right to conclude separate additional agreements for the non-exclusive distribution of the paper in the form in which it was published by this journal (for example, posting work in electronic repository or publishing as part of a monograph), provided that the link to the first publication in this journal is maintained.
The journal policy allows and encourages authors to post on the Internet (for example, in repositories of institutions or on personal websites) the manuscript of work, both before the submission of this manuscript to the editorial staff, and during its editorial work, as it contributes to the emergence of productive scientific discussion and positively affects the efficiency and dynamics of published work citation (see The Effect of Open Access).
