How can an SQL relational database be used to model a thesaurus? [closed]
- by Miles O'Keefe
I would like to design a web app that functions as a simple thesaurus: a long list of words with attributes, all of which are linked to each other.
This thesaurus data model can be defined as:
a controlled vocabulary arranged in a known order in which
equivalence, hierarchical, and associative relationships among
terms are clearly displayed and identified by standardized
relationship indicators.
My idea so far is to have one database in which every word is a table, and every table contains all words related to that word.
e.g.
Thesaurus(database) - happy(table) - excited(row)|cheerful(row)|lively(row)
Is there are more efficient way to store words and their relationship to other words in a relational SQL database?