2 Application Tasks

2.2.2.1 Channel Properties

Figure 2-4 shows the General tab for a channel stage.

Figure 2-4 General Tab for Channel Stage

Description of "Figure 2-4 General Tab for Channel Stage"

After you click Edit, you can modify the attributes that Table 2-1 describes.

For more information, see "channel" in the Oracle CEP IDE Developer's Guide for Eclipse.

2.2.2.2 Channel Properties: Outbound Channel

Figure 2-5 shows the General tab for an outbound channel stage (a channel stage with an upstream Oracle CQL processor). The Channel Parameter accordion tab is selected.

Figure 2-5 General Tab Outbound Channel Parameters

Description of "Figure 2-5 General Tab Outbound Channel Parameters "

After you click Edit, you can modify the attributes that Table 2-2 describes.

Figure 2-6 shows the General tab for a channel stage (with an upstream Oracle CQL processor). The Selectors accordion tab is selected.

Figure 2-6 General Tab Selectors for Outbound Channel Stage

Description of "Figure 2-6 General Tab Selectors for Outbound Channel Stage "

The Selector tab is only applicable if the up-stream node is an Oracle CQL processor.

After you click Edit, use the Selector tab, you can specify which up-stream Oracle CQL processor queries are permitted to output their results to the channel:

1. Select an up-stream Oracle CQL processor from the Processor pull-down menu.

   The available Oracle CQL rules associated with the selected processor are listed below the pull-down menu.

2. Use the left and right-pointing arrow buttons to move one or more rules to the Selected Queries list.

   Only rules in the Selected Queries list will output events to the channel.

For more information, see "channel" in the Oracle CEP IDE Developer's Guide for Eclipse.

2.2.2.3 Stream Properties

Figure 2-7 shows the General tab for a stream stage.

Figure 2-7 General Tab for Channel Stage

Description of "Figure 2-7 General Tab for Channel Stage"

After you click Edit, you can modify the attributes that Table 2-3 describes.

2.2.2.4 Oracle CQL Processor Properties

Table 2-3 shows the General tab for an Oracle CQL processor stage.

Figure 2-8 General Tab for Oracle CQL Processor Stage

Description of "Figure 2-8 General Tab for Oracle CQL Processor Stage"

There are no editable properties for this type of stage.

For more information, see "processor (Oracle CQL)" in the Oracle CEP IDE Developer's Guide for Eclipse.

2.2.2.5 EPL Processor Properties

Figure 2-9 shows the General tab for an EPL processor stage.

Figure 2-9 General Tab for EPL Processor Stage

Description of "Figure 2-9 General Tab for EPL Processor Stage"

There are no editable properties for this type of stage.

For more information, see "processor (EPL)" in the Oracle CEP IDE Developer's Guide for Eclipse.

2.2.2.6 Adapter Properties

Figure 2-10 shows the General tab for an adapter stage.

Figure 2-10 General Tab for an Adapter Stage

Description of "Figure 2-10 General Tab for an Adapter Stage"

There are no editable properties for this type of stage.

For more information, see "adapter" in the Oracle CEP IDE Developer's Guide for Eclipse.

2.2.2.7 JMS Adapter Properties

Figure 2-12 shows the General tab for a JMS adapter.

Figure 2-11 General Tabl for a JMS Adapter Stage

Description of "Figure 2-11 General Tabl for a JMS Adapter Stage"

There are no editable properties for this type of stage.

For more information, see "adapter" in the Oracle CEP IDE Developer's Guide for Eclipse.

2.2.2.8 Event Bean Properties

Figure 2-12 shows the General tab for an event bean stage.

Figure 2-12 General Tab for Event Bean Stage

Description of "Figure 2-12 General Tab for Event Bean Stage"

There are no editable properties for this type of stage.

For more information, see "event-bean" in the Oracle CEP IDE Developer's Guide for Eclipse.

2.2.2.9 POJO Properties

Figure 2-13 shows the General tab for a Plain Old Java Object (POJO) stage.

Figure 2-13 General Tab for POJO Stage

Description of "Figure 2-13 General Tab for POJO Stage"

There are no editable properties for this type of stage.

2.2.2.10 Cache Properties: Oracle CEP Local Cache

Figure 2-14 shows the properties for an Oracle CEP Local Cache stage.

Figure 2-14 Oracle CEP Local Cache Stage Properties

Description of "Figure 2-14 Oracle CEP Local Cache Stage Properties"

After you click Edit, you can modify the attributes that Table 2-4 describes.

For more information, see "cache" in the Oracle CEP IDE Developer's Guide for Eclipse.

2.2.2.11 Cache Properties: Oracle Coherence Cache

Figure 2-15 shows the properties for an Oracle Coherence Cache stage.

Figure 2-15 Oracle Coherence Cache Stage Properties

Description of "Figure 2-15 Oracle Coherence Cache Stage Properties"

There are no editable properties for this type of stage.

For more information, see:

• Section 3.8.5, "How to Monitor an Oracle Coherence Cache"

• Section 3.8.6, "How to Tune Oracle Coherence"

• "coherence-cache-config" in the Oracle CEP IDE Developer's Guide for Eclipse

2.2.3.1 How to Record Events

Using Oracle CEP Visualizer you can record events for a selected stage. Later, you can playback these events (see Section 2.2.3.2, "How to Playback Events").

To record events:

1. In the left pane, navigate to and expand the Applications node of the Oracle CEP instance to which the application is deployed.

2. Select appname, where appname is the name of the application you want to record and playback events with.

3. In the right pane, click the Event Processing Network tab.

   The Event Processor Network panel is displayed as Figure 2-16 shows.

   Figure 2-16 Event Processing Network Panel

   
   Description of "Figure 2-16 Event Processing Network Panel"
   
   

4. Select the stage for which you wish to record an event:

   1. To use the EPN diagram:

      • Right-click the stage for which you wish to record an event and select Record Event.

   2. To use the domain tree:

      • Expand the appname > Stages node, where appname is the name of the application you want to record and playback events with.

      • Click the stage for which you wish to record an event.

      • In the right pane, click the Record tab

   The Record panel appears as shown in Figure 2-17.

   Figure 2-17 The Record Tab

   
   Description of "Figure 2-17 The Record Tab"
   
   

   The Record tab in Oracle CEP Visualizer for a particular stage is divided into the following sections:

   • Recording Current Status: displays the current status of a recording. When the system has begun a recording session, then this field displays a blinking Recording message and it changes back to blank when the recording sessions ends. This section is read-only.

   • Recording Parameters: specifies the name of the database schema (Dataset name) and the provider information. You must pre-configure the provider for the event repository.

     For more information, see:

     • "Storing Events in the Persistent Event Store" in the Oracle CEP IDE Developer's Guide for Eclipse

     • Section 3.7, "Managing the Persistent Event Store"

   • Event Type List: contains the Event Type List pane that displays the list of event types that are associated with a selected stage of the Oracle CEP application. Choose one or more events to record.

   • Record Schedule Entry: entries in this table displays the recording start time and end time for an event type. The fields in this table are disabled by default. Click Update Record to enable the fields in this table. The start and end time entries are optional fields, to start recording immediately, click the Start Recording button at the bottom of the panel.

   • Change Recording Schedule: allows you to change some of the properties of your existing recording entry. Certain properties, such as the event type, cannot be changed using Oracle CEP Visualizer. Use the calendar and clock controls to specify or change an existing start and end time for recording events.

5. Decide what you want to do:

   1. To add a new record schedule entry, click Add.

   2. To modify an existing record schedule entry, select the entry in the Record Schedule Entry table and click Edit.

   3. To delete an existing record schedule entry, select the entry in the Record Schedule Entry table and click Delete.

