Database Systems: Design, Implementation, & Management. 14 Ed

Cover....1 Dedication....5 Brief Contents....6 Contents....8 About the Authors....15 Preface....16 Text Features....22 Additional Features....24 Acknowledgments....26 Part 1: Database Concepts....30 Chapter 1: Database Systems....31 1-1 Why Databases?....32 1-2 Data versus Information....33 1-3 Introducing the Database....36 1-4 Why Database Design Is Important....40 1-5 Evolution of File System Data Processing....43 1-6 Problems with File System Data Processing....46 1-7 Database Systems....49 1-8 Preparing for Your Database Professional Career....56 Summary....57 Key Terms....57 Review Questions....58 Problems....59 Chapter 2: Data Models....61 2-1 Data Modeling and Data Models....62 2-2 The Importance of Data Models....63 2-3 Data Model Basic Building Blocks....64 2-4 Business Rules....65 2-5 The Evolution of Data Models....67 2-6 Degrees of Data Abstraction....80 Summary....87 Key Terms....88 Review Questions....88 Problems....89 Part 2: Design Concepts....92 Chapter 3: The Relational Database Model....93 3-1 A Logical View of Data....95 3-2 Keys....97 3-3 Integrity Rules....101 3-4 Relational Algebra....103 3-5 The Data Dictionary and the System Catalog....112 3-6 Relationships within the Relational Database....114 3-7 Data Redundancy Revisited....122 3-8 Indexes....124 3-9 Codd's Relational Database Rules....126 Summary....126 Key Terms....127 Review Questions....127 Problems....130 Chapter 4: Entity Relationship (ER) Modeling....136 4-1 The Entity Relationship Model....137 4-2 Developing an ER Diagram....162 4-3 Database Design Challenges: Conflicting Goals....170 Summary....174 Key Terms....175 Review Questions....175 Problems....177 Cases....183 Chapter 5: Advanced Data Modeling....190 5-1 The Extended Entity Relationship Model....191 5-2 Entity Clustering....198 5-3 Entity Integrity: Selecting Primary Keys....199 5-4 Design Cases: Learning Flexible Database Design....203 Summary....210 Key Terms....210 Review Questions....210 Problems....211 Cases....213 Chapter 6: Normalization of Database Tables....220 6-1 Database Tables and Normalization....221 6-2 The Need for Normalization....222 6-3 The Normalization Process....225 6-4 Improving the Design....234 6-5 Surrogate Key Considerations....238 6-6 Higher-Level Normal Forms....240 6-7 Normalization and Database Design....246 6-8 Denormalization....250 6-9 Data-Modeling Checklist....253 Summary....255 Key Terms....255 Review Questions....256 Problems....257 Part 3: Advanced Design and Implementation....266 Chapter 7: Introduction to Structured Query Language (SQL)....267 7-1 SQL Basics....268 7-2 Basic SELECT Queries....272 7-3 SELECT Statement Options....273 7-4 FROM Clause Options....279 7-5 ORDER BY Clause Options....280 7-6 WHERE Clause Options....282 7-7 JOIN Operations....292 7-8 Aggregate Processing....305 7-9 Subqueries....314 7-10 SQL Functions....324 7-11 Relational Set Operators....332 7-12 Crafting SELECT Queries....338 Summary....340 Key Terms....341 Review Questions....342 Problems....343 Chapter 8: Advanced SQL....379 8-1 Data Definition Commands....380 8-2 Creating Table Structures....386 8-3 Altering Table Structures....395 8-4 Data Manipulation Commands....398 8-5 Virtual Tables: Creating a View....406 8-6 Auto Increment, Identity, and Sequences....409 8-7 Procedural SQL....415 8-8 Embedded SQL....440 Summary....445 Key Terms....446 Review Questions....446 Problems....446 Cases....453 Chapter 9: Database Design....459 9-1 The Information System....460 9-2 The Systems Development Life Cycle....462 9-3 The Database Life Cycle....465 9-4 Conceptual Design....476 9-5 DBMS Software Selection....486 9-6 Logical Design....487 9-7 Physical Design....490 9-8 Database Design Strategies....492 9-9 Centralized versus Decentralized Design....493 Summary....496 Key Terms....496 Review Questions....496 Problems....497 Part 4: Advanced Database Concepts....500 Chapter 10: Transaction Management and Concurrency Control....501 10-1 What Is a Transaction?....502 10-2 Concurrency Control....509 10-3 Concurrency Control with Locking Methods....514 10-4 Concurrency Control with Time Stamping Methods....520 10-5 Concurrency Control with Optimistic Methods....522 10-6 ANSI Levels of Transaction Isolation....522 10-7 Database Recovery Management....524 Summary....529 Key Terms....529 Review Questions....530 Problems....530 Chapter 11: Database Performance Tuning and Query Optimization....534 11-1 Database Performance-Tuning Concepts....535 11-2 Query Processing....541 11-3 Indexes and Query Optimization....544 11-4 Optimizer Choices....546 11-5 SQL Performance Tuning....549 11-6 Query Formulation....552 11-7 DBMS Performance Tuning....553 11-8 Query Optimization Example....555 Summary....561 Key Terms....562 Review Questions....562 Problems....563 Chapter 12: Distributed Database Management Systems....567 12-1 The Evolution of Distributed Database Management Systems....568 12-2 DDBMS Advantages and Disadvantages....570 12-3 Distributed Processing and Distributed Databases....571 12-4 Characteristics of Distributed Database Management Systems....573 12-5 DDBMS Components....574 12-6 Levels of Data and Process Distribution....575 12-7 Distributed Database Transparency Features....578 12-8 Distribution Transparency....579 12-9 Transaction Transparency....581 12-10 Performance and Failure Transparency....586 12-11 Distributed Database Design....587 12-12 The CAP Theorem....593 12-13 C. J. Date's 12 Commandments for Distributed Databases....595 Summary....596 Key Terms....596 Review Questions....597 Problems....598 Chapter 13: Business Intelligence and Data Warehouses....601 13-1 The Need for Data Analysis....602 13-2 Business Intelligence....602 13-3 Decision Support Data....611 13-4 The Data Warehouse....616 13-5 Star Schemas....620 13-6 Online Analytical Processing....630 13-7 Data Analytics....638 13-8 SQL Analytic Functions....642 13-9 Data Visualization....649 13-10 Data Lake....655 Summary....656 Key Terms....656 Review Questions....657 Problems....658 Chapter 14: Big Data and NoSQL....668 14-1 Big Data....669 14-2 Hadoop....675 14-3 NoSQL....682 14-4 NewSQL Databases....690 14-5 Working with Document Databases Using MongoDB....691 14-6 Working with Graph Databases Using Neo4j....694 Summary....698 Key Terms....700 Review Questions....701 Part 5: Databases and the Internet....702 Chapter 15: Database Connectivity and Web Technologies....703 15-1 Database Connectivity....704 15-2 Database Internet Connectivity....714 15-3 Extensible Markup Language (XML)....724 15-4 Cloud Computing Services....731 Summary....738 Key Terms....739 Review Questions....740 Problems....741 Part 6: Database Administration....742 Chapter 16: Database Administration and Security....743 16-1 Data as a Corporate Asset....744 16-2 The Need for a Database and Its Role in an Organization....746 16-3 Introduction of a Database: Special Considerations....747 16-4 The Evolution of Database Administration....749 16-5 The Database Environment's Human Component....752 16-6 Security....765 16-7 Database Administration Tools....769 16-8 Developing a Data Administration Strategy....774 16-9 The DBA's Role in the Cloud....776 16-10 The DBA at Work: Using Oracle for Database Administration....777 Summary....785 Key Terms....786 Review Questions....786 Glossary....788 Index....803