IDEAS home Printed from https://ideas.repec.org/a/gam/jijerp/v17y2020i15p5596-d393909.html
   My bibliography  Save this article

COVID-WAREHOUSE: A Data Warehouse of Italian COVID-19, Pollution, and Climate Data

Author

Listed:
  • Giuseppe Agapito

    (Department of Legal, Economic and Social Sciences, University Magna Graecia of Catanzaro, 88100 Catanzaro, Italy
    Data Analytics Research Center, University Magna Graecia of Catanzaro, 88100 Catanzaro, Italy)

  • Chiara Zucco

    (Department of Medical and Surgical Sciences, University Magna Graecia of Catanzaro, 88100 Catanzaro, Italy)

  • Mario Cannataro

    (Data Analytics Research Center, University Magna Graecia of Catanzaro, 88100 Catanzaro, Italy
    Department of Medical and Surgical Sciences, University Magna Graecia of Catanzaro, 88100 Catanzaro, Italy)

Abstract

The management of the COVID-19 pandemic presents several unprecedented challenges in different fields, from medicine to biology, from public health to social science, that may benefit from computing methods able to integrate the increasing available COVID-19 and related data (e.g., pollution, demographics, climate, etc.). With the aim to face the COVID-19 data collection, harmonization and integration problems, we present the design and development of COVID-WAREHOUSE, a data warehouse that models, integrates and stores the COVID-19 data made available daily by the Italian Protezione Civile Department and several pollution and climate data made available by the Italian Regions. After an automatic ETL (Extraction, Transformation and Loading) step, COVID-19 cases, pollution measures and climate data, are integrated and organized using the Dimensional Fact Model, using two main dimensions: time and geographical location. COVID-WAREHOUSE supports OLAP (On-Line Analytical Processing) analysis, provides a heatmap visualizer, and allows easy extraction of selected data for further analysis. The proposed tool can be used in the context of Public Health to underline how the pandemic is spreading, with respect to time and geographical location, and to correlate the pandemic to pollution and climate data in a specific region. Moreover, public decision-makers could use the tool to discover combinations of pollution and climate conditions correlated to an increase of the pandemic, and thus, they could act in a consequent manner. Case studies based on data cubes built on data from Lombardia and Puglia regions are discussed. Our preliminary findings indicate that COVID-19 pandemic is significantly spread in regions characterized by high concentration of particulate in the air and the absence of rain and wind, as even stated in other works available in literature.

