The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.

The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.

Date of Patent:
Sep. 17, 2024

Filed:

Mar. 20, 2023
Applicant:

International Business Machines Corporation, Armonk, NY (US);

Inventors:

Yuan Feng, Beijing, CN;

Ling Zhuo, Beijing, CN;

Qi Min, Beijing, CN;

Pei Pei Liang, Beijing, CN;

Yue Yang, Beijing, CN;

Jun Wang, Xi'an, CN;

Attorneys:
Primary Examiner:
Int. Cl.
CPC ...
G06F 16/2455 (2019.01); G06F 11/34 (2006.01); G06F 16/242 (2019.01); G06F 16/2453 (2019.01);
U.S. Cl.
CPC ...
G06F 16/2456 (2019.01); G06F 11/3409 (2013.01); G06F 16/2423 (2019.01); G06F 16/2453 (2019.01);
Abstract

A computer-implemented method, system and computer program product for recommending join operations of relational data among different tables. Relationships between one or more pairs of columns of relational data for one or more pairs of tables are identified by determining the semantic similarity between each pair of columns of relational data. The data content join converge for each of the identified relationships in connection with joining the tables involved in such identified relationships is determined. Furthermore, a join strength (indication of the degree that the relational data in the paired columns match) is calculated for each of the identified relationships based on the semantic similarity and the data content join coverage for such identified relationships. Based on the calculated join strength as well as other factors, a combination optimization algorithm identifies the best join combinations of relational data of the tables among a set of tables.


Find Patent Forward Citations

Loading…