QUERY OPTIMIZER FOR COMBINED STRUCTURED AND UNSTRUCTURED DATA RECORDS

A method of optimizing a query over a database, the method includes obtaining a set of data records from the database, the data records containing structured data and unstructured data documents, extracting the structured and unstructured data from the set of data records, transforming the structured and unstructured data into a vector that is an element of a weighted vector space, receiving a target data record containing structured and unstructured data, generating a target vector for the target data record, executing a similarity algorithm using the target vector and the weighted vector space generated by the collection of database records to provide a reduced number of data records that are most similar to the target data record, and executing a query against the reduced number of data records that are most similar to the target data record.