Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: DB Design Principles for RDBMS

Re: DB Design Principles for RDBMS

From: Anton Versteeg <anton_versteeg_at_nnll.iibbmm.com>
Date: Mon, 10 Feb 2003 13:42:49 +0100
Message-ID: <3E479E49.5C3DCC80@nnll.iibbmm.com>


I guess we agree :)

Paul Vernon wrote:

> "Anton Versteeg" <anton_versteeg_at_nnll.iibbmm.com> wrote in message
> news:3E477A6C.B4CD774C_at_nnll.iibbmm.com...
>
> or alternatively...
>
> > 1. Keep it simple
>
> Make it as complex as sufices to capture the detail of the thing being modeled
>
> > 2. Know your data/business processes
>
> Discover your data and processes (aka database constraints) during your
> design.
>
> > 3. Use commen sense
>
> Use rational and critical thinking
>
> > 4. Do not over-normalize your database design
>
> Normalise your design to the point where it makes the specification of most
> constraints easier
>
> > 5. Spend enoug time on your conceptual/logical data model,
> > because mistakes made there will be hard to correct.
>
> Generate your logical design directly as a physical database, and then
> iterate.
>
> ;-)
>
> Regards
> Paul Vernon
> Business Intelligence, IBM Global Services

--
Anton Versteeg
DB2 Specialist
IBM Netherlands
Received on Mon Feb 10 2003 - 06:42:49 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US