I had been thinking about doing that using a tree structure from Joe Celko's
SQL for Smarties.
But I don't think I'm smart enough. Amazon called... they want the book
back. I guess they heard.
> -----Original Message-----
> From: Marc Schipperheyn [mailto:[EMAIL PROTECTED]]
> Sent: Friday, July 06, 2001 5:41 AM
> To: Spectra-Talk
> Subject: Re: meta stuff
>
>
> IMHO, it would still be better to remove the Verity based
> metadata and add a
> relational based design.
> Tables would be
> METADATA_metadata
> metadataID
> label
> type [keyword|category]
> parentID (self referencing to metadataid)
> METADATA_link
> linkID
> metadataid
> objectid (identifier of the object linked to a particular keyword or
> category)
> typeid (optional)
>
> You get better performance, you don't get funny verity issues (apple and
> apple sirop may both be found for the keyword apple), and you can actually
> debug against a relational database.
>
> We've built a toolbox around this concept and it seems to work great.
> Haven't tested in Spectra though. I'd be interested if anybody
> sees this as
> a good alternative. We may release it into the open source Spectra site.
>
> Vriendelijke groet,
>
> Marc Schipperheyn
> <theFactor.e>
>
> Premium Partner for Macromedia
>
> The future is technological, but it will not be a world of gray steel
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
