Oracle Data Warehousing and Business Intelligence Solutions

409 Pages·2007·12.006 MB·English

by  Robert Stackowiak, Joseph Rayman, Rick Greenwald

01_919216 ffirs.qxp 11/21/06 10:28 PM Page i
Oracle® Data
Warehousing and
Business Intelligence
Solutions
01_919216 ffirs.qxp 11/21/06 10:28 PM Page ii
01_919216 ffirs.qxp 11/21/06 10:28 PM Page iii
Oracle® Data
Warehousing and
Business Intelligence
Solutions
Robert Stackowiak
Joseph Rayman
Rick Greenwald
01_919216 ffirs.qxp 11/21/06 10:28 PM Page iv
Oracle®Data Warehousing and Business Intelligence Solutions
Published by
Wiley Publishing, Inc.
10475 Crosspoint Boulevard
Indianapolis, IN 46256
www.wiley.com
Copyright © 2007 by Wiley Publishing, Inc., Indianapolis, Indiana
Published simultaneously in Canada
ISBN-13: 978-0-471-91921-6
ISBN-10: 0-471-91921-7
Manufactured in the United States of America
10 9 8 7 6 5 4 3 2 1
1MA/RS/RS/QW/IN
No part of this publication may be reproduced, stored in a retrieval system or transmitted
in any form or by any means, electronic, mechanical, photocopying, recording, scanning or
otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copy-
right Act, without either the prior written permission of the Publisher, or authorization
through payment of the appropriate per-copy fee to the Copyright Clearance Center, 222
Rosewood Drive, Danvers, MA01923, [phone], fax [phone]. Requests to the
Publisher for permission should be addressed to the Legal Department, Wiley Publishing,
Inc., 10475 Crosspoint Blvd., Indianapolis, IN 46256, [phone], fax [phone], or
online at http://www.wiley.com/go/permissions.
Limit of Liability/Disclaimer of Warranty:The publisher and the author make no repre-
sentations or warranties with respect to the accuracy or completeness of the contents of this
work and specifically disclaim all warranties, including without limitation warranties of fit-
ness for a particular purpose. No warranty may be created or extended by sales or promo-
tional materials. The advice and strategies contained herein may not be suitable for every
situation. This work is sold with the understanding that the publisher is not engaged in ren-
dering legal, accounting, or other professional services. If professional assistance is
required, the services of a competent professional person should be sought. Neither the
publisher nor the author shall be liable for damages arising herefrom. The fact that an orga-
nization or Website is referred to in this work as a citation and/or a potential source of fur-
ther information does not mean that the author or the publisher endorses the information
the organization or Website may provide or recommendations it may make. Further, read-
ers should be aware that Internet Websites listed in this work may have changed or disap-
peared between when this work was written and when it is read.
For general information on our other products and services or to obtain technical support,
please contact our Customer Care Department within the U.S. at [phone], outside the
U.S. at [phone] or fax [phone].
Library of Congress Cataloging-in-Publication Data: Available from publisher.
Trademarks: Wiley, the Wiley logo, and related trade dress are trademarks or registered
trademarks of John Wiley & Sons, Inc. and/or its affiliates, in the United States and other
countries, and may not be used without written permission. Oracle is a registered trademark
of Oracle Corporation. All other trademarks are the property of their respective owners.
Wiley Publishing, Inc., is not associated with any product or vendor mentioned in this book.
Wiley also publishes its books in a variety of electronic formats. Some content that appears
in print may not be available in electronic books.
01_919216 ffirs.qxp 11/21/06 10:28 PM Page v
About the Authors
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), OracleApplicationServer10gEssentials
(1st Edition, August 2004, O’Reilly), and Professional Oracle Programming
(1st Edition, June 2005, WROX).
Joseph Raymanleads 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, telecom-
munications, healthcare, and federal government. His technical and busi-
ness 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 con-
tributor 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 interna-
tional financial organization.
v
01_919216 ffirs.qxp 11/21/06 10:28 PM Page vi
vi About the Authors
Rick Greenwaldhas worked in the IT field for over 20 years for major ven-
dors, 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. Green-
wald currently works for Ingres Corporation.
01_919216 ffirs.qxp 11/21/06 10:28 PM Page vii
Credits
Executive Editor Project Coordinator
Robert Elliott Adrienne Martinez
Senior Development Editor Graphics and Production
Tom Dinse Specialists
Carrie A. Foster
Production Editor
Stephanie D. Jumper
Angela Smith
Barbara Moore
Copy Editor Heather Ryan
Michael Koch Alicia B. South
Editorial Manager Quality Control Technicians
Mary Beth Wakefield Jessica Kramer
Brian H. Walls
Production Manager
Tim Tate Book Proofreading
Techbooks
Vice President and Executive
Group Publisher Indexing
Richard Swadley Stephen Ingle
Vice President and Executive Anniversary Logo Design
Publisher Richard Pacifico
Joseph B. Wikert
vii
01_919216 ffirs.qxp 11/21/06 10:28 PM Page viii
02_919216 ftoc.qxp 11/21/06 10:28 PM Page ix
Contents
Acknowledgments xv
Introduction xvii
Part I Oracle Business Intelligence Defined 1
Chapter 1 Oracle Business Intelligence 3
Business Intelligence and Transactional Applications 4
Daily Business Intelligence 5
Balanced Scorecard 6
Enterprise Planning and Budgeting 8
Activity-Based Management 9
Oracle Integration Components Enabling Business Intelligence 9
Data Hubs 10
Business Activity Monitoring 10
BPELProcess Manager 11
Enterprise Messaging Service 11
Custom Data Warehouse Solutions 12
The Role of the Oracle Database 14
Oracle Warehouse Builder 15
Oracle Business Intelligence Standard Edition 16
Oracle Business Intelligence Enterprise Edition 18
BI (XML) Publisher 20
Oracle Portal 20
Spreadsheet Add-ins 21
Building Custom Business Intelligence Applications 23
Emerging Trends 24
ix