Bootstrapping the data lake and glossaries with ‘dataset joins’ metadata from existing application patterns

A computer system to search for at least one relationship pattern in a plurality of runtime artifacts, the computer system comprising:

• one or more processors, one or more computer-readable memories, one or more computer-readable tangible storage devices, and program instructions stored on at least one of the one or more storage devices for execution by at least one of the one or more processors via at least one of the one or more memories, wherein the computer system is capable of performing a method comprising:
• detecting at least one data manipulation statement in the plurality of runtime artifacts;
• extracting at least one relationship clause from the detected at least one data manipulation statement;
• parsing the extracted at least one relationship clause;
• generating at least one normalized syntax tree based on the parsed at least one relationship clause;
• and
• performing a classification and a snippet discovery on the generated at least one normalized syntax tree.

A computer program product, to search for at least one relationship pattern in a plurality of runtime artifacts, the computer program product comprising:

• one or more computer-readable storage devices and program instructions stored on at least one of the one or more tangible storage devices, the program instructions executable by a processor, the program instructions comprising:
• program instructions to detect at least one data manipulation statement in the plurality of runtime artifacts;
• program instructions to extract at least one relationship clause from the detected at least one data manipulation statement;
• program instructions to parse the extracted at least one relationship clause;
• program instructions to generate at least one normalized syntax tree based on the parsed at least one relationship clause;
• and
• program instructions to perform a classification and a snippet discovery on the generated at least one normalized syntax tree.