GC18-7562-00_Extending DW

GC18-7562-00_Extending DW - Information Integration...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
Information integration— Extending the data warehouse Information Integration Software Solutions March 2003 By Dr. Barry Devlin IBM Software
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Information integration—Extending the data warehouse page 2 Table of Contents 5 Data warehousing—20 years growing 9 Information integration—extending the data warehouse architecture 11 The relationship between information integration and data warehousing 12 Real-time data access 14 Access to unstructured content 15 Federating data marts and business data warehouses 17 To federate or not to federate 18 Using IBM DB2 Information Integrator in your data warehouse 19 Getting to up-to-date account information through the warehouse 20 Supply chain optimization and business activity monitoring 21 Executive information systems 22 Rationalizing government agency data marts 23 The programmer and database administrator views 23 Conclusion
Background image of page 2
Information integration—Extending the data warehouse page 3 Data warehousing is changing, changing to address new business needs. Of course, many of the original requirements remain like the need to deliver business value, the requirement for data cleanliness and consistency and the ability to dice, slice and dig into the information at will. The fundamental new requirements concern timeliness and extensibility to give business users the ability to see current data, remote data or unstructured data when they need it. All this must be seamlessly integrated with the historical information they have typically delivered through data warehouses and marts. These requirements have emerged over the past few years. Typically, IT organizations address them by creating operational data stores (ODS) or simply by trying to load the data warehouses more rapidly and regularly with more and more data. However, supplying data warehouses with fresh real-time data is very expensive, and not cost-effective for the majority of enterprises. Furthermore, some data cannot or need not be kept in the data warehouse even though it may be of critical value, because its usage, size or format is inappropriate for the data warehouse or user queries. To successfully address these needs, businesses require additional methods of integrating and delivering information without requiring all data to be stored in the data warehouse first. This is the goal of IBM’s vision for information integration. The aim is to make data location and format transparent to the user or application, enabling both centralized, local access, as found in traditional data warehouses, as well as distributed access to remote data from within the same infrastructure.
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
So do not fear! We are not proposing that you throw away all of the tooling and investment you have made in data warehousing. In fact, in many ways, information integration is a natural and logical extension of what you have already done to create and maintain your existing data warehouses. This white paper first briefly outlines the historical evolution of data
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/12/2010 for the course ECON CRM taught by Professor Prof during the Spring '10 term at École Normale Supérieure.

Page1 / 25

GC18-7562-00_Extending DW - Information Integration...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online