Detecting logical relationships based on structured query statements

A computer-implemented method, comprising:

• receiving a plurality of structured query statements associated with an application and a database;
• detecting a logical relationship between at least two of the plurality of structured query statements based on a common source, a predetermined threshold time, and a common transaction;
• generating a model based on the detected logical relationship;
• receiving a request to modify the database;
• and
• modifying the database in response to detecting that a predetermined threshold probability of application functionality impairment is not exceeded.

A computer program product for detecting logical relationships between structured query statements, the computer program product comprising a computer-readable storage medium having program code embodied therewith, wherein the computer readable storage medium is not a transitory signal per se, the program code executable by a processor to cause the processor to:

• receive a plurality of structured query statements associated with an application and a database;
• detect a logical relationship between at least two of the plurality of structured query statements based on a common source of the at least two of the plurality of structured query statements, a predetermined threshold time between the at least two of the plurality of structured query statements, and a common transaction associated with the at least two of the plurality of structured query statements;
• generate a model based on the detected logical relationship;
• receive a request to modify the database;
• and
• modify the database in response to detecting that a predetermined threshold probability of application functionality impairment is not exceeded.