A Principled Approach to Data Integration and Reconciliation in Data Warehousing
A Principled Approach to Data Integration and Reconciliation in Data Warehousing
复制标题
DOI：
--
复制
发表时间：
1999
期刊：
影响因子：
--
通讯作者：
Diego Calvanese;Giuseppe De Giacomo;M. Lenzerini;D. Nardi;R. Rosati
中科院分区：
文献类型：
--
作者：
Diego Calvanese;Giuseppe De Giacomo;M. Lenzerini;D. Nardi;R. Rosati
集成是数据仓库最重要的方面之一。当数据从面向应用程序的业务环境的来源传递到数据仓库时，应解决可能的不一致和冗余问题，以便数据仓库能够提供组织数据的综合和协调视图。基于数据仓库应用领域的概念表示，我们描述了一种新的数据集成和协调方法。其主要思想是声明性地指定要使用的适当的匹配、转换和对帐操作，以便解决不同来源的数据之间可能的冲突。这样的规范是根据应用程序的概念模型提供的，并在将数据从源加载到数据仓库的软件模块的设计过程中有效地使用。
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.