Database Systems provides a comprehensive introduction to database theory, design, implementation, and management for technical and nontechnical readers. Using an integrated case study, it develops a practical methodology for relational DBMS design while also covering SQL, transaction management, query processing, security, administration, legal and ethical issues, and compliance.
The 7th Edition adds substantial new and updated coverage of distributed DBMSs; mobile and replicated DBMSs; object-relational and object-oriented systems; web, cloud, and microservices architectures; NoSQL, multimodel, and NewSQL DBMSs; and data warehousing.
Introduction to Databases
Database Environment
Database Architectures and Cloud Computing
The Relational Model
Relational Algebra and Relational Calculus
SQL: Data Manipulation
SQL: Data Definition
Advanced SQL
Database System Development Lifecycle
Database Analysis and the DreamHome Case Study
Entity-Relationship Modeling
Enhanced Entity-Relationship Modeling
Normalization
Advanced Normalization
Methodology-Conceptual Database Design
Methodology-Logical Database Design for the Relational Model
Methodology-Physical Database Design for Relational Databases
Methodology-Monitoring and Tuning the Operational System
Security and Administration
Professional, Legal, and Ethical Issues in Data Management
Transaction Management
Query Processing
Distributed DBMSs-Concepts and Design
Distributed DBMSs-Advanced Concepts
Replication and Mobile DBMSs
The Web, Cloud, and Microservices
Modern Frameworks in Database-Driven Development
Object-Relational DBMSs
Object-Oriented DBMSs
NoSQL, Multimodel, and NewSQL DBMSs
Data Warehousing Concepts
Data Warehousing Design
OLAP
Data Mining
APPENDICES
A. Users' Requirements Specification for DreamHome Case Study
B. Other Case Studies
C. Alternative ER Modeling Notations
D. Summary of the Database Design Methodology for Relational Databases
E. File Organizations and Indexes
F. When Is a DBMS Relational? (Online)
G. Estimating Disk Space Requirements (Online)
H. Introduction to Object-Oriented Concepts (Online)
