Datawarehouse

TE

AM
FL
Y

Uttama Reddy

Uttama Reddy

Building the
Data Warehouse
Third Edition

W. H. Inmon

Wiley Computer Publishing

John Wiley & Sons, Inc.
N EW YOR K • CH ICH ESTER • WEI N H EI M • B R ISBAN E • SI NGAPOR E • TORONTO

Uttama Reddy

Uttama Reddy

Building the
Data Warehouse
Third Edition

Uttama Reddy

Uttama Reddy

Building the
Data WarehouseThird Edition

W. H. Inmon

Wiley Computer Publishing

John Wiley & Sons, Inc.
N EW YOR K • CH ICH ESTER • WEI N H EI M • B R ISBAN E • SI NGAPOR E • TORONTO

Uttama Reddy

Publisher: Robert Ipsen
Editor: Robert Elliott
Developmental Editor: Emilie Herman
Managing Editor: John Atkins
Text Design & Composition: MacAllister Publishing Services, LLC
Designations used by companies todistinguish their products are often claimed as trademarks. In all
instances where John Wiley & Sons, Inc., is aware of a claim, the product names appear in initial capital or ALL CAPITAL LETTERS. Readers, however, should contact the appropriate companies for more complete information regarding trademarks and registration.
This book is printed on acid-free paper.
Copyright © 2002 by W.H. Inmon. Allrights reserved.
Published by John Wiley & Sons, Inc.
Published simultaneously in Canada.
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 Copyright Act, without either the priorwritten permission of the Publisher, or authorization through payment of the appropriate per-copy fee
to the Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, (978) 750-8400, fax (978)
750-4744. Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley & Sons, Inc., 605 Third Avenue, New York, NY 10158-0012, (212) 850-6011, fax (212)850-6008, E-Mail: PERMREQ @ WILEY.COM.
This publication is designed to provide accurate and authoritative information in regard to the subject
matter covered. It is sold with the understanding that the publisher is not engaged in professional services. If professional advice or other expert assistance is required, the services of a competent professional person should be sought.
Library ofCongress Cataloging-in-Publication Data:
ISBN: 0-471-08130-2
Printed in the United States of America.
10 9 8 7 6 5 4 3 2 1

Uttama Reddy

To Jeanne Friedman—a friend for all times

Uttama Reddy

Uttama Reddy

C O N T E N TS

Preface for the Second Edition

xiii

Preface for the Third Edition

xiv

Acknowledgments

xix

About the Author

xx

Chapter 1

Evolution ofDecision Support Systems

1

The Evolution

2
4
4
5
6

The Advent of DASD
PC/4GL Technology
Enter the Extract Program
The Spider Web

Problems with the Naturally Evolving Architecture
Lack of Data Credibility
Problems with Productivity
From Data to Information
A Change in Approach

The Architected Environment
Data Integration in the Architected Environment

6
6
9
1215
16
19

Who Is the User?
The Development Life Cycle

21

Patterns of Hardware Utilization

22

Setting the Stage for Reengineering

23

Monitoring the Data Warehouse Environment

25

Summary
Chapter 2

19

28

The Data Warehouse Environment

31

The Structure of the Data Warehouse

35

Subject Orientation

36

Day 1-Day n Phenomenon

41

Granularity43
45
46
49

The Benefits of Granularity
An Example of Granularity
Dual Levels of Granularity

vii

Uttama Reddy
C O N T E N TS

Exploration and Data Mining

53

Living Sample Database

53

Partitioning as a Design Approach

55
56

Partitioning of Data

Data Warehouse: The Standards Manual

64

Auditing and the Data Warehouse

64

Cost Justification...