6. Configure the Recording Parameters:

   • DataSet Name: the value of the record-parameters child element dataset-name element from the simpleEventSource adapter application configuration file ORACLE-CEP-HOME\ocep_11.1\samples\domains\recplay_domain\defaultserver\applications\recplay\config.xml as Example 2-1 shows.

     Example 2-1 recplay Application Configuration File config.xml: adapter Element

     <adapter>
         <name>simpleEventSource</name>
         <record-parameters>
             <dataset-name>recplay_sample</dataset-name>
             <event-type-list>
                 <event-type>SimpleEvent</event-type>
             </event-type-list>
             <provider-name>test-rdbms-provider</provider-name>
             <batch-size>1</batch-size>
             <batch-time-out>10</batch-time-out>
         </record-parameters>
     </adapter>
     

   • Provider Name: the value of the rdbms-event-store-provider child element name which corresponds to the data-source child element name as Example 2-2 shows.

     Example 2-2 recplay Oracle CEP Server Configuration File config.xml: data-source and rdbms-event-store-provider Elements

     <data-source>
         <name>derby1</name>
         <connection-pool-params>
             <initial-capacity>15</initial-capacity>
             <max-capacity>50</max-capacity>
         </connection-pool-params>
         <driver-params>
             <url>jdbc:derby:dbtest1;create=true</url>
             <driver-name>org.apache.derby.jdbc.EmbeddedDriver</driver-name>
         </driver-params>
     </data-source>
     <rdbms-event-store-provider>
         <name>test-rdbms-provider</name>
         <data-source-name>derby1</data-source-name>
     </rdbms-event-store-provider>
     

     For more information, see Section 3.4, "Managing Data Sources".

7. Configure the Event type list:

   Use the left and right-pointing arrow buttons to move the events you want recorded from the Available event list to the Recorded event list.

   For more information, see Section 3.6, "Managing the Event Type Repository".

8. Decide when you want recording to start and end:

   1. If you want to schedule a record start and end time:

      • Click the calendar and clock controls to add a start time and end time.

      • Click Save.

        An alert dialog appears as Figure 2-18 shows.

        Figure 2-18 Record Schedule Confirmation Dialog

        
        Description of "Figure 2-18 Record Schedule Confirmation Dialog"
        
        

      • Click OK.

   2. If you want to record events immediately:

      • Click Save.

        An alert dialog appears as Figure 2-18 shows.

        Figure 2-19 Record Schedule Confirmation Dialog

        
        Description of "Figure 2-19 Record Schedule Confirmation Dialog"
        
        

      • Click OK.

      • Click Start.

   Oracle CEP Visualizer keeps track of whether a particular stage is currently recording or playing back events; based on this information, the Start and End buttons may be enabled or disabled as appropriate.

   When you start recording using Oracle CEP Visualizer, Oracle CEP uses the event type information from your record entry and begins recording immediately; the pre-scheduled time, if any, remains unchanged. Use the End button to stop recording of your session immediately.

9. Decide when you want to stop recording:

   1. If you scheduled a stop time, event recording will stop at that time.

   2. If you want to stop event recording immediately, click Stop.

2.2.3.2 How to Playback Events

Using Oracle CEP Visualizer you can playback previously recorded events (see Section 2.2.3.2, "How to Playback Events") for a selected stage.

To playback events:

1. In the left pane, navigate to and expand the Applications node of the Oracle CEP instance to which the application is deployed.

2. Select appname, where appname is the name of the application you want to record and playback events with.

3. In the right pane, click the Event Processing Network tab.

   The Event Processor Network panel is displayed as Figure 2-20 shows.

   Figure 2-20 Event Processing Network Panel

   
   Description of "Figure 2-20 Event Processing Network Panel"
   
   

4. Select the stage for which you wish to playback an event:

   1. To use the EPN diagram:

      • Right-click the stage for which you wish to record an event and select Playback Event.

   2. To use the domain tree:

      • Expand the appname > Stages node, where appname is the name of the application you want to record and playback events with.

      • Click the stage for which you wish to record an event.

      • In the right pane, click the Playback tab

   The Record panel appears as shown in Figure 2-21.

   Figure 2-21 The Playback Tab

   
   Description of "Figure 2-21 The Playback Tab"
   
   

   The Playback tab in Oracle CEP Visualizer for a particular stage is divided into the following sections:

   • Playback Current Status: displays the current status of playback. When the system has begun playing back a session, then this field displays a blinking Playback message and it changes back to blank when the playback session ends. This section is read-only.

   • Playback Parameters: specifies the name of the database schema (Dataset name) and the provider information. You must pre-configure the provider for the event repository.

     For more information, see:

     • "Storing Events in the Persistent Event Store" in the Oracle CEP IDE Developer's Guide for Eclipse

     • Section 3.7, "Managing the Persistent Event Store"

   • Event Type List: contains the Event Type List pane that displays the list of event types that are associated with a selected stage of the Oracle CEP application. Choose one or more events to playback.

   • Playback Filter Entry: specify a set of filters using the clock and time controls, to run a playback for an event type in event type repository. Only events that were recorded during the start and end times you specify here will be played back.

   • Playback Schedule Entry: entries in this table displays the playback start time and end time for an event type. The fields in this table are disabled by default. Click Update Playback to enable the fields in this table. The start and end time entries are optional fields, to start recording immediately, click the Start Playback button at the bottom of the panel.

   • Change Playback Filter Parameters: allows you to change some of the properties of the selected playback filter entry.

   • Change Playback Schedule Parameters: allows you to change some of the properties of the selected playback schedule entry. Use the calendar and clock controls to specify or change an existing start and end time for playing back events.

5. Configure the Playback Parameters:

   • DataSet Name: the value of the record-parameters child element dataset-name element from the simpleEventSource adapter application configuration file ORACLE-CEP-HOME\ocep_11.1\samples\domains\recplay_domain\defaultserver\applications\recplay\config.xml as Example 2-3 shows.

     Example 2-3 recplay Application Configuration File config.xml: stream Element

     <stream>
         <name>eventStream</name>
         <playback-parameters>
             <dataset-name>recplay_sample</dataset-name>
             <event-type-list>
                 <event-type>SimpleEvent</event-type>
             </event-type-list>
             <provider-name>test-rdbms-provider</provider-name>
         </playback-parameters>
         <max-size>10000</max-size>
         <max-threads>2</max-threads>
     </stream> 
     

   • Provider Name: the value of the rdbms-event-store-provider child element name which corresponds to the data-source child element name as Example 2-4 shows.

     Example 2-4 recplay Oracle CEP Server Configuration File config.xml: data-source and rdbms-event-store-provider Elements

     <data-source>
         <name>derby1</name>
         <connection-pool-params>
             <initial-capacity>15</initial-capacity>
             <max-capacity>50</max-capacity>
         </connection-pool-params>
         <driver-params>
             <url>jdbc:derby:dbtest1;create=true</url>
             <driver-name>org.apache.derby.jdbc.EmbeddedDriver</driver-name>
         </driver-params>
     </data-source>
     <rdbms-event-store-provider>
         <name>test-rdbms-provider</name>
         <data-source-name>derby1</data-source-name>
     </rdbms-event-store-provider>
     

     For more information, see Section 3.4, "Managing Data Sources".

6. Configure the Event type list:

   Use the left and right-pointing arrow buttons to move the events you want played back from the Available event list to the Playback event list.

   For more information, see Section 3.6, "Managing the Event Type Repository".

7. Decide what you want to do:

   1. To add a new playback schedule entry, click Add.

   2. To modify an existing playback filter entry, select the entry in the Playback Filter Entry table and click Edit.

   3. To modify an existing playback schedule entry, select the entry in the Playback Schedule Entry table and click Edit.

   4. To delete an existing playback filter or schedule entry, select the entry in the appropriate table and click Delete.

