Modern Database Management

Cover......Page 1
Title Page......Page 4
Copyright Page......Page 5
ACKNOWLEDGMENTS......Page 35
Contents......Page 10
Preface......Page 26
 An Overview of Part One......Page 38
  Data Matter!......Page 39
  Introduction......Page 40
  Basic Concepts and Definitions......Page 42
  Traditional File Processing Systems......Page 44
  The Database Approach......Page 46
  Components of the Database Environment......Page 52
  The Database Development Process......Page 54
  Evolution of Database Systems......Page 61
  The Range of Database Applications......Page 64
  Developing a Database Application for Pine Valley Furniture Company......Page 68
  Summary......Page 78
  Review Questions......Page 79
  Problems and Exercises......Page 81
  Field Exercises......Page 82
  Further Reading......Page 83
  Web Resources......Page 84
  Case: Forondo Artist Management Excellence Inc......Page 85
 An Overview of Part Two......Page 88
  Introduction......Page 90
  The E-R Model: An Overview......Page 93
  Modeling the Rules of the Organization......Page 96
  Modeling Entities and Attributes......Page 102
  Modeling Relationships......Page 111
  E-R Modeling Example: Pine Valley Furniture Company......Page 129
  Database Processing at Pine Valley Furniture......Page 131
  Summary......Page 135
  Review Questions......Page 136
  Problems and Exercises......Page 137
  References......Page 147
  Web Resources......Page 148
  CASE: Forondo Artist Management Excellence Inc......Page 149
  Introduction......Page 151
  Representing Supertypes and Subtypes......Page 152
  Specifying Constraints in Supertype/Subtype Relationships......Page 159
  EER Modeling Example: Pine Valley Furniture Company......Page 165
  Entity Clustering......Page 168
  Packaged Data Models......Page 171
  Summary......Page 180
  Review Questions......Page 181
  Problems and Exercises......Page 182
  Further Reading......Page 185
  Web Resources......Page 186
  CASE: Forondo Artist Management Excellence Inc......Page 187
 An Overview of Part Three......Page 190
  Introduction......Page 192
  The Relational Data Model......Page 193
  Integrity Constraints......Page 197
  Transforming EER Diagrams into Relations......Page 202
  Introduction to Normalization......Page 215
  Normalization Example: Pine Valley Furniture Company......Page 219
  Merging Relations......Page 225
  A Final Step for Defining Relational Keys......Page 227
  Summary......Page 229
  Review Questions......Page 231
  Problems and Exercises......Page 232
  Web Resources......Page 241
  CASE: Forondo Artist Management Excellence Inc......Page 242
  Introduction......Page 243
  The Physical Database Design Process......Page 244
  Designing Fields......Page 247
  Denormalizing and Partitioning Data......Page 250
  Designing Physical Database Files......Page 256
  Using and Selecting Indexes......Page 265
  Designing a Database for Optimal Query Performance......Page 267
  Summary......Page 269
  Review Questions......Page 270
  Problems and Exercises......Page 271
  Further Reading......Page 274
  Web Resources......Page 275
  CASE: Forondo Artist Management Excellence Inc......Page 276
 An Overview of Part Four......Page 278
  Introduction......Page 280
  Origins of the SQL Standard......Page 282
  The SQL Environment......Page 284
  Defining a Database in SQL......Page 288
  Inserting, Updating, and Deleting Data......Page 294
  Internal Schema Definition in RDBMSs......Page 297
  Processing Single Tables......Page 298
  Summary......Page 318
  Review Questions......Page 319
  Problems and Exercises......Page 320
  Field Exercises......Page 323
  Web Resources......Page 324
  CASE: Forondo Artist Management Excellence Inc......Page 325
  Introduction......Page 326
  Processing Multiple Tables......Page 327
  Tips for Developing Queries......Page 347
  Ensuring Transaction Integrity......Page 351
  Data Dictionary Facilities......Page 352
  Recent Enhancements and Extensions to SQL......Page 354
  Triggers and Routines......Page 358
  Embedded SQL and Dynamic SQL......Page 364
  Summary......Page 366
  Review Questions......Page 367
  Problems and Exercises......Page 368
  Further Reading......Page 371
  Web Resources......Page 372
  CASE: Forondo Artist Management Excellence Inc......Page 373
  Location, Location, Location!......Page 374
  Client/Server Architectures......Page 375
  Databases in a Two-Tier Architecture......Page 377
  Three-Tier Architectures......Page 382
  Web Application Components......Page 384
  Databases in Three-Tier Applications......Page 386
  Key Considerations in Three-Tier Applications......Page 393
  Extensible Markup Language (XML)......Page 398
  Summary......Page 406
  Review Questions......Page 407
  Problems and Exercises......Page 408
  Web Resources......Page 409
  CASE: Forondo Artist Management Excellence Inc......Page 410
  Introduction......Page 411
  Basic Concepts of Data Warehousing......Page 413
  Data Warehouse Architectures......Page 417
  Some Characteristics of Data Warehouse Data......Page 425
  The Derived Data Layer......Page 429
  The Future of Data Warehousing: Integration with Big Data and Analytics......Page 445
  Key Terms......Page 447
  Problems and Exercises......Page 448
  References......Page 452
  Web Resources......Page 453
 An Overview of Part Five......Page 454
  Introduction......Page 456
  Data Governance......Page 457
  Managing Data Quality......Page 458
  Master Data Management......Page 465
  Data Integration: An Overview......Page 466
  Data Integration for Data Warehousing: The Reconciled Data Layer......Page 468
  Data Transformation......Page 474
  Review Questions......Page 478
  Problems and Exercises......Page 479
  References......Page 480
  Web Resources......Page 481
  Introduction......Page 482
  Big Data......Page 484
  NoSQL......Page 486
  Analytics......Page 497
  Impact of Big Data and Analytics......Page 513
  Implications of Big Data Analytics and Decision Making......Page 515
  Summary......Page 517
  Review Questions......Page 518
  Problems and Exercises......Page 519
  References......Page 520
  Web Resources......Page 521
  Introduction......Page 522
  The Roles of Data and Database Administrators......Page 523
  The Open Source Movement and Database Management......Page 529
  Managing Data Security......Page 531
  Database Software Data Security Features......Page 536
  Sarbanes-Oxley (SOX) and Databases......Page 542
  Database Backup and Recovery......Page 544
  Controlling Concurrent Access......Page 552
  Data Dictionaries and Repositories......Page 558
  Overview of Tuning the Database for Performance......Page 560
  Data Availability......Page 563
  Key Terms......Page 565
  Review Questions......Page 566
  Problems and Exercises......Page 567
  References......Page 569
  Web Resources......Page 570
 I......Page 664
 Y......Page 665
 C......Page 666
 D......Page 667
 F......Page 668
 L......Page 669
 P......Page 670
 S......Page 671
 V......Page 672
 X......Page 673
 B......Page 674
 C......Page 675
 D......Page 676
 E......Page 679
 F......Page 680
 I......Page 681
 M......Page 682
 O......Page 683
 P......Page 684
 R......Page 685
 S......Page 686
 T......Page 688
 U......Page 689
 X......Page 690
 Z......Page 691