Triple-driven data modeling methodology in data warehousing: a case study

In this paper, we present a useful data modeling methodology in data warehousing which integrates three existing approaches normally used in isolation: goal-driven, data-driven and user-driven. It comprises of four stages. Goal-driven stage produces subjects and KPIs(Key Performance Indicators) of main business fields. Data-driven stage produces subject oriented enterprise data schema. User-driven stage yields analytical requirements represented by measures and dimensions of each subject. Combination stage combines the triple-driven results. By triple-driven, we can get a more complete, more structured and more layered data model of a data warehouse. We illustrate each stage step by step using examples in our case study.

[1]  Stefano Rizzi.  Open problems in data warehousing: eight years later , 2003, DMDW.

[2]  Laura M. Haas,et al.  Data-driven understanding and refinement of schema mappings , 2001, SIGMOD '01.

[3]  William O'Connell.  Trends in Data Warehousing: A Practitioner's View , 2004, VLDB.

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

[5]  Paolo Giorgini,et al.  Goal-oriented requirement analysis for data warehouse design , 2005, DOLAP '05.

[6]  Verónika Peralta,et al.  On the Applicability of Rules to Automate Data Warehouse Logical Design , 2003, CAiSE Workshops.

[7]  Florian Melchert,et al.  Sponsorship Models for Data Warehousing: Two Case Studies , 2004, AMCIS.

[8]  A Min Tjoa,et al.  Data Warehousing and Knowledge Discovery: A Chronological View of Research Challenges , 2005, DaWaK.

[9]  Achim Ulbrich-vom Ende,et al.  Business Process Oriented Development of Data Warehouse Structures , 2000 .

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

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

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

[13]  Jon M. Kerridge,et al.  Best Practice for Implementing a Data Warehouse: A Review for Strategic Alignment , 2003, DMDW.

[14]  Maria Luiza Machado Campos,et al.  Getting Users Involved in the Development of Data Warehouse Applications , 2002, DMDW.

[15]  Il-Yeol Song,et al.  Data warehouse design to support customer relationship management analyses , 2004, DOLAP '04.

[16]  David C. Yen,et al.  Critical factors influencing the adoption of data warehouse technology: a study of the banking industry in Taiwan , 2004, Decis. Support Syst..

[17]  Jorge Oliveira e Sá,et al.  Data Warehouse Methodology: A Process Driven Approach , 2004, CAiSE.

[18]  Karen C. Davis,et al.  Automating data warehouse conceptual schema design and evaluation , 2002, DMDW.

[19]  Robert Winter,et al.  Demand-driven Information Requirements Analysis in Data Warehousing , 2003 .