Welcome to the InfoSci Platform
Reference Hub4
Source Integration for Data Warehousing

Source Integration for Data Warehousing

Andrea Cali, Domenico Lembo, Maurizio Lenzerini, Riccardo Rosati
Copyright: © 2003 |Pages: 32
ISBN13: 9781591400530|ISBN10: 1591400538|EISBN13: 9781591400868
DOI: 10.4018/978-1-59140-053-0.ch012
Cite Chapter Cite Chapter

MLA

Cali, Andrea, et al. "Source Integration for Data Warehousing." Multidimensional Databases: Problems and Solutions, edited by Maurizio Rafanelli, IGI Global, 2003, pp. 361-392. https://doi.org/10.4018/978-1-59140-053-0.ch012

APA

Cali, A., Lembo, D., Lenzerini, M., & Rosati, R. (2003). Source Integration for Data Warehousing. In M. Rafanelli (Ed.), Multidimensional Databases: Problems and Solutions (pp. 361-392). IGI Global. https://doi.org/10.4018/978-1-59140-053-0.ch012

Chicago

Cali, Andrea, et al. "Source Integration for Data Warehousing." In Multidimensional Databases: Problems and Solutions, edited by Maurizio Rafanelli, 361-392. Hershey, PA: IGI Global, 2003. https://doi.org/10.4018/978-1-59140-053-0.ch012

Export Reference

Mendeley
Favorite

Abstract

While the main goal of a data warehouse is to provide support for data analysis and management’s decisions, a fundamental aspect in design of a data warehouse system is the process of acquiring the raw data from a set of relevant information sources. We will call source integration system the component of a data warehouse system dealing with this process. The main goal of a source integration system is to deal with the transfer of data from the set of sources constituting the application-oriented operational environment, to the data warehouse. Since sources are typically autonomous, distributed, and heterogeneous, this task has to deal with the problem of cleaning, reconciling, and integrating data coming from the sources. The design of a source integration system is a very complex task, which comprises several different issues. The purpose of this chapter is to discuss the most important problems arising in the design of a source integration system, with special emphasis on schema integration, processing queries for data integration, and data cleaning and reconciliation.

Request Access

You do not own this content. Please login to recommend this title to your institution's librarian or purchase it from the IGI Global bookstore.