C. J. Date

Relational Theory for Computer Professionals (eBook, PDF)

What Relational Databases Are Really All About

• Format: PDF

Produktbeschreibung

All of todays mainstream database products support the SQL language, and relational theory is what SQL is supposed to be based on. But are those products truly relational? Sadly, the answer is no. This book shows you what a real relational product would be like, and how and why it would be so much better than whats currently available.With this unique book, you will:Learn how to see database systems as programming systemsGet a careful, precise, and detailed definition of the relational modelExplore a detailed analysis of SQL from a relational point of viewThere are literally hundreds of books on relational theory or the SQL language or both. But this one is different. First, nobody is more qualified than Chris Date to write such a book. He and Ted Codd, inventor of the relational model, were colleagues for many years, and Chriss involvement with the technology goes back to the time of Codds first papers in 1969 and 1970. Second, most books try to use SQL as a vehicle for teaching relational theory, but this book deliberately takes the opposite approach. Its primary aim is to teach relational theory as such. Then it uses that theory as a vehicle for teaching SQL, showing in particular how that theory can help with the practical problem of using SQL correctly and productively.Any computer professional who wants to understand what relational systems are all about can benefit from this book. No prior knowledge of databases is assumed.

---

Dieser Download kann aus rechtlichen Gründen nur mit Rechnungsadresse in A, B, BG, CY, CZ, D, DK, EW, E, FIN, F, GR, HR, H, IRL, I, LT, L, LR, M, NL, PL, P, R, S, SLO, SK ausgeliefert werden.

Produktdetails

• Verlag: O'Reilly Media
• Seitenzahl: 284
• Erscheinungstermin: 21. Mai 2013
• Englisch
• ISBN-13: 9781449369460
• Artikelnr.: 39270833

Autorenporträt

Chris Date has a stature in the database industry that's unique. He enjoys a reputation that's second to none for his ability to explain complex technical issues in a clear and understandable fashion. His previous books for O'Reilly include SQL and Relational Theory (2nd edition); Database Design and Relational Theory; and View Updating and Relational Theory. The present book serves as an introduction to those previous ones.

Inhaltsangabe

1.
2.  
3. About the Author
4. Preface
5. Foundations
* Chapter 1: Basic Database Concepts
* Chapter 2: Relations and Relvars
* Chapter 3: Keys, Foreign Keys, and Related Matters
* Chapter 4: Relational Operators I
* Chapter 5: Relational Operators II
* Chapter 6: Constraints and Predicates
* Chapter 7: The Relational Model
6. Transactions and Database Design
* Chapter 8: Transactions
* Chapter 9: Database Design
7. SQL
* Chapter 10: SQL Tables
* Chapter 11: SQL Operators I
* Chapter 12: SQL Operators II
* Chapter 13: SQL Constraints
* Chapter 14: SQL vs. the Relational Model
8. Appendixes
* A Tutorial D Grammar
* TABLE_DUM and TABLE_DEE
* Set Theory
* Relational Calculus
* A Guide to Further Reading