Handbook of Data Management: 1999 Edition PDF
Preview Handbook of Data Management: 1999 Edition
Handbook 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
The list of books you might like
