Change search
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • harvard1
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • Other style
More styles
Language
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Other locale
More languages
Output format
  • html
  • text
  • asciidoc
  • rtf
Dimensional modeling of HIV data using open source
Responsible organisation
2010 (English)In: Proceedings of World Academy of Science, Engineering and Technology, ISSN 2010-376X, E-ISSN 2070-3740, Vol. 62, no March, 156-161 p.Article in journal (Refereed) Published
Abstract [en]

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.

Place, publisher, year, edition, pages
World Academy of Science, Engineering and Technology , 2010. Vol. 62, no March, 156-161 p.
Keyword [en]
About database, Data mining, Data warehouse, Dimensional modeling, Open source
National Category
Media and Communications
Identifiers
URN: urn:nbn:se:bth-7505Local ID: oai:bth.se:forskinfoB896A783E8C46F33C12578BE002A964COAI: oai:DiVA.org:bth-7505DiVA: diva2:835129
Available from: 2012-09-18 Created: 2011-06-29 Last updated: 2015-06-30Bibliographically approved

Open Access in DiVA

No full text

Search in DiVA

By author/editor
Otine, CharlesTrojer, Lena
In the same journal
Proceedings of World Academy of Science, Engineering and Technology
Media and Communications

Search outside of DiVA

GoogleGoogle Scholar

Total: 22 hits
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • harvard1
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • Other style
More styles
Language
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Other locale
More languages
Output format
  • html
  • text
  • asciidoc
  • rtf