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.
    Jan 31 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
    Jan 31 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.
    Feb 1 at 10:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.