1 / 16

Using Matrixes for Cross-Checking

Using Matrixes for Cross-Checking. 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?. column. row. third axis.

fritz-cleveland
Télécharger la présentation

Using Matrixes for Cross-Checking

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