Getting Started With Data Warehouse

Getting Started with Data Warehouse and Business Intelligence
Maria Sueli Almeida, Missao Ishikawa, Joerg Reinschmidt, Torsten Roeber

International Technical Support Organization www.redbooks.ibm.com

SG24-5415-00

SG24-5415-00

International Technical Support Organization Getting Started with Data Warehouse and Business Intelligence August 1999

Take Note! Before using thisinformation and the product it supports, be sure to read the general information in Appendix B, “Special Notices” on page 225.

First Edition (August 1999) This edition applies to Version 5, Release 1of DB2 Server for VSE & VM Program Number 5648-158, Version 5, Release 1of DB2 Server for OS/390 Program Number 5655-DB2, Version 5.2 of IBM Visual Warehouse, Version 1.0.1 of IBM DB2 OLAP Server, Version2.1.2 of IBM Intelligent Miner for Data, Version 5.2 of IBM DB2 UDB for NT, Version 2.1.1of IBM DB2 DataJoiner Classic Connect, Version 2.1.3 of IBM DB2 Datajoiner for use with the Windows NT operating system, and Version 5.2 of IBM DB2 UDB for AIX, Version 2.1.2 of IBM Intelligent MIner for Data, Version 2.1.3 of IBM DB2 DataJoiner, Version 2.1.1 of IBM DB2 DataJoiner Classic Connect for usewith the AIX Version 4.3.1 Operating System, CrossAccess VSE V4.1. Comments may be addressed to: IBM Corporation, International Technical Support Organization Dept. QXXE Building 80-E2 650 Harry Road San Jose, California 95120-6099 When you send information to IBM, you grant IBM a non-exclusive right to use or distribute the information in any way it believes appropriate without incurring anyobligation to you.

© Copyright International Business Machines Corporation 1999. All rights reserved Note to U.S Government Users – Documentation related to restricted rights – Use, duplication or disclosure is subject to restrictions set forth in GSA ADP Schedule Contract with IBM Corp.

Contents
Figures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. . . . vii Tables. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .ix Preface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .xi The Team That Wrote This Redbook . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xi Comments Welcome . . . . . . . . . . . . . . . . . . . .. . . . . . . . . . . . . . . . . . . . . . . . xiii Chapter 1. What is BI ? . . . . . . . . . . . . . . . . . . . . . . . . . . . 1.1 The Evolution of Business Information Systems . . . . . . . 1.1.1 First-Generation: Host-Based Query and Reporting 1.1.2 Second-Generation: Data Warehousing . . . . . . . . . 1.1.3 Third-Generation: Business Intelligence . . . . . . . . . 1.2 Why Do You NeedBusiness Intelligence ? . . . . . . . . . . . 1.3 What Do You Need for Business Intelligence ? . . . . . . . 1.4 Business Driving Forces . . . . . . . . . . . . . . . . . . . . . . . . . 1.5 Business Intelligence Requirements . . . . . . . . . . . . . . . . 1.6 The IBM Business Intelligence Product Set . . . . . . . . . . 1.6.1 Business Intelligence Applications . . . . . . . . . . . . . 1.6.2 DecisionSupport Tools. . . . . . . . . . . . . . . . . . . . . . 1.7 The Challenge of Data Diversity . . . . . . . . . . . . . . . . . . . Chapter 2. ITSO Scenario . . . . . . 2.1 The Environment . . . . . . . . . . . 2.1.1 Database Server . . . . . . . 2.1.2 Visual Warehouse . . . . . . 2.1.3 Communication Gateways 2.1.4 Data Analysis Tools . . . . . 2.2 The Data . . . . . . . . . . . . . . . . . 2.2.1Sales Information . . . . . . . 2.2.2 Article Information . . . . . . 2.2.3 Organization Information . 2.3 Data Warehouse for OLAP . . . . . . . . . . . . . . . .. .. .. .. .. .. .. .. .. .. .. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. .. .. .. .. .. .. .. .. .. .. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. .. .. .. .. .....