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

Summary

This chapter looked at some of the key Business Intelligence concepts and techniques. We showed that OLTP systems typically have a normalized database structure optimized for updates rather than queries. Trying to provide access to this data is difficult because the complex schemas of OLTP databases makes them difficult for end users to work with, even when simplifying views are provided; furthermore, there are usually multiple data sources in an organization that need to be accessed together.

We propose building a data warehouse relational database with a design and an operational approach optimized for queries. Data from all the source systems is loaded into the warehouse through a process of extraction, transformation, and ...

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