Database Design Know It All

Front cover......Page 1
Database Design: Know It All......Page 4
Copyright page......Page 5
Table of contents......Page 6
About This Book......Page 10
Contributing Authors......Page 12
1.1 DATA AND DATABASE MANAGEMENT......Page 18
1.2 THE DATABASE LIFE CYCLE......Page 19
1.3 CONCEPTUAL DATA MODELING......Page 24
1.5 LITERATURE SUMMARY......Page 26
CHAPTER 2: Entity–Relationship Concepts......Page 28
2.1 INTRODUCTION TO ER CONCEPTS......Page 30
2.2 FURTHER DETAILS OF ER MODELING......Page 37
2.3 ADDITIONAL ER CONCEPTS......Page 46
2.4 CASE STUDY......Page 49
2.5 NORMALIZATION: PRELIMINARIES......Page 53
2.6 FUNCTIONAL DEPENDENCIES......Page 58
2.7 LOSSLESS DECOMPOSITIONS......Page 74
2.8 NORMAL FORMS......Page 82
2.9 ADDITIONAL DESIGN CONSIDERATIONS......Page 97
2.10 SUGGESTIONS FOR FURTHER READING......Page 100
3.1 INTRODUCTION......Page 102
3.2 OBJECT ORIENTATION......Page 105
3.3 ATTRIBUTES......Page 108
3.4 ASSOCIATIONS......Page 114
3.5 SET-COMPARISON CONSTRAINTS......Page 122
3.6 SUBTYPING......Page 130
3.7 OTHER CONSTRAINTS AND DERIVATION RULES......Page 135
3.8 MAPPING FROM ORM TO UML......Page 149
3.9 SUMMARY......Page 153
3.10 LITERATURE SUMMARY......Page 155
4.1 INTRODUCTION......Page 158
4.2 REQUIREMENTS ANALYSIS......Page 159
4.3 CONCEPTUAL DATA MODELING......Page 160
4.4 VIEW INTEGRATION......Page 169
4.5 ENTITY CLUSTERING FOR ER MODELS......Page 177
4.6 SUMMARY......Page 182
4.7 LITERATURE SUMMARY......Page 184
5.1 INTRODUCTION......Page 186
5.2 OVERVIEW OF THE TRANSFORMATIONS REQUIRED......Page 187
5.3 TABLE SPECIFICATION......Page 189
5.4 BASIC COLUMN DEFINITION......Page 198
5.5 PRIMARY KEY SPECIFICATION......Page 204
5.6 FOREIGN KEY SPECIFICATION......Page 206
5.7 TABLE AND COLUMN NAMES......Page 217
5.8 LOGICAL DATA MODEL NOTATIONS......Page 218
5.9 SUMMARY......Page 220
6.1 TRANSLATING AN ER DIAGRAM INTO RELATIONS......Page 222
6.2 NORMAL FORMS......Page 223
6.3 FIRST NORMAL FORM......Page 224
6.4 SECOND NORMAL FORM......Page 229
6.5 THIRD NORMAL FORM......Page 231
6.6 BOYCE-CODD NORMAL FORM......Page 233
6.7 FOURTH NORMAL FORM......Page 234
6.8 NORMALIZED RELATIONS AND DATABASE PERFORMANCE......Page 236
6.9 FURTHER READING......Page 241
7.1 INTRODUCTION......Page 242
7.2 INPUTS TO DATABASE DESIGN......Page 243
7.3 OPTIONS AVAILABLE TO THE DATABASE DESIGNER......Page 245
7.4 DESIGN DECISIONS THAT DO NOT AFFECT PROGRAM LOGIC......Page 246
7.5 CRAFTING QUERIES TO RUN FASTER......Page 254
7.6 LOGICAL SCHEMA DECISIONS......Page 255
7.7 VIEWS......Page 264
7.8 SUMMARY......Page 267
8.1 BASICS OF NORMALIZATION......Page 268
8.2 COMMON TYPES OF DENORMALIZATION......Page 272
8.3 TABLE DENORMALIZATION STRATEGY......Page 276
8.4 EXAMPLE OF DENORMALIZATION......Page 277
8.6 FURTHER READING......Page 284
9.2 TYPES OF BUSINESS METADATA......Page 286
9.3 THE METADATA WAREHOUSE......Page 288
9.4 DELIVERY CONSIDERATIONS......Page 290
9.5 INTEGRATION......Page 292
9.6 ADMINISTRATIVE ISSUES......Page 296
9.7 METADATA REPOSITORY: BUY OR BUILD?......Page 297
9.9 THE THIRD ALTERNATIVE: USE A PREEXISTING REPOSITORY......Page 298
9.10 SUMMARY......Page 299
10.1 INTRODUCTION......Page 300
10.2 THE NEED FOR PERSISTENCE......Page 301
10.3 SQL/XML’S XML TYPE......Page 310
10.4 ACCESSING PERSISTENT XML DATA......Page 311
10.5 XML “ON THE FLY” : NONPERSISTENT XML DATA......Page 312
10.6 SUMMARY......Page 314
11.1 LOCATION MANAGEMENT......Page 316
11.2 MOST—A DATA MODEL FOR CURRENT AND FUTURE MOVEMENT......Page 318
11.3 FTL—A QUERY LANGUAGE BASED ON FUTURE TEMPORAL LOGIC......Page 323
11.4 LOCATION UPDATES—BALANCING UPDATE COST AND IMPRECISION......Page 334
11.5 THE UNCERTAINTY OF THE TRAJECTORY OF A MOVING OBJECT......Page 340
11.6 PRACTICE......Page 350
11.7 LITERATURE NOTES......Page 352
Index......Page 354