ARCHITECTURE DEVELOPMENT AND IMPLEMENTATION OF A MEDICINE SEARCH SITE USING THE DROGON FRAMEWORK

2024;
: 88-95
Received: November 04, 2024
Revised: November 20, 2024
Accepted: November 25, 2024
1
Lviv Polytechnic National University
2
Lviv Polytechnic National University
3
Lviv Polytechnic National University
4
Lviv Polytechnic National University
5
Lviv Polytechnic National University

A new computer program (CP) has been created as a website for ATX classification groups to search for lists of medicinal products (MPs) as potential candidates for import substitution. The development of the CP with the conditional name "Computer Program for Import Substitution of Medicines" (CPISM) was carried out using open databases, which are regulated by the regulatory legal acts of the pharmaceutical industry of Ukraine. CPISM helps to quickly find lists of necessary medicinal products (MPs) subject to import substitution since these medicines are represented only by imported drugs in the Ukrainian pharmaceutical market. Using the CPISM website, you can obtain a list of pharmacological groups of MPs that require import substitution, which is especially important in martial law conditions. The production of these drugs can be implemented in domestic pharmaceutical enterprises. The advantages of the CPISM website, compared to other similar search programs, are the use and processing of 3 main drug databases with a convenient presentation: The State Register of Medicinal Products of Ukraine, the National List of Essential Medicinal Products, and the Register of Wholesale Prices of Manufacturers of Medicinal Products. This also allows searching for drugs by international non-proprietary names in all dosage forms with different dosages. CPISM is implemented as a web page and adapted for various devices. The architecture of the developed CPISM website is built based on a modular monolith. The web part and the data processing program are written in C++. The web part is implemented using the Drogon framework, providing an ORM for working with MySQL.

  1. Farmrynok Ukrainy-2022: Padinnia obsiahiv, zrostannia sobivartosti ta perspektyvy vyrobnytstva – dumky https://interfax.com.ua/news/pharmacy/888686.html (in Ukrainian).
  2. Pasichnyk V.V., Pasichnyk O.V., Uhryn D.I. Veb-tekhnolohii.: pidruchnyk / Lviv: «Mahnoliia2006», 2018. – 336 s. (in Ukrainian).
  3.  V. A. Pavlysh, L. K. Hlinenko, N. B. Shakhovska. Osnovy informatsiinykh tekhnolohii i system, Lvivska politekhnika, 2018, 620 s. (in Ukrainian).
  4.  Reiestr optovo-vidpusknykh tsin na likarski zasoby URL: https://moz.gov.ua/reestr-optovo-vidpusknih-cin-na-likarski-zasobi(in Ukrainian).
  5.  Derzhavnyi reiestr likarskykh zasobiv Ukrainy URL: http://www.drlz.com.ua/(in Ukrainian).
  6. Natsionalnyi perelik osnovnykh likarskykh zasobiv URL:  https://moz.gov.ua/uploads/0/3799-nacperelic_dodatok_web.pdf (in Ukrainian).
  7.  Dr. Ashley Godbold, Mastering UI Development with Unity: Develop engaging and immersive user interfaces with Unity , Packt Publishing, 2024Jiadong Chen; Ed Price, Game Development with Unity for .NET Developers: The ultimate guide to creating games with Unity and Microsoft Game Stack , Packt Publishing, 2022.
  8. Sotnik S., Shakurova T., Lyashenko V. (2023). Development Features Web-Applications.// International Journal of Academic and Applied Research (IJAAR) . – 2023. – Вип. 7(1). – С. 79-85. https://openarchive.nure.ua/handle/document/21600
  9.  [Electronic resource] https://github.com/drogonframework/drogon/issues/1878
  10. [Electronic resource] https://drogonframework.github.io/drogon-docs/#/ENG/ENG-01-Overview
  11. [Electronic resource]  https://uk.wikipedia.org/wiki/Tabletki.ua
  12.  [Electronic resource] https://apteki.ua/uk/pro-kompaniyu
  13. [Electronic resource] Liky 24. URL: http://surl.li/ujsmie. (in Ukrainian).
  14. [Electronic resource] https://drogon.org/
  15.  Freeman, A. Pro ASP.NET Core MVC 2. Apress, 2017.
  16.  Lock, A. ASP.NET Core in Action. Manning, 2018.
  17.  Marius Bancila, Modern C++ Programming Cookbook: Master modern C++ including the latest features of C++23 with 140+ practical recipes , Packt Publishing, 2024.
  18.  S. Ghosh, C. Alsobrooks, M. Rüfenacht, A. Skjellum, P. V. Bangalore and A. Lumsdaine, "Towards Modern C++ Language Support for MPI," 2021 Workshop on Exascale MPI (ExaMPI), St. Louis, MO, USA, 2021, pp. 27-35, doi: 10.1109/ExaMPI54564.2021.00009
  19.  "ISO/IEC 23026:2006, Software Engineering---Recommended Practice for the Internet---Web Site Engineering, Web Site Management, and Web Site Life Cycle," in ISO/IEC 23026; IEEE Std 2001-2002, First edition , vol., no., pp.1-86, 1 June 2006, doi: 10.1109/IEEESTD.2006.6484079.
  20. K. Gos and W. Zabierowski, "The Comparison of Microservice and Monolithic Architecture," 2020 IEEE XVIth International Conference on the Perspective Technologies and Methods in MEMS Design (MEMSTECH), Lviv, Ukraine, 2020, pp. 150-153, doi: 10.1109/MEMSTECH49584.2020.9109514.