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
A systematic approach for transformation of ER Schema to dimensional schema
KTH, School of Information and Communication Technology (ICT), Computer and Systems Sciences, DSV.
2009 (English)In: Proceedings of the 6th International Conference on Frontiers of Information Technology, FIT '09, 2009, 1838060- p.Conference paper, Published paper (Refereed)
Abstract [en]

Development of Star model for data warehouse (DW) requires ample amount of time, experience, expertise and adequate knowledge of data warehouse designing steps. As an alternative to data warehouse designing steps, transformation techniques are used. These techniques transform ER model (of relational OLTP) to Star model/s. In this study, we present and evaluate a systematic approach for transformation of ER model to Star model. Based on an experiment, we prove that, by using our approach, inexperienced designers can produce Star models identical to the star models produced by experienced data warehouse designers.

Place, publisher, year, edition, pages
2009. 1838060- p.
Keyword [en]
Computer-based decision aids, Data warehouse, Decision support systems, Er model, Star model
National Category
Computer and Information Science
Identifiers
URN: urn:nbn:se:kth:diva-152421DOI: 10.1145/1838002.1838060Scopus ID: 2-s2.0-77956296773ISBN: 978-160558642-7 (print)OAI: oai:DiVA.org:kth-152421DiVA: diva2:752023
Conference
6th International Conference on Frontiers of Information Technology, FIT '09, 16 December 2009 through 18 December 2009, Abbottabad, Pakistan
Note

QC 20141002

Available from: 2014-10-02 Created: 2014-09-26 Last updated: 2014-10-02Bibliographically approved

Open Access in DiVA

No full text

Other links

Publisher's full textScopus

Search in DiVA

By author/editor
Shahzad, Khurram
By organisation
Computer and Systems Sciences, DSV
Computer and Information Science

Search outside of DiVA

GoogleGoogle Scholar

doi
isbn
urn-nbn

Altmetric score

doi
isbn
urn-nbn
Total: 12 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