Table Of ContentHandbook
Data
Management
1999
Sanjiv Purba, Editor
Boca Raton London New York
CRC Press is an imprint of the
Taylor & Francis Group, an informa business
First published 1999 by CRC Press
Taylor & Francis Group
6000 Broken Sound Parkway NW, Suite 300
Boca Raton, FL 33487-2742
Reissued 2018 by CRC Press
© 1999 by CRC Press, LLC
CRC Press is an imprint of Taylor & Francis Group, an Informa business
No claim to original U.S. Government works
This book contains information obtained from authentic and highly regarded sources. Reasonable efforts have been
made to publish reliable data and information, but the author and publisher cannot assume responsibility for the
validity of all materials or the consequences of their use. The authors and publishers have attempted to trace the
copyright holders of all material reproduced in this publication and apologize to copyright holders if permission to
publish in this form has not been obtained. If any copyright material has not been acknowledged please write and let
us know so we may rectify in any future reprint.
Except as permitted under U.S. Copyright Law, no part of this book may be reprinted, reproduced, transmitted, or
utilized in any form by any electronic, mechanical, or other means, now known or hereafter invented, including pho-
tocopying, microfilming, and recording, or in any information storage or retrieval system, without written permission
from the publishers.
For permission to photocopy or use material electronically from this work, please access www.copyright.com (http://
www.copyright.com/) or contact the Copyright Clearance Center, Inc. (CCC), 222 Rosewood Drive, Danvers, MA
01923, 978-750-8400. CCC is a not-for-profit organization that provides licenses and registration for a variety of
users. For organizations that have been granted a photocopy license by the CCC, a separate system of payment has
been arranged.
Trademark Notice: Product or corporate names may be trademarks or registered trademarks, and are used only for
identification and explanation without intent to infringe.
Library of Congress Cataloging-in-Publication Data
Handbook of data management / Sanjiv Purba, editor. – 1999 ed.
p. cm.
Includes bibliographical references and index.
ISBN 0-8493-9976-9 (alk. paper)
1. Database management. I. Purba, Sanjiv.
QA76.9.D3H3473 1998b
658.4’038’0285–dc21 98-38833
A Library of Congress record exists under LC control number: 98038833
Publisher’s Note
The publisher has gone to great lengths to ensure the quality of this reprint but points out that some imperfections in
the original copies may be apparent.
Disclaimer
The publisher has made every effort to trace copyright holders and welcomes correspondence from those they have
been unable to contact.
ISBN 13: 978-1-315-89338-9 (hbk)
ISBN 13: 978-1-351-07248-9 (ebk)
Visit the Taylor & Francis Web site at http://www.taylorandfrancis.com and the
CRC Press Web site at http://www.crcpress.com
Contributors
HEDYA LBANF, reelance Writer, Cherry Hill, NJ
MARYA YALA-BUSHPr, incipal, Computer Sciences Corporation, Waltham, MA
CHARLEBSA NYAYM, anager, Deloitte & Touche Consulting Group, Toronto, On-
tario, Canada
DAVIDB RASSORT, echnology Architect, Deloitte & Touche Consulting Croup,
Toronto, Ontario, Canada
JEFFB ULLERC,o nsultant, VISUAL Systems Development Group, Toronto, Ontar-
io, Canada
JAMESC ANNADRYe, search Scientist, Georgia Tech Research Institute, Atlanta,
CA
PATRICILA. CARBONEP,r incipal Staff,M ih-etek Systems, McLean, VA
MARIONG . CERUTSI,c ientist, Advanced C41 Systems, Engineering and Integra-
tion Group, Command and Intelligence Systems Diuision, Naval Com-
mand, Control, and Ocean Surveillance Center, RDT&E Division, San
Diego, CA
HANNANC HERVINSKPYri,n cipal and Cofounder,A BS Systems Consultants Ltd.,
Pickering, Ontario, Canada
TIMC HRISTMANSNen, ior Consultant, Deloitte & Touche Consulting Group, Tor-
onto, Ontario, Canada
CARMINCEU TONES, enior Manager, Deloitte and Touche Consulting Croup, Tor-
onto, Ontario, Canada
STEPHEND 'SILVAS, enior Consultant and Technology Leader, Deloitte & Touche
Consulting Croup, Toronto, Ontario, Canada
CHARLEDSO W,P ractice Leader, Object-Oriented Technologies, Deloitte & Tou-
che Consulting Croup, Toronto, Ontario, Canada
RICHARTD. DUE,P resident, Thomsen Due'&Associates, Ltd.,, Edmonton, Alber-
ta, Canada
LEND VORKIPNr, esident, Italex Consulting, Inc., Thornhill, Ontario, Canada
ELIZABETNH. FONC,C omputer Systems Laboratory, National Institute ofS tan-
dards and Technology, Gaithersburg, MD
JUDITHN. FROSCHEPRr, incipal Investigator, SINTRA Project, Naval Research
Laboratory, Washington, DC
YONCJIAFNu , Professor, Computer Science, University ofM issouri, Rolla, MO
FREDERICGKA LLEGOSA,d junct Professor and MSBA-Information Systems Audit
Advisor, Computer Information Systems Department, California State
Polytechnic University, Pomona, CA
IDO GILEADMI, anager, Deloitte & Touche Consulting Group, Toronto, Ontario,
Canada
NARASIMHAWGHO RLAA, ssociate Professor, Business Administration, Cleveland
State University, Cleveland, OH
FRITZH . GRUPEA, ssociate Professor, Computer Information Systems, Univer-
sity ofN evada, Reno, NV
VENKATN . GUDIVADDAO, WJ ones, Jersey City, NJ
BARBARAJ. HALEYC, ollege ofB usiness, University of Georgia, Athens, CA
CANDICGE. HARP,H uman Resources Consultant, Atlanta, GA
KATHRYNA . HARVILLC, omputer Systems Laboratory, National Institute ofS tan-
dards and Technology, Gaithersburg, MD
DAVIDC . HAY,P resident, Essential Strategies, Inc., Houston, 7X
DEBORAHH ENDERSONR,e search Information Coordinator, Ontario Hydro, Pick-
ering, Ontario, Canada
DAVIDK . HOLTHAUSS,o thare Specialist, Nationwide Insurance Enterprise, Co-
lumbus, OH
ASHVINIY ENGARC,o nsultant, Object Technologies, Deloitte & Touche Consult-
ing Group, DRTSystems, Toronto, Ontario, Canada
SUSHILJA JODIAP, rofessor, George Mason University, Fairfax, K4
JOHNJ ORDANP, rincipal, Consulting & Systems Integration, Computer Sciences
Corporation, Waltham, MA
WOLFGANGK ELLERS, enior Manager, Software Design & Management Ltd., Mu-
nich, Germany
GIGIG . KELLYP, rofessor, Management and Information Science, College of
William and Mary, Williamsburg, VA
KARLK ELTONS, enior Manager, Deloitte & Touche Consulting Group, Toronto,
Ontario, Canada
BONN-OHK IM,A ssistant Professor, Information Systems, Department ofM an-
agement, University ofN ebraska, Lincoln, NE
STEVENK REHBIEDL,o ctoral Student, Business Administration, Cleveland State
University, Cleveland, OH
WALTERK UKETZ, Consulting and Systems Integration, Computer Sciences Cor-
poration, Waltham, AM
CAROLL . LARSON,T echnical Writer and Desktop Publisher, Hillsboro, OR
JAMESA . LARSONS, enior Software Engineer, Intel Architecture Laboratory,
Hillsboro, OR
&CHARD LEE,S enior Consultant, Operations Reengineering, Deloitte & Touche
Consulting Croup, Toronto, Ontario, Canada
PIERREJ. LEMAYS, enior Consultant, Document Management, PJL Information
Systems, Orleans, Ontario, Canada
DAVIDS . LINTHICUMTe, chnical Manager, EDS, Falls Church, VA
GARYL ORDP, artner, KPMG Peat Marwick, Palo Alto, CA
PHILLIQP . MAIERM, ember, Secure Network Initiative, Lockheed Martin Corpo-
ration, Sunnyvale, CA
DANIEML ANSONA, ssociate Professor, Computer Information Systems Depart-
ment, California State Polytechnic University, Pomona, CA
JACKM CELREATHM, anaging Partner, Consulting and Systems Integration, Com-
puter Sciences Corporation, Waltham, MA
LYNDAL . MCGHIED, irector, Information Security, Lockheed Martin Corpora-
tion, Bethesda, MD
MICHAEKL. MILLERS,e nior Data Architect, Worldwide Data Planning and Archi-
tecture, NCR Corp., Dayton, OH
STEWARTS . MILLERP, resident and Owner, Executive Information Services,
Carlsbad, CA
JAGDISHM IRANSI,e nior Product Manager, Data Warehousing, Oracle Corp.,
Redwood Shores, CA
MADHAMV OGANTIA, dvanced Technologies, Bell Laboratories, Naperuille, /L
BRETTM OLOTSKYL,o tus Notes Product Manager, Omicron Consulting, Philadel-
phia, PA
ALIH . MURTAZAS,e nior Consultant, Data WarehousingServiceL ine, Deloitte &
Touche Consulting Group, Toronto, Ontario, Canada
MARGARETT. O'HARAA, ssistant Professor, Computer and Information Science,
Central Missouri State University, Warrensburg, MO
M. MEDHOI WRANGA, ssociate Professor, Computer Information Systems, Uni-
versity ofN evada, Reno, NV
R. MICHAEPLI CKERINCGo, nsultant, Red Brick Systems, Inc., Toronto, Ontario,
Canada
SRIRAMPI DAPARTCI,a rgill Financial Services Corporation, Minnetonka, MN
SANJIVP URBAS, enior Manager, Deloitte & Touche Consulting Group, Toronto,
Ontario, Canada
T.M. WKUMARA,s sociate Professor, Department ofD ecision Sciences and
MIS, Miami University, Oxford, OH
NYAPATHRIA MANAD, epartment of Computer Science, University of Florida,
Gainesville, FL
Lols RICHARDDS,a ta Warehousing Project Manager, Dynamic Information Sys-
tems Corp., Boulder, CO
RAVIS . SANDHUP,r ofessor, Software and Systems Engineering, George Mason
University, Fairfax, VA
CHARLELS. SHEPPARDC,o mputer Systems Laboratory, National Institute ofS tan-
dards and Technology, Gaithersburg, MD
SANDRASH UFFLERSe, nior Consultant, Deloitte and Touche Consulting Group,
Toronto, Ontario, Canada
ANTONIOS I,A ssistant Professor, Department of Computing, Hong-Kong Poly-
technic University, Hong Kong, China
MICHAESLI MONYIIn,d ependent Consultant, Etobicoke, Ontario, Canada
MARTIND . SOLOMONC,. W Costello, Inc., Middletown, CT
DANIELL. SPAR,C onsultant, Transarc Corp., Falls Church, VA
NANCYST ONELAKSEen, ior Consultant,D eloitte & Touche Consulting Group, Tor-
onto, Ontario, Canada
WINSTOJN. SULLIVAPNre, sident, WJS, Toronto, Ontario, Canada
MICHAEJ.LD . SUTTONR, ockland, Ontario, Canada
BHAVATNHI URAISINGHLAeaMd, Engineer, Center for Integrated Intelligence Sys-
tems, The MITRE Corporation, Bedford, MA
DAVIDW ADSWORTJHav, a Evangelist, Sun Microsystems, Toronto, Ontario, Can-
ada
DAVIDC . WALLACPEr, ofessor, Applied Computer Science Department, Illinois
State University, Normal, IL
HUGHJ. WATSONC, hair, Business Administration, College ofB usiness, Univer-
sity of Georgia, Athens, CA
JASONW EIR,T echnical Writer, DataMirror Corporation, Markham, Ontario,
Canada
RONALAD. WENCERM, anagement Consultant, Toronto, Ontario, Canada
NANCYM . WILKINSOCNo,n sultant, Object-Oriented Design and C++,W estfield,
NJ
JAMESW OODSI,n dependent Consultant, Lewisville, TX
MILESA U YEUNGM, anager, Deloitte & Touche Consulting Group, Toronto, On-
tario, Canada
DAVIDA . ZIMMERPr, esident, American Eagle Group, Warrington, PA
MICHAEZLIM MESRe, nior Data Administrator, Ministry of Health, Victoria, Brit-
ish Columbia, Canada
viii
Contents
INTRODUCTION ................................................. xv
SECTION I
DATA DEVELOPMENT METHODOLOGIES, DEFINITIONS, AND
STRATEGY
1 Database Development Methodology and
Organization.. .................................. 1-1
2 A Review of Database System Terminology. ......... 2-1
3 Developing a Global Information Vision. ............ 3-1
4 An Approach for Establishing Enterprise Data
Standards ...................................... 4-1
5 Completeness, Context, and Proportion: Shaping
Data Design to the Business. ...................... 5-1
6 An Enterprise Decision Framework for System
Selection ....................................... 6-1
7 The Importance of Data Architecture in a
ClientJServer Environment. ....................... 7-1
SECTION I1
DATA MODELS AND MODELING TECHNIQUES
8 Making Data Models Readable. .................... 81
9 Component Design for Relational Databases. ........ 9-1
10 Practices in Enterprise Data Modeling. ............ 10-1
11 Integrating Process and Data Models in a
Horizontal Organization ......................... 11-1
12 Object-Oriented Aspects of Windows
Component-Based Software. ..................... 12-1
13 Data Warehouse Design: Issues in Dimensional
Data Modeling ................................. 13-1
SECTION 111
DATA INTEGRITY AND QUALITY
14 Programming Data Constraints using Microsoft
SQLServer .................................... 14-1
