Re: To De-Normalize or Normalize ?

From: Francois LeMay <lemayf_at_istar.ca>
Date: 1998/09/24
Message-ID: <qrxO1.88$Sf2.410906@NewsRead.Toronto.iSTAR.net>#1/1

Well, de-normalized databases are used in datawarehouse and normalize db in your application. But the rules can be broken in the 2 above sceranios
Francois

In article <360a208f.11106841_at_news.tele.dk>, cr_at_post.dk says...
>
>How do you get faster response-times from queries ?
>
>Some people argue that you
>
>A)
>have to De-Normalize your database, so that you have fewer joins, which
in turn
>results in faster response-times from your queries.
>
>B)
>have to Normalize your database, so that you can have more data in
memory, which
>in turn results in faster response-times from your queries.
>
>
>What is YOUR experience ?
>
>Why and/or When do YOU either De-Normalize or Normalize your database ?
>
>TIA - Christian
>
>
>*-*-* Disclaimer *-*-*
>The Questions, Answers, Opinions etc. stated in this
>message are my own !
Received on Thu Sep 24 1998 - 00:00:00 CDT