Overview

The Silk Central reporting data mart makes it easy to access data for reporting purposes. It moves data from the production tables into dedicated views which should be used for creating advanced reports. The advantages include:
  • Clear naming of tables and views, allowing you to quickly locate the data you are looking for.
  • Pre-processed data, giving you the possibility to access aggregated data without having to calculate it yourself.
  • Performance improvement, as reports can use much simpler and faster SQL queries.
  • Less dependency on production database load, which also improves performance and removes load spikes.
The current version of the data mart covers the results area. Further areas for reporting will be added to the data mart in future releases. The following tables and views are currently available:
  • The DM_TestStatus table is the basis for status-related views.
  • The RV_TestStatusExtended view provides detailed information for a certain test execution.
  • The RV_LatestTestStatus view provides status and extended information on the latest test run of a test within the context of a specific execution plan and build.
  • The RV_LatestFinishedTestStatus view provides status and extended information on the latest test run of a test within the context of a specific execution plan and build. This view provides similar information as the RV_LatestTestStatus view, but only for test runs within finished execution plan runs.
  • The RV_MaxTestRunID view is a helper to retrieve the latest test run ID for every test, execution plan, and build combination.
  • The RV_MaxFinishedTestRunID view is a helper to retrieve the latest test run ID for every test, execution plan, and build combination. This view provides similar information as the RV_MaxTestRunID view, but only for test runs from finished execution plan runs.
  • The RV_TestingCycleStatus view provides status information for testing cycles.
  • The RV_ExecutionPlanStatusPerBuild view retrieves the latest test status sums for every execution plan in context of builds.
  • The RV_EPFinishedStatusPerBuild view retrieves the latest test status sums for every execution plan in context of builds. This view provides similar information as the RV_ExecutionPlanStatusPerBuild view, but only for test runs from finished execution plan runs.
  • The RV_ExecutionPlanStatusRollup view retrieves the sums for passed, failed, and not-executed tests per execution plan or folder in context of a build.
  • The RV_EPFinishedStatusRollup view retrieves the sums for passed, failed, and not-executed tests per execution plan or folder in context of a build. This view provides similar information as the RV_ExecutionPlanStatusRollup view, but only for test runs from finished execution plan runs.
  • The RV_ConfigurationSuiteStatus view lists the status counts for all configuration suites and configurations per build.
  • The RV_ConfigSuiteFinishedStatus view lists the status counts for all configuration suites and configurations per build. This view provides similar information as the RV_ConfigurationSuiteStatus view, but only for test runs from finished execution plan runs.

You can download a .zip file with detailed information about the database schema of Silk Central. In the menu, click Help > Documentation and then click Silk Central Database Schema to download the .zip file.

Parent topic: The Reporting Data Mart