Suggested Citation

  • Giuseppe Agapito & Chiara Zucco & Mario Cannataro, 2020. "COVID-WAREHOUSE: A Data Warehouse of Italian COVID-19, Pollution, and Climate Data," IJERPH, MDPI, vol. 17(15), pages 1-22, August.
    • Handle: RePEc:gam:jijerp:v:17:y:2020:i:15:p:5596-:d:393909
    as

    Download full text from publisher

    File URL: https://www.mdpi.com/1660-4601/17/15/5596/pdf
    Download Restriction: no
    File URL: https://www.mdpi.com/1660-4601/17/15/5596/
    Download Restriction: no
    ---><---

    References listed on IDEAS

    as
    1. Erik Brynjolfsson & John J. Horton & Adam Ozimek & Daniel Rock & Garima Sharma & Hong-Yi TuYe, 2020. "COVID-19 and Remote Work: An Early Look at US Data," NBER Working Papers 27344, National Bureau of Economic Research, Inc.
    2. Marianna Milano & Mario Cannataro, 2020. "Statistical and Network-Based Analysis of Italian COVID-19 Data: Communities Detection and Temporal Evolution," IJERPH, MDPI, vol. 17(12), pages 1-64, June.
    3. Behrouz Pirouz & Sina Shaffiee Haghshenas & Behzad Pirouz & Sami Shaffiee Haghshenas & Patrizia Piro, 2020. "Development of an Assessment Method for Investigating the Impact of Climate and Urban Parameters in Confirmed Cases of COVID-19: A New Challenge in Sustainable Development," IJERPH, MDPI, vol. 17(8), pages 1-17, April.
    Full references (including those not matched with items on IDEAS)

    Citations

    Citations are extracted by the CitEc Project, subscribe to its RSS feed for this item.
    as


    Cited by:

    1. David Meintrup & Martina Nowak-Machen & Stefan Borgmann, 2021. "Nine Months of COVID-19 Pandemic in Europe: A Comparative Time Series Analysis of Cases and Fatalities in 35 Countries," IJERPH, MDPI, vol. 18(12), pages 1-17, June.

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Raymond Hernandez & Elizabeth A. Pyatak & Cheryl L. P. Vigen & Haomiao Jin & Stefan Schneider & Donna Spruijt-Metz & Shawn C. Roll, 2021. "Understanding Worker Well-Being Relative to High-Workload and Recovery Activities across a Whole Day: Pilot Testing an Ecological Momentary Assessment Technique," IJERPH, MDPI, vol. 18(19), pages 1-17, October.
    2. Filippos Petroulakis, 2023. "Task Content and Job Losses in the Great Lockdown," ILR Review, Cornell University, ILR School, vol. 76(3), pages 586-613, May.
    3. Elstner, Steffen & Grimme, Christian & Kecht, Valentin & Lehmann, Robert, 2022. "The diffusion of technological progress in ICT," European Economic Review, Elsevier, vol. 149(C).
    4. Malik, Khyati & Kim, Sowon & Cultice, Brian J., 2023. "The impact of remote work on green space values in regional housing markets," Journal of Housing Economics, Elsevier, vol. 62(C).
    5. Ina Kern & Philip Emmerich & Anna Lübbe, 2023. "How to Enable Trust While Transforming Teamwork from a Face-to-Face to a Virtual Environment in the Context of COVID-19," Central European Business Review, Prague University of Economics and Business, vol. 2023(5), pages 117-149.
    6. Barrero, Jose Maria & Bloom, Nick & Davis, Steven J., 2020. "Why Working From Home Will Stick," SocArXiv wfdbe, Center for Open Science.
    7. Masayuki Morikawa, 2023. "Productivity dynamics of remote work during the COVID‐19 pandemic," Industrial Relations: A Journal of Economy and Society, Wiley Blackwell, vol. 62(3), pages 317-331, July.
    8. Nicholas Bloom & Philip Bunn & Paul Mizen & Pawel Smietanka & Gregory Thwaites, 2020. "The Impact of Covid-19 on Productivity," NBER Working Papers 28233, National Bureau of Economic Research, Inc.
    9. Jesper Akesson & Sam Ashworth-Hayes & Robert Hahn & Robert Metcalfe & Itzhak Rasooly, 2022. "Fatalism, beliefs, and behaviors during the COVID-19 pandemic," Journal of Risk and Uncertainty, Springer, vol. 64(2), pages 147-190, April.
    10. Yoon, Jisung & Park, Jinseo & Yun, Jinhyuk & Jung, Woo-Sung, 2023. "Quantifying knowledge synchronization with the network-driven approach," Journal of Informetrics, Elsevier, vol. 17(4).
    11. Julia Darby & Stuart McIntyre & Graeme Roy, 2022. "What can analysis of 47 million job advertisements tell us about how opportunities for homeworking are evolving in the United Kingdom?," Industrial Relations Journal, Wiley Blackwell, vol. 53(4), pages 281-302, July.
    12. Holgersen, Henning & Jia, Zhiyang & Svenkerud, Simen, 2021. "Who and how many can work from home? Evidence from task descriptions," Journal for Labour Market Research, Institut für Arbeitsmarkt- und Berufsforschung (IAB), Nürnberg [Institute for Employment Research, Nuremberg, Germany], vol. 55, pages 1-4.
    13. Christian Kagerl & Julia Starzetz, 2023. "Working from home for good? Lessons learned from the COVID-19 pandemic and what this means for the future of work," Journal of Business Economics, Springer, vol. 93(1), pages 229-265, January.
    14. French, Michael T. & Gumus, Gulcin, 2021. "Death on the job: The Great Recession and work-related traffic fatalities," Social Science & Medicine, Elsevier, vol. 280(C).
    15. Alina Simona Tecau & Cristinel Petrisor Constantin & Radu Constantin Lixandroiu & Ioana Bianca Chitu & Gabriel Bratucu, 2020. "Impact of the COVID-19 Crisis on Heavy Work Investment in Romania," The AMFITEATRU ECONOMIC journal, Academy of Economic Studies - Bucharest, Romania, vol. 22(Special 1), pages 1049-1049, November.
    16. Hansen, Stephen & Lambert, Peter John & Bloom, Nicholas & Davis, Steven J. & Sadun, Raffaella & Taska, Bledi, 2023. "Remote Work across Jobs, Companies, and Space," IZA Discussion Papers 15980, Institute of Labor Economics (IZA).
    17. Doerr, S. & Erdem, M. & Franco, G. & Gambacorta, L. & Illes, A., 2021. "Technological capacity and firms’ recovery from Covid-19," Economics Letters, Elsevier, vol. 209(C).
    18. Astorquiza-Bustos, Bilver Adrian & Quintero-Peña, Jose Wilmar, 2023. "Who can work from home? A remote working index for an emerging economy," Telecommunications Policy, Elsevier, vol. 47(10).
    19. Leukhina Oksana & Yu Zhixiu, 2022. "Home Production and Leisure during the COVID-19 Recession," The B.E. Journal of Macroeconomics, De Gruyter, vol. 22(1), pages 269-306, January.
    20. Vijaya Sunder M & Anupama Prashar, 2023. "State and citizen responsiveness in fighting a pandemic crisis: A systems thinking perspective," Systems Research and Behavioral Science, Wiley Blackwell, vol. 40(1), pages 170-193, January.

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:gam:jijerp:v:17:y:2020:i:15:p:5596-:d:393909. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: MDPI Indexing Manager (email available below). General contact details of provider: https://www.mdpi.com .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.