Oracle Data Warehousing and Business Intelligence Solutions (Paperback)

Robert Stackowiak, Joseph Rayman, Rick Greenwald

  • 出版商: Wiley
  • 出版日期: 2007-01-10
  • 定價: $1,900
  • 售價: 2.1$399
  • 語言: 英文
  • 頁數: 408
  • 裝訂: Paperback
  • ISBN: 0471919217
  • ISBN-13: 9780471919216
  • 相關分類: Oracle
  • 立即出貨 (庫存=1)

買這商品的人也買了...

相關主題

商品描述

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.

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.

Chapter 7 Data Loading.

Oracle Database Data Loading Features.

Embedded ETL in the Oracle Database.

SQL*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.

Chapter 8 Managing the Oracle Data Warehouse.

Oracle Enterprise Manager Grid Control.

Database Performance Monitoring.

Database Administration.

Database Maintenance.

Database Topology.

Management and Management Options.

Chapter 9 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.

Part III Best Practices.

Chapter 10 Scoping the Effort and an Approach for Success.

Uncovering Key Business Initiatives.

Where to Start.

Information Sources.

What is Important.

Accountability and Securing Business Sponsorship.

Establish a Steering Committee.

Project Review Board.

Endorsing a Methodology.

Choices of Methodologies.

A Business-focused Approach.

Staffing the Project.

Organization Structure.

End-User Experience.

Engaging the Business: Education and Training.

Managing Risk.

Communication — Managing Expectations.

Contingency Allocation.

Financial Risk.

Technology Risk.

No Place to Shortcut.

Chapter 11 Understanding Business Needs.

How Bad Deployment Choices Impact the Business.

Independent Data Marts.

Limited and Inflexible Reporting.

Sources of Information Limited to Internal Data.

Limited Data History.

Lack of Current High-Quality Data.

Limited Growth Flexibility.

Project Drivers and Business Types.

Financial Companies.

Healthcare.

Manufacturing.

Media and Entertainment.

Retail.

Telecommunications.

Other Business Types: Transportation and Utilities.

Educational Institutions.

Government Agencies.

Developing Scope and Gaining Business Support.

Chapter 12 Justifying Projects and Claiming Success.

Concept to Project.

Business Constraints.

Where to Start Justification.

Measuring Value.

Common Metrics to Measure.

Common Budgeting Techniques.

Total Cost of Ownership.

Modeling Total Cost of Ownership.

Return on Investment.

Modeling Return on Investment.

Claiming Success.

Index.

商品描述(中文翻譯)

描述

最新、全面的Oracle數據庫和商業智能工具的涵蓋範圍

數據倉庫是企業用來捕獲、存儲和分析大量業務數據的核心技術,而Oracle已成為領先的數據庫平台。其商業智能工具使得分析數據以支持市場營銷、銷售和其他項目變得更加容易。本權威書籍由Oracle內部人員組成的團隊撰寫,為您提供了最新的Oracle數據倉庫平台以及完整的商業智能工具的涵蓋範圍。

您將學習如何利用Oracle的功能以及這些功能如何用於滿足各種需求和要求的解決方案。此外,您還將獲得基於作者們的實際經驗和自己的實施的寶貴提示和見解。

作為一本旨在幫助您避免許多常見陷阱並取得專業成功的單一參考資料,Oracle數據倉庫分享了以下最佳實踐:

- 利用Oracle技術設計、構建和管理數據倉庫
- 整合來自其他供應商的特定數據庫和商業智能解決方案
- 使用新的Oracle商業智能工具套件分析市場營銷、銷售等數據
- 解決典型的數據倉庫性能挑戰
- 發現您的業務社區、安全業務贊助、項目人員配置和風險管理的項目

附帶網站包含了書中使用的所有代碼,以及相關網站的鏈接。

Wiley Technology Publishing 及時、實用、可靠。

請訪問我們的網站www.wiley.com/compbooks/

請訪問附帶網站www.wiley.com/go/stackowiak

目錄

致謝

引言

第一部分 Oracle商業智能定義

第1章 Oracle商業智能

商業智能和交易應用

日常商業智能

平衡計分卡

企業計劃和預算

基於活動的管理

啟用商業智能的Oracle集成組件

數據中樞

業務活動監控

BPEL流程管理器

企業消息服務

自定義數據倉庫解決方案

Oracle數據庫的角色

Oracle倉庫生成器

Oracle商業智能標準版

Oracle商業智能企業版

BI(XML)發布者

Oracle門戶

電子表格插件

構建自定義業務```