howachen@gmail.com wrote:
> well, this is not a completely mysql related topic, but i tihnk mysql
> users/developers might be interested in the topic, so i post here...
>
>
> Q. What is the best database table design for a tagging system?
>
> Consider the following examples...
>
>
> tags for item A : coke cola
> tags for item B : fanta drink
> tags for item C : coke pepsi drink
> ...
> ...
>
> so the following set are generated: (only one-level depth)
>
> set for the tag "coke" : cola pepsi drink
> ...
>
> any idea on this?

this looks like a thesaurus. there's stuff out there on thesaurus db
construction - also, tematres provide open source thesaurus management
which I've heard good things about.