DWQ

Overview

DWQ is a basic research project bringing together a team of four European countries to investigate the foundations of data warehouse quality. DWQ started in October 1996 and was finished in December 1999.

Data Warehouses are distributed databases which store materialized views on heterogeneous data sources of an enterprise. The multidimensional data model of data warehouses is often used for decision support systems of an enterprise. Many data warehouse projects have failed because they could not handle the quality problems which arised during the integration of data from different information sources. The goal of the DWQ project is to develop a semantic foundation that will allow the designers of data warehouses to link the choice of deeper models, richer data structures and rigorous implementation techniques to quality-of-service factors in a systematic manner, thus improving the design, the operation, and most importantly the evolution of data warehouse applications. 

The project participants are the Knowledge and Databse Systems Laboratory from National Technical Univ. of Athens (Prof. Sellis, Prof. Vassiliou), Informatik V (Prof. Jarke) and LuFG Theo. Informatik (Prof. Baader) from RWTH Aachen, INRIA Rocquencourt (Prof. Bouzeghoub, Dr. Simon), DFKI Saarbrucken (Dr. Nutt),  the AI Research Group of Univ. of Rome "La Sapienza" (Prof. Lenzerini), the Knowledge Representation and Reasoning Group of IRST and the
Information Management Group of University of Manchester (Dr. Franconi). 

The role of Aachen (Informatik V) was to develop a model for data warehouse components and their relationship to quality factors like accuracy. The model forms the basis for a design tool for data warehouses. This model has been implemented with the metadata repository ConceptBase. A demonstration of some tools which have been developed in DWQ has been given at SIGMOD 2000. Screenshots and a short description of the demo can be found here.

Publications

2009

• Christoph Quix

  Metadatabase Design for Data Warehouses

  Published in In M.A. Jeusfeld, M. Jarke, J. Mylopoulos (eds.): Metamodeling for Method Engineering, MIT Press 2009, pp. 329-355

2003

• Matthias Jarke, M. Lenzerini, Y. Vassiliou, P. Vassiliadis

  Fundamentals of Data Warehouses

  Published in 2nd revised and extended edition, Springer-Verlag, ISBN 3-540-42089-4, 2003

• Matthias Jarke, M. Lenzerini, Y. Vassiliou, P. Vassiliadis

  Hurownie Danych - Podstawy Organizacji Funkcjonowania

  Published in Wydawnictwa Szkolne i Pedagogiczne Spolka Akcyjna, Warszawa, Poland, 2003 (Polish translation of Fundamentals of Data Warehouses )

• Christoph Quix

  Repository Support for Data Warehouse Evolution

  Published in ICFAI Journal of Systems Management, Vol. 1, No. 2, pp. 57-72, August 2003

• Christoph Quix

  Metadatenverwaltung zur qualitätsorientierten Informationslogistik in Data-Warehouse-Systemen

  Published in Dissertation, RWTH Aachen, 2003

2001

• P. Vassiliadis, Christoph Quix, Y. Vassiliou, Matthias Jarke

  Data Warehouse Process Management

  Published in Information Systems, Vol. 26, No. 3, pp. 205-236, 2001

2000

• Matthias Jarke, M. Lenzerini, Y. Vassiliou, P. Vassiliadis

  Fundamentals of Data Warehouses

  Published in Springer, 2000

• P. Vassiliadis, M. Bouzeghoub, Christoph Quix

  Towards Quality-Oriented Data Warehouse Usage and Evolution

  Published in Information Systems, Vol. 25, No. 2, pp. 89-115, June 2000

• Matthias Nicola, Matthias Jarke

  Performance modeling of distributed and replicated databases: Research Survey Paper

  Published in IEEE Transactions on Knowledge and Data Engineering, Vol. 12, No. 4, pp. 645-672, July/Aug 2000

• Matthias Jarke, Matthias Nicola

  Analysis of wireless health care information systems in developing countries

  Published in In: Avgerou, C.; Walsham, G. (ed.): Information Technology in Context - Implementing Systems in the Developing World. Ashgate Publishing House, Aldershot, Hampshire, UK, 2000, pp. 153-167

• Matthias Jarke, Christoph Quix, D. Calvanese, M. Lenzerini, E. Franconi, S. Ligoudistianos, P. Vassiliadis, Y. Vassiliou

  Concept Based Design of Data Warehouses: The DWQ Demonstrators

  Published in ACM SIGMOD International Conference on Management of Data (SIGMOD 2000), Dallas, TX, May 2000

