O'Reilly logo

Practical Business Intelligence: with SQL Server 2005 by Roger Toren, John C. Hancock

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 12 Real-Time Business Intelligence

There is a great need for current information in many business applications. In scenarios such as credit card fraud or outbreaks of serious contagious diseases, time is of the essence. However, many data warehouses on which BI solutions are based are loaded overnight, at best. The data you are analyzing is between 8 and 24 hours old. The reasons for this latency are often based on operational efficiencies or the lack of accessibility of the cubes during updates. New features in SQL Server 2005 address many of the issues relating to real-time analysis, and the process of building a real-time solution has been greatly simplified.

In this chapter, real-time design should be thought of as “real-enough” ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required