Relational Database Systems

This book presents a structured introduction to relational databases, progressing from the relational model, relational algebra, and SQL to database design and normalization, physical storage and indexing, query processing and optimization, transactions, concurrency control, security, and distributed and parallel databases. It also examines analytical and procedural SQL and the management of JSON, XML, spatial, textual, vector, and graph data within modern relational systems.

Relational databases remain central to reliable data management, but contemporary applications increasingly combine structured data with heterogeneous formats and advanced search requirements. This book explains how established relational principles can support these workloads while preserving data integrity, performance, security, and maintainability.

Designed as both a learning resource and a practical reference, this book is intended for undergraduate and graduate students, instructors, software developers, database administrators, data engineers, analysts, and researchers. Its combination of theoretical foundations, design reasoning, and executable SQL helps readers progress from fundamental concepts to the implementation and evaluation of modern database solutions.