BOOK
Modern Database Management, Global Edition
Jeff Hoffer | Ramesh Venkataraman | Heikki Topi
(2016)
Additional Information
Book Details
Abstract
For introductory courses in Database Management.
Provide the latest information in database development
Focusing on what leading database practitioners say are the most important aspects to database development, Modern Database Management presents sound pedagogy, and topics that are critical for the practical success of database professionals. The Twelfth Edition further facilitates learning with illustrations that clarify important concepts and new media resources that make some of the more challenging material more engaging. Also included are general updates and expanded material in the areas undergoing rapid change due to improved managerial practices, database design tools and methodologies, and database technology.Table of Contents
| Section Title | Page | Action | Price |
|---|---|---|---|
| Cover | Cover | ||
| Title Page | 3 | ||
| Copyright Page | 4 | ||
| ACKNOWLEDGMENTS | 34 | ||
| Contents | 9 | ||
| Preface | 25 | ||
| Part I: The Context of Database Management | 37 | ||
| An Overview of Part One | 37 | ||
| Chapter 1 the Database environment and Development Process | 38 | ||
| Learning Objectives | 38 | ||
| Data Matter! | 38 | ||
| Introduction | 39 | ||
| Basic Concepts and Definitions | 41 | ||
| Traditional File Processing Systems | 43 | ||
| The Database Approach | 45 | ||
| Components of the Database Environment | 51 | ||
| The Database Development Process | 53 | ||
| Evolution of Database Systems | 60 | ||
| The Range of Database Applications | 63 | ||
| Developing a Database Application for Pine Valley Furniture Company | 67 | ||
| Summary | 77 | ||
| Key Terms | 78 | ||
| Review Questions | 78 | ||
| Problems and Exercises | 80 | ||
| Field Exercises | 81 | ||
| References | 82 | ||
| Further Reading | 82 | ||
| Web Resources | 83 | ||
| Case: Forondo Artist Management Excellence Inc | 84 | ||
| Part II: Database Analysis | 87 | ||
| An Overview of Part Two | 87 | ||
| Chapter 2 Modeling Data in the organization | 89 | ||
| Learning Objectives | 89 | ||
| Introduction | 89 | ||
| The E-R Model: An Overview | 92 | ||
| Modeling the Rules of the Organization | 95 | ||
| Modeling Entities and Attributes | 101 | ||
| Modeling Relationships | 110 | ||
| E-R Modeling Example: Pine Valley Furniture Company | 128 | ||
| Database Processing at Pine Valley Furniture | 130 | ||
| Summary | 134 | ||
| Key Terms | 135 | ||
| Review Questions | 135 | ||
| Problems and Exercises | 136 | ||
| Field Exercises | 146 | ||
| References | 146 | ||
| Further Reading | 147 | ||
| Web Resources | 147 | ||
| CASE: Forondo Artist Management Excellence Inc | 148 | ||
| Chapter 3 the enhanced e-r Model | 150 | ||
| Learning Objectives | 150 | ||
| Introduction | 150 | ||
| Representing Supertypes and Subtypes | 151 | ||
| Specifying Constraints in Supertype/Subtype Relationships | 158 | ||
| EER Modeling Example: Pine Valley Furniture Company | 164 | ||
| Entity Clustering | 167 | ||
| Packaged Data Models | 170 | ||
| Summary | 179 | ||
| Key Terms | 180 | ||
| Review Questions | 180 | ||
| Problems and Exercises | 181 | ||
| Field Exercises | 184 | ||
| References | 184 | ||
| Further Reading | 184 | ||
| Web Resources | 185 | ||
| CASE: Forondo Artist Management Excellence Inc | 186 | ||
| Part III: Database Design | 189 | ||
| An Overview of Part Three | 189 | ||
| Chapter 4 Logical Database Design and the relational Model | 191 | ||
| Learning Objectives | 191 | ||
| Introduction | 191 | ||
| The Relational Data Model | 192 | ||
| Integrity Constraints | 196 | ||
| Transforming EER Diagrams into Relations | 201 | ||
| Introduction to Normalization | 214 | ||
| Normalization Example: Pine Valley Furniture Company | 218 | ||
| Merging Relations | 224 | ||
| A Final Step for Defining Relational Keys | 226 | ||
| Summary | 228 | ||
| Key Terms | 230 | ||
| Review Questions | 230 | ||
| Problems and Exercises | 231 | ||
| Field Exercises | 240 | ||
| References | 240 | ||
| Further Reading | 240 | ||
| Web Resources | 240 | ||
| CASE: Forondo Artist Management Excellence Inc | 241 | ||
| Chapter 5 Physical Database Design and Performance | 242 | ||
| Learning Objectives | 242 | ||
| Introduction | 242 | ||
| The Physical Database Design Process | 243 | ||
| Designing Fields | 246 | ||
| Denormalizing and Partitioning Data | 249 | ||
| Designing Physical Database Files | 255 | ||
| Using and Selecting Indexes | 264 | ||
| Designing a Database for Optimal Query Performance | 266 | ||
| Summary | 268 | ||
| Key Terms | 269 | ||
| Review Questions | 269 | ||
| Problems and Exercises | 270 | ||
| Field Exercises | 273 | ||
| References | 273 | ||
| Further Reading | 273 | ||
| Web Resources | 274 | ||
| CASE: Forondo Artist Management Excellence Inc | 275 | ||
| Part IV: Implementation | 277 | ||
| An Overview of Part Four | 277 | ||
| Chapter 6 introduction to sQL | 279 | ||
| Learning Objectives | 279 | ||
| Introduction | 279 | ||
| Origins of the SQL Standard | 281 | ||
| The SQL Environment | 283 | ||
| Defining a Database in SQL | 287 | ||
| Inserting, Updating, and Deleting Data | 293 | ||
| Internal Schema Definition in RDBMSs | 296 | ||
| Processing Single Tables | 297 | ||
| Summary | 317 | ||
| Key Terms | 318 | ||
| Review Questions | 318 | ||
| Problems and Exercises | 319 | ||
| Field Exercises | 322 | ||
| References | 323 | ||
| Further Reading | 323 | ||
| Web Resources | 323 | ||
| CASE: Forondo Artist Management Excellence Inc | 324 | ||
| Chapter 7 Advanced sQL | 325 | ||
| Learning Objectives | 325 | ||
| Introduction | 325 | ||
| Processing Multiple Tables | 326 | ||
| Tips for Developing Queries | 346 | ||
| Ensuring Transaction Integrity | 350 | ||
| Data Dictionary Facilities | 351 | ||
| Recent Enhancements and Extensions to SQL | 353 | ||
| Triggers and Routines | 357 | ||
| Embedded SQL and Dynamic SQL | 363 | ||
| Summary | 365 | ||
| Key Terms | 366 | ||
| Review Questions | 366 | ||
| Problems and Exercises | 367 | ||
| Field Exercises | 370 | ||
| References | 370 | ||
| Further Reading | 370 | ||
| Web Resources | 371 | ||
| CASE: Forondo Artist Management Excellence Inc | 372 | ||
| Chapter 8 Database Application Development | 373 | ||
| Learning Objectives | 373 | ||
| Location, Location, Location! | 373 | ||
| Introduction | 374 | ||
| Client/Server Architectures | 374 | ||
| Databases in a Two-Tier Architecture | 376 | ||
| Three-Tier Architectures | 381 | ||
| Web Application Components | 383 | ||
| Databases in Three-Tier Applications | 385 | ||
| Key Considerations in Three-Tier Applications | 392 | ||
| Extensible Markup Language (XML) | 397 | ||
| Summary | 405 | ||
| Key Terms | 406 | ||
| Review Questions | 406 | ||
| Problems and Exercises | 407 | ||
| Field Exercises | 408 | ||
| References | 408 | ||
| Further Reading | 408 | ||
| Web Resources | 408 | ||
| CASE: Forondo Artist Management Excellence Inc | 409 | ||
| Chapter 9 Data Warehousing | 410 | ||
| Learning Objectives | 410 | ||
| Introduction | 410 | ||
| Basic Concepts of Data Warehousing | 412 | ||
| Data Warehouse Architectures | 416 | ||
| Some Characteristics of Data Warehouse Data | 424 | ||
| The Derived Data Layer | 428 | ||
| The Future of Data Warehousing: Integration with Big Data and Analytics | 444 | ||
| Summary | 446 | ||
| Key Terms | 446 | ||
| Review Questions | 447 | ||
| Problems and Exercises | 447 | ||
| Field Exercises | 451 | ||
| References | 451 | ||
| Further Reading | 452 | ||
| Web Resources | 452 | ||
| Part V: Advanced Database Topics | 453 | ||
| An Overview of Part Five | 453 | ||
| Chapter 10 Data Quality and integration | 455 | ||
| Learning Objectives | 455 | ||
| Introduction | 455 | ||
| Data Governance | 456 | ||
| Managing Data Quality | 457 | ||
| Master Data Management | 464 | ||
| Data Integration: An Overview | 465 | ||
| Data Integration for Data Warehousing: The Reconciled Data Layer | 467 | ||
| Data Transformation | 473 | ||
| Summary | 477 | ||
| Key Terms | 477 | ||
| Review Questions | 477 | ||
| Problems and Exercises | 478 | ||
| Field Exercises | 479 | ||
| References | 479 | ||
| Further Reading | 480 | ||
| Web Resources | 480 | ||
| Chapter 11 Big Data and Analytics | 481 | ||
| Learning Objectives | 481 | ||
| Introduction | 481 | ||
| Big Data | 483 | ||
| NoSQL | 485 | ||
| Analytics | 496 | ||
| Impact of Big Data and Analytics | 512 | ||
| Implications of Big Data Analytics and Decision Making | 514 | ||
| Summary | 516 | ||
| Key Terms | 517 | ||
| Review Questions | 517 | ||
| Problems and Exercises | 518 | ||
| References | 519 | ||
| Further Reading | 520 | ||
| Web Resources | 520 | ||
| Chapter 12 Data and Database Administration | 521 | ||
| Learning Objectives | 521 | ||
| Introduction | 521 | ||
| The Roles of Data and Database Administrators | 522 | ||
| The Open Source Movement and Database Management | 528 | ||
| Managing Data Security | 530 | ||
| Database Software Data Security Features | 535 | ||
| Sarbanes-Oxley (SOX) and Databases | 541 | ||
| Database Backup and Recovery | 543 | ||
| Controlling Concurrent Access | 551 | ||
| Data Dictionaries and Repositories | 557 | ||
| Overview of Tuning the Database for Performance | 559 | ||
| Data Availability | 562 | ||
| Summary | 564 | ||
| Key Terms | 564 | ||
| Review Questions | 565 | ||
| Problems and Exercises | 566 | ||
| Field Exercises | 568 | ||
| References | 568 | ||
| Further Reading | 569 | ||
| Web Resources | 569 | ||
| Glossary of Acronyms | 570 | ||
| A | 570 | ||
| B | 570 | ||
| C | 570 | ||
| D | 570 | ||
| E | 570 | ||
| F | 570 | ||
| G | 570 | ||
| H | 570 | ||
| I | 570 | ||
| J | 571 | ||
| L | 571 | ||
| M | 571 | ||
| N | 571 | ||
| O | 571 | ||
| P | 571 | ||
| R | 571 | ||
| S | 571 | ||
| T | 571 | ||
| U | 571 | ||
| W | 571 | ||
| X | 571 | ||
| Y | 571 | ||
| Glossary of Terms | 572 | ||
| A | 572 | ||
| B | 572 | ||
| C | 572 | ||
| D | 573 | ||
| E | 574 | ||
| F | 574 | ||
| G | 575 | ||
| H | 575 | ||
| J | 575 | ||
| L | 575 | ||
| M | 576 | ||
| N | 576 | ||
| O | 576 | ||
| P | 576 | ||
| Q | 577 | ||
| R | 577 | ||
| S | 577 | ||
| T | 578 | ||
| U | 578 | ||
| V | 578 | ||
| W | 579 | ||
| X | 579 | ||
| Index | 580 | ||
| A | 580 | ||
| B | 580 | ||
| C | 581 | ||
| D | 582 | ||
| E | 585 | ||
| F | 586 | ||
| G | 587 | ||
| H | 587 | ||
| I | 587 | ||
| J | 588 | ||
| K | 588 | ||
| L | 588 | ||
| M | 588 | ||
| N | 589 | ||
| O | 589 | ||
| P | 590 | ||
| Q | 591 | ||
| R | 591 | ||
| S | 592 | ||
| T | 594 | ||
| U | 595 | ||
| V | 596 | ||
| W | 596 | ||
| X | 596 | ||
| Y | 597 | ||
| Z | 597 |