This book sheds light on the principles behind the relational model, which is fundamental to all database-backed applications--and, consequently, most of the work that goes on in the computing world today.Database in Depth: The Relational Model for Practitionersgoes beyond the hype and gets to the heart of how relational databases actually work.Ideal for experienced database developers and designers, this concise guide gives you a clear view of the technology--a view that's not influenced by any vendor or product. Featuring an extensive set of exercises, it will help you:
- understand why and how the relational model is still directly relevant to modern database technology (and will remain so for the foreseeable future)
- see why and how the SQL standard is seriously deficient
- use the best current theoretical knowledge in the design of their databases and database applications
- make informed decisions in their daily database professional activities
Database in Depthwill appeal not only to database developers and designers, but also to a diverse field of professionals and academics, including database administrators (DBAs), information modelers, database consultants, and more. Virtually everyone who deals with relational databases should have at least a passing understanding of the fundamentals of working with relational models.Author C.J. Date has been involved with the relational model from its earliest days. An exceptionally clear-thinking writer, Date lays out principle and theory in a manner that is easily understood. Few others can speak as authoritatively the topic of relational databases as Date can.
Dedicated to the memory of E.F.Codd;Foreword;Preface;What Makes This Book Different?;Further Preliminaries;Conventions Used in This Book;Using Code Examples;Safari Enabled;Comments and Questions;Acknowledgments;Chapter One: Introduction;1.1 A Remark on Terminology;1.2 Principles, Not Products;1.lƒe