Database Design Know It All

Front cover......Page 1
Database Design: Know It All......Page 3
Copyright page......Page 4
Table of contents......Page 5
About This Book......Page 9
Contributing Authors......Page 11
1.1 DATA AND DATABASE MANAGEMENT......Page 17
1.2 THE DATABASE LIFE CYCLE......Page 18
1.3 CONCEPTUAL DATA MODELING......Page 23
1.5 LITERATURE SUMMARY......Page 25
CHAPTER 2: Entity–Relationship Concepts......Page 27
2.1 INTRODUCTION TO ER CONCEPTS......Page 29
2.2 FURTHER DETAILS OF ER MODELING......Page 36
2.3 ADDITIONAL ER CONCEPTS......Page 45
2.4 CASE STUDY......Page 48
2.5 NORMALIZATION: PRELIMINARIES......Page 52
2.6 FUNCTIONAL DEPENDENCIES......Page 57
2.7 LOSSLESS DECOMPOSITIONS......Page 73
2.8 NORMAL FORMS......Page 81
2.9 ADDITIONAL DESIGN CONSIDERATIONS......Page 96
2.10 SUGGESTIONS FOR FURTHER READING......Page 99
3.1 INTRODUCTION......Page 101
3.2 OBJECT ORIENTATION......Page 104
3.3 ATTRIBUTES......Page 107
3.4 ASSOCIATIONS......Page 113
3.5 SET-COMPARISON CONSTRAINTS......Page 121
3.6 SUBTYPING......Page 129
3.7 OTHER CONSTRAINTS AND DERIVATION RULES......Page 134
3.8 MAPPING FROM ORM TO UML......Page 148
3.9 SUMMARY......Page 152
3.10 LITERATURE SUMMARY......Page 154
4.1 INTRODUCTION......Page 157
4.2 REQUIREMENTS ANALYSIS......Page 158
4.3 CONCEPTUAL DATA MODELING......Page 159
4.4 VIEW INTEGRATION......Page 168
4.5 ENTITY CLUSTERING FOR ER MODELS......Page 176
4.6 SUMMARY......Page 181
4.7 LITERATURE SUMMARY......Page 183
5.1 INTRODUCTION......Page 185
5.2 OVERVIEW OF THE TRANSFORMATIONS REQUIRED......Page 186
5.3 TABLE SPECIFICATION......Page 188
5.4 BASIC COLUMN DEFINITION......Page 197
5.5 PRIMARY KEY SPECIFICATION......Page 203
5.6 FOREIGN KEY SPECIFICATION......Page 205
5.7 TABLE AND COLUMN NAMES......Page 216
5.8 LOGICAL DATA MODEL NOTATIONS......Page 217
5.9 SUMMARY......Page 219
6.1 TRANSLATING AN ER DIAGRAM INTO RELATIONS......Page 221
6.2 NORMAL FORMS......Page 222
6.3 FIRST NORMAL FORM......Page 223
6.4 SECOND NORMAL FORM......Page 228
6.5 THIRD NORMAL FORM......Page 230
6.6 BOYCE-CODD NORMAL FORM......Page 232
6.7 FOURTH NORMAL FORM......Page 233
6.8 NORMALIZED RELATIONS AND DATABASE PERFORMANCE......Page 235
6.9 FURTHER READING......Page 240
7.1 INTRODUCTION......Page 241
7.2 INPUTS TO DATABASE DESIGN......Page 242
7.3 OPTIONS AVAILABLE TO THE DATABASE DESIGNER......Page 244
7.4 DESIGN DECISIONS THAT DO NOT AFFECT PROGRAM LOGIC......Page 245
7.5 CRAFTING QUERIES TO RUN FASTER......Page 253
7.6 LOGICAL SCHEMA DECISIONS......Page 254
7.7 VIEWS......Page 263
7.8 SUMMARY......Page 266
8.1 BASICS OF NORMALIZATION......Page 267
8.2 COMMON TYPES OF DENORMALIZATION......Page 271
8.3 TABLE DENORMALIZATION STRATEGY......Page 275
8.4 EXAMPLE OF DENORMALIZATION......Page 276
8.6 FURTHER READING......Page 283
9.2 TYPES OF BUSINESS METADATA......Page 285
9.3 THE METADATA WAREHOUSE......Page 287
9.4 DELIVERY CONSIDERATIONS......Page 289
9.5 INTEGRATION......Page 291
9.6 ADMINISTRATIVE ISSUES......Page 295
9.7 METADATA REPOSITORY: BUY OR BUILD?......Page 296
9.9 THE THIRD ALTERNATIVE: USE A PREEXISTING REPOSITORY......Page 297
9.10 SUMMARY......Page 298
10.1 INTRODUCTION......Page 299
10.2 THE NEED FOR PERSISTENCE......Page 300
10.3 SQL/XML’S XML TYPE......Page 309
10.4 ACCESSING PERSISTENT XML DATA......Page 310
10.5 XML “ON THE FLY” : NONPERSISTENT XML DATA......Page 311
10.6 SUMMARY......Page 313
11.1 LOCATION MANAGEMENT......Page 315
11.2 MOST—A DATA MODEL FOR CURRENT AND FUTURE MOVEMENT......Page 317
11.3 FTL—A QUERY LANGUAGE BASED ON FUTURE TEMPORAL LOGIC......Page 322
11.4 LOCATION UPDATES—BALANCING UPDATE COST AND IMPRECISION......Page 333
11.5 THE UNCERTAINTY OF THE TRAJECTORY OF A MOVING OBJECT......Page 339
11.6 PRACTICE......Page 349
11.7 LITERATURE NOTES......Page 351
Index......Page 353