发明名称 AUTOMATED JOIN DETECTION
摘要 Automated join detection includes: identifying a set of one or more candidate joins of a first table and a second table; evaluating a set of one or more quality measures corresponding to the set of one or more candidate joins; obtaining a set of one or more selected joins among the set of one or more candidate joins, the set of one or more selected joins being selected based at least in part on one or more corresponding quality measures; and generating a joined table, including by joining the first table and the second table according to a selected join.
申请公布号 US2017109402(A1) 申请公布日期 2017.04.20
申请号 US201514883500 申请日期 2015.10.14
申请人 Paxata, Inc. 发明人 Brewster Dave;Tso Victor Tze-Yeuan;Jin Ashley;Ta Quan Chuong;Sankar Lakshman Roy;Bardoliwalla Nenshad Dinshaw
分类号 G06F17/30 主分类号 G06F17/30
代理机构 代理人
主权项 1. A method, comprising: identifying a set of one or more candidate joins of a first table and a second table, wherein a candidate join specifies a set of one or more conditions associated with joining a first set of one or more columns in the first table and a second set of one or more columns in the second table; evaluating a set of one or more quality measures corresponding to the set of one or more candidate joins, a quality measure being determined based at least in part on: an overlap measure that measures an amount of overlap between the corresponding first set of one or more columns in the first table and the corresponding second set of one or more columns in the second table, and a selectivity measure that measures how selectively a join condition maps a row in the first table to one or more rows in the second table; obtaining a set of one or more selected joins among the set of one or more candidate joins, the set of one or more selected joins being selected based at least in part is on one or more corresponding quality measures; and generating a joined table, including by joining the first table and the second table according to a selected join.
地址 Redwood City CA US
您可能感兴趣的专利