Paper 4
A Data Warehouse of Wi-Fi Sessions for Contact Tracing and Outbreak InvestigationAuthors: Guilherme Augusto Zagatti, See-Kiong Ng, Stéphane Bressan |
AbstractThe COVID-19 pandemic has spurred the development of a large number of automated and semi-automated contact tracing frameworks. Many of these are reactive and require active client participation, such as installing a specific contact tracing app on the clients’ smartphones, and they are often unable to scale in time to reach the requisite critical mass adoption. To be better prepared for the emergence and re-emergence of coronavirus epidemics, we seek to leverage on the availability of common existing digital infrastructure such as the increasingly ubiquitous Wi-Fi networks that can be readily activated to assist in large-scale contact tracing. We present and discuss the design, implementation, and deployment of a data warehouse of Wi-Fi sessions for contact tracing and disease outbreak investigation. We discuss the conceptual design of the data warehouse and present the logical model that implements the conceptual model. We describe the data staging procedures and discuss the analysis of the Wi-Fi session data for mobility-based contact tracing and disease outbreak investigation. Finally, we present the case where the data warehouse of Wi-Fi sessions is experimentally deployed at full scale on a large local university campus in Singapore. Keywords: Data warehouse, COVID-19, Contact tracing, Epidemiology. |