Relation Map

The Relation Map operator performs a select on two or more incoming relations, equivalent to a SQL join view of a minimum of one relation and additional tables and relations. The Relation Map operator can take multiple inputs.

You can use a Relation Map to join input from other operator sources, for example, from two or more tuple based windows, or from two or more partitioned windows.

For example, with the latest two-hour window of stock transactions and the latest two-hour window of trader information as input, you can compute the latest two-hour window of possible trades by joining the trader's name with the name provided in the trader information.

To Create a Relation Map Operator

1. Drag a Relation Map operator from the Palette to the Design view.

2. Connect at least two inputs to the Relation Map operator.

3. Double-click the Relation Map operator.

   The property editor opens.

4. In the Expression box, enter the expression for the SQL SELECT statement. Add attribute names, data types and sizes, as applicable. Add, delete, or move attributes.

5. In the From field, define the input on which to perform the selection.

6. In the Where clause field, provide additional search criteria.

7. Click OK.