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 5: Query Processing and Performance
Chapter 6: Transaction Management
Chapter 7: Transactions and the Database Recovery
Leave a Reply