Affiliation:
1. Dipartimento di Informatica e Sistemistica, Università di Roma "La Sapienza" Via Salaria 113, 00198 Roma, Italy
Abstract
Information 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 in Data Warehousing. Our approach is based on a conceptual representation of the Data Warehouse application domain, and follows the so-called local-as-view paradigm: both source and Data Warehouse relations are defined as views over the conceptual model. We propose a technique for declaratively specifying suitable reconciliation correspondences to be used in order to solve conflicts among data in different sources. The main goal of the method is to support the design of mediators that materialize the data in the Data Warehouse relations. Starting from the specification of one such relation as a query over the conceptual model, a rewriting algorithm reformulates the query in terms of both the source relations and the reconciliation correspondences, thus obtaining a correct specification of how to load the data in the materialized view.
Publisher
World Scientific Pub Co Pte Lt
Subject
Computer Science Applications,Information Systems
Cited by
71 articles.
订阅此论文施引文献
订阅此论文施引文献,注册后可以免费订阅5篇论文的施引文献,订阅后可以查看论文全部施引文献
1. In-Situ Cross-Database Query Processing;2023 IEEE 39th International Conference on Data Engineering (ICDE);2023-04
2. Data Integration and Transformation using Artificial Intelligence;2023 International Conference on Intelligent Data Communication Technologies and Internet of Things (IDCIoT);2023-01-05
3. Real-time data integration of an internet-of-things-based smart warehouse: a case study;International Journal of Pervasive Computing and Communications;2021-07-23
4. A Cloud-Native Serverless Approach for Implementation of Batch Extract-Load Processes in Data Lakes;Communications in Computer and Information Science;2021
5. Implementing an ETL-driven Data Integration Framework for State Universities and Colleges;IOP Conference Series: Materials Science and Engineering;2020-04-01