Andrew Channels Dexter Pinion

Wherein I write some stuff that you may like to read. Or not, its up to you really.

January 20, 2004

Relational v Object-Relational

A very nice post from Tom Kyte on the pros and cons of storing your data in relational or object-relational form.

The killer point here is that an object model is application (or actor) focussed whereas a data model is independent. The point being that you will have different requirements from different types of users and storing your data independently of those viewpoints empowers them all. If you stick to a single view of the world you will diminish your ability to service the other actors in your system.

I shall be mentioning this to the object bigots at work, just to gauge their reaction.

This is a sort of follow on from this post by VS Babu, which in turn follows up on a comment I made on an earlier post.

Posted by Andy Todd at January 20, 2004 12:04 PM