Hi, Detail table is not a official concept. Here it is meant a separate
table with the same primary key, wherein you can store the images.
The main advantage is that in the master table more entries can be written
per block. This will reduce physical i/o, generally spoken.
Greetings
Han
kev heeft geschreven in bericht <37C2918B.620B441F_at_fast.no>...
>Hi,
>
>I'm wondering what's the best way to store a news story (or any general
>article) which will have a title, a body of text, and possibly an image
>associated with it.
>While reading p.120 of Oracle Design, it says that the favoured way of
>storing string data of more than 2000 characters is to hold it in a
>details table. I've heard the term before, but would be grateful if
>someone could tell me exactly what a detail table is (it's not in the
>index of this book) and why it is the favoured option.
>
>On the image side, should I store the images in the database itself or
>should I just store the image filename?
>The same question applies to large bodies of text too, I suppose, and
>any other data which I may want to convert to binary (and store as RAW),
>such as video data, etc. What are the advantages and disadvantages of
>the two methods?
>
>TIA,
>
>- Kev
>
Received on Tue Aug 24 1999 - 09:53:10 CDT
