AutoCollect - Creating User Defined DELTA Rowsets › Manipulating Delta Rowsets - User Created Delta Rowsets › Creating Delta Baseline Rowsets

Creating Delta Baseline Rowsets

AutoCollect also provides a facility to create Baseline rowsets. Baseline rowsets provide a different function from Summary rowsets.

As you were collecting and displaying data for performance monitoring, you have seen that it is useful to have a performance baseline to compare results.

In the preceding examples, we saw how a user could use the SUMMARY function to combine various Delta rowsets into weekly Summary rowsets for week-to-week comparison.

Once you have built a number of Delta rowsets that represent the summary of a weekly processing for normal periods. You may want to create a baseline of weekly performance to use for future comparisons. A baseline is typically an average of a set of similar time periods.

In this case, the baseline would represent a weekly baseline.

Note: When creating a baseline, the rows that are selected to be averaged must represent like periods of time. Selecting a set of Delta rowsets representing unequal periods of time may create a baseline that is not truly representative.

Once a baseline is created, it can be compared to new weekly statistics as they are created.

When doing performance tuning, making changes to the MUF, it is important to compare the performance after the change to the baseline of the performance from before the change.

In a different case, you may want to track the weekly performance, a baseline, from one month to the next month, or even one year to the next year. Summary and baseline rowsets can provide these functions without significant user interaction.

BASELINE Function Example

In the preceding SUMMARY Example 2, summary records were constructed for each of the four weeks in June, ending on July 2.

We can create a baseline rowset for the four weeks using the BASELINE function.

After completing the BASELINE run, you would have a new rowset inserted into the Delta tables.