Fundamentals of Database Management Systems

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 xixAbout The Author xxiii1 Data: The New Corporate Resource 12 Data Modeling 163 The Database Management System Concept 364 Relational Data Retrieval: SQL 595 The Relational Database Model: Introduction 956 The Relational Database Model: Additional Concepts 1277 Logical Database Design 1458 Physical Database Design 1859 Object-Oriented Database Management 22910 Data Administration, Database Administration, and Data Dictionaries 24811 Database Control Issues: Security, Backup and Recovery, Concurrency 26812 The Data Warehouse 28913 NoSQL Database Management 31914 Blockchain 34115 Database in the Cloud 35216 Database Applications 363Index I-1