Patent ID: 7209923

Claim:
A method for extracting contextual information about a plurality of objects and a plurality of activities from a plurality of tables comprising a plurality of columns and a plurality of rows in a database comprising: selecting a number P partitioning columns, said partitioning columns to be used for partitioning said database rows into partitions; each said partition comprising zero or more rows, wherein if one or more rows exist, each said row having the same values, or value ranges, in each row and partitioning column in said partition; selecting a number R processing columns of said database to be used in extracting information from said database; said processing columns comprising structured columns and unstructured columns; said unstructured columns including one or more columns containing words or phrases expressed in a language; modeling classes and relationships among said plurality of objects and said plurality of activities described by entries in said database; searching the said partitions for said contextual information based on the modeling; and presenting said contextual information to a user; wherein of P and R is greater than zero.