View Updating and Relational Theory by C.J. Date
Summary: Right explanation of complex things
This is yet another book from C.J. Date on the relational theory. This time, C.J. takes you on the journey of View updates. The topic is controversial as this is not that obvious whether it is possible to perform view updates or not. C.J. approaches the topic from the relational theory point of view. That means, you will not find any SQL here. Some time ago while I was reading SQL and Relational Theory I claimed that Tutorial D language introduced by C.J. was an unnecessary element. In here, however, I think it serves it’s purpose very well. Thanks to the specifics of Tutorial D, topics are easier to track by reader.
When it comes to the style of the book it’s rather academic one. It means you will find here rather formal language, quite a lot of definitions and mathematically ascetic way of describing concepts presented in the book. I’d suggest this book to people who are experienced with relational theory (it’s too tough for beginners) and for SQL experts who are looking for relational based explanation of problems that are currently not solved in SQL based databases.
I think this book is worth reading but you should be warned it is not an easy and pleasant read. It’s rather demanding position in the field of database. However, if you are ready for that, go for it. Do not hesitate.
Product page: http://shop.oreilly.com/product/0636920028437.do
If you haven’t read about relational model before, please note you need to know it prior to reading this book! There is a book that covers this topic quite well: SQL and Relational Theory, 2nd Edition. There is also very good video material here: C.J. Date’s SQL and Relational Theory Master Class
Note! Books mentioned above are relational model oriented. It means you will not learn SQL that is usually applied in commercial products. Rather than that you will learn the basis of all that.
Note2! You can find my review of SQL and Relational Theory, 2nd Edition here http://www.owsiak.org/?p=1009