Patent ID: 7660814
Filing Date: 2010-02-09
Classification: G06F,Y10S

Abstract:
1. A computer-implemented method to process on a computer, comprising: identifying a plurality of concepts from different physical data store tables associated with a query search results set, the concepts are logical collections of fields and columns defined in the data store tables that share at least one same field and one same column with one another across the data store tables and that are derived from the data store tables; mapping a plurality of collections of the concepts to their own virtual table associated with virtual table definitions in a data store by mining the query search results using pre-existing table definitions for each collection, the virtual tables represent permutations of the columns in the query search results set and the virtual table definitions are predefined associations in the data store that are independent of the data store tables and are identified via the pre-existing table definitions for each collection; returning a handle to a new results table; performing a search against the new results table via the handle the new results table joins each of the virtual tables into the new results table, the handle used as a single table reference for new searching against multiple virtual table definitions derived from the original query search results, and the concepts or collections of the concepts are logical associations identified within the data store that provides linkages between the different physical data store tables; assembling a number of the virtual tables into a sub graph representing the virtual tables within the query search results set; collecting the sub graph and other sub graphs as a set of sub graphs; and submitting the set of sub graphs to a table join analysis service that performs the join from the set of sub graphs and produces the new results table.