DB Table Structure for Thesauri

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.

Advertisements
https://highcontext.com/2002/09/18/db-table-structure-for-thesauri/
highcontext.com
crawl=CC-MAIN-2018-13
40442
application/http; msgtype=response
sha1:ZIPOSYKRZEOTHMXVN7AOQ65Y7QB6HEW2
<urn:uuid:472f473a-4ea0-4ad9-b659-e7646cce3c0b>
2018-03-22T13:58:37Z
192.0.78.25
text/html
sha1:5C27IKECDUZ4T3RJCGLC6JII4QCV3QZL
<urn:uuid:54eb83e0-b3b9-44d9-a7d2-8e2073e2c03b>
https://highcontext.com/2002/09/18/db-table-structure-for-thesauri/
length
response
<urn:uuid:62eab43c-a139-4d7d-851b-e8c30f04e338>
robots: classic
hostname: ip-10-229-49-97.ec2.internal
software: Nutch 1.6 (CC)
isPartOf: CC-MAIN-2018-13
operator: Common Crawl Admin
description: Wide crawl of the web for March 2018
publisher: Common Crawl
format: WARC File Format 1.0
conformsTo: http://bibnum.bnf.fr/WARC/WARC_ISO_28500_version1_latestdraft.pdf