350 rub
Journal Information-measuring and Control Systems №7 for 2012 г.
Article in number:
Data processing system of medical examination and physical qualification of schoolchildren based on relational model
Authors:
M.А. Lyadov, S.B. Frolov
Abstract:
In the network of a pilot project to improve school meals in 2008, in Tambov region began to be monitored the health of schoolchildren. In the process of monitoring the measurement of anthropometric parameters, blood pressure, assessment of physical qualification, the distribution of schoolchildren by group health and fitness groups, taking into account both acute and chronic morbidity. In evaluating the results of measurements used sophisticated and age-related sexual norms, based on the percentile distribution, which is most applicable in medical practice today. In this regard, in monitoring the influx of students there is a problem of automated evaluation of the results of measurements on standards. To solve this problem in 2011 at the Department of «Biomedical engineering» of Tambov State Technical University has developed an automated information system (AIS) «Children's Health». Mathematical tool for assessing the health status of the AIS «Child» is a relational data model. The basis of the relational data model is the relationship, which basically represent different age and sex norms required in calculating the overall weight and height indices and blood pressure of the child. In conducting the medical examination system user sets such information of schoolchild as sex, date of birth, height, weight, systolic and diastolic blood pressure, date of examination, etc. The system automatically evaluates the input data and provides user with the result of evaluation of individual student health. In evaluating the results of measurements of relations, in which age-sex norms are laid, relational algebra operations are applied: selection, projection, and connection. Similarly, the system assesses the level of physical qualification of schoolchildren. Height and weight recorded in the student's AIS via USB-port with electronic Rostom Mr. weights and the complex CMD «Healthy Child», produced by JSC Tulinovka-s instrument-building plant «TVES». At the present, 102 work places AIS «Children's Health» are established in the schools of Tambov region. Using the reduced model, the analysis of individual health state of 51 677 pupils was conducted, which confirms the correctness of the constructed models. Data processing system, building on the relational model, enables the assessment of the health status of schoolchildren in the AIS «Children's Health».
Pages: 55-62
References
  1. Кучма В.Р., Сухарева Л. М., Рапопорт И. К., Горелова Ж. Ю., Ямпольская Ю. А., Звездина И. В. Мониторинг состояния здоровья обучающихся, воспитанников и заболеваемости, связанной с алиментарными факторами, в процессе реализации экспериментальных проектов по совершенствованию организации питания обучающихся в общеобразовательных учреждениях (Методические указания) М.: РАМН, ГУ НЦ здоровья детей, НИИ гигиены и охраны здоровья детей и подростков, некоммерческое партнерство «Федерация рестораторов и отельеров». 2008.
  2. Фролов С. В., Лядов М. А., Комарова И. А. Региональная информационная система мониторинга здоровья школьников // Врач и информационные технологии. 2011. № 6. С. 24-33.
  3. Мейер Д. Теория реляционных баз данных. М.: Мир. 1987.
  4. Фролов С. В., Фролова М. С., Лоскутов С. А. Комплекс для автоматизации работы врача-педиатра // Бюллетень Волгоградского научного центра РАМН и Администрации Волгоградской области. 2007. №3. С.63-64.