8. Decide when you want playback to start and end:

   1. If you want to create a new playback filter entry:

      • Click the calendar and clock controls in the Change Playback Filter Parameters area to add a start time and end time.

      • Click Save.

        An alert dialog appears as Figure 2-22 shows.

        Figure 2-22 Playback Schedule Confirmation Dialog

        
        Description of "Figure 2-22 Playback Schedule Confirmation Dialog"
        
        

      • Click OK.

   2. If you want to create a new playback schedule entry:

      • Click the calendar and clock controls in the Change Playback Schedule Parameters area to add a start time and end time and to specify a speed and repeat mode.

        Speed: the default speed value is 1, which corresponds to normal speed. A value of 2 means that events will be played back 2 times faster than the original record speed. Similarly, a value of 0.5 means that events will be played back at half the speed.

        Repeat: set this to true to repeat playback until the scheduled end time or until you stop playback manually; set this to false to playback only once.

      • Click Save.

        An alert dialog appears as Figure 2-23 shows.

        Figure 2-23 Playback Schedule Confirmation Dialog

        
        Description of "Figure 2-23 Playback Schedule Confirmation Dialog"
        
        

      • Click OK.

   3. If you want to playback events immediately:

      • Click Save.

        An alert dialog appears as Figure 2-18 shows.

        Figure 2-24 Playback Schedule Confirmation Dialog

        
        Description of "Figure 2-24 Playback Schedule Confirmation Dialog"
        
        

      • Click OK.

      • Click Start.

   Oracle CEP Visualizer keeps track of whether a particular stage is currently recording or playing back events; based on this information, the Start and End buttons may be enabled or disabled as appropriate.

   When you start playback using Oracle CEP Visualizer, Oracle CEP uses the event type information from your playback entry and begins playback immediately; the pre-scheduled time, if any, remains unchanged. Use the End button to stop playback session immediately.

9. Decide when you want to stop playback:

   1. If you scheduled a stop time, event playback will stop at that time.

   2. If you want to stop event playback immediately, click Stop.

2.4.6.1 Configuring an RSource CQL Construct

The RSource Oracle CQL construct represents an Oracle CQL relation that your Oracle CEP application provides or a relation type of view that you create. To create a stream type of source, an SSource, see Section 2.4.6.2, "Configuring an SSource CQL Construct".

For more information and detailed syntax, see:

• "Streams and Relations" in the Oracle CEP CQL Language Reference

• "Queries, Views, and Joins" in the Oracle CEP CQL Language Reference

• "Oracle CQL Statements" in the Oracle CEP CQL Language Reference

To configure an RSource CQL construct:

1. Double click the RSource icon as Figure 2-58 shows.

   Figure 2-58 RSource Icon

   
   

   The RSource editor dialog appears as Figure 2-59 shows.

   Figure 2-59 Query Wizard RSource Editor Dialog

   
   Description of "Figure 2-59 Query Wizard RSource Editor Dialog"
   
   

2. Edit the dialog as Table 2-8 describes.

   Table 2-8 Query Wizard RSource Editor Attributes

   Attribute	Description
   Type	Select the type of source: Relation: select this option to process events offered by a relation (query) currently running on this Oracle CQL processor. View: select this option to process events offered by a view currently running on this Oracle CQL processor.
   Select a source	Select the relation or view to use as the source of events.
   As	Optionally specify an alias for this source.
   Source Properties	Read-only list of the properties of the event offered by this source.
   Generated CQL Statement	Read-only Oracle CQL fragment associated with this CQL Construct.

   
   

3. Click the Validate button to ensure that your changes are syntactically correct.

   Correct any errors before proceeding.

4. Click Save.

   The RSource icon displays a green check mark to indicate that it is configured.

2.4.6.2 Configuring an SSource CQL Construct

The SSource Oracle CQL construct represents an Oracle CQL stream that your Oracle CEP application provides or a stream type of view you create. To create a relation type of source, an RSource, see Section 2.4.6.1, "Configuring an RSource CQL Construct".

For more information and detailed syntax, see:

• "Streams and Relations" in the Oracle CEP CQL Language Reference

• "Queries, Views, and Joins" in the Oracle CEP CQL Language Reference

• "Oracle CQL Statements" in the Oracle CEP CQL Language Reference

To configure an SSource CQL construct:

1. Double click the SSource icon as Figure 2-58 shows.

   Figure 2-60 SSource Icon

   
   

   The SSource editor dialog appears as Figure 2-59 shows.

   Figure 2-61 Query Wizard Source Editor Dialog

   
   Description of "Figure 2-61 Query Wizard Source Editor Dialog"
   
   

2. Edit the dialog as Table 2-8 describes.

   Table 2-9 Query Wizard Source Editor Attributes

   Attribute	Description
   Type	Select the type of source: Stream: select this option to process events offered by a stream provided by your Oracle CEP application. View: select this option to process events offered by a view currently running on this Oracle CQL processor.
   Select a source	Select the stream or view to use as the source of events.
   As	Optionally specify an alias for this source.
   Source Properties	Read-only list of the properties of the event offered by this source.
   Generated CQL Statement	Read-only Oracle CQL fragment associated with this CQL Construct.

   
   

3. Click the Validate button to ensure that your changes are syntactically correct.

   Correct any errors before proceeding.

4. Click Save.

   The Source icon displays a green check mark to indicate that it is configured.

2.4.6.3 Configuring a Cache-Table CQL Construct

The Cache-Table CQL construct represents an external relation, usually a pull data source, that a cache or relational database table provides. The only operation that is allowed on the Cache-Table CQL construct is a join with another stream source using the Now window.

For more information, see:

• "Configuring Access to a Relational Database" in the Oracle CEP Administrator's Guide

• "Configuring an Oracle CQL Processor Table Source" in the Oracle CEP IDE Developer's Guide for Eclipse

• "Configuring Caching" in the Oracle CEP IDE Developer's Guide for Eclipse

• "Configuring an Oracle CQL Processor Cache Source" in the Oracle CEP IDE Developer's Guide for Eclipse

• "Oracle Continuous Query Language (CQL) Example" in the Oracle CEP Getting Started

• Section 2.4.6.6, "Configuring a Join CQL Construct"

• Section 2.4.6.7, "Configuring a Window CQL Construct"

To configure a Cache-Table CQL construct:

1. Double click the Cache-Table icon as Figure 2-62 shows.

   Figure 2-62 Cache-Table Icon

   
   

   The Cache-Table editor dialog appears as Figure 2-63 shows.

   Figure 2-63 Query Wizard Cache-Table Editor Dialog

   
   Description of "Figure 2-63 Query Wizard Cache-Table Editor Dialog"
   
   

2. Edit the dialog as Table 2-10 describes.

   Table 2-10 Query Wizard Cache-Table Editor Attributes

   Attribute	Description
   Select a source	Select the cache to use as the source of events.
   As	Optionally specify an alias for this source.
   Source Properties	Read-only list of the properties of the event offered by this source.
   Generated CQL Statement	Read-only Oracle CQL fragment associated with this CQL Construct.

   
   

3. Click Save.

   The Cache-Table icon displays a green check mark to indicate that it is configured.

2.4.6.4 Configuring a Pattern CQL Construct

The Pattern Oracle CQL construct represents the Oracle CQL MATCH_RECOGNIZE condition. The MATCH_RECOGNIZE condition is the principle means of performing complex event processing. Using its various clauses, you can succinctly express complex conditions among stream elements to perform advanced comparisons optimized for data streams.

The Pattern Oracle CQL construct editor provides a tab for each of the following MATCH_RECOGNIZE sub-clauses:

• PATTERN: Use this clause to specify quantifiers that constrain and control when conditions in the DEFINE clause match.

  See Figure 2-65, "Query Wizard Pattern Editor Dialog: Pattern Tab".

• DEFINE: Use this clause to specify one or more conditions. Specify one or more patterns made up of a pattern identifier, the AS operator, and a condition. The condition can use any stream elements in the schema of the stream, view, or sliding window specified by the identifier you used in your query or view select statement.

  See Figure 2-66, "Query Wizard Pattern Editor Dialog: Define Tab".

• SUBSET: Using this clause, you can bind a name to the stream elements that one or more patterns select. You can use this named subset in the MEASURE and DEFINE clauses.

  See Figure 2-67, "Query Wizard Pattern Editor Dialog: Subset Tab".

• MEASURE: Use this clause to define expressions in a MATCH_RECOGNIZE condition and to bind stream elements that match conditions in the DEFINE clause to arguments that you can include in the select statement of a query. You can use any of the Oracle CQL built-in or user-defined functions.

  See Figure 2-68, "Query Wizard Pattern Editor Dialog: Measure Tab".

For more information and detailed syntax, see:

• "MATCH_RECOGNIZE Condition" in the Oracle CEP CQL Language Reference

• "PATTERN Clause" in the Oracle CEP CQL Language Reference

• "DEFINE Clause" in the Oracle CEP CQL Language Reference

• "SUBSET Clause" in the Oracle CEP CQL Language Reference

