[thelist] Database Schema Suggestions

[John.Brooking at sappi.com]

> -----Original Message-----
> From: Burhan Khalid
> Sent: Monday, May 03, 2004 6:59 AM
>
>    I'm once again faced with a database design problem, and not quite 
> sure what is the best way to solve it.  The task is to design one of 
> those unlimited category directories.  Like dmoz.org or yahoo 
> directories, et. al.

Thanks for the two great article links, Sarah and Joshua. I forwarded them
on to some people here at my company, and was reminded of another potential
method by my Oracle DBA, if you have Oracle and don't mind being
database-specific. Oracle has special syntax, something like, "SELECT ...
CONNECT BY ... START WITH ..." for retrieving a tree-structured data branch
starting at any given node. I've used it before, and It's pretty powerful,
at the expense of being specific to Oracle only. If you are interested, a
comprehensive introduction is here:

http://otn.oracle.com/oramag/webcolumns/2003/techarticles/gennick_connectby.
html

- John
-- 

This message may contain information which is private, privileged or
confidential and is intended solely for the use of the individual or entity
named in the message. If you are not the intended recipient of this message,
please notify the sender thereof and destroy / delete the message. Neither
the sender nor Sappi Limited (including its subsidiaries and associated
companies) shall incur any liability resulting directly or indirectly from
accessing any of the attached files which may contain a virus or the like.