March 12, 2016 at 10:44 pm
Heya All,
Requirement:
Data is accessed by users from different organisations. Users will enter a text used search to find relevant data. The data will have a default 'name' value, for lack of a better word, and also a description.
Challenge:
Different organisations, and therefore users, will have a different taxonomy for the same data.
Proposed Solution:
Tag the data with keywords/tags.
The question is, does anyone know a data pattern for this requirement that is different from something basic like:
- A Data Source
- A Keyword Source
- A Data/Keyword Link
I am happy to go with the above just checking. 🙂
Thanks
Steve D
March 13, 2016 at 4:47 am
SteveD SQL (3/12/2016)
The question is, does anyone know a data pattern for this requirement that is different from something basic like:- A Data Source
- A Keyword Source
- A Data/Keyword Link
I am happy to go with the above just checking. 🙂
I think you only need the keyword source if you want to ensure that tags are always chosen from a set list and changes to that list are controlled, or if you want to have translated versions of tags (so that an English search for database and a German search for Datenbank would return the same results).
Otherwise, I would go with a data source, and a tags table with just the foreign key into the data source plus the tag itself as an additional column and a primary key over all those columns combined.
March 14, 2016 at 1:50 am
Heya Hugo,
Yes the requirement does include have some control over the keywords/tags used and provide a list for user to select from so I will be including a keyword source.
Thanks
Steve
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply