Invention Grant
- Patent Title: Join with predictive merging of multiple columns
-
Application No.: US15299404Application Date: 2016-10-20
-
Publication No.: US10585888B2Publication Date: 2020-03-10
- Inventor: Sumit Gulwani , Daniel Adam Perelman , Ranvijay Kumar , Euan Peter Garden , Chairy Chiu Ying Cheung
- Applicant: Microsoft Technology Licensing, LLC
- Applicant Address: US WA Redmond
- Assignee: MICROSOFT TECHNOLOGY LICENSING, LLC
- Current Assignee: MICROSOFT TECHNOLOGY LICENSING, LLC
- Current Assignee Address: US WA Redmond
- Agency: Alleman Hall Creasman & Tuttle LLP
- Main IPC: G06F16/2453
- IPC: G06F16/2453 ; G06F16/25 ; G06F16/2455 ; G06F17/24

Abstract:
A computing device is provided, comprising a processor configured to select at least one pair of tuples of columns including a source tuple from a first table and a target tuple from a second table. For each pair, the processor may select one or more rows from the source tuple and elements of the target tuple. For each selected row, the processor may programmatically generate a script that, when performed on the source tuple, produces a value consistent with the target tuple. The processor may apply each script to other rows of the source tuple and determine that an output is in the target tuple. For each column of the target tuple, for the script with output that meets a matching criterion, the processor may convey the output and, in response to a signal accepting the script, join the tables at least in part by performing each accepted script.
Public/Granted literature
- US20180113907A1 JOIN WITH PREDICTIVE MERGING OF MULTIPLE COLUMNS Public/Granted day:2018-04-26
Information query