Dataware Housing by Paulraj Ponnaih

Only available on StudyMode
  • Download(s) : 9
  • Published : February 27, 2013
Open Document
Text Preview
NILESH ZABAK, BIRLA COLLEGE
Data Warehousing Fundamentals: A Comprehensive Guide for IT Professionals. Paulraj Ponniah Copyright © 2001 John Wiley & Sons, Inc.
ISBNs: 0-471-41254-6 (Hardback); 0-471-22162-7 (Electronic)

DATA WAREHOUSING
FUNDAMENTALS

DATA WAREHOUSING
FUNDAMENTALS
A Comprehensive Guide for
IT Professionals

PAULRAJ PONNIAH

A Wiley-Interscience Publication
JOHN WILEY & SONS, INC.
New York / Chichester / Weinheim / Brisbane / Singapore / Toronto

MSc (IT) Notes...Mail: znilesh@hotmail.com

Designations used by companies to distinguish 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.

Copyright © 2001 by John Wiley & Sons, Inc. All rights reserved.

No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic or mechanical, including uploading, downloading, printing, decompiling, recording or otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without the prior written permission of the Publisher. 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 rendering professional services. If professional advice or other expert assistance is required, the services of a competent professional person should be sought. ISBN 0-471-22162-7

This title is also available in print as ISBN 0-471-41254-6. For more information about Wiley products, visit our web site at www.Wiley.com.

MSc (IT) Notes...Mail: znilesh@hotmail.com

To
Vimala, my loving wife
and to
Joseph, David, and Shobi,
my dear children

MSc (IT) Notes...Mail: znilesh@hotmail.com

CONTENTS

Foreword

xxi

Preface

xxiii
Part 1 OVERVIEW AND CONCEPTS

1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1

The Compelling Need for Data Warehousing
Chapter Objectives 1
Escalating Need for Strategic Information 2
The Information Crisis 3
Technology Trends 4
Opportunities and Risks 5
Failures of Past Decision-Support Systems 7
History of Decision-Support Systems 8
Inability to Provide Information 9
Operational Versus Decision-Support Systems 9
Making the Wheels of Business Turn 10
Watching the Wheels of Business Turn 10
Different Scope, Different Purposes 10
Data Warehousing—The Only Viable Solution 12
A New Type of System Environment 12
Processing Requirements in the New Environment 12
Business Intelligence at the Data Warehouse 12
Data Warehouse Defined 13
A Simple Concept for Information Delivery 14

1

vii

MSc (IT) Notes...Mail: znilesh@hotmail.com

viii

CONTENTS

1
An Environment, Not a Product 14
1
A Blend of Many Technologies 14
1 Chapter Summary 15
1 Review Questions 16
1 Exercises 16
2 Data Warehouse: The Building Blocks
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1

19

Chapter Objectives 19
Defining Features 20
Subject-Oriented Data 20
Integrated Data 21
Time-Variant Data 22
Nonvolatile Data 23
Data Granularity 23
Data Warehouses and Data Marts 24
How are They Different? 251
Top-Down Versus Bottom-Up Approach 26
A Practical Approach 27
Overview of the Components 28
Source Data Component 28
Data Staging Component 31
Data Storage Component 33
Information Delivery Component 34
Metadata Component 35
Management and Control Component 35
Metadata in the Data Warehouse 35
Types of Metadata 36...
tracking img