Knowledge Synthesize System Base on Research Document
COVID-WAREHOUSE: A Data Warehouse of Italian COVID-19, Pollution, and Climate Data | |
Agapito, Giuseppe; Cannataro, Mario; Zucco, Chiara | |
2020-08 | |
发表期刊 | INTERNATIONAL JOURNAL OF ENVIRONMENTAL RESEARCH AND PUBLIC HEALTH |
EISSN | 1660-4601 |
摘要 | 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. |
关键词 | Italian COVID-19 data data analysis data warehouse data integration pollution data climate data |
DOI | 10.3390/ijerph17155596 |
WOS研究方向 | Environmental Sciences & Ecology ; Public, Environmental & Occupational Health |
WOS类目 | Environmental Sciences ; Public, Environmental & Occupational Health |
出版者 | MDPI |
引用统计 | |
文献类型 | 期刊论文 |
专题 | 新冠肺炎 循证社会科学证据集成 |
作者单位 | Magna Graecia Univ Catanzaro |
推荐引用方式 GB/T 7714 | Agapito, Giuseppe,Cannataro, Mario,Zucco, Chiara. COVID-WAREHOUSE: A Data Warehouse of Italian COVID-19, Pollution, and Climate Data[J]. INTERNATIONAL JOURNAL OF ENVIRONMENTAL RESEARCH AND PUBLIC HEALTH,2020. |
APA | Agapito, Giuseppe,Cannataro, Mario,&Zucco, Chiara.(2020).COVID-WAREHOUSE: A Data Warehouse of Italian COVID-19, Pollution, and Climate Data.INTERNATIONAL JOURNAL OF ENVIRONMENTAL RESEARCH AND PUBLIC HEALTH. |
MLA | Agapito, Giuseppe,et al."COVID-WAREHOUSE: A Data Warehouse of Italian COVID-19, Pollution, and Climate Data".INTERNATIONAL JOURNAL OF ENVIRONMENTAL RESEARCH AND PUBLIC HEALTH (2020). |
条目包含的文件 | 下载所有文件 | |||||
文件名称/大小 | 文献类型 | 版本类型 | 开放类型 | 使用许可 | ||
Agapito-2020-COVID-W(2172KB) | 期刊论文 | 出版稿 | 开放获取 | CC BY-NC-SA | 浏览 下载 |
除非特别说明,本系统中所有内容都受版权保护,并保留所有权利。
修改评论