Goal-oriented requirement analysis for data warehouse design

Several surveys indicate that a significant percentage of data warehouses fail to meet business objectives or are outright failures. One of the reasons for this is that requirement analysis is typically overlooked in real projects. In this paper we propose a goal-oriented approach to requirement analysis for data warehouses, based on the Tropos methodology. Two different perspectives are integrated for requirement analysis: organizational modeling, centered on stakeholders, and decisional modeling, focused on decision makers. Our approach can be employed within both a demand-driven and a mixed supply/demand-driven design framework: in the second case, while the operational sources are still explored to shape hierarchies, user requirements play a fundamental role in restricting the area of interest for analysis and in choosing facts, dimensions, and measures. The methodology proposed, supported by a prototype, is described with reference to a real case study.

[1]  Robert Winter,et al.  A method for demand-driven information requirements analysis in data warehousing projects , 2003, 36th Annual Hawaii International Conference on System Sciences, 2003. Proceedings of the.

[2]  Jaelson Brelaz de Castro,et al.  DWARF: an approach for requirements definition and management of data warehouse systems , 2003, Proceedings. 11th IEEE International Requirements Engineering Conference, 2003..

[3]  Ralph Kimball,et al.  The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying Data Warehouses with CD Rom , 1998 .

[4]  Fausto Giunchiglia,et al.  Tropos: An Agent-Oriented Software Development Methodology , 2004, Autonomous Agents and Multi-Agent Systems.

[5]  Zhang Hengxi,et al.  A Methodological Framework for Data Warehouse Design , 2003 .

[6]  Stephen Fickas,et al.  Goal-Directed Requirements Acquisition , 1993, Sci. Comput. Program..

[7]  Gottfried Vossen,et al.  Conceptual Data Warehouse Design , 2000 .

[8]  John Mylopoulos,et al.  Simple and Minimum-Cost Satisfiability for Goal Models , 2004, CAiSE.

[9]  G. G. Stokes "J." , 1890, The New Yale Book of Quotations.

[10]  W. H. Inmon,et al.  Building the data warehouse , 1992 .

[11]  Juan Trujillo,et al.  The Gold Model Case Tool: An Environment for Designing OLAP Applications , 2002, ICEIS.

[12]  Beate List,et al.  Developing Requirements for Data Warehouse Systems with Use Cases , 2001 .

[13]  Matteo Golfarelli,et al.  The Dimensional Fact Model: A Conceptual Model for Data Warehouses , 1998, Int. J. Cooperative Inf. Syst..

[14]  Matteo Golfarelli,et al.  WAND: A CASE Tool for Workload-Based Design of a Data Mart , 2002, SEBD.

[15]  John Mylopoulos,et al.  Formal Reasoning Techniques for Goal Models , 2003, J. Data Semant..

[16]  Anjana Gosain,et al.  Requirements Driven Data Warehouse Development , 2003, CAiSE Short Paper Proceedings.

[17]  John Mylopoulos,et al.  Towards requirements-driven information systems engineering: the Tropos project , 2002, Inf. Syst..

[18]  Sergio Luján-Mora,et al.  A Comprehensive Method for Data Warehouse Design , 2003, DMDW.

[19]  Stefano Paraboschi,et al.  Designing data marts for data warehouses , 2001, TSEM.

[20]  Daniel L. Moody,et al.  From enterprise models to dimensional models: a methodology for data warehouse and data mart design , 2000, DMDW.

[21]  Jens Lechtenbörger,et al.  Data warehouse schema design , 2001, DISDBIS.

[22]  Beate List,et al.  A Comparison of Data Warehouse Development Methodologies Case Study of the Process Warehouse , 2002, DEXA.