• "MEASURES Clause" in the Oracle CEP CQL Language Reference

• "Functions" in the Oracle CEP CQL Language Reference

• "Oracle CQL Statements" in the Oracle CEP CQL Language Reference

To configure a Pattern CQL construct:

1. Double click the Pattern icon as Figure 2-64 shows.

   Figure 2-64 Pattern Icon

   
   

   The Pattern editor dialog appears as Figure 2-65 shows.

   Figure 2-65 Query Wizard Pattern Editor Dialog: Pattern Tab

   
   Description of "Figure 2-65 Query Wizard Pattern Editor Dialog: Pattern Tab"
   
   

2. Edit the Pattern tab as Table 2-11 describes.

   Table 2-11 Query Wizard Pattern Editor Attributes: Pattern Tab

   Attribute	Description
   Pattern Expression	Use this clause to specify quantifiers that constrain and control when conditions in the DEFINE clause match. For example: (A B* C) Table 2-12 lists the pattern quantifiers Oracle CQL supports. Use the pattern quantifiers to specify the allowed range of pattern matches. The one-character pattern quantifiers are maximal or "greedy"; they will attempt to match the biggest quantity first. The two-character pattern quantifiers are minimal or "reluctant"; they will attempt to match the smallest quantity first. For more information, see "PATTERN Clause" in the Oracle CEP CQL Language Reference.
   Duration	By default, Oracle CEP updates the output relation at the time it recognizes a pattern match. Enter a duration value to specify a time delay between when Oracle CEP recognizes a pattern match and when it updates the output relation. You can use either of the following: When you specify a duration like 10, each time Oracle CEP recognizes a pattern match, it delays the specified time interval before updating the output relation. If no input matches the pattern, Oracle CEP does not update the output relation When you specify a duration like MULTIPLES OF 10, each time Oracle CEP recognizes a pattern match, it delays the specified time interval before updating the output relation. If no input matches the pattern or if no input is received, Oracle CEP still updates the output relation. In this case, some terms in the selection may be null and aggregate values may be reset. For more information, see "DURATION Clause" in the Oracle CEP CQL Language Reference.
   Partition By	Use this optional clause to specify the stream elements by which a MATCH_RECOGNIZE clause should partition its results. You can reference any stream elements in the schema of the stream, view, or sliding window specified by the identifier you used in the query or view select statement. To add a stream element to the partition by list, select a stream element from the pull-down menu and click the Add button. To remove a stream element from the partition by list, click the Undo button. For more information, see "PARTITION BY Clause" in the Oracle CEP CQL Language Reference.
   Pattern Alias	Specifies the relation_variable clause AS operator to define an alias to label the immediately preceding expression in the select list so that you can reference the result by that name. The alias effectively renames the select list item for the duration of the query. Specifying a pattern alias of its would correspond to the following example: <query id="detectPerish"><![CDATA[ select its.itemId as badItem from ItemTempStream MATCH_RECOGNIZE ( PARTITION BY ... MEASURES ... PATTERN ... DEFINE ... ) as its ]]></query> For more information, see "Aliases in the relation_variable Clause" in the Oracle CEP CQL Language Reference.
   All Matches	Check this option to configure Oracle CEP to match overlapping patterns. Uncheck this option to configure Oracle CEP to match only one pattern. For more information, see "ALL MATCHES Clause" in the Oracle CEP CQL Language Reference.
   Generated CQL Statement	Editable Oracle CQL fragment associated with this CQL Construct.

   
   

   Table 2-12 Pattern Quantifiers

   Maximal	Minimal	Description
   *	*?	0 or more times
   +	+?	1 or more times.
   ?	??	0 or 1 time.

   
   

   For more information, see "PATTERN Clause" in the Oracle CEP CQL Language Reference.

3. Click the Define tab.

   The Define tab appears as Figure 2-66 shows.

   Figure 2-66 Query Wizard Pattern Editor Dialog: Define Tab

   
   Description of "Figure 2-66 Query Wizard Pattern Editor Dialog: Define Tab"
   
   

4. Edit the Define tab as Table 2-12 describes.

   Table 2-13 Query Wizard Pattern Editor Attributes: Define Tab

   Attribute	Description
   Object Name	Enter an object name as you specified in the Pattern Expression attribute of the Pattern tab (see Table 2-11). For example, if the pattern expression is: (A B* C) Then create a definition for each of A, B, and C.
   AS	Define an expression by clicking the Expression Builder button. For example: A AS (A.temp >= 25) B AS ((B.temp >= 25) and (B.element_time - A.element_time < INTERVAL "0 00:00:05:00" DAY TO SECOND)) C AS (C.element_time - A.element_time >= INTERVAL "0 00:00:05:00" DAY TO SECOND) For more information, see Section 2.4.6.16, "Configuring an Expression Using the Expression Builder".
   Object List	A list of the definitions you specify. To add a definition to the Object List, click the Add button. To remove a definition from the Object List, click the Delete button.
   Generated CQL Statement	Read-only Oracle CQL fragment associated with this CQL Construct.

   
   

   For more information, see "DEFINE Clause" in the Oracle CEP CQL Language Reference.

5. Click the Subset tab.

   The Subset tab appears as Figure 2-67 shows.

   Figure 2-67 Query Wizard Pattern Editor Dialog: Subset Tab

   
   Description of "Figure 2-67 Query Wizard Pattern Editor Dialog: Subset Tab"
   
   

6. Edit the Subset tab as Table 2-14 describes.

   Table 2-14 Query Wizard Pattern Editor Attributes: Subset Tab

   Attribute	Description
   Subset name	Enter a name for the subset.
   AS	Enter a list of the object names as you specified in the Pattern Expression attribute of the Pattern tab (see Table 2-11). For example, given the following pattern: (A W+ X+ Y+ Z+) You could define subsets such as: S1 AS (Z) S2 AS (A) S3 AS (A,W,Y)
   Subset List	A list of the subsets you specify. To add a subset to the Subset List, click the Add button. To remove a subset from the Subset List, click the Delete button.
   Generated CQL Statement	Read-only Oracle CQL fragment associated with this CQL Construct.

   
   

   For more information, see "SUBSET Clause" in the Oracle CEP CQL Language Reference.

7. Click the Measure tab.

   The Measure tab appears as Figure 2-68 shows.

   Figure 2-68 Query Wizard Pattern Editor Dialog: Measure Tab

   
   Description of "Figure 2-68 Query Wizard Pattern Editor Dialog: Measure Tab"
   
   

8. Edit the Measure tab as Table 2-15 describes.

   Table 2-15 Query Wizard Pattern Editor Attributes: Measure Tab

   Attribute	Description
   Object Name	Enter an object name as you specified in the Pattern Expression attribute of the Pattern tab (see Table 2-11) or Subset name attribute of the Subset tab (see Figure 2-67). For example, if the pattern expression is: (A B* C) Then you could create a measure for any of A, B, and C. If you define subsets: S1 AS (Z) S2 AS (A) S3 AS (A,W,Y) Then you could create a measure for any of S1, S2, and S3.
   AS	Define an expression by clicking the Expression Builder button. For example: sumDecrArm as sum(S3.c2) For more information, see Section 2.4.6.16, "Configuring an Expression Using the Expression Builder".
   Measure List	A list of the measures you specify. To add a measure to the Properties list, click the Add button. To remove a measure from the Properties list, click the Delete button.
   Generated CQL Statement	Read-only Oracle CQL fragment associated with this CQL Construct.

   
   

   For more information, see "MEASURES Clause" in the Oracle CEP CQL Language Reference.

9. Click the Validate button to ensure that your changes are syntactically correct.

   Correct any errors before proceeding.

10. Click Save.

    The Pattern icon displays a green check mark to indicate that it is configured.

2.4.6.5 Configuring a Select CQL Construct

The Select Oracle CQL construct represents the Oracle CQL SELECT clause. For information on representing the WHERE clause, see Section 2.4.6.8, "Configuring a Filter CQL Construct".

The Select Oracle CQL construct editor provides a tab for each of the following sub-clauses:

• select_clause: Use this clause to specify the stream elements to select from the stream or view you specify.

  See Figure 2-70, "Query Wizard Select Editor Dialog: Project Tab".

