This book provides a detailed coverage of various database concepts and models, and also covers emerging technologies in the field.
Summary of The Book
The book begins with the basics and then takes the reader into an exploration of the different concepts, methodologies, and models involved in Database Systems.
The book is divided into eight parts. The first part covers the basic concepts like databases and users, database system architecture, data modeling methodologies like entity relationship (ER), and the enhanced entity relationship (EER) models.
The second chapter goes deep into the concepts of relational databases such as relational models and constraints, relational algebra and calculus, RDBMS design by using ER and EER to relational mapping, and SQL programming.
Part three examines database theory and methodologies such as functional dependencies and normalization, design algorithms, practical database design methodologies, and the use of UML diagrams.The next chapter looks at data storage, physical design, indexing, and query processing.
Part five deals with transaction processing concepts and applications like introduction to the concepts of transaction processing, concurrency control, and database recovery techniques. Part six examines object database models. It begins with an introduction to object oriented techniques, object database standards, languages and design, and object-relational and extended-relational databases.
The next part deals with security, advanced modeling, and distribution. After this, an overview of many recent database related technologies is given, like web database programming (using PHP), XML, data mining concepts, data warehousing, and OLAP. It also introduces some emerging database technologies and applications like mobile and multimedia databases, Geographical Information Systems (GIS), and genome data management.
Each chapter ends with a summary, review questions, exercises, and selected bibliography relevant to that chapter. There are a total of five appendices for the book. The first three are in the book, and the last two are available in the book’s companion website.
The Appendices are Alternative Diagrammatic Notations for ER models, parameters of disks, and an overview of the query by example (QBE) language. Appendix D provides an overview of the hierarchical model and Appendix E introduces the concepts of the network data model.
About the Authors
Dr. Ramez Elmasri has many years of teaching and research experience. He is the Professor of Computer Science and Engineering at the University of Texas.
Other books by Elmasri include Fundamentals of Database Systems/Oracle 9i Programming, and Operating Systems: A Spiral Approach.
He has been with the faculty of the University of Texas since 1994. Previously, he was an associate professor at the University of Houston.
Before that he had held several academic, research, and consultancy positions. He received his B.S degree in electrical engineering from the University of Alexandria, Egypt. He obtained his M.S. and doctorate in computer science from Stanford University.
Shamkant B. Navathe is a research scholar in the field of database systems. He is currently a professor at the College of Computing, Georgia Institute of Technology.
Navathe has also authored and co-authored other books like Conceptual Database Design: An Entity-Relationship Approach, and Business Intelligence for the Real-Time Enterprises, First International Workshop.
He graduated with a degree in Electrical Communications Engineering from the Indian Institute of Science (IISc). He did his M.S. at the Ohio State University, and received his doctorate from the University of Michigan. He founded the Research Group in Database Systems at the college and has been at Georgia Tech since 1990.
|Book Full Name||Fundamentals of Database Systems|
|Author Name||Ramez Elmasri and Shanmkanth B. Navathe|