O'Reilly logo

Oracle® Data Warehousing and Business Intelligence Solutions by Rick Greenwald, Joseph Rayman, Robert Stackowiak

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 3. Introduction to Oracle Data Warehousing

The solutions outlined in Chapter 2 provide business intelligence gleaned from transactional data. Such solutions can provide reporting and simple drill-downs to more detailed data and, in some cases, rely on data warehousing features present in the Oracle database. In this chapter, we'll introduce Oracle database features and describe how they might be used if you deploy a classic data warehouse solution. We'll also describe some of the data warehouses available today for some of Oracle's applications that will be merged in Oracle's next generation Project Fusion business intelligence applications.

In subsequent chapters, we'll explore how to leverage these features and deploy a data warehouse solution in more detail. Chapter 4 describes some of the hardware platform configuration choices. Chapter 5 describes database schema design choices and types of analyses these choices enable. We describe Oracle's business intelligence tools and how they are used in Chapter 6. In Chapter 7, we'll describe loading options that might be used in populating a data warehouse. In Chapter 8, we describe manageability of an Oracle data warehouse in much greater detail.

But, given that we described in the previous chapter how some business intelligence solutions might be deployed as extended applications in transaction processing systems, you might need more detail on why a separate and largely custom data warehouse could be necessary. So, we begin ...

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