A relational database with pharmaceutical information: problems of creation and primary filling for provision of a qualitative statistical processing

Keywords: pharmacy information, drug form, drug dose, a structure of a relational database


The disclosure of pharmaceutical information is not intended to provide the possibility of further automated processing of the data provided by independent experts, and, accordingly, the choice of the methods of presentation is aimed to optimize visual perception by users.

The aim of the work was to analyze in the internet-sources the availability of information in the appropriate format for automatic filling of the relational database. The subjects of the study were: ATC: ICD-10 (International Classification of Diseases); content of EF 9.8; classification of dosage forms by the Ministry of Health of Ukraine, FDA (Food and Drug Administration, USA), EMA (European Medicines Agency) and EphMRA (European Pharmaceutical Market Research Association). Methods used are review of information with the corresponding structure in the internet, processing of the information found using computer code.

Approbation was carried out on the basis of the digital online system «Likypedia» (http://likypedia.zzz.com.ua; http://facebook.com/likypedia).

The basic goals for the quality of the results of statistical processing of pharmaceutical information are formed. To achieve them, a list of required information for the initial download to the relational database is defined. The sources of the received information which was used for initial loading to the relational database are presented. The multicomponent record of pharmaceutical information is described.

The list of dosage forms was formed on the basis of own practical experience, trends in the indication on packaging of medicines by manufacturers, electronic databases of pharmaceutical wholesalers, the titles of articles given in the EF 9.8 edition. Information from different sources about pharmaceutical dosage forms was analyzed and divided into five information blocks: made by manufacturer; its characteristic; for DF, which will be prepared with DF produced by the manufacturer; its characteristic; way of using DF.

A variant has been developed and presented for structuring the information record of the drug dose in the relational database in several variants, which makes it possible to further carry out automated calculations, optimize the selection and sorting of data.


1. Yanishevska K. D., Balenko Ye. O. Administratyvno-pravove rehuliuvannia dostupu do publichnoi informatsii // Pravovi horyzonty. – 2018. – Vyp. 13 (26). – S. 86–91. https://doi.org/10.21272/legalhorizons.2018.i13.p86

2. Pavlov M. M. Osoblyvosti realizatsii kontseptu vidkrytykh danykh u systemi publichnoho upravlinnia: vitchyznianyi ta zarubizhnyi dosvid // Derzhavne upravlinnia: teoriia ta praktyka. – 2018. – № 1. – S. 34–45.

3. Blynova N. M., Kyrylova O. V. Kopiraitynh yak diialnist zi stvorennia onlainovoho kontentu // Communications and Communicative Technologies (CCT). – 2018. – Vyp. 18. https://doi.org/10.15421/291802

4. Zubets V. V., Ylyna Y. V. O kachestve setevoi ynformatsyy // Vestnyk Tambovskoho unyversyteta. – 2016. – T. 21, Vyp. 12 (164). – S. 168– 172. https://doi.org/10.20310/1810-0201-2016-21-12(164)-168-172

5. Kazymyrov Y. A. Problemы sozdanyia y pervychnoho napolnenyia bazы dannыkh sdelok y predlozhenyi na rыnke nedvyzhymosty // Vestnyk YrHTU. – 2014. – № 12. – S. 283–286.

6. Makukh Kh. I., Chaikivskyi R. A., Zimenkovskyi A. B. Istoriia likodiieznavstva: likarski formy, evoliutsiia yikh tekhnolohii ta terminolohii // Klinichna farmatsiia, farmakoterapiia ta medychna standartyzatsiia. – 2010. – № 3–4. – S. 108–117.
How to Cite
Rervyatskyy, I. Y. (2019). A relational database with pharmaceutical information: problems of creation and primary filling for provision of a qualitative statistical processing. Farmatsevtychnyi Zhurnal, (4), 23-31. https://doi.org/10.32352/0367-3057.4.19.03
Management of pharmacy