Keys, Foreign Keys, and Relational Theory
“Keys, Foreign Keys, and Relational Theory” by Chris Date, published by Technics Publications on August 21, 2023, offers an in-depth exploration of the essential concepts of keys and foreign keys in relational databases. This 292-page edition delves into how these elements identify objects of interest and connect them within a database framework. The book addresses the complexities surrounding these concepts, which may not be as straightforward as they initially appear, providing clarity on their historical development and theoretical underpinnings.
Readers will find a thorough examination of the key and foreign key concepts, including a critical review of their evolution and practical implications in relational database management. The book features case studies related to the SQL standard and IBM DB2, enhancing the understanding of these critical topics in database administration and data modeling. This edition serves as a valuable resource for professionals in the fields of data science and database management, offering insights that are crucial for effective data warehousing and design.
Official synopsis Publisher
Keys and foreign keys play a crucial role in relational databases-keys identify the objects of interest, and foreign keys knit those objects together. The basic idea couldn’t be simpler. As so often, however, the devil is in the detail … The fact is, these concepts aren’t quite as straightforward as they might seem on first acquaintance-or, at least, such would appear to be the case, if the literature is anything to go by. In this one of a kind book, noted database author C. J. Date traces the somewhat checkered history of the key and foreign key concepts, shedding some light on what turns out to be, on occasion, a surprisingly murky subject and explaining in detail what proper support should look like in true relational products. Topics covered include a detailed look at the pertinent theory; a critical review of the historical development of these ideas; and a couple of important case studies, one having to do with the SQL standard and one with the IBM DB2 product family. No serious database professional can afford to be without this book.
Publisher
Topics
FAQ
What is “Keys, Foreign Keys, and Relational Theory” about?
Who is the author of “Keys, Foreign Keys, and Relational Theory”?
When was “Keys, Foreign Keys, and Relational Theory” published?
What is the ISBN for “Keys, Foreign Keys, and Relational Theory”?
What are the book details (language, pages, edition)?
