Stored Procedure Assessment Report via LeapLogic AI
This topic provides an overview of the Stored Procedure Assessment Report generated using LeapLogic AI. The report offers detailed insights into your stored procedure workloads by analyzing query structures, patterns, and complexity using advanced AI models such as Amazon Bedrock Claude, Nova Lite, and others.
These insights help you better understand your stored procedure inventory, highlight potential areas that may require optimization or refactoring, and support decision making during modernization or migration initiatives.
The AI generated report provides a clear, structured view of your workloads, making it easier to evaluate them, identify challenges, and plan the next steps efficiently.
In this Topic:
Highlights
The Highlights section provides a high‑level overview of the assessment performed on the selected workloads. It includes graphical summaries of query complexity and other workload attributes, along with an overall summary of the files analyzed.
Summary
This section presents an overview of the input files and the associated workload inventory. It includes details such as the total number of files, queries, procedures, functions, and entities identified during analysis.
Statement Types
This section displays a summary of the analyzed queries based on their statement types, showing how many queries fall under categories such as SELECT, UPDATE, DELETE, CREATE, DROP, INSERT, and OTHERS.
Complexity
This section provides a graphical representation of query complexity. The visualization helps in understanding the distribution of simple, medium, and complex queries, which can support decision making, including effort estimation or planning.
Downloadable Reports
Downloadable reports allow you to export detailed assessment reports of your source data which enables you to gain in-depth insights with ease. To access these assessment reports, click Reports.
Types of Reports
In the Reports section, you can see various types of reports such as Insights and Recommendations and Source Inventory Analysis. Each report type offers detailed information allowing you to explore your assessment results.
Insights and Recommendations
This report provides an in-depth insight into the source input files. It contains the final output including the details of queries, files, objects, tables, and so on.
Here, you can see the procedure folder along with LLM_REPORT.xlsx report.
LLM_REPORT.xlsx: This report provides insights about the source inventory. It helps you plan the next frontier of a modern data platform methodically. It includes aggregated inventory, files, procedure dependencies, pattern analysis, and more.
This report contains the following information:
- Volumetric Info: Lists an aggregated inventory of every source file. For instance, it provides information about the total number of files, lines of code, queries, loops, and a lot more.
- File_Summary: Provides information about files along with their size, total lines, total number of lines, procedures, functions, and more.
- Object_Inventory: Lists all the objects along with their type, complexity, parameters, and more.
- Code_Metrics: Provides information about code level metrics such as variables, cursors, loops, conditional statements, subqueries, joins, and other components extracted from the analyzed objects.
- Procedure_Dependency_Report: Provides information about procedure level dependencies, including called and calling procedures, shared tables, coupling level, and independence score.
- Table_Usage: Provides information about tables, including access patterns, usage contexts, schemas, and relationships.
- Missing_Artifacts: Provides information about missing objects along with their severity, impact, and more.
- Object_References: Provides information about objects, including their type, where they are defined, which objects reference them, procedure categories, and more.
- Code_Quality: Provides information about code quality scores and specific issues identified in each procedure.
- Pattern_Analysis: Provides information about patterns along their occurrences, affected procedures, severity, recommendations, and impact.
- Summary_of_Package_Objects: Provides information about package objects, including their lines of code, number of queries, complexity, and more.
- Query_Summary: Provides information about the MD5 query hash along with the query’s statement type, complexity, sample query, and more.
- Edges: Provides information about relationships between source and target objects, including their types and the type of the relationship.
To access llm_procedure_highlight.csv, Object_References.csv, Procedure_Dependency_Report.csv, Query_Summary.csv, and Summary_of_Package_Objects.csv, go to procedure folder.
llm_procedure_highlight.csv: This report provides high level highlights of the assessment, including total procedures, functions, queries, entities, and the distribution of low, medium, and high complexity queries by statement type.
Object_References.csv: This report provides information about objects, including their type, where they are defined, which objects reference them, procedure categories, and more.
Procedure_Dependency_Report.csv: This report provides information about procedure level dependencies, including called and calling procedures, shared tables, coupling level, and independence score.
Query_Summary.csv: This report provides information about the MD5 query hash along with the query’s statement type, complexity, sample query, and more.
Summary_of_Package_Objects.csv: This report provides information about package objects, including their lines of code, number of queries, complexity, and more.
Source Inventory Analysis
It is an intermediate report which helps to debug failures or calculate the final report. It includes all the generated csv reports.
Code_Metrics.csv: This report provides information about code level metrics such as variables, cursors, loops, conditional statements, subqueries, joins, and other components extracted from the analyzed objects.
Missing_Artifacts.csv: This report provides information about missing objects along with their severity, impact, and more.
Object_Inventory.csv: This report lists all the objects along with their type, complexity, parameters, and more.
Pattern_Analysis.csv: This report provides information about patterns along their occurrences, affected procedures, severity, recommendations, and impact.
Leaplogic