Re: variable column table

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Wed, 28 May 2003 09:14:45 +0000
Message-ID: <bb1no3$r41$1@ctb-nnrp2.saix.net>

Paul Brewer wrote:

> But you're getting into 4th and 5th normal form. Design becomes
> aesthetically perfect, but real world performance goes down the plughole.
> IMHO it's good for 'user extensions to the application', but one needs to
> be careful.

Agree. And that's what I'm looking for. Where to draw the line and how to tackle such a an implementation in Oracle - if at all.

So moving away from the relational design and all that - focussing solely on the db toolbox called Oracle. What magic can we pull from there?

We have partitioning, clusters, nested tables, objects etc. etc. - is there any innovative way to address this type of db model in Oracle.

--
Billy

Received on Wed May 28 2003 - 04:14:45 CDT