INFORMATION TECHNOLOGY OF CRYPTOGRAPHY-PROTECTED EXPORTS (IMPORTS) OF ROWS OF DATABASE TABLES

Authors

  • Ye. B. Lopin Military Medicine Problems Research Institute of Ukrainian Military Medical Academy

DOI:

https://doi.org/10.11603/mie.1996-1960.2018.2.9296

Keywords:

export of database information, import of information into the database, cryptographic protection of information, medical information system

Abstract

Background. Despite the recent developments in eastern Ukraine and complicated economic situation in the state, Ukraine Armed Forces Medical Service is introducing medical information systems for informatization of Ukraine Ministry of Defense healthcare facilities functioning and, in particular, is planning the creation of the medical information system of components of defense forces.

At the same time, this project will be performed in low-resource environment with insufficiently developed information infrastructure, shortage of medical service funding and lack of qualified personnel.

This article is devoted to the possible solution of the scientific problem of ensuring functioning of territorially (geographically) and structurally scalable information systems in the absence of direct access to global networks (Internet, etc.) by developing and implementing information technology for cryptographic-protected export/import of databases information.

Materials and methods. Materials used for research: the database of patients registered and classified as combat casualties of the Military Medical Clinical Center of the Southern Region (Odessa) for the period of 2015-2016; the databases of patients registered and treated in the National Military Medical Clinical Center (Kyiv) and the Military Medical Clinical Center of Occupational Pathology of the Ukraine Armed Forces Personnel (Irpin) patients.

For the purposes of this study the developed by the author software and computer equipment that has characteristics similar to the characteristics of the equipment, which is employed in the health facilities of the Ukraine Armed Forces, were utilized.

Results. In order to resolve the research task, the information technology for cryptographically-protected export/import of database tables rows has been developed. The developed information technology is presented as the technological processes of an export and import of information. The description of this technology in a form of a list of stages and the algorithms of information processing is in this article.

The time intervals of execution of the technological processes of export and import of information from the patients' records databases tables of the Ukraine Armed Forces health facilities have been determined with the developed information technology-based software. The results of these experiments, namely, the average time of export and import, is presented in tables in the article.

In order to assess the amount of information that can be exported and imported daily in the medical information system, frequency characteristics of the number of patients who were admitted in the above-mentioned health facilities of the Ukraine Armed Forces.

On the basis of the frequency characteristics data, the ranges of values (the number of admitted patients) that include the maximum value and values, which are most often found in the sample, also have been determined.

Also, in the article the main directions of application of the developed information technology for the construction of integrated information security systems have been considered.

Conclusions. Based on the results of the above studies, conclusions about the advantages and a possibility of daily use of the developed information technology for an export and import of information during functioning of medical information system is formulated.

In particular, the main advantages of the developed information technology are: providing with it the possibility of territorial and structural scaling of medical information systems in the absence of access to global information networks (Internet, etc.); suitability and ease using for the construction of integrated information security systems; ensuring a reduction of dependence of informatization projects in military medicine from a underdeveloped information infrastructure of segregate health facilities or their groups.

References

Ukaz Prezydenta Ukrainy vid 6 chervnia 2016 roku № 240/2016 "Pro rishennia Rady natsionalnoi bezpeky i oborony Ukrainy vid 20 travnia 2016 roku "Pro Stratehichnyi oboronnyi biuleten Ukrainy" [Decree of the President of Ukraine dated June 6, 2016 No. 240/2016 "On the decision of the National Security and Defense Council of Ukraine dated May 20, 2016,

"On the Strategic Defense Bulletin of Ukraine"]. (n.d.). Retrieved from http://zakon.rada.gov.ua/laws/ show/240/2016/paran10#n10 [in Ukrainian].

