Abstract
The paper reports on a case study regarding the integration of heterogeneous data sources, coming from different institutions, needed to support several studies related to the health status of the population of L’Aquila (Italy) after the earthquake of April 6th 2009. In detail, the paper initially describes all the health studies, then the data sources required to support them, finally proposes a simplified federated architecture and a straightforward technological solution to implement it.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsNotes
- 1.
The Abruzzo’s RHA is a technical body of the Abruzzo Region that concurs to the definition of the health policies and strategies.
- 2.
The case of citizen that provide to an alternative accommodation by themselves.
- 3.
New houses build for the emergency period by the central government.
- 4.
Temporary houses built for the emergency period by the municipality.
- 5.
For sake of clarity, in English, COD_FISCALE is the tax code, DATA_RIC means the date of admission, DATA_DIM means the date of discharge.
References
AIFA. L’uso dei farmaci in Italia - Rapporto OsMed 2015 (2015)
Asher, M.I., Montefort, S., Björkstén, B., Lai, C.K.W., Strachan, D.P., Weiland, S.K., Williams, H., ISAAC Phase Three Study Group.: Worldwide time trends in the prevalence of symptoms of asthma, allergic rhinoconjunctivitis, eczema in childhood: ISAAC phases one and three repeat multicountry cross-sectional surveys. Lancet (Lond. Engl.) 368(9537), 733–743 (2006)
Bartholomew, D.: MariaDB Cookbook. Packt Publishing Ltd, Birmingham (2014)
Beck, C.A., Southern, D.A., Saitz, R., Knudtson, M.L., Ghali, W.A.: Alcohol and drug use disorders among patients with myocardial infarction: associations with disparities in care and mortality. PloS One 8(9), e66551 (2013)
Bingefors, K., Svensson, A., Isacson, D., Lindberg, M.: Self-reported lifetime prevalence of atopic dermatitis and co-morbidity with asthma and eczema in adulthood: a population-based cross-sectional survey. Acta Dermato-Venereologica 93(4), 438–441 (2013)
Burgio, A., Grippo, F., Pappagallo, M., Crialesi, R.: Hospitalization for drug-related disorders in Italy: trends and comorbidity. Epidemiol. Biostatistics Publ. Health 12(1), 1–6 (2015)
Cofini, V., Carbonelli, A., Cecilia, M.R., Binkin, N., di Orio, F.: Post traumatic stress disorder and coping in a sample of adult survivors of the Italian earthquake. Psychiatry Res. 229(1–2), 353–358 (2015)
Comino, E.J., Hermiz, O., Flack, J., Harris, E., Powell Davies, G., Harris, M.F.: Using population health surveys to provide information on access to and use of quality primary health care. Aust. Health Rev.: Publ. Aust. Hosp. Assoc. 30(4), 485–495 (2006)
Conferenza delle Regioni e delle Provincie Autonome. Accordo Interregionale per la Compensazione della Mobilità Sanitaria, May 2013
Davis, K., Anderson, G., Steinberg, E.: Diagnosis related group prospective payment: implications for health care and medical technology. Health Policy (Amst. Neth.) 4(2), 139–147 (1984)
Dusetzina, S.B., Tyree, S., Meyer, A.-M., Meyer, A., Green, L., Carpenter, W.R.: An Overview of Record Linkage Methods. Agency for Healthcare Research and Quality (US), September 2014
Elmasri, R., Navathe, S.B.: Fundamentals of Database Systems. Prentice Hall College Div, Boston (2010). 6 har/psc edizione edition
Fabiani, L., Mammarella, L., Vittorini, P., Zazzara, F., Di Orio, F.: Preliminary analysis of the respiratory disease, based on hospital discharge records, in the province of L’Aquila, Abruzzo, Italy. Annali Di Igiene: Medicina Preventiva E Di Comunita 28(6), 392–403 (2016)
Gigantesco, A., Mirante, N., Granchelli, C., Diodati, G., Cofini, V., Mancini, C., Carbonelli, A., Tarolla, E., Minardi, V., Salmaso, S., D’Argenio, P.: Psychopathological chronic sequelae of the 2009 earthquake in L’Aquila, Italy. J. Affect. Disord. 148(2–3), 265–271 (2013)
Haas, L., Miller, R., Niswonger, B., Tork Roth, M., Schwarz, P., Wimmers, E.: Transforming heterogeneous data with database middleware: beyond integration. Data Eng. 22(1), 31–36 (1999)
Indinnimeo, L., Porta, D., Forastiere, F., De Vittori, V., De Castro, G., Zicari, A.M., Tancredi, G., Melengu, T., Duse, M.: Prevalence and risk factors for atopic disease in a population of preschool children in Rome: challenges to early intervention. Int. J. Immunopathol. Pharmacol. 29(2), 308–319 (2016)
Watson, J.T., Gayer, M., Connolly, M.A.: Epidemics after natural disasters. Emerg. Infect. Dis. J. 13(1), 1 (2007)
Kawano, T., Hasegawa, K., Watase, H., Morita, H., Yamamura, O.: Infectious disease frequency among evacuees at shelters after the great eastern Japan earthquake and tsunami: a retrospective study. Disaster Med. Publ. Health Preparedness 8(1), 58–64 (2014)
Kouadio, I.K., Aljunid, S., Kamigaki, T., Hammad, K., Oshitani, H.: Infectious diseases following natural disasters: prevention and control measures. Expert Rev. Anti-Infective Therapy 10(1), 95–104 (2012)
MariaDB. CONNECT Table Types, December 2016
MariaDB. User-defined Functions, December 2016
Mattei, A., Angelone, A.M., Michetti, M., Sbarbati, M., Ceci, R., Murgano, A., di Orio, F.: Epidemiological impact of RV gastroenteritis in the Abruzzo Region: SDO analysis. Annali Di Igiene: Medicina Preventiva E Di Comunita 21(1), 41–49 (2009)
Mattei, A., Sbarbati, M., Fiasca, F., Angelone, A.M., Mazzei, M.C., di Orio, F.: Temporal trends in hospitalization for rotavirus gastroenteritis: a nationwide study in Italy, 2005–2012. Hum. Vaccines Immunotherapeutics 12(2), 534–539 (2016)
Minardi, V., Gigantesco, A., Mancini, C., Quarchioni, E., D’Argenio, P., Cofini, V.: Behavioural risk factors in L’Aquila (Central Italy) 3–5 years after the 2009 earthquake. Epidemiologia E Prevenzione 40(2 Suppl 1), 34–41 (2016)
Ministero della Salute. Sistemi di sorveglianza, May 2016
Mohammed, M.A., Stevens, A.: The value of administrative databases. BMJ: Br. Med. J. 334(7602), 1014–1015 (2007)
W. H. Organization. International Statistical Classification of Diseases and Related Health Problems, vol. 1. World Health Organization, Geneva (2004)
Parker, J.D., Akinbami, L.J., Woodruff, T.J.: Air pollution and childhood respiratory allergies in the United States. Environ. Health Perspect. 117(1), 140–147 (2009)
Pollice, R., Bianchini, V., Roncone, R., Casacchia, M.: Marked increase in substance use among young people after L’Aquila earthquake. Eur. Child Adolesc. Psychiatry 20(8), 429–430 (2011)
Rahm, E., Bernstein, P.A.: A survey of approaches to automatic schema matching. VLDB J. 10(4), 334–350 (2001)
Reddy, M.P., Prasad, B.E., Reddy, P.G., Gupta, A.: A methodology for integration of heterogeneous databases. IEEE Trans. Knowl. Data Eng. 6(6), 920–933 (1994)
Riedler, J., Braun-Fahrländer, C., Eder, W., Schreuer, M., Waser, M., Maisch, S., Carr, D., Schierl, R., Nowak, R., von Mutius, E., ALEX Study Team.: Exposure to farming in early life, development of asthma, allergy: a cross-sectional survey. Lancet (Lond. Engl.) 358(9288), 1129–1133 (2001)
Ripoll Gallardo, A., Alesina, M., Pacelli, B., Serrone, D., Iacutone, G., Faggiano, F., Della Corte, F., Allara, E.: Medium- and long-term health effects of the L’Aquila earthquake (Central Italy, 2009) and of other earthquakes in high-income Countries: a systematic review. Epidemiologia E Prevenzione 40(2 Suppl 1), 14–21 (2016)
Romanelli, A.M., Raciti, M., Protti, M.A., Prediletto, R., Fornai, E., Faustini, A.: How reliable are current data for assessing the actual prevalence of chronic obstructive pulmonary disease? PloS One 11(2), e0149302 (2016)
Roth, M.T., Schwarz, P.M.: Don’t scrap it, wrap it! A wrapper architecture for legacy data sources. In: VLDB, vol. 97, pp. 25–29 (1997)
Ruokolainen, L., von Hertzen, L., Fyhrquist, N., Laatikainen, T., Lehtomäki, J., Auvinen, P., Karvonen, A.M., Hyvärinen, A., Tillmann, V., Niemelä, O., Knip, M., Haahtela, T., Pekkanen, J., Hanski, I.: Green areas around homes reduce atopic sensitization in children. Allergy 70(2), 195–202 (2015)
Sheth, A.P., Larson, J.A.: Federated database systems for managing distributed, heterogeneous, and autonomous databases. ACM Comput. Surv. 22(3), 183–236 (1990)
Sorrentino, C.: La dinamica temporale della variabilità regionale, July 2013
Sujansky, W.: Heterogeneous database integration in biomedicine. J. Biomed. Inform. 34(4), 285–298 (2001)
Thygesen, L.C., Ersbøll, A.K.: When the entire population is the sample: strengths and limitations in register-based epidemiology. Eur. J. Epidemiol. 29(8), 551–558 (2014)
van der Hulst, A.E., Klip, H., Brand, P.L.P.: Risk of developing asthma in young children with atopic eczema: a systematic review. J. Allergy Clin. Immunol. 120(3), 565–569 (2007)
Williams, H.C.: Clinical practice. Atopic dermatitis. New Engl. J. Med. 352(22), 2314–2324 (2005)
Zuberbier, T., Lötvall, J., Simoens, S., Subramanian, S.V., Church, M.K.: Economic burden of inadequate management of allergic diseases in the European Union: a GA(2) LEN review. Allergy 69(10), 1275–1279 (2014)
Acknowledgements
The authors thank Dr. Mascitelli and Dr. Di Candia for their valuable support.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2017 Springer International Publishing AG
About this paper
Cite this paper
Vittorini, P., Angelone, A.M., Cofini, V., Fabiani, L., Mattei, A., Necozione, S. (2017). A Case Study on the Integration of Heterogeneous Data Sources in Public Health. In: Rojas, I., Ortuño, F. (eds) Bioinformatics and Biomedical Engineering. IWBBIO 2017. Lecture Notes in Computer Science(), vol 10209. Springer, Cham. https://doi.org/10.1007/978-3-319-56154-7_37
Download citation
DOI: https://doi.org/10.1007/978-3-319-56154-7_37
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-56153-0
Online ISBN: 978-3-319-56154-7
eBook Packages: Computer ScienceComputer Science (R0)