Here is a nice db structure shared by Dale Mead on the IA-CMS list (a new Yahoo group that just started up recently):

Another approach to Logical Data Model for a thesaurus could look something like this:

Table: Term
______________________
term_id (primary key)
term_name
term_description

Table: Relation_Dict
_______________________
relation_type
(values: broader_narrower, related)

Table: Relation
_________________

relation_id
parent_id
child_id
relation_type

More CMS vendors need to provide support for thesauri management and integration (the database structure above is based on what is used in Documentum). Don’t take my word for it. Listen to Lou:

Content management system vendors take note: your bloody products might actually provide value if 1) you enabled manual indexing by integrating thesaurus management capabilities; and 2) that manual indexing stuff is “real work” too, so start figuring out how to better integrate it within your work flow support.