Skip to content

Oracle Data Warehousing and Business Intelligence Solutions

ISBN-10: 0471919217

ISBN-13: 9780471919216

Edition: 2007

Authors: Robert Stackowiak, Rick Greenwald, Joseph Rayman

List price: $55.00
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

Description:

Oracle Data Warehousing shows readers how to use Oracle technologies to design and build the data warehouse; use Oracle's business intelligence tools to analyze data to solve buisiness problems; and integrate specific database and business intelligence solutions from other vendors. This is the first book on Oracle data warehousing to address all of these areas. The authors--all of whom are highly respected Oracle insiders--focus on best practices throughout the book. The companion Web site provides all sample code, plus links to related sites.
Customers also bought

Book details

List price: $55.00
Copyright year: 2007
Publisher: John Wiley & Sons, Incorporated
Publication date: 1/10/2007
Binding: Paperback
Pages: 408
Size: 7.50" wide x 9.50" long x 1.00" tall
Weight: 1.254
Language: English

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