US 12,468,672 B2
Database schema relationship analysis system
Yan Yan Han, Xi'an (CN); Yue Yang, Beijing (CN); Pei Pei Liang, Beijing (CN); Ling Zhuo, Beijing (CN); Yuan Feng, Beijing (CN); and Yan Hao Zhang, Beijing (CN)
Assigned to International Business Machines Corporation, Armonk, NY (US)
Filed by International Business Machines Corporation, Armonk, NY (US)
Filed on Mar. 5, 2024, as Appl. No. 18/595,492.
Prior Publication US 2025/0284668 A1, Sep. 11, 2025
Int. Cl. G06F 16/21 (2019.01); G06F 16/28 (2019.01)
CPC G06F 16/212 (2019.01) [G06F 16/288 (2019.01)] 17 Claims
OG exemplary drawing
 
1. A computer-implemented method comprising:
receiving a table name associated with a table entity that has been modified in a database of an application;
generating an application documentation table association tree using a set of data extracted from application documentation of the application using the table name, wherein the application documentation table association tree includes (Structured Query Language) SQL statements generated from text segments of the application documentation that contain the table name;
generating a source code table association tree using a different set of data extracted from source code of the application using the table name;
determining a similarity level by comparing a structure and relationships of nodes in the application documentation table association tree and the source code table association tree; and
in response to determining that the similarity level is within a threshold value, generating a message comprising a suggestion to modify an associated table entity associated with the table entity that has been modified using data from the application documentation table association tree and the source code table association tree,
wherein the source code table association tree is generated by:
generating a method call relationship graph using code segments of the source code containing the table name;
generating a method call relationship table from the method call relationship graph;
generating a method call tree from the method call relationship table; and
generating the source code table association tree from the method call tree.