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.
Patent No.:
Date of Patent:
Jan. 06, 2015
Filed:
Mar. 30, 2012
Leon Burda, Cupertino, CA (US);
Salil Datta, Cupertino, CA (US);
Alexander Gorelik, Palo Alto, CA (US);
Dongmei Ren, Sunnyvale, CA (US);
Lev M. Tsentsiper, Santa Clara, CA (US);
Leon Burda, Cupertino, CA (US);
Salil Datta, Cupertino, CA (US);
Alexander Gorelik, Palo Alto, CA (US);
Dongmei Ren, Sunnyvale, CA (US);
Lev M. Tsentsiper, Santa Clara, CA (US);
International Business Machines Corporation, Armonk, NY (US);
Abstract
According to a present invention embodiment, a system determines a relationship between source and target database tables, and includes a computer system including at least one processor. Potential pivot keys of the target database table are determined, and maps are created for each potential pivot key between the database tables based on distinct values. Transformations for each map are generated that enable target data to be produced from source data. The transformations for each potential pivot key are analyzed and the potential pivot key with the transformations that generate the greatest amount of matching data is selected as the resulting pivot key. The database table columns corresponding to the resulting pivot key are determined to be associated by the relationship. Embodiments of the present invention further include a method and computer program product for determining a relationship between source and target database tables in substantially the same manner described above.