© 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
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset