Dimensional modeling of HIV data using open source

Document type: Journal Articles
Article type: Original article
Peer reviewed: Yes
Author(s): Charles Otine, Samule Baker Kucel, Lena Trojer
Title: Dimensional modeling of HIV data using open source
Journal: Proceedings of World Academy of Science, Engineering and Technology
Year: 2010
Volume: 62
Issue: March
Pagination: 156-161
ISSN: 2010-376X
Publisher: World Academy of Science, Engineering and Technology
Organization: Blekinge Institute of Technology
Department: School of Planning and Media Design (Sektionen för planering och mediedesign)
School of Planning and Media Design S-371 79 Karlskrona
+46 455 38 50 00
http://www.bth.se/dsn/
Language: English
Abstract: Selecting the data modeling technique for an information system is determined by the objective of the resultant data model. Dimensional modeling is the preferred modeling technique for data destined for data warehouses and data mining, presenting data models that ease analysis and queries which are in contrast with entity relationship modeling. The establishment of data warehouses as components of information system landscapes in many organizations has subsequently led to the development of dimensional modeling. This has been significantly more developed and reported for the commercial database management systems as compared to the open sources thereby making it less affordable for those in resource constrained settings. This paper presents dimensional modeling of HIV patient information using open source modeling tools. It aims to take advantage of the fact that the most affected regions by the HIV virus are also heavily resource constrained (sub-Saharan Africa) whereas having large quantities of HIV data. Two HIV data source systems were studied to identify appropriate dimensions and facts these were then modeled using two open source dimensional modeling tools. Use of open source would reduce the software costs for dimensional modeling and in turn make data warehousing and data mining more feasible even for those in resource constrained settings but with data available.
Subject: Technoscience Studies\ICT for Development
Keywords: About database, Data mining, Data warehouse, Dimensional modeling, Open source
Edit