A Principled Approach to Data Integration and Reconciliation in Data Warehousing

Diego Calvanese, Giuseppe De Giacomo, Maurizio Lenzerini, Daniele Nardi, and Riccardo Rosati

Proc. of the Int. Workshop on Design and Management of Data Warehouses (DMDW'99). Volume 19 of CEUR Workshop Proceedings, http://ceur-ws.org/. 1999.

Integration is one of the most important aspects of a Data Warehouse. When data passes from the sources of the application-oriented operational environment to the Data Warehouse, possible inconsistencies and redundancies should be resolved, so that the warehouse is able to provide an integrated and reconciled view of data of the organization. We describe a novel approach to data integration and reconciliation, based on a conceptual representation of the Data Warehouse application domain. The main idea is to declaratively specify suitable matching, conversion, and reconciliation operations to be used in order to solve possibile conflicts among data in different sources. Such a specification is provided in terms of the conceptual model of the application, and is effectively used during the design of the software modules that load the data from the sources into the Data Warehouse.


@inproceedings{DMDW-1999,
   title = "A Principled Approach to Data Integration and Reconciliation in
Data Warehousing",
   year = "1999",
   author = "Diego Calvanese and De Giacomo, Giuseppe and Maurizio
Lenzerini and Daniele Nardi and Riccardo Rosati",
   booktitle = "Proc. of the Int. Workshop on Design and Management of Data
Warehouses (DMDW'99)",
   pages = "16.1--16.11",
   volume = "19",
   series = "CEUR Workshop Proceedings, http://ceur-ws.org/",
}
pdf url