Associative "key-" words

[Bill Weale]

I'd appreciate a heads-up (RTFM is even OK) if this topic is already  
handled and described cleanly in an earlier thread, technote, etc.

Use here of the term "keyword" is local to this task--not to 4D's  
definition. I'm trying to develop a structure so that a user may  
create and assign keywords, and eventually perhaps phrases, to  
records. It won't be likely or necessary for a keyword itself to  
appear in any fields of a given record, but I don't intend to prohibit  
the possibility. Additionally, assigning keywords may (should?) have a  
context, such as "matches," "goes well with," "substitutes for,"  
"higher quality version," etc.

The purpose is to enable fast searches based upon rules controlled by  
the db users--not based upon matching the literal values of search  
terms and field content.

My thinking is to have a "keywords" table containing essentially an  
index and a keyword field. Add to that a "Keyword Associations" table  
which contains, in addition to its own index field, fields for the  
Keyword Index, associated [table]field and context. Each instance of  
one keyword having an association with one record in one table would  
be represented by one Keyword Associations record.

With this scheme in place, 4D Queries would be pointed to the Keyword  
Associations table with the results then being used to pull from the  
desired table/fields.

It seems simple enough, which is why I'm checking here...

8-)

Thanks,

Bill Weale
**********************************************************************
Get the speed and power of 4D v11 SQL
before upgrade prices increase - http://www.4d.com
   

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4D.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************