Abstract
Malaria is a vector-borne disease that contributes substantially to the global burden of morbidity and mortality. The management of malaria-related data from heterogeneous, autonomous, and distributed data sources poses unique challenges and requirements. Although online data storage systems exist that address specific malaria-related issues, a globally integrated online resource to address different aspects of the disease does not exist. In this article, we describe the design, implementation, and applications of a multi-dimensional, online analytical processing data warehouse, named the VecNet Data Warehouse (VecNet-DW). It is the first online, globally-integrated platform that provides efficient search, retrieval and visualization of historical, predictive, and static malaria-related data, organized in data marts. Historical and static data are modelled using star schemas, while predictive data are modelled using a snowflake schema. The major goals, characteristics, and components of the DW are described along with its data taxonomy and ontology, the external data storage systems and the logical modelling and physical design phases. Results are presented as screenshots of a Dimensional Data browser, a Lookup Tables browser, and a Results Viewer interface. The power of the DW emerges from integrated querying of the different data marts and structuring those queries to the desired dimensions, enabling users to search, view, analyse, and store large volumes of aggregated data, and responding better to the increasing demands of users.Database URL https://dw.vecnet.org/datawarehouse/
Highlights
Malaria is probably the third most important pathogenspecific cause of human morbidity and mortality in the world today
The data sources ingested in the data marts and the lookup tables in Vector-Borne Disease Network (VecNet)-data warehouse (DW) are available in the VecNet Digital Library [24], which is another major component of VecNet
Interventions: contains operational coverage data for three malaria control interventions: artemisinin combination therapy (ACT), indoor residual spraying (IRS) and insecticide-treated net (ITN) [4], which are stored as individual fact tables; associated with dimensions ‘location’ and ‘date’
Summary
Malaria is probably the third most important pathogenspecific cause of human morbidity and mortality in the world today. VecNet-DW is an online multi-dimensional DW, designed to store, access, and analyse malaria-related data scattered in heterogeneous forms across many data storage systems. Subject-oriented: VecNet-DW targets multiple subjects of analysis according to the requirements of malaria decision-making managers/users at various levels; these subjects include data on existing and new malaria control interventions, household surveys, antimalarial drugs, entomological inoculation rates (EIRs), distributions and abundances of dominant vector species, various models and studies (e.g. mathematical, agent-based, field-based), model-specific parameters etc. VecNet-DW serves a wide range of (often overlapping) user groups, including researchers, modellers, malaria control managers, product developers, etc It stores three broad categories of data: historical, predictive, and static. A dictionary may in turn be a relational table, or may contain semantic definitions (Level 4), which are stored as records
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
More From: Database : the journal of biological databases and curation
Disclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.