Using the Time Based Aggregator Operator Property Editor

See Also

The Time Based Aggregator operator performs statistical analysis within a specified amount of time which you provide as a Size, which is period of time over which you can perform a calculation,or the time slot. Increment specifies the frequency of the calculation; that is, how often you calculate the statistical analysis.

For example, you want to calculate a stock price's 20 day moving average. You can supply a Size of 20 in the Time Based Aggregator property editor, and an Increment that specifies often you want to perform that calculation; for example, once a day.

Statistics you can compute via SQL statements within the Property Editor of the Tuple Based Aggregator include:

To create a Time Based Aggregator operator:

  1. Drag a Time Based Aggregator operator from the Palette to the Design view.
  2. Double-click the Time Based Aggregator operator icon. The property editor opens.
  3. In the Start field, enter the time to start calculating the tasks that are to be performed by the Time Based Aggregator within the process.
  4. In the Increment field, enter the time increment for the Time Based Aggregator to perform the analysis.
  5. In the Size field, enter the time range for the Time Based Aggregator to perform the analysis.
  6. In the Expression box, enter the expression for the SQL Select statement to specify the input attribute upon which the Select is performed. Add attribute names, data types. and sizes, as applicable.
  7. In the From box, define the input on which to perform the selection.
  8. In the Where clause box, provide additional filtering on records, for example, WHERE price > 30.00 AND stockDate < '2006-01-01' ;
  9. In the Group by box, group a result into subsets that have matching values for one or more columns of the database by specifying a comma-separated list of qualified attribute names.
  10. Click OK.
See Also
 
Using the Tuple Based Aggregator Operator Property Editor

Legal Notices