The Visual Expert Dashboard provides key application-level metrics, giving crucial information on code quality and maintenance requirements. It helps pinpoint potential problems, track progress and make data-driven decisions to ensure optimal code maintainability and reliability.
Code Clean Up
Visual Expert helps to clean up code by identifying dead code and duplicated functions, streamlining the code base. This helps improve maintainability and guarantees cleaner, more reliable applications.
Naming Rules
Visual Expert checks naming rules across the database and source code to ensure that all objects follow established coding standards and conventions.This feature ensures consistency, readability and easier code management, helping developers to understand the structure of the database/code and work more efficiently.
Continuous Code Inspection
Integrating Visual Expert into a CI/CD workflow enables automatic code inspection to detect anomalies, ensure compliance with programming standards and monitor code quality in real time. Early detection and resolution of problems such as code smells and vulnerabilities helps maintain a robust and reliable environment.
Cross References
Deep Impact Analysis
Visual Expert performs a comprehensive impact analysis across all referenced items, providing precise insights into dependencies and potential effects on tables, columns, procedures, variables, events, functions and other database/application objects.
CRUD Matrix
Visual Expert generates a 2-dimensional CRUD matrix, offering detailed visibility into Create, Read, Update, and Delete operations, while illustrating interactions and data flow across multiple tables and columns.
Object Dependency Matrix
This matrix provides a detailed view of the relationships and dependencies between tables, views, procedures and other database objects, enabling you to understand how changes may affect interconnected components.
Call Graphs
Visual Expert generates call graphs as tree views and diagrams, illustrating the hierarchy and flow of function calls, which is essential for understanding and optimizing complex code structures.
Performance Analysis
Find missing indexes
Visual Expert identifies queries with WHERE, GROUP BY, or HAVING clauses targeting tables without indexes. This helps developers prevent full table scans, ensuring the application runs more efficiently.
Find the slowest objects
Identify the slowest objects to systematically target and optimize resource-intensive operations,
and ensure that the most critical performance issues are addressed first.
Find bottlenecks
Identify bottlenecks in a chain of calls by visualizing the execution times of each element. This feature provides you with detailed insights into the execution flow, allowing you to pinpoint the components responsible for slow execution.
Source Code Documentation
HTML References Manuals
Schedule and automatically document the references in your code. Navigate between them using hyperlinks.
Share knowledge with teammates.
Code Review Reports
Automatically generate detailed code review reports for PowerBuilder, Oracle or SQL Server code, based on pre-defined rules.
Source Code Diagrams
Visualize objects and dependencies.
Diagrams and source code are synchronized.
Select objects to generate a diagram.
Visual Expert Videos
Watch these short videos to catch a glimpse of Visual Expert powerful features
Using VE's features allows a much quicker turnaround, reduces
expenses and frees up resources for more productive work.
- Project Manager
New York State Department of
Environmental Conservation
Become familiar with a new application in literally a few hours
(The) More you work with Visual Expert - more you understand
how convenient it is. (...) I cannot remember so powerful a tool
that allows a user to become familiar with a new application in
literally a few hours