Rishennia RNBO Ukrainy vid 29 hrudnia 2016 roku, vvedene v diiu Ukazom Prezydenta Ukrainy vid 22 bereznia 2017 roku № 73/2017 "Pro Derzhavnu prohramu rozvytku Zbroinykh Syl Ukrainy na period do 2020 roku" [The decision of the National Security and Defense Council of Ukraine dated December 29, 2016, put into effect by the Decree of the President of Ukraine dated March 22, 2017 No. 73/2017 "On the State Program for the Development of the Armed Forces of Ukraine for the period up to 2020]. (n.d.). Retrieved from http://zakon.rada.gov.ua/laws/show/n0017525-16/ paran2#n2 [in Ukrainian].

Nakaz Ministra oborony Ukrainy vid 17.09.2014 № 650 "Pro zatverdzhennia Kontseptsii informatyzatsii Ministerstva oborony Ukrainy" [Order of the Minister of Defense of Ukraine No. 650 dated 17.09.2014 "On Approval of the Concept of Informatization of the Ministry of Defense of Ukraine"]. (n.d.). Retrieved from http://www.mil.gov.ua/content/other/MOU650_2014. pdf [in Ukrainian].

Lopin, Ye.B. (2013) Analiz chasovykh pokaznykiv shyfruvannia/deshyfruvannia failiv baz danykh medychnykh informatsiinykh system [Analysis of time distances of encryption/decryption of medical information systems databases files]. Medychna informatyka ta inzheneriia - Medical Informatics and Engineering, 4, 28-35 [in Ukrainian].

Blowfish [Descr. of cryptographic algorithm]. (December 5, 2006). Retrieved from http://ru.wikipedia.org/wiki/ Blowfish [in Russian].

Ivanov, V.S. (Eds.), (1990). Osnovy matematicheskoj statistiki: Uchebnoe posobie dlya in-tov fiz. kul't. [Fundamentals of mathematical statistics: Textbook for institutes of physical culture]. Moscow: Fizkul'tura i sport [in Russian].

Ukaz Prezydenta Ukrainy vid 26 travnia 2015 roku № 285/2015 "Pro rishennia Rady natsionalnoi bezpeky i oborony Ukrainy vid 6 travnia 2015 roku "Pro stan vykonannia rishen Rady natsionalnoi bezpeky i oborony Ukrainy ta dodatkovi zakhody shchodo zabezpechennia oboronozdatnosti derzhavy" [Decree of the President of Ukraine dated May 26, 2015, No. 285/2015 "On the decision of the National Security and Defense Council of Ukraine dated May 6, 2015 "On the state of implementation of the decisions of the National Security and Defense Council of Ukraine and additional measures to ensure the defense of the state"]. (n.d.). Retrieved from http://zakon.rada.gov.ua/laws/show/285/2015 [in Ukrainian].

Rishennia Rady natsionalnoi bezpeky i oborony Ukrainy vid 6 travnia 2015 r. "Pro stan vykonannia rishen Rady natsionalnoi bezpeky i oborony Ukrainy ta dodatkovi zakhody shchodo zabezpechennia oboronozdatnosti derzhavy" [The decision of the National Security and Defense Council of Ukraine dated May 6, 2015 "On the state of implementation of the decisions of the National Security and Defense Council of Ukraine and additional measures to ensure the defense capability of the state"]. (n.d.). Retrieved from http://zakon.rada.gov.ua/laws/ show/n0007525-15/paran2#n2 [in Ukrainian].

Kozyrev, A.A. (Eds.), (2003). Informacionnye tekhnologii v ehkonomike i upravlenii: Uchebnik. [Information Technologies in Economics and Management: A Textbook]. Saint Petersburg: Izd-vo Mihajlova V.A. [in Russian].

Tekhnologicheskij process [Technological process]. (October 2, 2009). Retrieved from https://ru.wikipedia. org/wiki/Texнологический_процесс [in Russian].

Delphi Encryption Compedium Part I v.3.0. (n.d.). Retrieved from http://torry.net/authorsmore. php?id=1881 [in English].

ND TZI 2.5-004-99 "Kryterii otsinky zakhyshchenosti informatsii v komp'iuternykh systemakh vid

nesanktsionovanoho dostupu" [Normative document on technical protection of information 2.5-004-99 "Criteria for assessing the security of information in computer systems from unauthorized access"]. (n.d.). Retrieved from http://dstszi.kmu.gov.ua/dstszi/doccatalog/ document?id=106342 [in Ukrainian].

ND TZI 2.5-005-99 "Klasyfikatsiia avtomatyzovanykh system i standartni funktsionalni profili zakhyshchenosti obrobliuvanoi informatsii vid nesanktsionovanoho dostupu" [Normative document on technical protection of information 2.5-005-99 "Classification of automated systems and standard functional profiles of protection of processed information from unauthorized access"]. (n.d.). Retrieved from http://dstszi.kmu.gov.ua/dstszi/control/ uk/publish/article;jsessionid= 5510AAB9DB971D6B 6F895BBA3ECD8BAD.app1?showHidden=1&art_ id=101870&cat_id=89734&ctime=1344501089407 [in Ukrainian].

Published

2018-12-21

How to Cite

Lopin, Y. B. (2018). INFORMATION TECHNOLOGY OF CRYPTOGRAPHY-PROTECTED EXPORTS (IMPORTS) OF ROWS OF DATABASE TABLES. Medical Informatics and Engineering, (2), 62–72. https://doi.org/10.11603/mie.1996-1960.2018.2.9296

Issue

Section

Articles