• opt_group_by_clause: Use this clause to specify optional grouping conditions your query applies to its results.

  See Figure 2-71, "Query Wizard Select Editor Dialog: Group Tab".

• opt_having_clause:Use this clause to restrict the groups of returned stream elements to those groups for which the specified condition is TRUE. If you omit this clause, then Oracle CEP returns summary results for all groups.

  See Figure 2-72, "Query Wizard Select Editor Dialog: Condition Tab".

• order_by_clause: Use this clause to specify optional ordering conditions your query applies to its results.

  See Figure 2-73, "Query Wizard Select Editor Dialog: Order Tab".

For more information, see:

• "Select, From, Where Block" in the Oracle CEP CQL Language Reference

• "select_clause" in the Oracle CEP CQL Language Reference

• "opt_group_by_clause" in the Oracle CEP CQL Language Reference

• "opt_having_clause" in the Oracle CEP CQL Language Reference

• "order_by_clause" in the Oracle CEP CQL Language Reference

• "Oracle CQL Statements" in the Oracle CEP CQL Language Reference

To configure a Select CQL construct:

1. Double click the Select icon as Figure 2-69 shows.

   Figure 2-69 Select Icon

   
   

   The Select editor dialog appears as Figure 2-70 shows.

   Figure 2-70 Query Wizard Select Editor Dialog: Project Tab

   
   Description of "Figure 2-70 Query Wizard Select Editor Dialog: Project Tab"
   
   

2. Edit the Project tab as Table 2-16 describes.

   The general procedure is:

   1. Select a Source.

   2. Select a Target event type.

   3. Double click a property in the Properties list to add the property to the Project expression field.

   4. Click the Expression Builder button and create a Project expression.

   5. In the AS field, enter an alias for the project expression result or select one of the Target event type attributes.

   6. Click the Add button.

      To remove a project expression, select it in the Project predicates list and click Delete.

   7. Optionally, check Distinct.

   Table 2-16 Query Wizard Select Editor Attributes: Project Tab

   Attribute	Description
   Distinct	Check this option if you want Oracle CEP to return only one copy of each set of duplicate tuples selected. Uncheck this option if you want Oracle CEP to return all tuples selected, including duplicates. Duplicate tuples are those with matching values for each expression in the select list. Oracle CEP does not support nested aggregations.
   Target event type	Select or input the name of the event expected by the down-stream channel you connected to this Oracle CQL processor. For more information, see "Event Types" in the Oracle CEP IDE Developer's Guide for Eclipse
   Source	Select the name of the stream, relation, or view Source CQL Construct that you connected to this Project CQL construct. For more information, see Section 2.4.6.1, "Configuring an RSource CQL Construct".
   Properties	Read-only list of the properties of the event offered by this source. For more information, see Section 2.4.6.1, "Configuring an RSource CQL Construct".
   Project Predicates	A list of the project expressions you define. To add a project expression to the Project Predicates list, click the Add button. To remove a project expression from the Project Predicates list, select the project expression in the Project Predicates list and click the Delete button.
   Project Expressions	Define an expression by clicking the Expression Builder button. For example: LENGTH( FxQuoteStream.symbol < 100 ) For more information, see Section 2.4.6.16, "Configuring an Expression Using the Expression Builder".
   AS	Enter an alias for the project expression result or select one of the Target event type attributes.
   Generated CQL Statement	Read-only Oracle CQL fragment associated with this CQL Construct.

   
   

   For more information, see "select_clause" in the Oracle CEP CQL Language Reference.

3. Click the Group tab.

   The Group tab editor dialog appears as Figure 2-70 shows.

   Figure 2-71 Query Wizard Select Editor Dialog: Group Tab

   
   Description of "Figure 2-71 Query Wizard Select Editor Dialog: Group Tab"
   
   

4. Edit the Group tab as Table 2-17 describes.

   The general procedure is:

   1. Select a source from the pull down menu.

   2. Select a property in the Properties list.

   3. To add the selected property to the Grouping properties list, click the Add button.

      To remove a property from the Grouping properties list, select the property in the Grouping properties list and click the Delete button.

   Table 2-17 Query Wizard Select Editor Attributes: Group Tab

   Attribute	Description
   Select a source	Select a source from the pull-down menu.
   Properties	The properties of the event offered by the selected source.
   Grouping Properties	A list of the grouping properties you define. To add the selected property to the Grouping properties list, click the Add button. To remove a property from the Grouping properties list, select the property in the Grouping properties list and click the Delete button.
   Generated CQL Statement	Editable Oracle CQL fragment associated with this CQL Construct.

   
   

   For more information, see "opt_group_by_clause" in the Oracle CEP CQL Language Reference.

5. Click the Condition tab.

   The Condition tab editor dialog appears as Figure 2-70 shows.

   Figure 2-72 Query Wizard Select Editor Dialog: Condition Tab

   
   Description of "Figure 2-72 Query Wizard Select Editor Dialog: Condition Tab"
   
   

6. Edit the Condition tab as Table 2-18 describes.

   Table 2-18 Query Wizard Select Editor Attributes: Condition Tab

   Attribute	Description
   Having Predicate	Define an expression by entering a having predicate directly or clicking the Expression Builder button. For example: lastPrice > 500 For more information, see Section 2.4.6.16, "Configuring an Expression Using the Expression Builder". To add a condition expression to the generated CQL statement, click the Add button. To remove the condition expression from the generated CQL statement, click the Delete button.
   Generated CQL Statement	Editable Oracle CQL fragment associated with this CQL Construct.

   
   

   For more information, see "opt_having_clause" in the Oracle CEP CQL Language Reference.

7. Click the Order tab.

   The Order tab editor dialog appears as Figure 2-70 shows.

   Figure 2-73 Query Wizard Select Editor Dialog: Order Tab

   
   Description of "Figure 2-73 Query Wizard Select Editor Dialog: Order Tab"
   
   

8. Edit the Order tab as Table 2-19 describes.

   The general procedure is:

   1. Select a source from the pull down menu.

   2. Select a property in the Properties list.

   3. To add the selected property to the Ordering properties list, click the Add button.

      To remove a property from the Ordering properties list, select the property in the Ordering properties list and click the Delete button.

   Table 2-19 Query Wizard Select Editor Attributes: Order Tab

   Attribute	Description
   Select a source	Select a source from the pull-down menu.
   Properties	The properties of the event offered by the selected source.
   Ordering Properties	A list of the ordering properties you define. To add the selected property to the Ordering properties list, click the Add button. To remove a property from the Ordering properties list, select the property in the Ordering properties list and click the Delete button.
   Generated CQL Statement	Editable Oracle CQL fragment associated with this CQL Construct.

   
   

   For more information, see "order_by_clause" in the Oracle CEP CQL Language Reference.

9. Click the Validate button to ensure that your changes are syntactically correct.

   Correct any errors before proceeding.

10. Click Save.

    The Select icon displays a green check mark to indicate that it is configured.

2.4.6.6 Configuring a Join CQL Construct

The Join Oracle CQL construct represents an Oracle CQL join between two or more sources. You can create inner joins and left and right outer joins.

For more information, see:

• "Joins" in the Oracle CEP CQL Language Reference

• "Oracle CQL Statements" in the Oracle CEP CQL Language Reference

To configure a Join CQL construct:

1. Double click the Join icon as Figure 2-74 shows.

   Figure 2-74 Join Icon

   
   

   The Join editor dialog appears as Figure 2-75 shows.

   Figure 2-75 Query Wizard Join Editor Dialog

   
   Description of "Figure 2-75 Query Wizard Join Editor Dialog"
   
   

2. Edit the dialog as Table 2-20 describes.

   Table 2-20 Query Wizard Join Editor Attributes

   Attribute	Description
   Source 1	Select the first source to join.
   Properties	Read-only list of properties of Source 1.
   Source 2	Select the second source to join.
   Properties	Read-only list of properties of Source 2.
   Join Type	Select the type of join: No outer join: select this option to create a simple join. For more information, see "Inner Joins" in the Oracle CEP Visualizer User's Guide. Left outer join: select this option to create a left outer join. For more information, see "Left Outer Joins" in the Oracle CEP Visualizer User's Guide. Right outer join: select this option to create a right outer join. For more information, see "Right Outer Joins" in the Oracle CEP Visualizer User's Guide.
   Join Predicate	Create the Join Predicate by doing either of the following: Click the Plus Sign button to create the join predicate using the Source 1 and Source 2 properties you select. Click the Expression Builder button to create the join predicate using any of the Source 1 and Source 2 properties and Oracle CQL functions and operators.
   Generated CQL Statement	Editable Oracle CQL fragment associated with this CQL Construct.

   
   

