Database Systems: Design, Implementation, & Management

Cover
Dedication
Brief Contents
Contents
About the Authors
Preface
Text Features
Additional Features
Acknowledgments
Part 1: Database Concepts
Chapter 1: Database Systems
1-1 Why Databases?
1-2 Data versus Information
1-3 Introducing the Database
1-4 Why Database Design Is Important
1-5 Evolution of File System Data Processing
1-6 Problems with File System Data Processing
1-7 Database Systems
1-8 Preparing for Your Database Professional Career
Summary
Key Terms
Review Questions
Problems
Chapter 2: Data Models
2-1 Data Modeling and Data Models
2-2 The Importance of Data Models
2-3 Data Model Basic Building Blocks
2-4 Business Rules
2-5 The Evolution of Data Models
2-6 Degrees of Data Abstraction
Summary
Key Terms
Review Questions
Problems
Part 2: Design Concepts
Chapter 3: The Relational Database Model
3-1 A Logical View of Data
3-2 Keys
3-3 Integrity Rules
3-4 Relational Algebra
3-5 The Data Dictionary and the System Catalog
3-6 Relationships within the Relational Database
3-7 Data Redundancy Revisited
3-8 Indexes
3-9 Codd's Relational Database Rules
Summary
Key Terms
Review Questions
Problems
Chapter 4: Entity Relationship (ER) Modeling
4-1 The Entity Relationship Model
4-2 Developing an ER Diagram
4-3 Database Design Challenges: Conflicting Goals
Summary
Key Terms
Review Questions
Problems
Cases
Chapter 5: Advanced Data Modeling
5-1 The Extended Entity Relationship Model
5-2 Entity Clustering
5-3 Entity Integrity: Selecting Primary Keys
5-4 Design Cases: Learning Flexible Database Design
Summary
Key Terms
Review Questions
Problems
Cases
Chapter 6: Normalization of Database Tables
6-1 Database Tables and Normalization
6-2 The Need for Normalization
6-3 The Normalization Process
6-4 Improving the Design
6-5 Surrogate Key Considerations
6-6 Higher-Level Normal Forms
6-7 Normalization and Database Design
6-8 Denormalization
6-9 Data-Modeling Checklist
Summary
Key Terms
Review Questions
Problems
Part 3: Advanced Design and Implementation
Chapter 7: Introduction to Structured Query Language (SQL)
7-1 SQL Basics
7-2 Basic SELECT Queries
7-3 SELECT Statement Options
7-4 FROM Clause Options
7-5 ORDER BY Clause Options
7-6 WHERE Clause Options
7-7 JOIN Operations
7-8 Aggregate Processing
7-9 Subqueries
7-10 SQL Functions
7-11 Relational Set Operators
7-12 Crafting SELECT Queries
Summary
Key Terms
Review Questions
Problems
Chapter 8: Advanced SQL
8-1 Data Definition Commands
8-2 Creating Table Structures
8-3 Altering Table Structures
8-4 Data Manipulation Commands
8-5 Virtual Tables: Creating a View
8-6 Auto Increment, Identity, and Sequences
8-7 Procedural SQL
8-8 Embedded SQL
Summary
Key Terms
Review Questions
Problems
Cases
Chapter 9: Database Design
9-1 The Information System
9-2 The Systems Development Life Cycle
9-3 The Database Life Cycle
9-4 Conceptual Design
9-5 DBMS Software Selection
9-6 Logical Design
9-7 Physical Design
9-8 Database Design Strategies
9-9 Centralized versus Decentralized Design
Summary
Key Terms
Review Questions
Problems
Part 4: Advanced Database Concepts
Chapter 10: Transaction Management and Concurrency Control
10-1 What Is a Transaction?
10-2 Concurrency Control
10-3 Concurrency Control with Locking Methods
10-4 Concurrency Control with Time Stamping Methods
10-5 Concurrency Control with Optimistic Methods
10-6 ANSI Levels of Transaction Isolation
10-7 Database Recovery Management
Summary
Key Terms
Review Questions
Problems
Chapter 11: Database Performance Tuning and Query Optimization
11-1 Database Performance-Tuning Concepts
11-2 Query Processing
11-3 Indexes and Query Optimization
11-4 Optimizer Choices
11-5 SQL Performance Tuning
11-6 Query Formulation
11-7 DBMS Performance Tuning
11-8 Query Optimization Example
Summary
Key Terms
Review Questions
Problems
Chapter 12: Distributed Database Management Systems
12-1 The Evolution of Distributed Database Management Systems
12-2 DDBMS Advantages and Disadvantages
12-3 Distributed Processing and Distributed Databases
12-4 Characteristics of Distributed Database Management Systems
12-5 DDBMS Components
12-6 Levels of Data and Process Distribution
12-7 Distributed Database Transparency Features
12-8 Distribution Transparency
12-9 Transaction Transparency
12-10 Performance and Failure Transparency
12-11 Distributed Database Design
12-12 The CAP Theorem
12-13 C. J. Date's 12 Commandments for Distributed Databases
Summary
Key Terms
Review Questions
Problems
Chapter 13: Business Intelligence and Data Warehouses
13-1 The Need for Data Analysis
13-2 Business Intelligence
13-3 Decision Support Data
13-4 The Data Warehouse
13-5 Star Schemas
13-6 Online Analytical Processing
13-7 Data Analytics
13-8 SQL Analytic Functions
13-9 Data Visualization
13-10 Data Lake
Summary
Key Terms
Review Questions
Problems
Chapter 14: Big Data and NoSQL
14-1 Big Data
14-2 Hadoop
14-3 NoSQL
14-4 NewSQL Databases
14-5 Working with Document Databases Using MongoDB
14-6 Working with Graph Databases Using Neo4j
Summary
Key Terms
Review Questions
Part 5: Databases and the Internet
Chapter 15: Database Connectivity and Web Technologies
15-1 Database Connectivity
15-2 Database Internet Connectivity
15-3 Extensible Markup Language (XML)
15-4 Cloud Computing Services
Summary
Key Terms
Review Questions
Problems
Part 6: Database Administration
Chapter 16: Database Administration and Security
16-1 Data as a Corporate Asset
16-2 The Need for a Database and Its Role in an Organization
16-3 Introduction of a Database: Special Considerations
16-4 The Evolution of Database Administration
16-5 The Database Environment's Human Component
16-6 Security
16-7 Database Administration Tools
16-8 Developing a Data Administration Strategy
16-9 The DBA's Role in the Cloud
16-10 The DBA at Work: Using Oracle for Database Administration
Summary
Key Terms
Review Questions
Glossary
Index