• P. Vassiliadis, Christoph Quix, Y. Vassiliou, Matthias Jarke

  A Model for Data Warehouse Operational Processes

  Published in Benkt Wangler, Lars Bergman (Eds.): Advanced Information Systems Engineering, Proceedings 12th International Conference CAiSE 2000, Stockholm, Sweden, June 2000, Lecture Notes in Computer Science, Vol. 1789, Springer, 2000

• Christoph Quix

  Metadata Management to Improve the Quality in Data Warehouses and Business Data Repositories

  Published in Doctoral Consortium of the Twenty-first Annual International Conference on Information Systems, Brisbane, Australia, December 2000

• P. A. Bernstein, L. Haas, Matthias Jarke, E. Rahm, G. Wiederhold

  Panel: Is generic metadata management feasible?

  Published in Proceedings of the 26th International Conference on Very Large Data Bases (VLDB 2000), 10.-13.9. 2000 Cairo,Egypt. Morgan Kaufmann Publ., 2000, pp. 660-662.

• E. Schaefer, J.-D. Becker, A. Boehmer, Matthias Jarke

  DB-Prism: Integrated Data Warehouses and Knowledge Networks for Bank Controlling

  Published in Proceedings of 26th International Conference on Very Large Data Bases (VLDB 2000), September 10-14, 2000, Cairo, Egypt

1999

• Matthias Nicola

  Performance Evaluation of Distributed, Replicated, and Wireless Information Systems

  Published in Doctoral Thesis, November 1999, ISSN 0935-3232

• Matthias Jarke, Manfred Jeusfeld, Christoph Quix, P. Vassiliadis

  Architecture and Quality for Data Warehouses: An Extended Repository Approach

  Published in Information Systems, 24(3), pp. 229-253, 1999

• Manfred Jeusfeld, Matthias Jarke, Christoph Quix

  Qualitätsanalyse im Data Warehousing

  Published in Informatik/Informatique, Journal of the Swiss Information processing societies, No. 3, June 1999 (in german)

• Manfred Jeusfeld, Matthias Jarke, Christoph Quix

  Qualitätsanalyse im Data Warehousing

  Published in EMISA Forum 1/1999

• Martin Staudt, René Soiron, Christoph Quix, Matthias Jarke

  Cost-Based Query Optimization for Metadata Repositories

  Published in Applied Computing Review (Publication of ACM SIGAPP), Vol. 7, No. 2, pp. 10-21, Summer 1999

• Martin Staudt, René Soiron, Christoph Quix, Matthias Jarke

  Optimizing Queries for Repository-Based Applications

  Published in ACM Symposium on Applied Computing, San Antonio, Texas, USA, 1999

