Join with predictive granularity modification by example
US10394815B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Oct 20, 2016 |
| Grant date | Aug 27, 2019 |
| Priority date | — |
| Expiry date | May 16, 2037 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F40/18
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A computing device is provided, comprising a processor configured to select at least one pair of columns. Each pair may include a source column of the first table and a target column of the second table. For each pair, the processor may detect that the columns contain data with different granularities. The processor may modify the data to have the same granularity, and may generate an example including an element from the source column and an element from the target column. For each example, the processor may programmatically generate a script that, when performed on the source column, produces a value consistent with the target column. For the script with output that meets a matching criterion, the processor may convey the output for display, and may, in response to a signal accepting the script, join the tables at least in part by performing the script on the source column.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.