…
comment: The repository administrator has not yet configured an RDF license.
primary topic: From ER model to star model: A systematic transformation approach

From ER model to star model: A systematic transformation approach
type: AcademicArticle
type: Article
abstract: Data warehouse is an important component of decision support systems, because it provides data of interest for analysis and decision support purposes. This data of interest is useful for analysis due to the multidimensional nature of Star model. Designing a Star model 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 proposed in literature. These techniques transform entity-relationship (ER) model (of online transaction process systems) to Star model. In this study, we present and evaluate a systematic approach for transformation of ER model to Star model. We prove that by using our approach, inexperienced designers can produce star models identical to the star models produced by experienced data warehouse designers. Also, we prove that the Star model produced by existing approaches is different from the Star model produced by our transformation approach. Copyright © 2015 Inderscience Enterprises Ltd.
date: 2015
volume: 18
issue: 3
is part of: International Journal of Business Information Systems
status: peerReviewed
status: published
author list: authors
type: EPrint
type: ArticleEPrint
is part of: repository

Inderscience Publishers
type: Organization

International Journal of Business Information Systems
type: Collection
issn: 17460972

A. Sohail
type: Person
given name: A.
family name: Sohail

P.D.D. Dominic
type: Person
given name: P.D.D.
family name: Dominic

HTML Summary of #6360 From ER model to star model: A systematic transformation approach
format: text/html
primary topic: From ER model to star model: A systematic transformation approach