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...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: Kumar, Ranvijay, Garden, Euan Peter, Cheung, Chairy Chiu Ying, Perelman, Daniel Adam, Gulwani, Sumit
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&amp;date=20180426&amp;DB=EPODOC&amp;CC=US&amp;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&amp;date=20180426&amp;DB=EPODOC&amp;CC=US&amp;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