The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Apr. 19, 2016
Filed:
Oct. 05, 2011
Kris Ganjam, Seattle, WA (US);
Vivek Ravindranath Narasayya, Redmond, WA (US);
Raghav Kaushik, Bellevue, WA (US);
Arvind Arasu, Bothell, WA (US);
Surajit Chaudhuri, Redmond, WA (US);
Kris Ganjam, Seattle, WA (US);
Vivek Ravindranath Narasayya, Redmond, WA (US);
Raghav Kaushik, Bellevue, WA (US);
Arvind Arasu, Bothell, WA (US);
Surajit Chaudhuri, Redmond, WA (US);
Microsoft Corporation, Redmond, WA (US);
Abstract
A fuzzy joins system that is integrated in a database system generates fuzzy joins between records from two datasets. The fuzzy joins system includes a tokenizer to generate tokens for data records and a transformer to find transforms for the tokens. The fuzzy joins system invokes a signature generator, running within a runtime layer of the database system, to generate signatures for data records based on the tokens and their transforms. Subsequently, an equi-join operation joins the records from the two datasets with at least one equal signature. A similarity calculator, running within a runtime layer of the database system, computes a similarity measure using the token information of the joined records. If the similarity measure for any two records is above a threshold, the fuzzy joins system generates a fuzzy join between such two records.