{"title":"Dimensional Modeling of HIV Data Using Open Source","authors":"Charles D. Otine, Samuel B. Kucel, Lena Trojer","country":null,"institution":"","volume":39,"journal":"International Journal of Computer and Systems Engineering","pagesStart":95,"pagesEnd":101,"ISSN":"1307-6892","URL":"https:\/\/publications.waset.org\/pdf\/8994","abstract":"Selecting the data modeling technique for an\r\ninformation system is determined by the objective of the resultant\r\ndata model. Dimensional modeling is the preferred modeling\r\ntechnique for data destined for data warehouses and data mining,\r\npresenting data models that ease analysis and queries which are in\r\ncontrast with entity relationship modeling. The establishment of data\r\nwarehouses as components of information system landscapes in\r\nmany organizations has subsequently led to the development of\r\ndimensional modeling. This has been significantly more developed\r\nand reported for the commercial database management systems as\r\ncompared to the open sources thereby making it less affordable for\r\nthose in resource constrained settings. This paper presents\r\ndimensional modeling of HIV patient information using open source\r\nmodeling tools. It aims to take advantage of the fact that the most\r\naffected regions by the HIV virus are also heavily resource\r\nconstrained (sub-Saharan Africa) whereas having large quantities of\r\nHIV data. Two HIV data source systems were studied to identify\r\nappropriate dimensions and facts these were then modeled using two\r\nopen source dimensional modeling tools. Use of open source would\r\nreduce the software costs for dimensional modeling and in turn make\r\ndata warehousing and data mining more feasible even for those in\r\nresource constrained settings but with data available.","references":null,"publisher":"World Academy of Science, Engineering and Technology","index":"Open Science Index 39, 2010"}