3. Select a source from the Source 1 pull-down menu.

4. Select a source from the Source 2 pull-down menu.

5. Select a property in the Source 1 Properties list to join on.

6. Select a property in the Source 2 Properties list to join on.

7. Choose the Join Type.

8. Create the Join Predicate by doing either of the following:

   1. Click the Plus Sign button to create the join predicate using the Source 1 and Source 2 properties you select.

   2. Click the Expression Builder button to create the join predicate using any of the Source 1 and Source 2 properties and Oracle CQL functions and operators.

9. To add the join predicate to the generated CQL statement, click the Add Join button.

10. To remove the join predicate from the generated CQL statement, click the Undo Join button.

11. Click the Validate button to ensure that your changes are syntactically correct.

    Correct any errors before proceeding.

12. Click Save.

    The Join icon displays a green check mark to indicate that it is configured.

2.4.6.7 Configuring a Window CQL Construct

The Window Oracle CQL construct represents an Oracle CQL stream-to-relation operator.

For more information, see:

• "Stream-to-Relation Operators (Windows)" in the Oracle CEP CQL Language Reference

• "Oracle CQL Statements" in the Oracle CEP CQL Language Reference

To configure a Window CQL construct:

1. Double click the Window icon as Figure 2-76 shows.

   Figure 2-76 Window Icon

   
   

   The Window editor dialog appears as Figure 2-77 shows.

   Figure 2-77 Query Wizard Window Editor Dialog

   
   Description of "Figure 2-77 Query Wizard Window Editor Dialog"
   
   

2. Edit the dialog as Table 2-21 describes.

   Table 2-21 Query Wizard Window Editor Attributes

   Attribute	Description
   Partition List	Select one or more stream elements to add to the partition list if you want to create a partitioned window. To remove stream elements from the Partition List, click and drag to select the values in the Partition List and press the Delete key on your keyboard.
   Type	The type of window to create: Now: Select this option to create a time-based range window that defines its output relation such that, when T = 0, the relation at time t consists of tuples obtained from elements of S with timestamp t. For more information, see "S[now]" in the Oracle CEP CQL Language Reference. Time: Select this option to create a time-based range window that defines its output relation over time by sliding an interval of size T time units capturing the latest portion of an ordered stream. Elements that have been in the window for more than T time units are subject to deletion. In this case, the range and slide are equal. For more information, see "S[range T]" in the Oracle CEP CQL Language Reference. Optionally, specify a time-based slide for this window using the Slide attribute. Row: Select this option to create a tuple-based window that defines its output relation over time by sliding a window of the last N tuples of an ordered stream. For the output relation R of S [rows N], the relation at time t consists of the N tuples of S with the largest timestamps <= t (or all tuples if the length of S up to t is <= N). For more information, see "S[rows N]" in the Oracle CEP CQL Language Reference. Optionally, specify a row-based slide for this window using the Slide attribute. Partition: Select this option to create any of the following partitioned windows: "S [partition by A1,..., Ak rows N]" in the Oracle CEP CQL Language Reference "S [partition by A1,..., Ak rows N range T]" in the Oracle CEP CQL Language Reference The Partition type is inactive unless you add one or more stream elements to the Partition List. Optionally, specify a time-based slide for this window using the Slide attribute. Unbounded: Select this option to create a time-based range window defines its output relation such that, when T = infinity, the relation at time t consists of tuples obtained from all elements of S up to t. Elements remain in the window indefinitely. For more information, see "S[range unbounded]" in the Oracle CEP CQL Language Reference.
   Slide	Specify a sliding window: Row Based: Select this option to create any of the following row-based sliding windows: "S[rows N1 slide N2]" in the Oracle CEP CQL Language Reference Time Based: Select this option to create any of the following time-based sliding windows: "S[range T1 slide T2]" in the Oracle CEP CQL Language Reference "S [partition by A1,..., Ak rows N range T1 slide T2]" in the Oracle CEP CQL Language Reference
   Generated CQL Statement	Editable Oracle CQL fragment associated with this CQL Construct.

   
   

3. If you want a partitioned window, select the stream elements you want in the Partition List.

   To remove stream elements from the Partition List, click and drag to select the values in the Partition List and press the Delete key on your keyboard.

4. Select the Type.

   The Partition type is inactive unless you add one or more stream elements to the Partition List.

5. Select Row Based or Time Based for the selected type.

6. Enter the size of the window:

   1. For a Row Based type, enter a number of rows (tuples or stream elements).

   2. For a Time Based type, enter a number of time units and select the time unit.

7. Select a Slide:

   1. For a Row Based type, enter a number of rows (tuples or stream elements).

   2. For a Time Based type, enter a number of time units and select the time unit.

8. Click the Validate button to ensure that your changes are syntactically correct.

   Correct any errors before proceeding.

9. To add the window to the generated CQL statement, click the Add Window button.

10. Click Save.

    The Window icon displays a green check mark to indicate that it is configured.

2.4.6.8 Configuring a Filter CQL Construct

The Filter Oracle CQL construct represents an Oracle CQL WHERE clause. For information on representing the SELECT and FROM clauses, see Section 2.4.6.5, "Configuring a Select CQL Construct".

For more information, see:

• "opt_where_clause" in the Oracle CEP CQL Language Reference

• "Oracle CQL Statements" in the Oracle CEP CQL Language Reference

To configure a Filter CQL construct:

1. Double click the Filter icon as Figure 2-78 shows.

   Figure 2-78 Filter Icon

   
   

   The Filter editor dialog appears as Figure 2-79 shows.

   Figure 2-79 Query Wizard Filter Editor Dialog

   
   Description of "Figure 2-79 Query Wizard Filter Editor Dialog"
   
   

2. Edit the dialog as Table 2-22 describes.

   Table 2-22 Query Wizard Filter Editor Attributes

   Attribute	Description
   Filter Predicate	Define an expression by entering a filter predicate directly or clicking the Expression Builder button. For example: SUM( FxQuoteStream.lastPrice < 5000 ) For more information, see Section 2.4.6.16, "Configuring an Expression Using the Expression Builder". To add the filter predicate to the generated CQL statement, click the Add Filter button. To remove the filter predicate from the generated CQL statement, click the Delete Filter button.
   Generated CQL Statement	Editable Oracle CQL fragment associated with this CQL Construct.

   
   

3. Define the filter predicate by doing one of the following:

   1. Enter the filter predicate directly.

   2. Click the Expression Builder button.

      For more information, see Section 2.4.6.16, "Configuring an Expression Using the Expression Builder".

4. To add a condition expression to the generated CQL statement, click the Add Filter button.

5. To remove the condition expression from the generated CQL statement, click the Delete Filter button.

6. Click the Validate button to ensure that your changes are syntactically correct.

   Correct any errors before proceeding.

7. Click Save.

   The Source icon displays a green check mark to indicate that it is configured.

2.4.6.9 Configuring a Union CQL Construct

The Union Oracle CQL construct represents an Oracle CQL UNION or UNION ALL clause. You can perform a union between two relations; relation can be emitted either from a view or a channel. You can perform a union between two relations or two streams. You cannot perform a union between a relation and a stream.

For more information, see:

• "binary" in the Oracle CEP CQL Language Reference

• "BINARY Example: UNION and UNION ALL" in the Oracle CEP CQL Language Reference

• "Oracle CQL Statements" in the Oracle CEP CQL Language Reference

To configure a Union CQL construct:

1. Double click the Union icon as Figure 2-80 shows.

   Figure 2-80 Union Icon

   
   

   The Union editor dialog appears as Figure 2-81 shows.

   Figure 2-81 Query Wizard Union Editor Dialog

   
   Description of "Figure 2-81 Query Wizard Union Editor Dialog"
   
   

