Visual Expert Workshop

Review CRUD operations
(Create, Read, Update, Delete)

Generate a CRUD matrix, showing which objects access your data, and how.
For instance, which Procedures Create/Read/Update/Delete which Tables.

Generate diagrams from your code

Visualize objects and dependencies. Diagrams and source code are synchronized. Select objects to generate a diagram. Save, export and share your diagrams.

Analyze and improve code performance

Find the slowest procedures, functions, triggers. Break down the execution time of a large object into sub-queries or instructions. Decompose the performance of a chain of calls.

Explore complex chains of calls

Display callers and callees for procedures, tables, triggers... Explore all possible execution paths. Click on referenced items to see their definitions. Evaluate the effects of modifications.

Impact Analysis

Don't break your application after a change!
Discover what should be modified

• If I add a parameter to a function, what else is affected?
• If a table or column is changed, which code should I update...

Code Documentation

Schedule and automatically create HTML reference manuals.

Document the references in your code and navigate between these using hyperlinks. Share knowledge with teammates.

Code Comparison

A unique approach: application-wide comparisons based on the code structure.

Visualize the difference in a container hierarchy and drill down in the code.

Code Review

Cleanup the code. Streamline maintenance efforts. Avoid unexpected behavior.

Identify unused objects, empty methods, duplicates. oversized scripts, etc. Produce code metrics.