Comparison of Data Warehouse Design Approaches from User Requirement to Conceptual Model: A Survey

Data warehouses contain vast amount of data from different sources. In order to maintain data in data warehouse according to the organization some designing approaches are important. Requirement Analysis and Conceptual Design are two of the key steps within the data warehouse design process. They are to a great extent responsible for the success of a data warehouse project since, during these two phases, the expressive of the multidimensional schemata is completely defined. In this paper we surveyed the literature related to the design approaches that have done in last few years and propose a comparative analysis of various design approaches according to its characteristic.

[1]  Matteo Golfarelli,et al.  A Survey on Temporal Data Warehousing , 2009, Int. J. Data Warehous. Min..

[2]  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.

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

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

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

[6]  Ralph Kimball,et al.  The Data Warehouse Lifecycle Toolkit , 2009 .

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

[8]  TrujilloJuan,et al.  An MDA approach for the development of data warehouses , 2008 .

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

[10]  Shiwei Tang,et al.  Triple-driven data modeling methodology in data warehousing: a case study , 2006, DOLAP '06.

[11]  Jaelson Brelaz de Castro,et al.  Enhancing Data Warehouse Design with the NFR Framework , 2002, WER.

[12]  Mario Piattini,et al.  Towards Comprehensive Requirement Analysis for Data Warehouses: Considering Security Requirements , 2008, 2008 Third International Conference on Availability, Reliability and Security.

[13]  John Mylopoulos,et al.  Representing and Using Nonfunctional Requirements: A Process-Oriented Approach , 1992, IEEE Trans. Software Eng..

[14]  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..