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?

howachen (AT) gmail (DOT) com wrote:
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.