SYSTEM AND METHOD FOR IDENTIFYING ISSUES IN DYNAMIC SQL FOR PROMOTING DYNAMIC SQL QUALITY

摘要

Disclosed is a system and method for identifying issues in dynamic SQL for promoting dynamic SQL quality. In one implementation, a framework is disclosed which can form all possible sets of queries based on input parameters of function/procedure and find any syntax issue, functional/performance hint related issue, query plan related issue and dynamic sql query plan comparison issue with other database for any query which is formed based on the input parameter combination defined for that database object. The framework stores all the sets along with an object name and other environment details with which the dynamic sql query plan needs to be compared and evaluated. The framework forms all the possible queries and report all the sql syntax issue, functional/performance hint related issue, query plan issue and dynamic sql query plan comparison issue with other database issues with the detailed information about the problem and reports the issues. (TO BE PUBLISHED WITH FIGURE 2 & 5)