2. Edit the dialog as Table 2-23 describes.

   Table 2-23 Query Wizard Union Editor Attributes

   Attribute	Description
   Source 1	Select the first source to union.
   Properties	Read-only list of properties of Source 1.
   Source 2	Select the second source to union.
   Properties	Read-only list of properties of Source 2.
   Union Type	Select the type of union: Union: select this to create a UNION statement. Union All: select this option to create a UNION ALL statement. For more information, see "BINARY Example: UNION and UNION ALL" in the Oracle CEP CQL Language Reference.
   Generated CQL Statement	Editable Oracle CQL fragment associated with this CQL Construct.

   
   

3. Select a source from the Source 1 pull-down menu.

4. Select a source from the Source 2 pull-down menu.

5. Choose the Union Type.

6. To add the union clause to the generated CQL statement, click the Add Union button.

7. To remove the union clause from the generated CQL statement, click the Undo Union button.

8. Click the Validate button to ensure that your changes are syntactically correct.

   Correct any errors before proceeding.

9. Click Save.

   The Union icon displays a green check mark to indicate that it is configured.

2.4.6.10 Configuring an Intersect CQL Construct

The Intersect Oracle CQL construct represents an Oracle CQL INTERSECT clause. You can perform an intersect between two relations. You cannot perform an intersect between a relation and a stream or between two streams.

For more information, see:

• "binary" in the Oracle CEP CQL Language Reference

• "BINARY Example: INTERSECT" in the Oracle CEP CQL Language Reference

• "Oracle CQL Statements" in the Oracle CEP CQL Language Reference

To configure an Intersect CQL construct:

1. Double click the Intersect icon as Figure 2-82 shows.

   Figure 2-82 Intersect Icon

   
   

   The Intersect editor dialog appears as Figure 2-83 shows.

   Figure 2-83 Query Wizard Intersect Editor Dialog

   
   Description of "Figure 2-83 Query Wizard Intersect Editor Dialog"
   
   

2. Edit the dialog as Table 2-24 describes.

   Table 2-24 Query Wizard Intersect Editor Attributes

   Attribute	Description
   Source 1	Select the first source to intersect.
   Properties	Read-only list of properties of Source 1.
   Source 2	Select the second source to intersect.
   Properties	Read-only list of properties of Source 2.
   Generated CQL Statement	Editable Oracle CQL fragment associated with this CQL Construct.

   
   

3. To add the intersect clause to the generated CQL statement, click the Add Intersect button.

4. To remove the intersect clause from the generated CQL statement, click the Undo Intersect button.

5. Click the Validate button to ensure that your changes are syntactically correct.

   Correct any errors before proceeding.

6. Click Save.

   The Intersect icon displays a green check mark to indicate that it is configured.

2.4.6.11 Configuring a Minus CQL Construct

The Minus Oracle CQL construct represents an Oracle CQL MINUS clause. You can perform a minus between two relations. You cannot perform a minus between a relation and a stream or between two streams.

For more information, see:

• "binary" in the Oracle CEP CQL Language Reference

• "BINARY Example: MINUS" in the Oracle CEP CQL Language Reference

• "Oracle CQL Statements" in the Oracle CEP CQL Language Reference

To configure a Minus CQL construct:

1. Double click the Intersect icon as Figure 2-84 shows.

   Figure 2-84 Minus Icon

   
   

   The Minus editor dialog appears as Figure 2-85 shows.

   Figure 2-85 Query Wizard Minus Editor Dialog

   
   Description of "Figure 2-85 Query Wizard Minus Editor Dialog"
   
   

2. Edit the dialog as Table 2-25 describes.

   Table 2-25 Query Wizard Minus Editor Attributes

   Attribute	Description
   Source 1	Select the first source to minus.
   Properties	Read-only list of properties of Source 1.
   Source 2	Select the second source to minus.
   Properties	Read-only list of properties of Source 2.
   Generated CQL Statement	Editable Oracle CQL fragment associated with this CQL Construct.

   
   

3. To add the minus clause to the generated CQL statement, click the Add Minus button.

4. To remove the minus clause from the generated CQL statement, click the Undo Minus button.

5. Click the Validate button to ensure that your changes are syntactically correct.

   Correct any errors before proceeding.

6. Click Save.

   The Minus icon displays a green check mark to indicate that it is configured.

2.4.6.12 Configuring an IStream CQL Construct

The IStream Oracle CQL construct represents an Oracle CQL IStream relation-to-stream operator. Istream (for "Insert stream") applied to a relation R contains (s,t) whenever tuple s is in R(t) - R(t-1), that is, whenever s is inserted into R at time t. If a tuple happens to be both inserted and deleted with the same timestamp then IStream does not output the insertion.

For more information, see:

• "IStream Relation-to-Stream Operator" in the Oracle CEP CQL Language Reference

• "Streams and Relations" in the Oracle CEP CQL Language Reference

• "Oracle CQL Statements" in the Oracle CEP CQL Language Reference

To configure an IStream CQL construct:

1. Double click the IStream icon as Figure 2-86 shows.

   Figure 2-86 IStream Icon

   
   

   The IStream editor dialog appears as Figure 2-87 shows.

   Figure 2-87 Query Wizard IStream Editor Dialog

   
   Description of "Figure 2-87 Query Wizard IStream Editor Dialog"
   
   

2. Edit the dialog as Table 2-26 describes.

   Table 2-26 Query Wizard IStream Editor Attributes

   Attribute	Description
   Generated CQL Statement	Wrap the editable Oracle CQL fragment associated with this CQL Construct in: IStream()

   
   

3. Click the Validate button to ensure that your changes are syntactically correct.

   Correct any errors before proceeding.

4. Click Save.

   The IStream icon displays a green check mark to indicate that it is configured.

2.4.6.13 Configuring a DStream CQL Construct

The DStream Oracle CQL construct represents an Oracle CQL DStream relation-to-stream operator. Dstream (for "Delete stream") applied to a relation R contains (s,t) whenever tuple s is in R(t-1) - R(t), that is, whenever s is deleted from R at time t.

For more information, see:

• "DStream Relation-to-Stream Operator" in the Oracle CEP CQL Language Reference

• "Streams and Relations" in the Oracle CEP CQL Language Reference

• "Oracle CQL Statements" in the Oracle CEP CQL Language Reference

To configure a DStream CQL construct:

1. Double click the DStream icon as Figure 2-88 shows.

   Figure 2-88 DStream Icon

   
   

   The DStream editor dialog appears as Figure 2-89 shows.

   Figure 2-89 Query Wizard DStream Editor Dialog

   
   Description of "Figure 2-89 Query Wizard DStream Editor Dialog"
   
   

2. Edit the dialog as Table 2-27 describes.

   Table 2-27 Query Wizard DStream Editor Attributes

   Attribute	Description
   Generated CQL Statement	Wrap the editable Oracle CQL fragment associated with this CQL Construct in: DStream()

   
   

3. Click the Validate button to ensure that your changes are syntactically correct.

   Correct any errors before proceeding.

4. Click Save.

   The Dstream icon displays a green check mark to indicate that it is configured.

2.4.6.14 Configuring an RStream CQL Construct

The RStream Oracle CQL construct represents an Oracle CQL RStream relation-to-stream operator. The RStream operator maintains the entire current state of its input relation and outputs all of the tuples as insertions at each time step. Since Rstream outputs the entire state of the relation at every instant of time, it can be expensive if the relation set is not very small.

For more information, see:

• "RStream Relation-to-Stream Operator" in the Oracle CEP CQL Language Reference

• "Streams and Relations" in the Oracle CEP CQL Language Reference

• "Oracle CQL Statements" in the Oracle CEP CQL Language Reference

To configure an RStream CQL construct:

1. Double click the RStream icon as Figure 2-90 shows.

   Figure 2-90 RStream Icon

   
   

   The RStream editor dialog appears as Figure 2-91 shows.

   Figure 2-91 Query Wizard RStream Editor Dialog

   
   Description of "Figure 2-91 Query Wizard RStream Editor Dialog"
   
   

