A Relational Database Structure for Linking Air Pollution Levels with Children’s Respiratory Illnesses

Daniel DUNEA, Stefania IORDACHE, Mihaela OPREA, Tom SAVU, Alin POHOATA, Emil LUNGU

Abstract


Pollutants' data, meteorological data and medical data feeds the relational database with information from vulnerable urban areas (i.e., Targoviste and Ploiesti), which will help the running of algorithms between air quality, meteorology and health effects and later use of forecasted outputs to forecast health effects. Several computer-based tools were developed to facilitate the population of the database with specific data from various sources. One of these tools allows the automatic capturing of pollutants’ concentrations from web-based official sources. The relational database structure integrates the fields for the required variables in the attributed data tables (PM2.5 and carried compounds/metals sub-database, meteorological sub-database and medical sub-database). The main criteria in selecting the respiratory illnesses that are linked to atmospheric pollution for children are the wheezing. The medical database contains as main fields: the number of wheezing episodes, number of asthma attacks (with hospitalization), the response to inhalation medication, medication controller, eosinophil count, serum level of E immunoglobins (lgE), and residential address and school/kindergarten address of the children. The presented database structure and adjacent tools are expected to improve the current monitoring methodology of air pollutants, mainly respirable dusts, and their content in various compounds in correlation with children’s health.


Keywords


air pollution; computer-based tools; population exposure; relational database

Full Text:

PDF


DOI: http://dx.doi.org/10.15835/buasvmcn-agr:10689


University of Agricultural Sciences and Veterinary Medicine
3-5 Manastur St., 400372 Cluj-Napoca
Romania
Tel: +40-264-596.384 | Fax: +40-264-593.792 
biroupublicatii@usamvcluj.ro