Towards Quality-Oriented Data Warehouse Usage and Evolution

  • Panos Vassiliadis
  • Mokrane Bouzeghoub
  • Christoph Quix
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 1626)


As a decision support information system, a data warehouse must provide high level quality of data and quality of service. In the DWQ project we have proposed an architectural framework and a repository of metadata which describes all the data warehouse components in a set of metamodels to which is added a quality metamodel, defining for each data warehouse metaobject the corresponding relevant quality dimensions and quality factors. Apart from this static definition of quality, we also provide an operational complement, that is a methodology on how to use quality factors and to achieve user quality goals. This methodology is an extension of the Goal-Question-Metric (GQM) approach, which allows to capture (a) the inter-relationships between different quality factors and (b) to organize them in order to fulfil specific quality goals. After summarizing the DWQ quality model, this paper describes the methodology we propose to use this quality model, as well as its impact on the data warehouse evolution.


Quality Factor Quality Dimension Data Warehouse Quality Function Deployment Quality Goal 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


  1. 1.
    P.A. Bernstein, Th. Bergstraesser, J. Carlson, S. Pal, P. Sanders, D. Shutt. Microsoft Repository Version 2 and the Open Information Model. Information Systems 24(2), 1999.Google Scholar
  2. 2.
    V. R. Basili, G. Caldiera, H. D. Rombach. The Goal Question Metric Approach. Encyclopedia of Software Engineering–2 Volume Set, pp 528–532, John Wiley & Sons, Inc., available at, 1994
  3. 3.
    D. H. Besterfield, C. Besterfield-Michna, G. Besterfield, M. Besterfield-Sacre, Total Quality Management, Prentice Hall, 1995Google Scholar
  4. 4.
    M. Bouzeghoub, F. Fabret, M. Matulovic, E. Simon. Data Warehouse Refreshment: A Design Perspective from Quality Requirements. Tech. Rep. D 8.5, DWQ Consortium, 1998.Google Scholar
  5. 5.
    E. B. Dean, "Quality Functional Deployment from the Perspective of Competitive Advantage", available at, 1997
  6. 6.
    M. Jarke, M.A. Jeusfeld, C. Quix, P. Vassiliadis: Architecture and Quality in Data Warehouses, In Proc. CAiSE 98, Pisa, Italy, 1998.Google Scholar
  7. 7.
    M.A. Jeusfeld, C. Quix, M. Jarke: Design and Analysis of Quality Information for Data Warehouses. In Proc. 17th Intl. Conf. on the Entity Relationship Approach (ER’98), Singapore, 1998.Google Scholar
  8. 8.
    M. Jarke, Y. Vassiliou. Foundations of data warehouse quality–a review of the DWQ project. In Proc. 2 nd Intl. Conference Information Quality (IQ-97), Cambridge, Mass., 1997.Google Scholar
  9. 9.
    Metadata Coalition: Meta Data Interchange Specification, (MDIS Version 1.1), August 1997, available at
  10. 10.
    M. Oivo, V. Basili: Representing software engineering models: the TAME goal-oriented approach. IEEE Transactions on Software Engineering, 18, 10, 1992.CrossRefGoogle Scholar
  11. 11.
    K. Orr. Data quality and systems theory. In Communications of the ACM, 41,2, Feb. 1998.Google Scholar
  12. 12.
    C. Quix, M. Jarke, M. Jeusfeld, M. Bouzeghoub, D. Calvanese, E. Franconi, M. Lenzerini, U. Sattler, P. Vassiliadis. Quality Oriented Data Warehouse Evolution. Tech. Rep. D9.1, DWQ Consortium, 1998.Google Scholar
  13. 13.
    G. K. Tayi, D. P. Ballou: Examining Data Quality. In Com. of the ACM, 41,2, Feb. 1998.Google Scholar
  14. 14.
    R. Y. Wang. A product perspective on total data quality management. In Com. of the ACM, 41,2, Feb. 1998.Google Scholar
  15. 15.
    R.Y. Wang, H.B. Kon, S.E. Madnick. Data Quality Requirements Analysis and Modeling. Proc. 9th Intl. Conf. on Data Engineering, IEEE Computer Society, Vienna, Austria, 1993.Google Scholar
  16. 16.
    R.Y. Wang, V.C. Storey, C.P. Firth. A Framework for Analysis of Data Quality Research. IEEE Transactions on Knowledge and Data Engineering, Vol. 7,No. 4, August 1995.Google Scholar
  17. 17.
    R.Y. Wang, D. Strong, L.M. Guarascio. Beyond Accuracy: What Data Quality Means to Data Consumers. Technical Report TDQM-94-10, Total Data Quality Management Research Program, MIT Sloan School of Management, Cambridge, Mass., 1994.Google Scholar
  18. 18.
    Y. Wand, R.Y. Wang. Anchoring Data Quality Dimensions in Ontological Foundations. Communications of the ACM, Vol. 39,No. 11, November 1996.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1999

Authors and Affiliations

  • Panos Vassiliadis
    • 1
  • Mokrane Bouzeghoub
    • 2
  • Christoph Quix
    • 3
  1. 1.National Technical University of AthensGreece
  2. 2.University of Versailles and INRIAFrance
  3. 3.Informatik VRWTH AachenGermany

Personalised recommendations