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

Home -> Community -> Usenet -> comp.databases.theory -> Normalization ?

Normalization ?

From: Naran Hirani <N.Hirani_at_hgmp.mrc.ac.uk>
Date: Mon, 10 Sep 2001 22:18:06 +0100
Message-ID: <3B9D2E0E.C6605FF1@hgmp.mrc.ac.uk>


Hi,

I have the following interesting question concerning database normalization.
Please consider the following scenario:

Database A is an OLTP type of database which is of course "normalized". Whilst database B is a read-only database which takes its data on an ad-hoc basis
from database A in an incremental manner.

My question then is, given database B is read-only, is there anything to be gained
by normalizing this database?

My own view is that it is better to actually denormalize database B in relation to A
so as to improve performance by arranging data in a way that it is most often likely
to be queried. Naturally, the migration of data from A->B is then slightly more
involved and voluminous. But, apart from that I can not see any downsides.

I'd be very interested to hear what other perspectives people have in this NG.
If possible, please CC your replies to me as well as posting to this NG.

Many thanks
Naran Hirani Received on Mon Sep 10 2001 - 16:18:06 CDT

Original text of this message

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