Oracle Data Warehousing: With Business Intelligence Solutions

Overview

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

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

See more details below
Other sellers (Paperback)
  • All (18) from $1.99   
  • New (7) from $3.08   
  • Used (11) from $1.99   
Sending request ...

Overview

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

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. 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
Read More Show Less

Product Details

  • ISBN-13: 9780471919216
  • Publisher: Wiley
  • Publication date: 1/3/2007
  • Edition number: 1
  • Pages: 408
  • Product dimensions: 7.40 (w) x 9.25 (h) x 0.80 (d)

Meet the Author

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.

Read More Show Less

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.

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)