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
and then click
Silk Central Database Schema to download the .zip file.