SQL Queries - CAST Central Base - Queries on Metrics - How to get the list of items making up technical and business criteria

Purpose of Query

The purpose of this query on the central base is to provide a list of items that make up technical and business criteria. Generally, business criteria will be made up of technical criteria, and technical criteria will be made up of metrics.

Applicable CAST Version

Applicable RDBMS

Query for CSS

SELECT   DMTT.METRIC_PARENT_ID      AS PARENT_ID  ,
         DMD_PAR.METRIC_DESCRIPTION AS PARENT_NAME,
         DMTT.METRIC_ID             AS CHILD_ID   ,
         DMD.METRIC_DESCRIPTION     AS CHILD_NAME ,
         DMTT.AGGREGATE_WEIGHT                    ,
         DMTT.METRIC_CRITICAL AS CRITICAL_CONTRIBUTION
FROM     DSS_METRIC_TYPE_TREES DMTT ,
         DSS_METRIC_DESCRIPTIONS DMD,
         DSS_METRIC_DESCRIPTIONS DMD_PAR
WHERE    DMTT.METRIC_ID             =DMD.METRIC_ID
AND      DMD_PAR.METRIC_ID          =DMTT.METRIC_PARENT_ID
AND      DMD.DESCRIPTION_TYPE_ID    =0
AND      DMD.LANGUAGE               ='ENGLISH'
AND      DMD_PAR.DESCRIPTION_TYPE_ID=0
AND      DMD_PAR.LANGUAGE           ='ENGLISH'
ORDER BY DMTT.METRIC_PARENT_ID,
         DMTT.METRIC_ID

Query result example

60017;“Total Quality Index”;66068;“Efficiency - Expensive Calls in Loops”;10;0
60017;“Total Quality Index”;66069;“Programming Practices - Unexpected Behavior”;20;0
60017;“Total Quality Index”;66070;“Architecture - Architecture Models Automated Checks”;22;0
61001;“Architecture - Multi-Layers and Data Access”;610;“Avoid circular references between header files”;7;0
61001;“Architecture - Multi-Layers and Data Access”;614;“Avoid direct usage of database tables (C++)";8;1

Query result interpretation

The query returns the id of the parent, the name of the parent, the ids and names of the children, along with the weight and critical contribution of the children.

In the example results above, the business criterion Total Quality Index (TQI) is made up of several technical criteria such as ‘Programming Practices - Unexpected Behavior’, while the technical criterion ‘Architecture - Multi-Layers and Data Access’ is made up of several metrics such as ‘Avoid circular references between header files’

Query for Oracle

Enter the SQL query

Query result example

Query result interpretation

Query for SQL server

Enter the SQL query

Query result example

Query result interpretation

Notes/comments

Related Pages