Email RIS file
Bookmark
Report an Issue

Preparing for DB2 near-realtime business intelligence / [Chuck Ballard and others].

Published
Poughkeepsie, NY : IBM, International Technical Support Organization, [2004]
Copyright Date
©2004
Edition
1st ed.
Physical Description
1 online resource (xviii, 294 pages) : illustrations
Additional Creators
Ballard, Chuck and International Business Machines Corporation. International Technical Support Organization
Access Online

Availability

I Want It
I Want It

Finding items...

Series
Language Note
English.
Summary
In this IBM Redbooks publication we discuss primary processes and various alternatives that prepare you in implementing a DB2 near-realtime business intelligence environment. We discuss architectural alternatives and include overviews of software products that you can use in an implementation. As a primary focus, we tested the capabilities for supporting continuous update of a DB2 data warehouse while running a continuous concurrent query workload against that data warehouse. We tested several implementation scenarios and the variables that impact them. The results of our testing and the issues we encountered are provided. We used an IBM p-Series multiprocessor, along with a number of software products, including WebSphere MQ, DB2 MQ Listener, DB2 UDB, and DB2 Information Integrator - Replication Edition. We discuss ETL processing in a near-realtime environment, with reference to DB2 Warehouse Manager and DataStage from Ascential Software. We used WebSphere Studio Application Developer to generate online query applications, along with Java, SQL, and C-based stored procedures. We discuss DB2 Query Patroller and DB2 Governor. We provide guidelines and recommended best practices, and this book is what you need to get prepared to implement near-realtime business intelligence in your environment.
Subject(s)
ISBN
0738498394 (pbk.)
9780738498393 (pbk.)
Digital File Characteristics
data file
Bibliography Note
Includes bibliographical references (pages 287-288) and index.
View MARC record | catkey: 37413273