Interactive CRUD Matrix - Visual Expert Web

Visual Expert Web's CRUD matrix offers a truly interactive interface where each cell becomes an entry point to further analysis. The user can instantly navigate from the result to the corresponding source code, execute macros and perform dynamic impact analyses through PL/SQL, T-SQL and PowerBuilder applications.

This feature is particularly useful when modifying a table: the developer immediately visualizes all the SQL statements and application components that will be affected by the change, thus considerably reducing the risk of errors during maintenance.

Why use a CRUD matrix?

  1. Data Impact Analysis
    Visualize how your application interacts with the database. Assess the potential impact of changes on data operations, whether they involve creating, reading, updating, or deleting data.
  2. Optimized Database Management
    Identify overused or underused database elements, ensuring efficient data flow and performance optimization.
  3. Improved Code Maintenance
    Map database operations directly to code components, making it easier to track and troubleshoot any code that interacts with the database.
  4. Compliance & Auditing
    Gain a clear view of how sensitive data is manipulated, ensuring adherence to data management policies and simplifying audits.

Step-by-Step Guide to Using the CRUD Matrix

  • Navigate to the Code Explorer section → Select the range of tables you wish to evaluate (e.g., Product > Person) → Under the Cross Reference section, click on CRUD Matrix.
    Code Explorer CRUD Matrix Tables
  • You will see the CRUD matrix results on the left side of the dashboard:
    Create → Adding new records or data entries into the database.
    Read → Retrieving existing data from the database.
    Update → Modifying or updating existing data.
    Delete → Removing data from the database, either permanently or temporarily.
    CRUD Matrix Results - VE Web

Exploring the CRUD Matrix Dashboard

  1. Full-Screen View
    Click the Open Full Matrix Results button (top-left corner) → Expand the page to view all matrix results.
    CRUD Matrix Results - VE Web
  2. Search Functionality
    Use the Search icon → Filter columns → Specify search criteria for tailored results.
    CRUD Matrix Results - VE Web
  3. Information Icon
    Click the Information icon → View detailed information about the selected calling item.
    CRUD Matrix Results - VE Web
    For instance, for d_ff_employee_general, you’ll see:
    • General Information
    • Container Hierarchy
    • DataWindow Columns
    • DataSource Details
    • DataWindow Details
    • Code Inspection
  4. Calling Item Details
    Click any calling item → View detailed information, including the source code → Run macros from the page for more analysis.
    CRUD Matrix Results - VE Web
  5. Quick Macros
    Right-click → Execute macros → Sort results by your preferred criteria.
    CRUD Matrix Results - VE Web

 

See Also

Visual Expert Web, Oracle, PowerBuilder, SQL Server, Code Explorer, CRUD Matrix, Cross References