Suppose my database has column name and description for each column of each table. Need to design an interface where a user can enter a keyword and the interface will return the most relevance columns. For example, enter "payment" and the interface can just find and return a list of columns containing "payment" in column name and description. But what if the user enters a keyword doesn't exist in column name and description, then how to suggest the most relevant columns for this keyword? Any suggestions?

  • $\begingroup$ you should have a corpus of related words/synonyms $\endgroup$
    – Nikos M.
    Commented Jan 31, 2021 at 8:32
  • $\begingroup$ @NikosM. Ok, if I use column name and description as corpus, what to do next to get what I want? $\endgroup$
    – etang
    Commented Jan 31, 2021 at 22:38
  • $\begingroup$ If the column names and descriptions are enough then you are fine, else you can have an additional corpus of related words/synonyms (that map to column names) the user might use and which are not lexicaly related to column names $\endgroup$
    – Nikos M.
    Commented Feb 1, 2021 at 10:15


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.