Method to assist user in creation of highly inter-related models in complex databases

Abstract

A computer-implemented method is provided to facilitate creation of linked inter-related models in a database. The method comprises obtaining a search text and match criteria from a user, and determining whether a prequery exists. If not, a list of all destination items is obtained. If yes, a determination is made whether the prequery is enabled. If not, a list of all destination items is obtained. If enabled, a list of all destination items limited by the prequery is obtained. A determination is then made whether all match criteria is selected. If yes, all items in the destination list are returned to the user. If not, a word list is generated by parsing all words from the search text. All valid synonyms are added for each word in the word list. The items in the destination list are reduced to items that match at least one word in the word list. A determination is made whether one or more additional filters exist. If not, a reduced list filtered by the match criteria is returned to the user. If the additional filters exist, the filters are presented to the user. The matched item list is then reduced based on criteria of the filters. The reduced matched item list is then returned to the user.