Concept based design of data warehouses: the DWQ demonstrators

Authors:
M. Jarke;C. Quix;D. Calvanese;M. Lenzerini;E. Franconi;S. Ligoudistianos;P. Vassiliadis;Y. Vassiliou
Affiliations:
Informatik V, RWTH Aachen, Germany;Informatik V, RWTH Aachen, Germany;Dipartimento di Informatica e Sistemistica, Università di Roma "La Sapienza", Italy;Dipartimento di Informatica e Sistemistica, Università di Roma "La Sapienza", Italy;Dept. of Computer Science, Univ. of Manchester, United Kingdom;Dept. of Electrical and Computer Eng., National Technical University of Athens, Greece;Dept. of Electrical and Computer Eng., National Technical University of Athens, Greece;Dept. of Electrical and Computer Eng., National Technical University of Athens, Greece
Venue:
SIGMOD '00 Proceedings of the 2000 ACM SIGMOD international conference on Management of data
Year:
2000

Citing 2
Cited 6

Data Warehouse Configuration

VLDB '97 Proceedings of the 23rd International Conference on Very Large Data Bases
Modeling Multidimensional Databases, Cubes and Cube Operations

SSDBM '98 Proceedings of the 10th International Conference on Scientific and Statistical Database Management

Conceptual linking: ontology-based open hypermedia

Proceedings of the 10th international conference on World Wide Web
A Temporal Description Logic for Reasoning over Conceptual Schemas and Queries

JELIA '02 Proceedings of the European Conference on Logics in Artificial Intelligence
Ontology-based semantic integration scheme for medical image grid

International Journal of Grid and Utility Computing
A call to arms: revisiting database design

ACM SIGMOD Record
The ICOM 3.0 intelligent conceptual modelling tool and methodology

Semantic Web
The ICOM 3.0 intelligent conceptual modelling tool and methodology

Semantic Web

Quantified Score

Hi-index	0.00

Visualization

Abstract

The ESPRIT Project DWQ (Foundations of Data Warehouse Quality) aimed at improving the quality of DW design and operation through systematic enrichment of the semantic foundations of data warehousing. Logic-based knowledge representation and reasoning techniques were developed to control accuracy, consistency, and completeness via advanced conceptual modeling techniques for source integration, data reconciliation, and multi-dimensional aggregation. This is complemented by quantitative optimization techniques for view materialization, optimizing timeliness and responsiveness without losing the semantic advantages from the conceptual approach. At the operational level, query rewriting and materialization refreshment algorithms exploit the knowledge developed at design time. The demonstration shows the interplay of these tools under a shared metadata repository, based on an example extracted from an application at Telecom Italia.