JOIN WITH PREDICTIVE MERGING OF MULTIPLE COLUMNS
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 ta...
Gespeichert in:
Hauptverfasser: | , , , , |
---|---|
Format: | Patent |
Sprache: | eng |
Schlagworte: | |
Online-Zugang: | Volltext bestellen |
Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
container_end_page | |
---|---|
container_issue | |
container_start_page | |
container_title | |
container_volume | |
creator | Kumar, Ranvijay Garden, Euan Peter Cheung, Chairy Chiu Ying Perelman, Daniel Adam Gulwani, Sumit |
description | 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. |
format | Patent |
fullrecord | <record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_US2018113907A1</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>US2018113907A1</sourcerecordid><originalsourceid>FETCH-epo_espacenet_US2018113907A13</originalsourceid><addsrcrecordid>eNrjZDDw8vf0Uwj3DPFQCAhydfF0DvEMc1XwdQ1y9_RzV_B3U_AN9QnxDPBxVXD29wn19QvmYWBNS8wpTuWF0twMym6uIc4euqkF-fGpxQWJyal5qSXxocFGBoYWhobGlgbmjobGxKkCANAwJ1E</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>JOIN WITH PREDICTIVE MERGING OF MULTIPLE COLUMNS</title><source>esp@cenet</source><creator>Kumar, Ranvijay ; Garden, Euan Peter ; Cheung, Chairy Chiu Ying ; Perelman, Daniel Adam ; Gulwani, Sumit</creator><creatorcontrib>Kumar, Ranvijay ; Garden, Euan Peter ; Cheung, Chairy Chiu Ying ; Perelman, Daniel Adam ; Gulwani, Sumit</creatorcontrib><description>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.</description><language>eng</language><subject>CALCULATING ; COMPUTING ; COUNTING ; ELECTRIC DIGITAL DATA PROCESSING ; PHYSICS</subject><creationdate>2018</creationdate><oa>free_for_read</oa><woscitedreferencessubscribed>false</woscitedreferencessubscribed></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><linktohtml>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&date=20180426&DB=EPODOC&CC=US&NR=2018113907A1$$EHTML$$P50$$Gepo$$Hfree_for_read</linktohtml><link.rule.ids>230,308,780,885,25563,76318</link.rule.ids><linktorsrc>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&date=20180426&DB=EPODOC&CC=US&NR=2018113907A1$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>Kumar, Ranvijay</creatorcontrib><creatorcontrib>Garden, Euan Peter</creatorcontrib><creatorcontrib>Cheung, Chairy Chiu Ying</creatorcontrib><creatorcontrib>Perelman, Daniel Adam</creatorcontrib><creatorcontrib>Gulwani, Sumit</creatorcontrib><title>JOIN WITH PREDICTIVE MERGING OF MULTIPLE COLUMNS</title><description>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.</description><subject>CALCULATING</subject><subject>COMPUTING</subject><subject>COUNTING</subject><subject>ELECTRIC DIGITAL DATA PROCESSING</subject><subject>PHYSICS</subject><fulltext>true</fulltext><rsrctype>patent</rsrctype><creationdate>2018</creationdate><recordtype>patent</recordtype><sourceid>EVB</sourceid><recordid>eNrjZDDw8vf0Uwj3DPFQCAhydfF0DvEMc1XwdQ1y9_RzV_B3U_AN9QnxDPBxVXD29wn19QvmYWBNS8wpTuWF0twMym6uIc4euqkF-fGpxQWJyal5qSXxocFGBoYWhobGlgbmjobGxKkCANAwJ1E</recordid><startdate>20180426</startdate><enddate>20180426</enddate><creator>Kumar, Ranvijay</creator><creator>Garden, Euan Peter</creator><creator>Cheung, Chairy Chiu Ying</creator><creator>Perelman, Daniel Adam</creator><creator>Gulwani, Sumit</creator><scope>EVB</scope></search><sort><creationdate>20180426</creationdate><title>JOIN WITH PREDICTIVE MERGING OF MULTIPLE COLUMNS</title><author>Kumar, Ranvijay ; Garden, Euan Peter ; Cheung, Chairy Chiu Ying ; Perelman, Daniel Adam ; Gulwani, Sumit</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_US2018113907A13</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>eng</language><creationdate>2018</creationdate><topic>CALCULATING</topic><topic>COMPUTING</topic><topic>COUNTING</topic><topic>ELECTRIC DIGITAL DATA PROCESSING</topic><topic>PHYSICS</topic><toplevel>online_resources</toplevel><creatorcontrib>Kumar, Ranvijay</creatorcontrib><creatorcontrib>Garden, Euan Peter</creatorcontrib><creatorcontrib>Cheung, Chairy Chiu Ying</creatorcontrib><creatorcontrib>Perelman, Daniel Adam</creatorcontrib><creatorcontrib>Gulwani, Sumit</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>Kumar, Ranvijay</au><au>Garden, Euan Peter</au><au>Cheung, Chairy Chiu Ying</au><au>Perelman, Daniel Adam</au><au>Gulwani, Sumit</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>JOIN WITH PREDICTIVE MERGING OF MULTIPLE COLUMNS</title><date>2018-04-26</date><risdate>2018</risdate><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.</abstract><oa>free_for_read</oa></addata></record> |
fulltext | fulltext_linktorsrc |
identifier | |
ispartof | |
issn | |
language | eng |
recordid | cdi_epo_espacenet_US2018113907A1 |
source | esp@cenet |
subjects | CALCULATING COMPUTING COUNTING ELECTRIC DIGITAL DATA PROCESSING PHYSICS |
title | JOIN WITH PREDICTIVE MERGING OF MULTIPLE COLUMNS |
url | https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-01-11T13%3A00%3A06IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-epo_EVB&rft_val_fmt=info:ofi/fmt:kev:mtx:patent&rft.genre=patent&rft.au=Kumar,%20Ranvijay&rft.date=2018-04-26&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3EUS2018113907A1%3C/epo_EVB%3E%3Curl%3E%3C/url%3E&disable_directlink=true&sfx.directlink=off&sfx.report_link=0&rft_id=info:oai/&rft_id=info:pmid/&rfr_iscdi=true |