• P. Vassiliadis, M. Bouzeghoub, Christoph Quix

  Towards Quality-Oriented Data Warehouse Usage and Evolution

  Published in 11th Conference on Advanced Information Systems Engineering (CAiSE '99), Heidelberg, Germany, 1999

• Matthias Jarke, Christoph Quix, G. Blees, D. Lehmann, G. Michalk, S. Stierl

  Improving OLTP Data Quality Using Data Warehouse Mechanisms

  Published in ACM SIGMOD International Conference on Management of Data (SIGMOD '99), Philadelphia, PA, June 1999

• Christoph Quix

  Repository Support for Data Warehouse Evolution

  Published in Proceedings of the International Workshop on Design and Management of Data Warehouses (DMDW '99), Heidelberg, Germany, 1999

• Matthias Jarke, Matthias Nicola

  Telecommunication Databases: Applications and Performance Analysis

  Published in VLDB Workshop on Databases in Telecommunication, September 6th, 1999, Edinburgh, LNCS 1819, Springer, pp. 1-15

1998

• Matthias Jarke, eds.

  Special Issue on VLDB 97

  Published in VLDB Journal 7(3), 1998

• M. Raffanelli, Matthias Jarke, eds.

  Scientific and Statistical Database Management, Proceedings of SSDBM'98, Capri, Italy, July 1998

  Published in IEEE Press, 1998

• Matthias Nicola, Matthias Jarke

  Performance Modeling of Distributed and Replicated Databases

  Published in Aachener Informatik Berichte, 98-10, 1998

• Michael Gebhardt, Matthias Jarke, Manfred Jeusfeld, Christoph Quix, Stefan Sklorz

  Tools for Data Warehouse Quality

  Published in Proc. of the 10th International Conference on Scientific and Statistical Database Management (SSDBM'98), Capri, Italy, July 1998. IEEE Computer Society Press, pp. 229-232

• Matthias Jarke, Manfred Jeusfeld, Christoph Quix, P. Vassiliadis

  Architecture and Quality in Data Warehouses

  Published in 10th Conference on Advanced Information Systems Engineering(CAiSE '98), Pisa, Italy, 1998

• Manfred Jeusfeld, Matthias Jarke, Hans Nissen, Martin Staudt

  ConceptBase: Managing conceptual models about information systems

  Published in P.Bernus, K.Mertins, G.Schmidt (eds.), Handbook of InformationSystems, Springer-Verlag, pp. 265-285, 1998

• Manfred Jeusfeld, Christoph Quix, Matthias Jarke

  Design and Analysis of Quality Information for Data Warehouses

  Published in 17th International Conference on the Entity Relationship Approach (ER'98), Singapore, 1998

• Matthias Nicola, Matthias Jarke

  Design and Evaluation of Wireless Health Care Information Systems in Developing Countries

  Published in Proceedings of the IFIP 9.4 Conference on Implementation and Evaluation of Information Systems in Developing Countries, Bangkok, February 1998

• Matthias Nicola, Matthias Jarke

  Communication Technologies for Health Care Information Systems in Developing Countries

  Published in Proceedings of the BITWorld '98 Conference, Delhi, February 1998

• Martin Staudt, Christoph Quix, Manfred Jeusfeld

  View Maintenance and Change Notification for Application Program Views

  Published in ACM Symposium on Applied Computing, Atlanta, Georgia, USA, 1998

1997

• F. Baader, Manfred Jeusfeld, W. Nutt, eds.

  Intelligent Access to Heterogeneous Information.

  Published in Proceedings of the 4th Workshop KRDB-97, Athen, Griechenland, August 1997

• Matthias Jarke, M. J. Carey, K. R. Dittrich, F. Lochovsky, Pericles Loucopoulos, Manfred Jeusfeld

  VLDB'97, Proceedings of the 23rd International Conference on Very Large Data Bases

  Published in Large Data Bases, Morgan Kaufmann, 1997

• F. Baader, Manfred Jeusfeld, W. Nutt

  Intelligent access to heterogeneous information sources - Report on the 4th Workshop on Knowledge Representation Meets Data Bases,

  Published in SIGMOD Record, 26 (4), Dezember 1997, pp. 44-48

• Manfred Jeusfeld, Tung X. Bui

  Distributed decision support and organizational connectivity: a case study

  Published in Decision Support Systems, 19, 1997, pp. 215-225

• Matthias Nicola, Matthias Jarke

  Design and Evaluation of Wireless Health Care Information Systems in Developing Countries

  Published in Aachener Informatik Berichte, 97-6, 1997

• Matthias Nicola, Matthias Jarke

  Integrating Replication and Communication in Performance Models of Distributed Databases

  Published in Aachener Informatik Berichte, 97-10, 1997

• Michael Gebhardt, Matthias Jarke, Stephan Jacobs

  A Toolkit for Negotiation Support Interfaces to Multi-Dimensional Data

  Published in Proc. of the 1997 ACM SIGMOD International Conference on Managementof Data, Tucson, Arizona, USA, 1997

• Christoph Quix, Martin Staudt

  Database Change Propagation for a Medical Application Scenario

  Published in Proc. of the 5th European Congress on Intelligent Techniques and SoftComputing (EUFIT'97), Volume 2, Aachen, Germany, September 1997, pp. 1167-1170

• Matthias Jarke, Y. Vassiliou

  Foundations of Data Warehouse Quality - A Review of the DWQ Project

  Published in Proceedings of the 2nd International Conference on Information Quality (IQ-97), Cambridge, Mass., 1997.

1996

• Martin Staudt, Matthias Jarke

  Incremental maintenance of externally materialized views

  Published in Proceedings of the 22nd International Conference on Very Large Data Bases (VLDB'96), Bombay, India 1996, pp. 75-86

• Martin Staudt, Matthias Jarke, Christoph Quix

  Change notification for externally materialized application program views

  Published in Proceedings of the 8th IEEE International Conference on Tools with Artificial Intelligence (ICTAI'96), Toulouse, France 1996, pp. 96-99