A relational database with pharmaceutical information: problems of creation and primary filling for provision of a qualitative statistical processing
Journal Title: Фармацевтичний журнал - Year 2019, Vol 4, Issue 4
Abstract
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.
Authors and Affiliations
I. Yu. Rervyatskyy
Research of the system of information providing for safe pharmacotherapy pregnancy in the world
Improvement of information provision for safe and rational use of medicines at pregnancy is a priority task for all system of healthcare in the world. The purpose of this study was to analyze and carry out a systematic a...
Active pharmaceutical ingredients in dermatological medicines of Ukrainian pharmaceutical market
The problem of the diabetic foot is one of the most serious complications of diabetes mellitus. There is still an active search for medicines (drugs) that could be used in the complex treatment of trophic lesions in diab...
Application of mathematical experimental design for optimization of HPLC and HPLC-MC conditions
Development of new methods for determination of biological active substances in chemical mixtures, pharmaceuticals and biological material is a very important problem. The chromatographic methods of analysis with UV and...
The development of standard of good pharmacy practice regarding the participation of pharmacists in public health
The change in the focus of healthcare in Ukraine from treatment to preventive medicine is necessary for improvement of medical and demographic situation in the country and the formation of a responsible attitude of citiz...
Research of the rheological parameters of the combine compounding ointment with hydrocortisone butyrate
Though the range of the industrial semi-solid preparations are quite wide, just compounding ointments allow to combine differences in pharmacological activity of the components in one preparation which provides versatile...