Database in Depth: Relational Theory for Practitioners | 
|  | | | Title: | Database in Depth: Relational Theory for Practitioners | | Author: | C.J. Date | | Publisher: | O'Reilly Media, Inc. | | Type: | Book / Paperback | | Publication Date: | 05 May, 2005 | | ISBN / ISBN-13: | 0596100124 / 9780596100124 | | List Price: | $29.95 | | You Save: | $3.00 | | Amazon Price: | $26.95 | |
 This book is also available, brand-new, from 3rd-party marketplace sellers at Amazon.com, from $21.40. |
The HTML code below can be pasted onto your web-site, your MySpace page, or blog - or any number of similar places - to create a link to this page: If, instead of a text link, you'd like to create a link to this page which will display the book cover, if it's available, then the code below will do exactly that:
Check for the same book at these other US book sites:
• [ Abebooks ] • [ Alibris ] • [ Barnes & Noble ] • [ Half.com ] • [ Powells ] … or check UK bookstores
| Editorial Review / Publisher's Information:
Product Description
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 Practitioners" goes 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 Depth" will 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.
| Other Items You May Enjoy:
Browse Books From These Related Subjects:
Customer Reviews:
• An Excellent Introduction To The Relational Model By One Of The Best Thinkers In The Field. 22 February, 2007
When I was early in my Computer Science degree I took a course in which we discussed database fundamentals. In that class we learned about things like tuples, relations, predicates, predicate logic and deductive proofs. All of these were involved with the relational model, but it wasn't until later when I discovered the writings of Fabian Pascal and C. J. Date that I began to really understand how the above concepts tied into the database systems I was using, such as Oracle, MySQL, and Postgresql. One of those aha moments came when I realized that the deductive proofs we had done in that class were essentially queries to a database system. I came to see how each row (tuple) in a database table (relation) represented a set of values for a predicate that the relation represented. Overall, a database, then, was the logical AND of all the facts represented by the tuples of each relation. Queries were simply deductive proofs which allowed one to derive new facts from existing facts in the database. Good stuff all around.
If you're lucky, you will have studied Date's venerable Introduction to database systems while taking a college course in databases. If not, then you're still lucky, becuase Date has condensed the fundamentals of the relational model into a very approachable and very practical book published by O'Reilly, Database In Depth
Database In Depth takes you through a tour of the key concepts of the relational model, starting with the very basics (types, tuples, relations and so forth), and takes you step-by-step into more formiddable territory (stuff like normalization, join dependencies, integrity constraints, relational algebra, and the like). Throughout the book, Date explains each concept in his characteristic clarity. Date knows this stuff through and through, and it shows.
You may be tempted to think like many others that theory and fundamentals are fine and dandy, but how practical are they in the real world? In my experience, they're crucial. By understanding the fundamentals and the theory behind the databases you work with, you can avoid costly design flaws that lead to poor data integrity. By understanding these concepts, you can design databases that you can trust absolutely to store and deliver accurate results. I've had to work with databases that weren't designed with these concepts in mind, and the difference is stark.
One warning, you wont be spoon-fed here. The material can be challenging, and Date expects you to use your brain. This isn't SQL For Dummies. The real advantage you will gain by reading a book like this is that you will understand the mathematical and logical reasoning behind practical design principles such as why, for example, it's important to normalize (and the pitfalls you can run into when you de-normalize), why nulls can potentially lead to bad logic, and why duplicate rows are a bad idea all around. You'll be able to understand the ways in which most of today's database systems fail to faithfully implement the relational model, and the consequences of those failures (and consequently how to design your databases well despite these shortcomings).
Unlike many computer books that become obsolete within a year or two of their publication, Database in Depth is among that narrow collection of computer books that remain useful and relevant for years. This is precisely because it remains grounded in theory and fundamentals, instead of being tied to specific brands and versions of software.
The bottom line here is if you do much of anything with databases, then just about anything you read by C. J. Date will be worth your while. Database In Depth is no exception.
- Reviewed by customer ID: A73DVBHCNV0FP
• Theory Without Practice 13 May, 2008
Despite the sometimes critical earlier reviews I was hoping for an informative read. I was disappointed. There is theory in this book, no doubt, but where is the practice? Date goes on and on about the many failings of SQL, or to say it more in style, he pontificates on the sins of SQL against the one true relational model as, incidentally, incarnated in his own Tutorial D.
The writing is tedious as Date constantly refers to what he will say, what he has said, and what he won't say. The list of suggested readings may be an indication of the status of Date's views in the wider database (research) community: on three pages he almost exclusively refers to publications by himself or his close buddies.
I'd be willing to forgive all these shortcomings if I had learned one great practical idea in the book, just one thing that makes me a better software developer. Alas, no. For the theory alone it's hardly worth slogging through this volume, slim as it is. Instead, I recommend a solid academic textbook, such as Database Systems, The Complete Book by Garcia-Molina et al. It's dry book, but without the preaching.
- Reviewed by customer ID: A2YKD00MXGEY4C
• A Clear And Concise Introduction To The Theory Behind Relational Databases 21 May, 2007
This book is very well written. In spite of the fact that I had very little (near to none) knowledge of database systems when I bought this book, I had no trouble understanding it. It is clear, concise, and covers many important topics in relational database theory. The author uses plain English, so you don't need a degree in math in order to understand the book.
- Reviewed by customer ID: A2KG0EB1JCA7X
• Not My Cup Of Tea 28 March, 2007
Author concentrates too much on minute details which are in many ways irrelevant/implicit to many readers I feel. At times after reading a whole lot of pages, I feel like I have learnt very few newer things...same things are repeated often. Too much focus on the relational
jargon, rather the author says to strictly follow the terminology. Like the way, natural languages have many dialects, in the same fashion many readers will learn in different ways though conceptually they are on the same track. As far as I am concerned, it does not really matter what jargon is used as far as the knowledge can be put in practice correctly.
- Reviewed by customer ID: AVSD8KQNNUW0S
• Grumpy Theory 02 July, 2007
Contains only theory, with little real-word usefulness, despite what the author claims. Comes across as if it's written by a grumpy old man, constantly complaining about how SQL gets everything wrong.
- Reviewed by customer ID: A2W86ZYTXY61WB
|
