Paper Info
Title
An online analytical processing multi-dimensional data warehouse for malaria data.
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 multidimensional, 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.
Year
DOI
Venue
2017
10.1093/database/bax073
DATABASE-THE JOURNAL OF BIOLOGICAL DATABASES AND CURATION
Field
DocType
Volume
Data warehouse,Data mining,Data transformation,Star schema,Computer data storage,Visualization,Computer science,Dimensional modeling,Online analytical processing,Snowflake schema,Database
Journal
2017
ISSN
Citations 
PageRank 
1758-0463
0
0.34
References 
Authors
8
6
Name
Order
Citations
PageRank
S. M. Niaz Arifin11228.12
Gregory R. Madey244149.83
Alexander Vyushkov300.68
Benoit Raybaud400.34
Thomas R Burkot500.68
Frank H. Collins6565.54