Information Integration

Information Integration

Manjunath Ramachandra (MSR School of Advanced Studies, Philips, India)
DOI: 10.4018/978-1-60566-888-8.ch010

Abstract

In an information supply chain, data gets pumped over the web from several distinct sources in various forms calling for efforts towards data integration. The integration happens at various levels by means of different algorithms. This chapter provides a framework for the interoperability of the data from different sources. The use case of integration in data warehouses is provided.
Chapter Preview
Top

Background

In a distributed environment, with multiple users having access to the database for updating the data, inconsistencies crop up posing a challenge for the database management system. It calls for restricted access for the data update in the EII products. In general, the database is to be maintained read only. To make it happen smoothly, the metadata of the different data sources is to be integrated and a centralized metadata based retrieval mechanism should be in place.

Case Study: Integration of Data over a Supply Chain

The data getting generated along a supply chain gets stored in a data warehouse accessible for the different elements of the supply chain. A data warehouse performs the conventional Extract, transform and load (ETL) operations over the data (O'Leary, Daniel, 2000). The Enterprise information integration (EII) technology and the tools can be used to support the integration of the data. ETL can sit as a part in EII, enhancing the different abstract levels of the data over which EII operates. The architecture of ETL in a modern organization is shown in figure 1

Figure 1.

Architecture of ETL in modern organization

Complete Chapter List

Search this Book:
Reset