Fundamentals of Database Management Systems

In the newly revised third edition of Fundamentals of Database Management Systems, veteran database expert Dr. Mark Gillenson delivers an authoritative and comprehensive account of contemporary database management. The Third Edition assists readers in understanding critical topics in the subject, including data modeling, relational database concepts, logical and physical database design, SQL, data administration, data security, NoSQL, blockchain, database in the cloud, and more.

The author offers a firm grounding in the fundamentals of database while, at the same time, providing a wide-ranging survey of database subfields relevant to information systems professionals. And, now included in the supplements, the author's audio narration of the included PowerPoint slides! Readers will also find:

• Brand-new content on NoSQL database management, NewSQL, blockchain, and database-intensive applications, including data analytics, ERP, CRM, and SCM
• Updated and revised narrative material designed to offer a friendly introduction to database management
• Renewed coverage of cloud-based database management
• Extensive updates to incorporate the transition from rotating disk secondary storage to solid state drives

Dr. Mark L. Gillenson has been practicing, researching, teaching, writing, and, most importantly, thinking, about data and database management for over 50 years, split between working for the IBM Corporation and being a professor in the academic world. While working for IBM he designed databases for IBM's corporate headquarters, consulted on database issues for some of IBM's largest customers, taught database management at the prestigious IBM Systems Research Institute in New York, and conducted database seminars throughout the United States and on four continents. In one such seminar, he taught introduction to database to an IBM development group that went on to develop IBM’s first relational database management system products, SQL/DS.
Dr. Gillenson conducted some of the earliest studies on data and database administration and has written extensively about that subject as well as about database design. He is an associate editor of the Journal of Database Management, with which he has been associated since its inception. This is the third edition of his third book on database management, all published by John Wiley & Sons, Inc. Dr. Gillenson is currently University Research Professor in the Fogelman College of Business and Economics of The University of Memphis. He is also the Director of the UofM's Systems Testing Excellence Program (STEP). His degrees are from Rensselaer Polytechnic Institute and The Ohio State University.
Oh, and speaking of interesting kinds of data, as a graduate student Dr. Gillenson invented the world’s first computerized facial compositor and codeveloped an early computer graphics system that, among other things, was used to produce some of the special effects in the first Star Wars movie.

Preface xix

About The Author xxiii

1 Data: The New Corporate Resource 1

2 Data Modeling 16

3 The Database Management System Concept 36

4 Relational Data Retrieval: SQL 59

5 The Relational Database Model: Introduction 95

6 The Relational Database Model: Additional Concepts 127

7 Logical Database Design 145

8 Physical Database Design 185

9 Object-Oriented Database Management 229

10 Data Administration, Database Administration, and Data Dictionaries 248

11 Database Control Issues: Security, Backup and Recovery, Concurrency 268

12 The Data Warehouse 289

13 NoSQL Database Management 319

14 Blockchain 341

15 Database in the Cloud 352

16 Database Applications 363

Index I-1

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.