Querying Test Results

You can query test results for Confusion Matrix and Test Metrics from ODMR_USER_WF_CLAS_TEST_RESULTS and ODMR_USER_WF_REGR_TEST_RESULTS repository views.

You can query the test results from:

• ODMR_USER_WF_CLAS_TEST_RESULTS Repository View

• ODMR_USER_WF_REGR_TEST_RESULTS Repository View

This section contains examples to query the following:

• Query Test Metrics and Confusion Matrix results: Example 8-3

• Query Test Metrics: Example 8-4

• Query Confusion Matrix: Example 8-5

• Query Lift Table results: Example 8-6

Example 8-3 Querying Test Metrics and Confusion Matrix Results

SELECT TEST_METRICS, CONFUSION_MATRIX FROM ODMR_USER_WF_CLAS_TEST_RESULTS WHERE WORKFLOW_NAME = 'build_workflow' AND NODE_NAME = 'Class Build'

The output of this query is shown in the figure below. The query fetches the Test Metrics and Confusion Matrix from the ODMR_USER_WF_CLAS_TEST_RESULTS.

Figure 8-4 Query Output for Test Metrics and Confusion Matrix

Description of "Figure 8-4 Query Output for Test Metrics and Confusion Matrix"

Example 8-4 Querying TEST_METRICS

SELECT * FROM ODMR$18_51_18_106346IFHRNMF

The output of this query is shown in the screenshot below. It queries the Test Metrics ODMR$18_51_18_106346IFHRNMF. It fetches the Metric name, the metric VARCHAR value and the metric NUM value.

Figure 8-5 Query Output for TEST METRICS

Description of "Figure 8-5 Query Output for TEST METRICS"

Example 8-5 Querying CONFUSION_MATRIX

SELECT * FROM ODMR$18_51_17_954530VMUXPWL

The output of this query is shown in the screenshot below. It queries the Confusion Matrix ODMR$18_51_17_954530VMUXPWL. It fetches the actual target name, and the predicted target value.

Figure 8-6 Query Output for CONFUSION_MATRIX

Description of "Figure 8-6 Query Output for CONFUSION_MATRIX"

Example 8-6 Querying Lift Result Table from CLAS_SVM_MODEL_2

SELECT
MODEL_NAME, a.ATTRIBUTE_NAME "target value", a.VALUE "lift result table"
FROM
ODMR_USER_WF_CLAS_TEST_RESULTS, TABLE(LIFTS) a
WHERE
WORKFLOW_NAME = 'build_workflow' AND NODE_NAME = 'Class Build' AND ATTRIBUTE_NAME='Yes'

The output of this query is shown in the screenshot below. It queries the Lift Result table from the CLAS_SVM_MODEL_2.

Figure 8-7 Query Output for Lift Result Table from CLAS_SVM_MODEL_2

Description of "Figure 8-7 Query Output for Lift Result Table from CLAS_SVM_MODEL_2"