OER Textbook

Title: Esssential Aspects of Physical Design and Implementation of Relational Databases
by Tatiana Malyuta, Ashwin Satyanarayana

Abstract: The Essential Aspects of Physical Implementation and Design of Relational Databases discusses the physical design and implementation of relational databases — the two phases in building of databases that often do not get enough attention in textbooks on database design and management. The goal of this book is to give students a solid foundation on how to combine data design and the functionality of today’s DBMS to achieve the most effective database and database applications. It provides illustration of essential aspects of physical design and implementation of relational databases with simple examples of real-world business problems. The book includes coverage of Physical Design, Distributed Database Design, Database Security, Database Query Processing and Performance, Transaction Management and Database Recovery. The book is based on the database program taught at the New York City College of Technology.


The Table of Contents and OER links for all the chapters are below:

Chapter 1: User Requirements and Relational Databases

Chapter 2: The Physical Data Model

Chapter 3: Distributed Database Design

Chapter 4: Security

Chapter 5: Query Processing and Performance

Chapter 6: Transaction Management

Chapter 7: Transactions and the Database Recovery 

Appendix (1-6)