Enhancing Data Warehouse Quality with the NFR Framework

In recent years, Data Warehouse has emerged as a powerful technology for integrating heterogeneous data into a multidimensional repository on behalf of decision-support analysis. The complex extraction, transformation and loading process involved, as well as the aggregational-intensive queries are governed by a multitude of quality factors such as integrity, accessibility, performance, and other domain-specific non-functional requirements (NFRs). This clearly advocates the use of an NFR approach to support high-quality data warehouse specifications. In this work we extend the NFR Framework [3] to define catalogues of major data warehouse NFR types, related operational methods and correlation rules, for latter reuse during the development stage. We illustrate the contributions of our approach with a case study on a large data warehouse project.

[1]  Roger S. Pressman,et al.  Software Engineering: A Practitioner's Approach , 1982 .

[2]  Matthias Jarke,et al.  Architecture and Quality in Data Warehouses: An Extended Repository Approach , 1999, Information Systems.

[3]  Barry Boehm,et al.  Characteristics of software quality , 1978 .

[4]  Lawrence Chung,et al.  Architecture-based semantic evolution: a study of remotely controlled embedded systems , 2001, Proceedings IEEE International Conference on Software Maintenance. ICSM 2001.

[5]  Larry P. English.  Improving Data Warehouse and Business Information Quality: Methods for Reducing Costs and Increasing Profits , 1999 .

[6]  Ian Sommerville,et al.  Requirements Engineering: Processes and Techniques , 1998 .

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

[8]  Janis A. Bubenko,et al.  Theories underlying requirements engineering: an overview of NATURE at Genesis , 1993, [1993] Proceedings of the IEEE International Symposium on Requirements Engineering.

[9]  Stephen Shaoyi Liao,et al.  Exploring Alternatives during Requirements Analysis , 2001, IEEE Softw..

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

[11]  E. Yu,et al.  USING QUALITY REQUIREMENTS TO SYSTEMATICALLY DEVELOP QUALITY SOFTWARE , 1994 .

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

[13]  Lawrence Chung,et al.  NFR-Assistant: tool support for achieving quality , 1999, Proceedings 1999 IEEE Symposium on Application-Specific Systems and Software Engineering and Technology. ASSET'99 (Cat. No.PR00122).

[14]  Gio Wiederhold,et al.  Mediators in the architecture of future information systems , 1992, Computer.

[15]  Dimitri Theodoratos,et al.  Data Currency Quality Factors in Data Warehouse Design , 1999, DMDW.

[16]  Richard D. Hackathorn,et al.  Using the Data Warehouse , 1994 .

[17]  Bashar Nuseibeh,et al.  Weaving the Software Development Process Between Requirements and Architectures , 2001 .

[18]  Myra Spiliopoulou,et al.  Parallel Optimization of Large Join Queries with Set Operators and Aggregates in a Parallel Environment Supporting Pipeline , 1996, IEEE Trans. Knowl. Data Eng..

[19]  Lawrence Chung,et al.  Dealing with Non-Functional Requirements: Three Experimental Studies of a Process-Oriented Approach , 1995, 1995 17th International Conference on Software Engineering.

[20]  David A. Patterson,et al.  Reducing the cost of system administration of a disk storage system built from commodity components , 2000 .

[21]  Panos Vassiliadis,et al.  Data Warehouse Modeling and Quality Issues , 2000 .

[22]  Lawrence Chung,et al.  Process-Oriented Metrics for Software Architecture Adaptability , 2001, Proceedings Fifth IEEE International Symposium on Requirements Engineering.

[23]  Arie Shoshani,et al.  Summarizability in OLAP and statistical data bases , 1997, Proceedings. Ninth International Conference on Scientific and Statistical Database Management (Cat. No.97TB100150).

[24]  John Mylopoulos,et al.  Non-Functional Requirements in Software Engineering , 2000, International Series in Software Engineering.

[25]  David Marco,et al.  Building and Managing the Meta Data Repository: A Full Lifecycle Guide , 2000 .

[26]  Axel van Lamsweerde,et al.  Requirements engineering in the year 00: a research perspective , 2000, Proceedings of the 2000 International Conference on Software Engineering. ICSE 2000 the New Millennium.

[27]  Panos Vassiliadis,et al.  Towards Quality-oriented Data Warehouse Usage and Evolution , 2000, Inf. Syst..

[28]  José Samos,et al.  Benefits of an Object-Oriented Multidimensional Data Model , 2000, Objects and Databases.

[29]  Erhard Rahm,et al.  On Metadata Interoperability in Data Warehouses , 2000 .

[30]  Lawrence Chung,et al.  Software architecture adaptability: an NFR approach , 2001, IWPSE '01.