Skip to main content
European Commission logo print header

Foundations of data warehouse quality

Objectif

The DWQ project develops techniques and tools to support the rigorous design and operation of data warehouses:

- based on well-defined data quality factors,
- addressed by a rich semantic approach,
- realised by bringing together enabling technologies,
- demonstrated in a prototype suite of design and operation tools, and
- validated in co-operation with European DW vendors and users.

Taken together, these changes will evolve the vision of a data warehouse as a buffer between operational and analytic processing towards that of a competitive information supermarket that carefully selects and prepares its products, packages and displays them nicely, and continuously adapts to customer demands in a cost-efficient manner.

Starting from a definition of the basic DW architecture and the relevant data quality issues, the first project goal is to define the range of design and operational method alternatives for each of the main architecture components and quality factors. Since usually a combination of enabling technologies is required, innovations are envisioned both at the design (e.g. rich meta-data representation and reasoning facilities) as well as at the operational level (e.g. viewing DW contents as views over the underlying information sources, refreshment techniques and optimal handling of views with aggregate functions become important). In a second step, formal models of the DW architecture and services will be developed together with associated tools for consistency checking in the richer model, reuse by subsumption, view materialisation strategies, and other components of the data warehousing software. These models and tools will make the knowledge about operational alternatives and their configuration available to the data warehouse designer, in order to allow the dynamic adaptation of the data warehouse structure and quality-of-service to the ever-changing information sources and analysis patterns.

The project is executed by an interdisciplinary team of theoretically and practically oriented research groups in four European countries, all of which have links to industrial or public administration DW projects. DWQ will closely co-operate with Software AG, as well as other leading vendors of data warehousing solutions. Results will be validated with selected data warehousing efforts in European user organisations in the sectors of telecommunications (Telecom Italia) and environmental protection (French Ministry of the Environment). The CLN (Computational Logic) and IDOMENEUS Networks of Excellence will be actively involved in the dissemination of project results.

Data warehousing has become an important strategy to integrate heterogeneous information sources in organisations, and to enable on-line analytic processing. However, the wide variety of product and vendor strategies, combined with a weak understanding of the foundations of data warehousing, make the design and evolution of data warehouses haphazard and prone to failure.

Appel à propositions

Data not available

Coordinateur

Institute of Communications and Computer Systems National Technical University of Athens
Contribution de l’UE
Aucune donnée
Adresse
Patission Street 12
10682 Athens
Grèce

Voir sur la carte

Coût total
Aucune donnée

Participants (5)