Preface
Part 1: Introduction to Database Environments
Chapter 1: Introduction to Database Management
1.1 Database Characteristics
1.2 Features of Database Management Systems
1.3 Development of Database Technology and Market Structure
1.4 Architectures of Database Management Systems
1.5 Organizational Impacts of Database Technology
References for Further Study
Chapter 2: Introduction to Database Development
2.2 Goals of Database Development
2.3 Database Development Process
2.4 Tools for Database Development
References for Further Study
Part 2: Defining and Using SQL Databases
Chapter 3: The Relational Data Model in the SQL Standard
3.3 Operators of Relational Algebra
References for Further Study
Appendix 3.A: CREATE TABLE Statements for the University Database Tables
Appendix 3.B: SQL Syntax Summary
Appendix 3.C: Generation of Unique Values for Primary Keys
Chapter 4: Basic Query Formulation with SQL
4.2 Simplified Syntax and University Database
4.3 SELECT Statement Examples for Single Table Problems
4.4 SELECT Statement Examples for Joins, Grouping, and Ordering
4.5 Conceptual Evaluation Process for SELECT Statements
4.6 Traditional Set Operators and Modification Statements
References for Further Study
Appendix 4.A: SQL Syntax Summary
Appendix 4.B: Syntax Differences among Major DBMS Products
Appendix 4.C: NL2SQL for Chapter 4 Examples
Chapter 5: Intermediate Query Formulation with SQL
5.1 Problem Solving Guidelines for Query Formulation
5.2 Join Examples for Typical Join Patterns
5.3 Atypical Join Patterns
5.4 Errors, Coding Practices, and Refinements to the Query Formulation Process
References for Further Study
Appendix 5.A: SQL Syntax Summary
Appendix 5.B: University Database Tables
Appendix 5.C: Oracle Syntax Errors on Self-Join Problems
Appendix 5.D: NL2SQL for Chapter 5 Examples
Part 3: Data Modeling
Chapter 6: Understanding Entity Relationship Diagrams
6.1 Introduction to Entity Relationship Diagrams
6.2 Understanding Relationships
6.3 Classification in the Entity Relationship Model
6.4 Notation Summary and Diagram Rules
6.5 Comparison to Other Notations
References for Further Study
Chapter 7: Developing Data Models for Business Databases
7.1 Analyzing Business Data Modeling Problems
7.2 Refinements to an ERD
7.4 Converting an ERD to a Table Design
References for Further Study
Part 4: SQL Database Design
Chapter 8: Normalization Concepts and Processes
8.1 Overview of Relational Database Design
8.3 Refining M-Way Relationships
8.4 Higher Level Normal Forms
8.5 Practical Concerns about Normalization
References for Further Study
Chapter 9: Physical Database Design
9.1 Overview of Physical Database Design
9.2 Inputs of Physical Database Design
9.6 Additional Choices in Physical Database Design
References for Further Study
Part 5: Advanced Query Formulation
Chapter 10: Advanced Matching Problems with SQL
10.3 Membership Exceptions based on the Difference Operator
10.4 Containment Exceptions Based on the Division Operator
10.5 Summary and Common Table Expressions
References for Further Study
Appendix 10.A: SQL Syntax Summary
Appendix 10.B: NL2SQL for Chapter 10 Examples
Chapter 11: Derived Tables, Null Values, and Hierarchical Queries
11.1 Background for Views
11.2 Using Views for Retrieval and Update
11.4 Null Value Considerations
11.5 Hierarchical Queries
References for Further Study
Appendix 11.A: SQL Syntax Summary
Appendix 11.B: SQL Statements for the Employee2 Table
Appendix 11.C: Null-Aware Query Practices
Appendix 11.D: NL2SQL for Chapter 11 Examples
Chapter 12: Stored Procedures and Triggers
12.1 Database Programming Languages and PL/SQL
References for Further Study
Appendix 12.A: SQL Syntax Summary
Appendix 12.B: PostgreSQL Triggers and Trigger Functions
Appendix 12.C: NL2SQL for Chapter 12 Trigger Examples
Part 6: Data Warehouse Processing
Chapter 13: Data Warehouse Concepts and Management
13.2 Management of Data Warehouse Development
13.2 Management of Data Warehouse Development
13.3 Data Warehouse Examples
References for Further Study
Chapter 14: Conceptual Design of Data Warehouses
14.1 Multidimensional Representation of Data
14.2 SQL Data Modeling Patterns for Data Warehouses
14.3 Summarizability Problems and Patterns
14.4 Schema Integration and Design Methodologies
Practice Mini Case Study for Schema Integration
References for Further Study
Appendix 14.A: Details of the Schema Integration Problem
Appendix 14.B: Solution for the Schema Integration Problem
Chapter 15: Data Integration Concepts, Practices, and Emerging Alternatives
15.1 Data Integration Concepts
15.2 Data Cleaning Techniques
15.3 Data Integration Tools
15.4 Data Integration for Data Lakes
References for Further Study
Appendix 15.A: CREATE TABLE Statements for Section 15.3.5
Appendix 15.B: CREATE TABLE Statements for Chapter Problems
Chapter 16: Query Formulation for Data Warehouses and Data Lakes
16.1 SQL Extensions for Subtotal Operators
16.2 SQL Extensions for Analytic Functions
16.3 Query Formulation to Generate Data Mining Input
References for Further Study
Appendix 16.A: Data Warehouse Examples for Section 16.3
Appendix 16.B: NL2SQL for Chapter 16 Examples
Part 7 Managing Database Environments
Chapter 17: Data and Database Administration
17.1 Organizational Context for Managing Databases
17.2 Tools of Database Administration
17.3 Processes for Database Specialists
17.4 Managing Database Environments
References for Further Study
Appendix 17.A: SQL Syntax Summary
Chapter 18: Transaction Management
18.1 Basics of Database Transactions
18.4 Transaction Design Issues and Examples
18.5 Tools for Transaction Design
References for Further Study
Appendix 18.A: SQL Syntax Summary
Chapter 19: Distributed Processing, Parallel Database Processing, and Distributed Databases
19.1 Overview of Distributed Processing and Distributed Data
19.2 Database Architectures for Distributed Processing
19.3 Parallel Database Processing
19.4 Architectures for Distributed Database Management Systems
19.5 Transparency for Distributed Database Processing
19.6 Distributed Database Processing
References for Further Study
Chapter 20: DBMS Extensions for Object-Relational and NoSQL Databases
20.1 Motivation for Object Database Management
20.2 Object-Relational Features in the SQL Standard
20.3 Object-Relational Features in Oracle
20.4 Overview of NoSQL Database Management
20.5 Database Definition and Manipulation with Couchbase N1QL
References for Further Study
Appendix 20.A: INSERT Statements for N1QL
Appendix 20.B: Object-Relational Features in PostgreSQL
Glossary of Terms
Bibliography
