{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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

Info icon This 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
Image of page 1

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

View Full Document Right 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
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.
Image of page 3

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

View Full Document Right 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.
Image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern