主权项 |
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. |