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. 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.
    2. 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.
    3. 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.
    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. Carlos Díaz & Sebastian Fossati & Nicolás Trajtenberg, 2022. "Stay at home if you can: COVID‐19 stay‐at‐home guidelines and local crime," Journal of Empirical Legal Studies, John Wiley & Sons, vol. 19(4), pages 1067-1113, December.
    3. Louis-Philippe Beland & Abel Brodeur & Taylor Wright, 2020. "COVID-19, Stay-at-Home Orders and Employment: Evidence from CPS Data," Carleton Economic Papers 20-04, Carleton University, Department of Economics, revised 19 May 2020.
    4. Radu Vranceanu & Angela Sutan, 2023. "Should the firm or the employee pay for upskilling? A contract theory approach," Managerial and Decision Economics, John Wiley & Sons, Ltd., vol. 44(1), pages 197-207, January.
    5. Sangeeta Gupta & Poonam Devdutt & Urmila Jagadeeswari Itam, 2022. "Centrality of psychological well-being of IT employees during COVID-19 and beyond," DECISION: Official Journal of the Indian Institute of Management Calcutta, Springer;Indian Institute of Management Calcutta, vol. 49(4), pages 365-380, December.
    6. 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.
    7. Elstner, Steffen & Grimme, Christian & Kecht, Valentin & Lehmann, Robert, 2022. "The diffusion of technological progress in ICT," European Economic Review, Elsevier, vol. 149(C).
    8. Bergeaud, Antonin & Eyméoud, Jean-Benoît & Garcia, Thomas & Henricot, Dorian, 2023. "Working from home and corporate real estate," Regional Science and Urban Economics, Elsevier, vol. 99(C).
    9. Ko, Eun-Jung & Kim, A-Hyun & Kim, Sang-Soo, 2021. "Toward the understanding of the appropriation of ICT-based Smart-work and its impact on performance in organizations," Technological Forecasting and Social Change, Elsevier, vol. 171(C).
    10. Hamish Low & Michaela Benzeval & Jon Burton & Thomas F. Crossley & Paul Fisher & Annette Jäckle & Brendan Read, 2020. "The Idiosyncratic Impact of an Aggregate Shock The Distributional Consequences of COVID-19," Economics Series Working Papers 911, University of Oxford, Department of Economics.
    11. Giorgio Gnecco & Sara Landi & Massimo Riccaboni, 2024. "The emergence of social soft skill needs in the post COVID-19 era," Quality & Quantity: International Journal of Methodology, Springer, vol. 58(1), pages 647-680, February.
    12. 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.
    13. Ruud Gerards & Sanne Wetten & Cecile Sambeek, 2021. "New ways of working and intrapreneurial behaviour: the mediating role of transformational leadership and social interaction," Review of Managerial Science, Springer, vol. 15(7), pages 2075-2110, October.
    14. Barrero, Jose Maria & Bloom, Nick & Davis, Steven J., 2020. "Why Working From Home Will Stick," SocArXiv wfdbe, Center for Open Science.
    15. 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.
    16. 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.
    17. Marz, Waldemar & Şen, Suphi, 2022. "Does telecommuting reduce commuting emissions?," Journal of Environmental Economics and Management, Elsevier, vol. 116(C).
    18. Christina Kakderi & Nicos Komninos & Anastasia Panori & Eleni Oikonomaki, 2021. "Next City: Learning from Cities during COVID-19 to Tackle Climate Change," Sustainability, MDPI, vol. 13(6), pages 1-21, March.
    19. 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.
    20. Christopher L. Foote & Tyler Hounshell & William D. Nordhaus & Douglas Rivers & Pamela Torola, 2021. "Measuring the US Employment Situation Using Online Panels: The Yale Labor Survey," Current Policy Perspectives 93422, Federal Reserve Bank of Boston.

    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.