Ben Forta wrote an SQL book last year - published by SAMS. I think it's
Learn SQL in 10 Minutes.
Dave
=================================
"What we need is a list of specific unknown problems we will encounter"
David Hannum
Web Analyst/Programmer
Ohio University
[EMAIL PROTECTED]
(740) 597-2524
----- Original Message -----
From: Dan G. Switzer, II <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 21, 2000 10:04 AM
Subject: RE: Database Design Question
> Brook,
>
> I'd recommend buying SQL for Smarties by Joe Celko. There's a couple of
> chapter specifically on ways to handle hierarchy data w/different database
> systems. I really like the "Nested-Set Model." The nice thing about the
> Nested-Set model is that you can do all your tree parsing/order via SQL-no
> need to manipulate the data via CF (which you have to do when simply
storing
> the parent ID.)
>
> -Dan
>
> -----Original Message-----
> From: Brook Davies [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 20, 2000 7:42 PM
> To: [EMAIL PROTECTED]
> Subject: Database Design Question
>
> I have listings that look like:
>
> 1.0 foobars
> 1.1 foobars the revenge
> 1.1.2 foobars the revenge II
> 1.1.2.1 more foobar specials
> 2.0 brown foobars
> 3.0 green foobars
>
> etc..
>
> What is the best DB design in terms of performance for a classification
> system like this?
>
> Thanks,
> Brook Davies
> MaracasMedia Inc.
>
> --------------------------------------------------------------------------
--
> --
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
> --------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.