Patent ID: 7970768

Claim:
In a computing system having access to multiple content entities, each content entity including searchable content, a method for building a database for facilitating searching and retrieving of content entities in an efficient manner that returns results of content entities expected to be found, the method comprising: creating a skeleton database for storing a search index table and one or more other tables for facilitating a search for content entities within one or more content sources; inserting index data into the skeleton database, the index data including index entries pointing to content within the one or more content sources; processing content entities from a first content source and inserting data associated with the content entities into the search index table; adding to the skeleton database associations between content entities of the one or more content sources and processing related content entities identified by the associations; adding to the skeleton database the one or more other tables, wherein the one or more other tables include at least a double word table that includes all possible unique two word combinations of words from the processed content entities; and outputting the skeleton database into an output file that includes the search index table and the one or more other tables, and detaching the output file from a build server used to create the skeleton database.