Analysis of information integration in DB2 database system

Integration work is endless. IT environments are constantly changing. New applications continue to appear on the web. Publishing-level changes to packaged applications can have a ripple effect on the entire infrastructure. People always want to try to use the next new tool or technology. The investment we make must be focused on the future. As a result, organizations that focus on an integrated architecture appear within the company. Whether it is called information Management (information Management), Integrated Services (integration service), or data Architecture (database architecture), The specialized departments within the company are addressing issues in integrating the business and defining the integration architecture and infrastructure that provides the basis for their future business.

Integration is a daunting task, as the increase in information and the diversity of information sources combine to make it very complex to retrieve useful information. Enterprises must be able to access not only traditional application sources, such as relational databases, but also extensible Markup Language (extensible Markup language,xml) documents, text documents, scanned images, video clips, incoming news, Web content, e-mail, Analytical three-dimensional data and special-purpose storage (both internal and external). Because of organizational or operational constraints, information from different distributed data sources is often not fully replicated or merged into a single database. Although hidden information can be found, it is easier to take advantage of the information when it is interconnected and to serve the customer better.

Technology vendors in many markets, such as enterprise application integration, data warehousing, enterprise content management, portals, and application servers, have begun to shift their focus to the overall integration issue. This makes it more difficult for us to choose the best technology to meet our business needs. Moreover, the market positioning of blockbuster products often makes it difficult to take advantage of the advantages of an implementation in subsequent projects.

While competitors may only provide specific areas of integration, IBM can provide a comprehensive integrated platform with many products that can work seamlessly together. This article focuses on Db2®information integrator™ products to help you understand how they help solve information integration issues.

IBM DB2 Information Integrator Overview

The IBM DB2 Information Integrator software, shown in Figure 1, provides the basis for a strategic information integration framework. Such a framework helps customers to access, manipulate, and integrate various distributed data in real time. The folder (Portfolio) includes:

IBM DB2 Information Integrator V8.1, a new product based on DB2 information management technology

IBM DB2 Information Integrator for Content V8.2, formerly IBM Enterprise information Portal.

Figure 1. DB2 Information Integrator products provide integrated access to a variety of distributed and real-time data, as if data were from a single data source.

Each of these products enables customers to abstract common data models from a variety of distributed data and content sources, and enables customers to access and manipulate them as a single source. Each product supports a user community, which is defined primarily by the data that its members can access and the development communities they support. The product set supports scenarios that are primarily read-access, which are common to enterprise reporting generation, knowledge management, business intelligence, portal infrastructure, and customer relationship management.

DB2 Information Integrator: Servers for federated data and replication

DB2 Information Integrator's service object is an application development community that is familiar with relational database application development. Applications that use SQL, or tools that generate SQL (such as the Integrated development environment, reporting generation and analysis tools, and so on) can now access and manipulate various distributed data through federated data servers.