Buy New

or
Sign in to turn on 1-Click ordering.
or
Amazon Prime free trial required. Sign up when you check out. Learn more
Buy Used
Used - Good See details
Price: £10.46

or
Sign in to turn on 1-Click ordering.
 
   
More Buying Choices
Have one to sell? Sell yours here
or
Get a £3.60 Amazon.co.uk Gift Card
Database in Depth: Relational Theory for Practitioners: The Relational Model for Practitioners
 
 
Tell the Publisher!
I’d like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Database in Depth: Relational Theory for Practitioners: The Relational Model for Practitioners [Paperback]

C.J. Date
4.0 out of 5 stars  See all reviews (6 customer reviews)
RRP: £22.99
Price: £14.94 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
You Save: £8.05 (35%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In stock.
Dispatched from and sold by Amazon.co.uk. Gift-wrap available.
Only 3 left in stock--order soon (more on the way).
Want guaranteed delivery by Wednesday, May 30? Choose Express delivery at checkout. See Details
Trade In this Item for up to £3.60
Get an extra £5 when you trade in books worth £10 or more until June 30, 2012. Trade in Database in Depth: Relational Theory for Practitioners: The Relational Model for Practitioners for an Amazon.co.uk gift card of up to £3.60, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Find more products eligible for trade-in.

Frequently Bought Together

Customers buy this book with Applied Mathematics for Database Professionals (Expert's Voice) £41.32

Database in Depth: Relational Theory for Practitioners: The Relational Model for Practitioners + Applied Mathematics for Database Professionals (Expert's Voice)
Price For Both: £56.26

Show availability and delivery details



Product details

  • Paperback: 232 pages
  • Publisher: O'Reilly Media; 1 edition (12 May 2005)
  • Language English
  • ISBN-10: 0596100124
  • ISBN-13: 978-0596100124
  • Product Dimensions: 23.1 x 17.8 x 1.8 cm
  • Average Customer Review: 4.0 out of 5 stars  See all reviews (6 customer reviews)
  • Amazon Bestsellers Rank: 385,971 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Author

C. J. Date
Discover books, learn about writers, and more.

Visit Amazon's C. J. Date Page

Product Description

Review

"it's a manifesto for change written by someone who might make it happen." - Graham Morrison, Linux Format, October 2005

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.


Inside This Book (Learn More)
Explore More
Concordance
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
 
(2)

Your tags: Add your first tag
 

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

What Other Items Do Customers Buy After Viewing This Item?


Customer Reviews

Most Helpful Customer Reviews
22 of 23 people found the following review helpful
Format:Paperback
Many years ago when I was a student we were taught database theory. Although Ted Codd's paper "A Relational Model of Data for Large Shared Data Banks" had been published fifteen years earlier, relational databases hadn't yet become the dominant species and we were taught a number of alternatives (does anyone else remember Codasyl?) systems - relational databases and SQL were just the newest option.

Of course, once I left college and started working for a living, it wasn't long before relational databases were the only game in town. And over the years I've forgotten most of the non-relational theory that I once knew. Or, at least, that's what I thought. Reading this book, I realise that I had forgotten most of the relational theory too.

The relational model is what underpins most of the databases that we use in our day-to-day work. But in many ways, the databases that we use today have diverged greatly from Codd's original ideas. Many of the features of todays databases would have no place in a purely relational database.

And that is what Chris Date's latest book is all about. He reminds us of what a really relational database would look like and points out where current implementations fall short. In particular, it's clear that Date blames the ubiquity of SQL for most of these problems. SQL, he reminds us, started out as an attempt to put a user-friendly(!) query language on top of the relational model. When that didn't really work out, instead of going back to square one and trying to implement a better relational query language the database vendors instead stuck with SQL and ignored the bits of the relational model which it couldn't support. For most of the examples in the book, Date gives an SQL query alongside the same query rewritten in "Tutorial D" a relational query language of his own creation.

The book does contain a useful introduction to the relational model, but I have to say that in doing so it uses some mathematics that many potential readers might find a bit galling. Personally, I'd be very happy if more database practioners understood the underlying maths to the level required to read this book as that would hopefully mean an increase in the average quality of the database designs that I come across.

Date is at his most interesting when he is talking about the advantages that a "proper" relational database implementation would bring us. As he says in a recent interview:

"As far as I'm concerned, an object/relational system done right would simply be a relational system done right, nothing more and nothing less."

There are some exciting possibilities in a truely relational database, but it would mean the industry admitting that its current implementations are flawed. And I don't see that happening.

If you work with databases and you have any interest in the mathematical theories behind how your database works, then I recommend you read this book. You'll come out with a deeper understanding of your current database system. But, perhaps more importantly, you'll also have a slight sense of disappointment when you realise how good your database could be.

Comment | 
Was this review helpful to you?
2 of 2 people found the following review helpful
Format:Paperback|Amazon Verified Purchase
I am a CEO of a small (45 person) Software VAR / ISV company (M4 Systems) - I have read many books on databases and SQL, this is by far the best. In my 26 years of business experience I have been surprised to find that - in the general workplace (including IT) logic and common sense is in remarkably short supply - therefore I recommend this book to anyone who is interested in business systems to support effectiveness and efficiency. Gary Clarke P.S. This book is much easier reading that his other book on Logic and Databases.
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
Format:Paperback
Chris Date has written the only book you need to really understand how databases SHOULD be done building on Ted Codd's relational model. This book will change your perception of all databases and DBMSs especially on the subject of what a relation actually is. Personally I find Date's style of writing very much like the lectures I take (from Hugh Darwen actually so that probably explains it) and contrary to another poster's belief does not basically serve as propeganda on why he is great and all other comentators are wrong but that commentators who don't follow Codd's relational model are HIGHLY flawed.
Comment | 
Was this review helpful to you?

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   


Listmania!


Look for similar items by category


Look for similar items by subject


Feedback


Amazon.co.uk Privacy Statement Amazon.co.uk Delivery Information Amazon.co.uk Returns & Exchanges