Cost-benefit analysis of data warehouse design methodologies

详细信息    查看全文

• 作者：Francesco Di Tria ; ^{francesco.ditria@uniba.it" class="auth_mail" title="E-mail the corresponding author} ; Ezio Lefons ^{ezio.lefons@uniba.it" class="auth_mail" title="E-mail the corresponding author} ; Filippo Tangorra ^{filippo.tangorra@uniba.it" class="auth_mail" title="E-mail the corresponding author}
• 关键词：Schema quality ; Metrics ; Design effort ; Evaluation ; Automation
• 刊名：Information Systems
• 出版年：2017
• 出版时间：January 2017
• 年：2017
• 卷：63
• 期：Complete
• 页码：47-62
• 全文大小：1135 K

文摘

Methodologies for data warehouse design are increasing more and more in last years, and each of them proposes a different point of view. Among all the methodologies present in literature, the promising ones are the hybrid methodologies—because they represent the only way to ensure a multidimensional schema to be both consistent with data sources and adherent to user business goals—and those able to support the designer by providing some kind of automation. However, the results obtainable by the methodologies can differ substantially in terms of schema quality and required efforts. In this paper, we provide metrics for evaluating the quality of multidimensional schemata in reference to the effort spent in the design process and the automation degree of the methodology. As a case study, we apply our evaluation to the major emerging hybrid methodologies for data warehouse schema design.