QUALITY ORIENTED FOR PHYSICAL DESIGN DATA WAREHOUSE

To construct a data warehouse (DW) as a collection of data marts (DMs) all at once in a single project is very difficult. There is a need to determine the first DM that should be constructed. After two or more DMs are constructed, the next problem is integrating all DMs into the enterprise DW. This paper is adaptation of bus matrix, quality function deployment (QFD) matrix, political factors and DM integration technique to be a single framework in order to determine the priority of DMs that should be constructed and how to integrate the entire DMs into the enterprise DW.

[1]  Naomie Salim,et al.  Towards data warehouse quality through integrated requirements analysis , 2011, 2011 International Conference on Advanced Computer Science and Information Systems.

[2]  Naomie Salim,et al.  Comparative Study of Data Quality Dimensions for Data Warehouse Development: A Survey , 2012, AMLTA.

[3]  Naomie Salim,et al.  Quality Oriented Logical Design for D ata W arehouse Development , 2014 .

[4]  Xiuzhen Zhang,et al.  Inferring Aggregation Hierarchies for Integration of Data Marts , 2010, DEXA.

[5]  Riccardo Torlone,et al.  Two approaches to the integration of heterogeneous data warehouses , 2008, Distributed and Parallel Databases.

[6]  Ron McFadyen,et al.  QFD Matrix for Incremental Construction of a Warehouse via Data Marts , 2000, FMLDO.

[7]  Luca Cabibbo,et al.  Dimension Compatibility for Data Mart Integration , 2004, SEBD.

[8]  Debra Zahay,et al.  Why doesn't marketing use the corporate data warehouse? The role of trust and quality in adoption of data‐warehousing technology for CRM applications , 2005 .

[9]  Stephen R. Gardner.  Building the data warehouse , 1998, CACM.

[10]  Matteo Golfarelli,et al.  Conceptual design of data warehouses from E/R schemes , 1998, Proceedings of the Thirty-First Hawaii International Conference on System Sciences.

[11]  Payal Pahwa,et al.  Data Mart Designing and Integration Approaches , 2016 .

[12]  Hugh J. Watson,et al.  Data Warehousing Failures: Case Studies and Findings , 1999 .

[13]  B.H. Far,et al.  An intelligent project lifecycle data mart-based decision support system , 2004, Canadian Conference on Electrical and Computer Engineering 2004 (IEEE Cat. No.04CH37513).

[14]  Ralph Kimball,et al.  The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data , 2004 .

[15]  José Samos,et al.  On relationships offering new drill-across possibilities , 2002, DOLAP '02.

[16]  N. ElGamal,et al.  Towards a data warehouse testing framework , 2012, 2011 Ninth International Conference on ICT and Knowledge Engineering.

[17]  Naomie Salim,et al.  Quality-based framework for requirement analysis in data warehouse , 2014, 2014 International Conference of Advanced Informatics: Concept, Theory and Application (ICAICTA).

[18]  Ralph Kimball,et al.  The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling , 1996 .

[19]  Claudia Diamantini,et al.  Data Mart Integration at Measure Level , 2012 .