2. Edit the dialog as Table 2-28 describes.

   Table 2-28 Query Wizard RStream Editor Attributes

   Attribute	Description
   Generated CQL Statement	Wrap the editable Oracle CQL fragment associated with this CQL Construct in: RStream()

   
   

3. Click the Validate button to ensure that your changes are syntactically correct.

   Correct any errors before proceeding.

4. Click Save.

   The RStream icon displays a green check mark to indicate that it is configured.

2.4.6.15 Configuring an Output CQL Construct

The Output Oracle CQL construct represents the complete Oracle CQL query or view. Using the Output CQL construct, you can:

• Review and edit the complete Oracle CQL statement.

• Create a copy of the Oracle CQL statement and inject it into the Oracle CQL processor under a different name. This is a convenient way of duplicating and modifying an existing statement when you need to create multiple statements that share a common structure.

• Convert between a view and query.

For more information, see:

• "Queries, Views, and Joins" in the Oracle CEP CQL Language Reference

• "Oracle CQL Statements" in the Oracle CEP CQL Language Reference

To configure an Output CQL construct:

1. Double click the Output icon as Figure 2-92 shows.

   Figure 2-92 Output Icon

   
   

   The Output editor dialog appears as Figure 2-93 shows.

   Figure 2-93 Query Wizard Output Editor Dialog

   
   Description of "Figure 2-93 Query Wizard Output Editor Dialog"
   
   

2. Edit the dialog as Table 2-29 describes.

   Table 2-29 Query Wizard Output Editor Attributes

   Attribute	Description
   Type	The type of rule: Query: An Oracle CQL query is an operation that you express in Oracle CQL syntax and execute on an Oracle CQL Processor to process data from one or more streams or views. View: An Oracle CQL view represents an alternative selection on a stream or relation. In Oracle CQL, you use a view instead of a subquery. For more information, see "Queries, Views, and Joins" in the Oracle CEP CQL Language Reference.
   Query Name	The name of the query.
   Enable	Set this option to true to run the rule immediately after saving. Set this option to false to not run the rule after saving. A view cannot be enabled or disabled. If the query that uses a view is enabled, then the view is also enabled. If the query that uses a view is disabled, then the view is effectively disabled.
   View Name	The name of the view.
   View Schema	Editable list of the properties you specify in the SELECT clause. If you edit the generated CQL statement to add or remove properties from the SELECT clause, you must make the same change to the View Schema.
   Project List	Read-only list of the properties you specify in the SELECT clause.
   Generated CQL Statement	Editable Oracle CQL fragment associated with this CQL Construct.

   
   

3. To inject a new instance of the entire Oracle CQL rule into the Oracle CQL processor:

   1. If you are creating a new rule, Click Inject Rule.

      A new instance of the Oracle CQL rule is now visible on the Oracle Rules tab.

   2. If you are modifying an existing rule:

      • Click in the Query Name or View Name field and change the query or view name.

      • Click Inject Rule.

      A new instance of the Oracle CQL rule is now visible on the Oracle Rules tab with the new name.

4. To replace an existing instance of the entire Oracle CQL rule in the Oracle CQL processor, click Replace Rule.

   The existing instance of the Oracle CQL rule is updated on the Oracle Rules tab with the existing name.

5. Click the Validate button to ensure that your changes are syntactically correct.

   Correct any errors before proceeding.

6. Click Save.

   The Output icon displays a green check mark to indicate that it is configured.

2.4.6.16 Configuring an Expression Using the Expression Builder

You can use the Query Wizard Expression Builder to construct an expression using various Oracle CQL operators, expressions, built-in single-row and aggregate functions, and user-defined functions.

For more information, see:

• "Arithmetic Operators" in the Oracle CEP CQL Language Reference

• "Concatenation Operator" in the Oracle CEP CQL Language Reference

• "Expressions" in the Oracle CEP CQL Language Reference

• "Functions" in the Oracle CEP CQL Language Reference

To configure an expression using the Expression Builder:

1. Click the Expression Builder button on the CQl construct editor dialog.

   The Expression Builder dialog appears. Figure 2-94 shows the Expression Builder after clicking the Expression Builder button in the Pattern construct editor.

   Figure 2-94 Query Wizard Expression Builder

   
   Description of "Figure 2-94 Query Wizard Expression Builder"
   
   

2. Edit the dialog as Table 2-29 describes.

   Table 2-30 Query Wizard Expression Builder Attributes

   Attribute	Description
   Expression Builder	Editable field that contains the expression.
   Variables	Select a source from the Variables pull-down menu to list the properties it provides in the Properties list. Double-click a property to select it and add it to the Expression Builder at the current insertion point.
   Functions	Select a function category from the Functions pull-down menu to list the functions it provides in the Functions list. Select a function to see its syntax in the Function Description field. Double-click a function to select it and add it to the Expression Builder at the current insertion point.
   Operands	Double-click an operand to select it and add it to the Expression Builder at the current insertion point.
   Function Description	Read-only field that shows the syntax for the currently selected function.

   
   

3. Select a source from the Variables pull-down menu.

4. Select a function category from the Functions pull-down menu.

5. Double-click a function to select it and add it to the Expression Builder.

6. Double-click a property to select it and make it the argument of the function.

7. Use your mouse to position the insertion bar after the closing bracket of the function.

8. Double click an operand to select it and add it to the Expression Builder.

9. Double-click another property or type in a literal value in the Expression Builder.

10. To undo an operation, click the Undo button.

11. To redo an operation, click the Redo button.

12. To clear the Expression Builder, click the Erase button.

13. Click Save to save the expression and return to the CQL construct editor dialog.

2.4.8.1 Choose Layout

Use the Choose Layout pull-down menu to select alternate ways of distributing CQL constructs and showing their dependencies. You can choose any of:

• Left-Right

• Bottom-Top

• Right-Left

• Top-Bottom

2.4.8.2 Clear Canvas

Click the Clear Canvas button to erase the current Oracle CQL statement and its diagram from the Query Wizard canvas.

2.4.8.3 Save Query

Click the Save Query button at any time (even if you have not yet completed your Oracle CQL statement) to save your work to your local disk instead of the host.

2.4.8.4 Open Query

Click the Open Query button to reload a previously saved query.

2.4.8.5 Hover

Check the Hover option to display the Oracle CQL statement fragment associated with a given stage when you hover your mouse pointer over that stage.

Uncheck the Hover option to disable this feature.

2.4.8.6 Zoom In and Zoom Out

Click the Zoom In and Zoom Out buttons to change the zoom level. This is an alternative to using the Zoom slider (see Section 2.4.8.9, "Zoom").

2.4.8.7 Fit Content

Click the Fit Content button to adjust the zoom level automatically to make all of the diagram visible in the current browser window.

2.4.8.8 Toggle Constructs

Click the Toggle Constructs button to alternately hide and show the CQL Constructs and Templates gallery.

2.4.8.9 Zoom

Use the Zoom slider to increase or decrease the zoom level. This is an alternative to using the Zoom In and Zoom Out buttons (see Section 2.4.8.6, "Zoom In and Zoom Out").

2.4.10.1 Choose Layout

Use the Choose Layout pull-down menu to select alternate ways of distributing CQL constructs and showing their dependencies. You can choose any of:

• Left-Right

• Bottom-Top

• Right-Left

• Top-Bottom

2.4.10.2 Collapse All and Expand All

Use the Collapse All and Expand All buttons to collapse or expand the entries in the Data table.

2.4.10.3 Get Statistics and Stop Statistics

Use the Get Statistics button to instruct Oracle CEP to begin collecting statistics for the stages of the query plan.

When you click on the Get Statistics button, it turns into a Stop Statistics button. Click the Stop Statistics button to stop collecting statistics.

2.4.10.4 Refresh

Use the Refresh button to refresh the Query Plan diagram and Data table.

2.4.10.5 Show Legend

Use the Show Legend check box to show (checked) or hide (unchecked) the CQL Constructs Legend.

2.4.10.6 Preferences

Use the Preferences button to open the Query Plan pre-Renaissance dialog as Figure 2-99 shows.

2.4.10.7 Fit Content

Click the Fit Content button to adjust the zoom level automatically to make all of the diagram visible in the current browser window.

2.4.10.8 Zoom

Use the Zoom slider to increase or decrease the zoom level.