A study of multidimensional modeling approaches for data warehouse

Data warehouse system is used to support the process of organizational decision making. Hence, the system must extract and integrate information from heterogeneous data sources in order to uncover relevant knowledge suitable for decision making process. However, the development of data warehouse is a difficult and complex process especially in its conceptual design (multidimensional modeling). Thus, there have been various approaches proposed to overcome the difficulty. This study surveys and compares the approaches of multidimensional modeling and highlights the issues, trend and solution proposed to date. The contribution is on the state of the art of the multidimensional modeling design.

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

[2]  H. D. Rombach,et al.  The Goal Question Metric Approach , 1994 .

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

[4]  Torben Bach Pedersen,et al.  Discovering Multidimensional Structure in Relational Data , 2004, DaWaK.

[5]  Eric Yu,et al.  Modeling Strategic Relationships for Process Reengineering , 1995, Social Modeling for Requirements Engineering.

[6]  Matteo Golfarelli.  From User Requirements to Conceptual Design in Warehouse Design: A Survey , 2010 .

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

[8]  Alberto Abelló,et al.  A framework for multidimensional design of data warehouses from ontologies , 2010, Data Knowl. Eng..

[9]  Jamel Feki,et al.  An Automatic Method for the Design of Multidimensional Schemas from Object Oriented Databases , 2013, Int. J. Inf. Technol. Decis. Mak..

[10]  Daniel L. Moody,et al.  From ER Models to Dimensional Models: Bridging the Gap between OLTP and OLAP Design, Part I , 2003 .

[11]  Robert Winter,et al.  Information requirements engineering for data warehouse systems , 2004, SAC '04.

[12]  Jose-Norberto Mazón,et al.  A hybrid model driven development framework for the multidimensional modeling of data warehouses! , 2009, SGMD.

[13]  Luca Cabibbo,et al.  A Logical Approach to Multidimensional Databases , 1998, EDBT.

[14]  Anjana Gosain,et al.  An approach to engineering the requirements of data warehouses , 2008, Requirements Engineering.

[15]  Alberto Abelló,et al.  A Survey of Multidimensional Modeling Methodologies , 2009, Int. J. Data Warehous. Min..

[16]  K. Vivekanandan,et al.  An Ontology based Hybrid Approach to Derive Multidimensional Schema for Data warehouse , 2012 .

[17]  Paolo Giorgini,et al.  GRAnD: A goal-oriented approach to requirement analysis in data warehouses , 2008, Decis. Support Syst..

[18]  Isam M Aljawarneh,et al.  Design of a data warehouse model for decision support at higher education , 2016 .

[19]  Isabelle Comyn-Wattiau,et al.  A UML-based data warehouse design method , 2006, Decis. Support Syst..

[20]  S. Sepúlveda,et al.  A chronological study of paradigms for data warehouse design , 2012 .

[21]  Alberto Abelló,et al.  Automatic validation of requirements to support multidimensional design , 2010, Data Knowl. Eng..

[22]  Ralph Kimball,et al.  The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses , 1996 .

[23]  Alberto Abelló,et al.  Research in data warehouse modeling and design: dead or alive? , 2006, DOLAP '06.

[24]  Francesco Di Tria,et al.  Hybrid methodology for data warehouse conceptual design by UML schemas , 2012, Inf. Softw. Technol..

[25]  Anirban Sarkar.  Data Warehouse Requirements Analysis Framework: Business-Object Based Approach , 2012 .

[26]  Jose-Norberto Mazón,et al.  Reconciling requirement-driven data warehouses with data sources via multidimensional normal forms , 2007, Data Knowl. Eng..

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

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