1 / 16

Matrix Diagrammer: Visualizing Entities and Functions

A comprehensive tool to display entities, functions, and their relationships in matrix form, facilitating data analysis and system design. Customize axes, apply filters, and manipulate display settings for efficient management and reporting. Save changes automatically and utilize broadcasting features for seamless collaboration.

fritz-cleveland
Download Presentation

Matrix Diagrammer: Visualizing Entities and Functions

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Using Matrixes for Cross-Checking

  2. Setting the Scene The ER Diagrammer shows all Entities and Relationships... … and the Function Hierarchy Diagrammer shows all business functions... … but I want to see both Entities and Functions... How about a matrix?

  3. column row third axis intersection(cell) The Matrix Diagrammer • A two-dimensional Repository object display tool • Is not like ERD, PM, or DFD • Can maintain definitions • Shows CRUD matrixes and many others

  4. Defining Both Matrix Axes • Choose both object types for the horizontal and vertical axes • Most of the primary access elements • Some secondary access elements • Choice of second object type depends on choice of first axis

  5. New Matrix Dialog Initial Appearance Choose Row Type Choose Column Type

  6. Settings Dialog

  7. Resulting Matrix

  8. Defining What is Displayed • Properties displayed per object type and intersection (cell) • Filters to reduce number of axis elements • Sort order of objects

  9. Modifying Display

  10. New View

  11. 1 1 Displaying Properties Row - Business Functions Column - Entities Intersection-FunctionEntity Usage Properties View Order Filter Lines LabelShort DefinitionMaster FunctionParent FunctionAtomic?Elementary?FrequencyResponse NeededIntention to AutomateApplication System A is null D =‘Y’ Resulting Pseudo-SQL: SELECT label, response_neededFROM business_functionsWHERE master_function IS NULLAND elementary? =‘Y’ORDER BY short_definition, atomic? desc

  12. Defining Filter Conditions • Limited, SQL-like criteria: • =, >, <, >=, <=, <> • IS NULL, IS NOT NULL • value1 and value2 • ‘A%’, ‘_MEM%’ • No ORs, only implicit ANDs • No Not Like

  13. Attributes Business Functions LINE NO RENTAL DATE C*** C*** CR** *R** *R** *R** CRU* **U* **U* RENTAL RENTAL ITEM REVIEW PUBLICATION entities Displaying a Third Axis PRICE PA Settings automatically shows Entities tab

  14. Uses of a Matrix • Data entry • Completeness checking • Design reporting • Impact analysis • Repository management • Progress reporting

  15. Saving the Matrix • Changes to data are saved automatically in the Repository. • Saving a matrix means saving the matrix settings. • A matrix is automatically requeried when opened. • Broadcast is available for axis elements.

  16. Summary • Matrix Diagrammer: • Display and compact reporting tool • Used for verification and correction of entries • Over 160 different matrixes • Over 40 3D matrixes

More Related