Performance Data Warehouse database architecture

Using the Tracking Group tables, the Business Performance Data Warehouse creates views to make the tracked data externally available for both IBM® Business Process Manager and third-party reports. When you query the Business Performance Data Warehouse database, you should query the Tracking Group and other views outlined in the following topics.

Tracking Group views
Tracking Group views contain the same data as the Tracking Group tables, which includes a column for each tracked variable and several columns to capture timing and other important task information.
SNAPSHOTS view
The SNAPSHOTS view contains one row for each snapshot defined in the Process Center Console.
TASKS view
The TASKS view contains one row for each task that is executed and an additional row for each BPD instance that is started.
TRACKINGGROUPS view
The TRACKINGGROUPS view contains one row for each tracking group defined in IBM BPM.
TIMINGINTERVALS view
The TIMINGINTERVALS view contains one row for every timing interval defined in the Process Designer. When autotracking is enabled, IBM BPM adds a timing interval for every activity in an autotracked BPD.
TIMINGINTERVALVALUE view
In the TIMINGINTERVALVALUE view, a row is recorded each time a timing interval is traversed. When autotracking is enabled, a row is recorded each time an autotracked task is executed.
TRACKEDFIELDS view
The TRACKEDFIELDS view contains one row for every tracked field defined in the Process Designer.
TRACKEDFIELDUSE view
In the TRACKEDFIELDUSE view, a row is recorded when a tracked field from a tracking group is used by a specific tracking point.
TRACKINGPOINTS view
The TRACKINGPOINTS view contains one row for every tracking point defined in the Process Designer. When autotracking is enabled, two tracking points are created for each autotracked activity in order to mark the beginning and end of a task.
TRACKINGPOINTVALUE view
In the TRACKINGPOINTVALUE view, a row is recorded each time a tracking point is traversed. When autotracking is enabled, there are two rows for every task that is executed, because autotracking defines start and end tracking points for each autotracked activity.
PROCESSFLOWS view
The PROCESSFLOWS view is an implicit tracking group view that captures the following values each time that a line is traversed in a BPD. This view is used primarily for the flow-traversal visualization modes in the Optimizer.
SLASTATUS view
The SLASTATUS view is an implicit tracking group view that tracks the status of each SLA as a result of an SLA roll-up.
SLATHRESHOLDTRAVERSALS view
The SLATHRESHOLDTRAVERSALS view is an implicit tracking group view that tracks a value whenever an activity with an attached SLA completes. An activity has an attached SLA if there is an SLA with a condition dependent on a metric of that activity.
LSW_VIEW view
The LSW_VIEW holds the data for all the views that are created for the tracking data. It provides a list of the views that are being managed by the Performance Server.

Parent topic: Creating and configuring reports