Description

Up-to-date, comprehensive coverage of the Oracle database and business intelligence tools

Data warehouses are the core technology that businesses use to capture, store, and analyze vast amounts of business data, and Oracle has emerged as the leading database platform. Its business intelligence tools make it considerably easier to analyze data to support marketing, sales, and other initiatives. Written by a team of Oracle insiders, this authoritative book provides you with the most current coverage of the Oracle data warehousing platform as well as the full suite of business intelligence tools.

You'll learn how to leverage Oracle features and how those features can be used to provide solutions to a variety of needs and demands. Plus, you'll get valuable tips and insight based on the authors' real-world experiences and their own implementations.

Serving as a single reference that aims to help you avoid many common pitfalls while gaining professional success, Oracle Data Warehousing shares best practices for:

• Leveraging Oracle technologies to design, build, and manage data warehouses
• Integrating specific database and business intelligence solutions from other vendors
• Using the new suite of Oracle business intelligence tools to analyze data for marketing, sales, and more
• Handling typical data warehouse performance challenges
• Uncovering initiatives by your business community, security business sponsorship, project staffing, and managing risk

The companion Web site contains all the same code used throughout the book, plus links to related sites.

Wiley Technology Publishing Timely. Practical. Reliable.

Visit our Web site at www.wiley.com/compbooks/

Visit the companion Web site at www.wiley.com/go/stackowiak

 

Table of Contents

Acknowledgments.

Introduction.

Part I Oracle Business Intelligence Defined.

Chapter 1 Oracle Business Intelligence.

Business Intelligence and Transactional Applications.

Daily Business Intelligence.

Balanced Scorecard.

Enterprise Planning and Budgeting.

Activity-Based Management.

Oracle Integration Components Enabling Business Intelligence.

Data Hubs.

Business Activity Monitoring.

BPEL Process Manager.

Enterprise Messaging Service.

Custom Data Warehouse Solutions.

The Role of the Oracle Database.

Oracle Warehouse Builder.

Oracle Business Intelligence Standard Edition.

Oracle Business Intelligence Enterprise Edition.

BI (XML) Publisher.

Oracle Portal.

Spreadsheet Add-ins.

Building Custom Business Intelligence Applications.

Emerging Trends.

Chapter 2 Oracle’s Transactional Business Intelligence.

Transactional Business Intelligence.

Business Terminology.

Oracle’s Daily Business Intelligence.

How DBI Works.

Varieties of DBI.

Balanced Scorecards.

Oracle Balanced Scorecard Structure.

OBSC Architecture.

Creating an Oracle Balanced Scorecard.

Data Hubs.

The Oracle Customer Data Hub.

How Data Hubs Work.

Other Oracle Data Hubs.

Is Transactional Business Intelligence Enough?

Chapter 3 Introduction to Oracle Data Warehousing.

Oracle Data Warehousing Basics.

Oracle Database Analysis and Schema Considerations.

Managing an Oracle-based Data Warehouse.

Where to Start?

Oracle/PeopleSoft EPM.

Oracle/Siebel Business Analytics Applications.

Choosing Completely Custom.

Chapter 4 Choosing a Platform.

Scaling Up Platforms Versus Scaling Out.

Hardware Platforms.

Cost Considerations.

Availability Considerations.

Manageability Considerations.

Sizing the Platform.

Information Needed for Warehouse Hardware Sizing.

Benchmarking.

Sizing Hardware for Business Intelligence Tools.

Your Strategy.

Part II Custom-Built Data Warehousing Solutions.

Chapter 5 Designing for Usability.

Approaches for Design.

Key Design Considerations.

Features for Design — Enhancing Performance.

Business Scenario.

Normalized Design.

Dimensional Design.

Hybrid Design.

Online Analytical Processing Design.

Other Considerations.

Selecting the Best Approach.

Chapter 6 Business Intelligence Tools.

Oracle Portal and Portal Products.

Using Oracle Portal.

Building and Deploying Oracle Portal and Portlets.

Reporting.

<