9780471919216

Up-to-date, comprehensive coverage of the Oracle database and business intelligence toolsWritten 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.Youa??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, youa??ll get valuable tips and insight based on the authorsa?? real-world experiences and their own implementations. Avoid many common pitfalls while learning 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

Robert Stackowiak is Vice President of Business Intelligence in Oracle’s Technology Business Unit. He has worked for over 20 years in business intelligence, data warehousing, and IT-related roles at Oracle, IBM, Harris Corporation, and the U.S. Army Corps of Engineers. His papers regarding business intelligence and computer and software technology have appeared in publications such as President & CEO Magazine, Database Trends and Applications, and The Data Warehousing Institute’s publications. He also co-authored the books Oracle Essentials: Oracle Database 10g (currently in 3rd Edition, February 2004, O’Reilly), Oracle Application Server 10g Essentials (1st Edition, August 2004, O’Reilly), and Professional Oracle Programming (1st Edition, June 2005, WROX).

Joseph Rayman leads the Oracle Consulting Business Intelligence Practice in North America with over 20 years of business experience in a vast array of industries, including financial services, manufacturing, retail, telecommunications, healthcare, and federal government. His technical and business leadership spans enterprise architecture design, enterprise data modeling, VLDB system tuning, data warehouse design, data mining, and quality assurance activities for data warehouse practices. Joe is a key contributor in defining and authoring Oracle Consulting’s Data Warehousing Methodology. Prior to joining Oracle, Joe designed and deployed business intelligence and statistical analysis solutions for a large food manufacturer and provided real-time trading and analysis solutions for a major international financial organization.

Rick Greenwald has worked in the IT field for over 20 years for major vendors, including Oracle, Gupta Technologies, Cognos, and Data General. He has coauthored more than a dozen books, including Oracle Essentials: Oracle Database 10g (currently in 3rd Edition, February 2004, O’Reilly), Oracle Application Server 10g Essentials (1st Edition, August 2004, O’Reilly), and Professional Oracle Programming (1st Edition, June 2005, WROX). Mr. Greenwald currently works for Ingres Corporation.

Acknowledgments
Introduction
Oracle Business Intelligence Defined
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
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?
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
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
Custom-Built Data Warehousing Solutions
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
Business Intelligence Tools
Oracle Portal and Portal Products
Using Oracle Portal
Building and Deploying Oracle Portal and Portlets
Reporting
BI/XML Publisher
Oracle Reports
Oracle BI Reporting Workbench (Actuate)
Ad hoc Query and Analysis
Business Intelligence Enterprise Edition
Discoverer and Business Intelligence Standard Edition
Oracle Spreadsheet Add-ins
Building Business Intelligence Applications
JDeveloper and BI Beans
Data Miner
Other Tools
Data Loading
Oracle Database Data Loading Features
Embedded ETL in the Oracle Database
SQLa??
Loader
Change Data Capture
Transportable Tablespaces
Data Pump
Oracle Warehouse Builder
OWB Packaging
Typical Steps when using OWB
ETL Design in OWB
OWB and Dimensional Models
The OWB Process Editor
Balancing Data Loading Choices
Managing the Oracle Data Warehouse
Oracle Enterprise Manager Grid Control
Database Performance Monitoring
Database Administration
Database Maintenance
Database Topology
Management and Management Options
Data Warehouse Performance Tuning and Monitoring
Understanding Performance Challenges
Who Is Responsible?
Causes of Poor Performance
Successful Approaches to Performance Tuning
Critical Tasks for Performance Tuning Lifecycle
Hardware Configuration
Software Configuration
Database Application Design
Business Scenario: Tuning Our Sample Solution
Where To Start
Enterprise Manager Advisory Framework
Approaches for Success
Best Practices

Table of Contents provided by Publisher. All Rights Reserved.

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Amazon no longer offers textbook rentals. We do!

Oracle Data Warehousing and Business Intelligence Solutions

Oracle Data Warehousing and Business Intelligence Solutions

0471919217

Summary

Author Biography

Table of Contents

Supplemental Materials

Write a Review