Fundamentals of Database Systems, 4th Edition
'Fundamentals of Database Systems 4th Edition' is the definitive reference for understanding database architecture, relational design theory, and enterprise data management. Covering both theoretical conceptual foundations and practical database engineering, this volume serves as the core curriculum text for computer science students.
Key topics include Entity-Relationship (ER/EER) data modeling, relational algebra, SQL querying and schema definitions, functional dependencies, normalization (1NF through BCNF), indexing structures (B+ trees and hashing), query optimization, transaction management (ACID properties), concurrency control, and crash recovery.
A must-read for database administrators, backend software engineers, and systems architects responsible for designing reliable, high-concurrency database systems.
Key topics include Entity-Relationship (ER/EER) data modeling, relational algebra, SQL querying and schema definitions, functional dependencies, normalization (1NF through BCNF), indexing structures (B+ trees and hashing), query optimization, transaction management (ACID properties), concurrency control, and crash recovery.
A must-read for database administrators, backend software engineers, and systems architects responsible for designing reliable, high-concurrency database systems.
Contents at a Glance
Chapter 1: Databases and Database Users: Concepts and Architecture
Chapter 2: Conceptual Data Modeling Using the Entity-Relationship (ER) Model
Chapter 3: Enhanced Entity-Relationship (EER) and Object Modeling
Chapter 4: The Relational Data Model and Relational Database Constraints
Chapter 5: Relational Algebra and Relational Calculus
Chapter 6: SQL: Schema Definition, Constraints, Queries, and Views
Chapter 7: Advanced SQL: Triggers, Stored Procedures, and Embedded SQL
Chapter 8: Database Design Theory and Functional Dependencies
Chapter 9: Normalization Algorithms: 1NF, 2NF, 3NF, BCNF, and 4NF
Chapter 10: Indexing Structures: Primary, Secondary, Multilevel, and B+ Trees
Chapter 11: Query Processing and Optimization Strategies
Chapter 12: Transaction Processing Concepts and ACID Properties
Chapter 13: Concurrency Control Techniques: Locking, Timestamp, and Optimistic
Chapter 14: Database Recovery Techniques and Fault Tolerance
Index & Further Reading
Chapter 1: Databases and Database Users: Concepts and Architecture
Chapter 2: Conceptual Data Modeling Using the Entity-Relationship (ER) Model
Chapter 3: Enhanced Entity-Relationship (EER) and Object Modeling
Chapter 4: The Relational Data Model and Relational Database Constraints
Chapter 5: Relational Algebra and Relational Calculus
Chapter 6: SQL: Schema Definition, Constraints, Queries, and Views
Chapter 7: Advanced SQL: Triggers, Stored Procedures, and Embedded SQL
Chapter 8: Database Design Theory and Functional Dependencies
Chapter 9: Normalization Algorithms: 1NF, 2NF, 3NF, BCNF, and 4NF
Chapter 10: Indexing Structures: Primary, Secondary, Multilevel, and B+ Trees
Chapter 11: Query Processing and Optimization Strategies
Chapter 12: Transaction Processing Concepts and ACID Properties
Chapter 13: Concurrency Control Techniques: Locking, Timestamp, and Optimistic
Chapter 14: Database Recovery Techniques and Fault Tolerance
Index & Further Reading
