Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition

© Copyright IBM Corp. 2012. All rights reserved. 267

Chapter 7. Understand and address

data latency requirements

In this chapter we describe how to approach the challenge of identifying and

meeting your data latency requirements in an operational business intelligence

(BI) environment. We also take a look at how the SQL Warehousing (SQW) tool

can be used to develop an application for ingesting data into the data warehouse.

Getting the right information to the right people at the right time and in the right

format can be more complex in an operational BI environment than in a

traditional data warehousing environment because the timelines for each

workload are more aggressive.

Understanding the data latency requirements for each data source, which is the

elapsed time required to collect and store data for presentation to the query

workload, is key in determining the most appropriate tools and approach to use

to ingest data in as efficient a manner as possible.

In an environment that needs to ingest data and facilitate online backup and

maintenance operations while meeting service level objectives for data

availability and query performance on a 24x7 basis, finding the right balance of

resource allocation is a challenging task.

7