What is the best database design and/or software to model a thesaurus?
- 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.
Wikipedia defines it as:
In Information Science, Library Science, and Information Technology, specialized thesauri are designed for information retrieval. They are a type of controlled vocabulary, for indexing or tagging purposes. Such a thesaurus can be used as the basis of an index for online material. The Art and Architecture Thesaurus, for example, is used to index the Canadian Information retrieval thesauri are formally organized so that existing relationships between concepts are made explicit.
What database software, design or model would best fit this?
Are PHP and MySQL good technologies to handle it?