Preparing for DB2 Near-realtime Business Intelligence

Preparing for DB2 Near-realtime Business Intelligence, 9780738498393 (0738498394), IBM Press, 2004

In this IBM Redbook 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 Redbook is what you need to get prepared to implement near-realtime business intelligence in your environment.

Comments

Amazing Books

Managing Information Security, Second Edition

Syngress Publishing, 2013

Managing Information Security offers focused coverage of how to protect mission critical systems, and how to deploy security management systems, IT security, ID management, intrusion detection and prevention systems, computer forensics, network forensics, firewalls, penetration testing, vulnerability assessment, and more. It offers...

The Complete Direct Investing Handbook: A Guide for Family Offices, Qualified Purchasers, and Accredited Investors (Bloomberg Financial)

Bloomberg Press, 2017

The practical guide to direct investing strategies and best practices

The Complete Direct Investing Handbook provides comprehensive guidelines, principles and practical perspectives on this increasingly attractive private equity investment strategy. Interviews with leading family office investors, qualified private...

Reed-Solomon Codes and Their Applications

John Wiley & Sons, 1999

Electrical Engineering/Communications/Information Theory "The Berlekamp article alone will make this book worth having." --David Forney, Vice President, Motorola Codex Reed-Solomon Codes and Their Applications Edited by Stephen B. Wicker, Georgia Institute of Technology and Vijay K. Bhargava, University of Victoria On the Voyager...

VMware vCloud Director Cookbook

Packt Publishing, 2013

Over 80 recipes to help you master VMware vCloud Director

Overview

Learn how to work with the vCloud API

Covers the recently launched VMware vCloud Suite 5.5

Step-by-step instructions to simplify infrastructure provisioning

Real-life implementation of tested...

ASP.NET v. 2.0-The Beta Version (2nd Edition) (Microsoft Net Development Series)

Addison Wesley, 2004

In this book, three world-class ASP.NET experts present a start-to-finish, developer-focused preview of Microsoft's latest Web development breakthrough: ASP.NET 2.0.

The first book to fully reflect the new ASP.NET 2.0 Beta, ASP.NET v. 2.0—The Beta Version...

Red Hat Enterprise Linux 6 Administration: Real World Skills for Red Hat Administrators

Sybex, 2013

The definitive guide to administering a Red Hat Enterprise Linux 6 network

Linux professionals who need a go-to guide on version 6 of Red Hat Enterprise Linux (RHEL) will find what they need in this comprehensive Sybex book. It covers RHEL administration in detail, including how to set up and manage web and mail services,...