Additional Information
Book Details
Abstract
Data is a valuable corporate asset and its effective management can be vital to an organisation’s success. This professional guide covers all the key areas of data management, including database development and corporate data modelling. It is business-focused, providing the knowledge and techniques required to successfully implement the data management function. This new edition covers web technology and its relation to databases and includes material on the management of master data.
Keith Gordon is an independent consultant and trainer specialising in data management issues. He has spent over 50 years in technical, education and training environments as an engineer, computer consultant, business analyst, education and training manager. He was also an associate lecturer with the Open University for 10 years.
I've used and recommended the first edition of Keith's comprehensive text for several years. I've found that both practitioners and students are able to easily make use of these important concepts. I'm very pleased with the expanded and updated treatments in the second edition.
Peter Aiken PhD
This book provides a great introduction for anyone involved in data management, or requiring an appreciation of what it is and why it is so important.
Mehmet Hurer
Data is a valuable corporate asset and its effective management can be vital to an organisation’s success. This professional reference guide covers all the key areas of data management including database development, data quality and corporate data modelling. It is not based on a particular proprietary system; rather it is business-focused, providing the knowledge and techniques required to successfully implement the data management function. The book is aimed at all those involved with data management, including IT/IS and business managers, consultants, and business analysts, as well as data management practitioners from all business sectors. This new edition covers web technology and its relation to databases and includes material on the management of master data.
Keith Gordon has done an excellent job of laying out the full set of dimensions to be addressed for the effective management of an organization's information.
David Hay
A vital book for all IS professionals (from business analysts to web developers) who need to understand the effective management of that critical resource, information.
Tony Jenkins
Table of Contents
| Section Title | Page | Action | Price |
|---|---|---|---|
| Cover | Cover | ||
| Copyright | iv | ||
| CONTENTS | vii | ||
| LIST OF FIGURES AND TABLES | xi | ||
| AUTHOR | xiv | ||
| FOREWORD TO THE FIRST EDITION | xv | ||
| GLOSSARY | xvii | ||
| PREFACE | xxii | ||
| INTRODUCTION | xxv | ||
| PART 1 PRELIMINARIES | 1 | ||
| 1 DATA AND THE ENTERPRISE | 3 | ||
| INFORMATION IS A KEY BUSINESS RESOURCE | 3 | ||
| THE RELATIONSHIP BETWEEN INFORMATION AND DATA | 4 | ||
| THE IMPORTANCE OF THE QUALITY OF DATA | 6 | ||
| THE COMMON PROBLEMS WITH DATA | 7 | ||
| AN ENTERPRISE-WIDE VIEW OF DATA | 9 | ||
| MANAGING DATA IS A BUSINESS ISSUE | 10 | ||
| SUMMARY | 11 | ||
| 2 DATABASE DEVELOPMENT | 12 | ||
| THE DATABASE ARCHITECTURE OF AN INFORMATION SYSTEM | 12 | ||
| AN OVERVIEW OF THE DATABASE DEVELOPMENT PROCESS | 17 | ||
| CONCEPTUAL DATA MODELLING (FROM A PROJECT-LEVEL PERSPECTIVE) | 22 | ||
| RELATIONAL DATA ANALYSIS | 39 | ||
| THE ROLES OF A DATA MODEL | 51 | ||
| PHYSICAL DATABASE DESIGN | 52 | ||
| SUMMARY | 55 | ||
| 3 WHAT IS DATA MANAGEMENT? | 57 | ||
| THE PROBLEMS ENCOUNTERED WITHOUT DATA MANAGEMENT | 57 | ||
| DATA MANAGEMENT RESPONSIBILITIES | 59 | ||
| DATA MANAGEMENT ACTIVITIES | 60 | ||
| ROLES WITHIN DATA MANAGEMENT | 63 | ||
| THE BENEFITS OF DATA MANAGEMENT | 64 | ||
| THE RELATIONSHIP BETWEEN DATA MANAGEMENT AND ENTERPRISE ARCHITECTURE | 65 | ||
| SUMMARY | 66 | ||
| PART 2 DATA ADMINISTRATION | 67 | ||
| 4 CORPORATE DATA MODELLING | 69 | ||
| WHY DEVELOP A CORPORATE DATA MODEL? | 69 | ||
| THE NATURE OF A CORPORATE DATA MODEL | 70 | ||
| HOW TO DEVELOP A CORPORATE DATA MODEL | 72 | ||
| CORPORATE DATA MODEL PRINCIPLES | 74 | ||
| SUMMARY | 78 | ||
| 5 DATA DEFINITION AND NAMING | 80 | ||
| THE ELEMENTS OF A DATA DEFINITION | 80 | ||
| DATA NAMING CONVENTIONS | 84 | ||
| SUMMARY | 86 | ||
| 6 METADATA | 87 | ||
| WHAT IS METADATA? | 87 | ||
| METADATA FOR DATA MANAGEMENT | 87 | ||
| METADATA FOR CONTENT MANAGEMENT | 88 | ||
| METADATA FOR DESCRIBING DATA VALUES | 89 | ||
| SUMMARY | 90 | ||
| 7 DATA QUALITY | 91 | ||
| WHAT IS DATA QUALITY? | 91 | ||
| ISSUES ASSOCIATED WITH POOR DATA QUALITY | 91 | ||
| THE CAUSES OF POOR DATA QUALITY | 92 | ||
| THE DIMENSIONS OF DATA QUALITY | 93 | ||
| DATA MODEL QUALITY | 94 | ||
| IMPROVING DATA QUALITY | 95 | ||
| SUMMARY | 98 | ||
| 8 DATA ACCESSIBILITY | 99 | ||
| DATA SECURITY | 99 | ||
| DATA INTEGRITY | 104 | ||
| DATA RECOVERY | 106 | ||
| SUMMARY | 108 | ||
| 9 MASTER DATA MANAGEMENT | 109 | ||
| WHAT IS MASTER DATA? | 109 | ||
| HOW DO PROBLEMS WITH MASTER DATA OCCUR? | 112 | ||
| HOW DO WE MANAGE MASTER DATA? | 112 | ||
| SUMMARY | 114 | ||
| PART 3 DATABASE AND REPOSITORY ADMINISTRATION | 115 | ||
| 10 DATABASE ADMINISTRATION | 117 | ||
| DATABASE ADMINISTRATION RESPONSIBILITIES | 117 | ||
| PERFORMANCE MONITORING AND TUNING | 119 | ||
| SUMMARY | 120 | ||
| 11 REPOSITORY ADMINISTRATION | 121 | ||
| REPOSITORIES, DATA DICTIONARIES, ENCYCLOPAEDIAS, CATALOGS AND DIRECTORIES | 121 | ||
| REPOSITORY FEATURES | 124 | ||
| THE REPOSITORY AS A CENTRALISED SOURCE OF INFORMATION | 126 | ||
| METADATA MODELS | 127 | ||
| SUMMARY | 127 | ||
| PART 4 THE DATA MANAGEMENT ENVIRONMENT | 129 | ||
| 12 THE USE OF PACKAGED APPLICATION SOFTWARE | 131 | ||
| WHAT ARE APPLICATION SOFTWARE PACKAGES? | 131 | ||
| THE IMPACT ON DATA MANAGEMENT | 131 | ||
| SUMMARY | 133 | ||
| 13 DISTRIBUTED DATA AND DATABASES | 134 | ||
| THE RATIONALE FOR DISTRIBUTING DATA | 134 | ||
| THE PERFECT DISTRIBUTED DATABASE SYSTEM? | 135 | ||
| TOP-DOWN FRAGMENTATION AND PARTITIONING | 136 | ||
| BOTTOM-UP INTEGRATION | 137 | ||
| THE MANAGEMENT OF REPLICATION | 139 | ||
| SUMMARY | 140 | ||
| 14 BUSINESS INTELLIGENCE | 141 | ||
| DATA WAREHOUSING | 141 | ||
| THE MULTIDIMENSIONAL MODEL OF DATA | 143 | ||
| STANDARD REPORTING TOOLS | 144 | ||
| ONLINE ANALYTICAL PROCESSING (OLAP) | 144 | ||
| DATA MINING | 145 | ||
| A RELATIONAL SCHEMA FOR A DATA WAREHOUSE | 146 | ||
| SUMMARY | 148 | ||
| 15 OBJECT ORIENTATION | 149 | ||
| WHAT IS OBJECT ORIENTATION? | 149 | ||
| THE FUNDAMENTAL CONCEPTS OF OBJECT ORIENTATION | 150 | ||
| OBJECT ORIENTED DATABASES | 151 | ||
| OBJECT-RELATIONAL DATABASES | 153 | ||
| SUMMARY | 156 | ||
| 16 MULTIMEDIA | 158 | ||
| WHAT IS MULTIMEDIA? | 158 | ||
| STORING MULTIMEDIA OUTSIDE A DATABASE | 158 | ||
| STORING MULTIMEDIA INSIDE A DATABASE | 159 | ||
| STORING MULTIMEDIA USING SPECIAL PACKAGES | 160 | ||
| SUMMARY | 160 | ||
| 17 WEB TECHNOLOGY | 161 | ||
| THE INTERNET AND THE WEB | 161 | ||
| THE ARCHITECTURE OF THE WEB | 162 | ||
| XML AND DATABASES | 163 | ||
| OTHER WAYS TO LINK DATABASES INTO WEB TECHNOLOGY | 164 | ||
| DEALING WITH THE LARGE QUANTITIES OF DATA GENERATED OVER THE WEB | 165 | ||
| THE SEMANTIC WEB | 167 | ||
| SUMMARY | 169 | ||
| APPENDICES | 171 | ||
| APPENDIX A COMPARISON OF DATA MODELLING NOTATIONS | 173 | ||
| APPENDIX B HIERARCHICAL AND NETWORK DATABASES | 183 | ||
| APPENDIX C GENERIC DATA MODELS | 191 | ||
| APPENDIX D AN EXAMPLE OF A DATA NAMING CONVENTION | 195 | ||
| APPENDIX E METADATA MODELS | 206 | ||
| APPENDIX F A DATA MINING EXAMPLE | 212 | ||
| APPENDIX G HTML AND XML | 218 | ||
| APPENDIX H XML AND RELATIONAL DATABASES | 225 | ||
| APPENDIX I TECHNIQUES AND SKILLS FOR DATA MANAGEMENT | 233 | ||
| APPENDIX J INTERNATIONAL STANDARDS FOR DATA MANAGEMENT | 236 | ||
| APPENDIX K BIBLIOGRAPHY | 239 | ||
| INDEX | 243 | ||
| Back Cover | 250 |