1.1 --- a/iep.help/javahelp/org/netbeans/modules/iep/help/attbased_propedit.html Thu Apr 19 00:41:59 2007 +0000
1.2 +++ b/iep.help/javahelp/org/netbeans/modules/iep/help/attbased_propedit.html Thu Apr 19 01:10:48 2007 +0000
1.3 @@ -17,7 +17,7 @@
1.4 <li>Drag an Attribute Based Window operator from the Palette to the Design view.</li>
1.5 <li>Click the Attribute Based Window operator icon. The Property Window opens with the name of the Attribute Based Window operator and the output schema name populated. The Property Window displays the schema of the data that is input to the Attribute Based Window operator. </li>
1.6 <li>Supply the Attribute that is to be tracked for a specific column.</li>
1.7 - <li>Enter a Size value which represents the difference between the most recently received record's atrributes and any previous records. Only records that fall within that range are passed through. </li>
1.8 + <li>Enter a Size value which represents the difference between the most recently received record's attributes and any previous records. Only records that fall within that range are passed through. </li>
1.9 <li>Click Ok.</li>
1.10 </ol>
1.11 <p> </p>
2.1 --- a/iep.help/javahelp/org/netbeans/modules/iep/help/relagg_propedit.html Thu Apr 19 00:41:59 2007 +0000
2.2 +++ b/iep.help/javahelp/org/netbeans/modules/iep/help/relagg_propedit.html Thu Apr 19 01:10:48 2007 +0000
2.3 @@ -1,1 +1,41 @@
2.4 -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
2.5 <!--
2.6 * Copyright 2007 Sun Microsystems, Inc. All rights reserved.
2.7 * Use is subject to license terms.
2.8 -->
2.9 <html>
2.10 <head>
2.11 <link rel="stylesheet" href="nbdocs://org.netbeans.modules.usersguide/org/netbeans/modules/usersguide/ide.css" type="text/css">
2.12 <title>Using the Relation Aggregator Property Editor </title>
2.13 </head>
2.14 <body>
2.15 <h2>Using the Relation Aggregator Operator Property Editor </h2>
2.16 <p><small><a href="#seealso">See Also</a></small></p>
2.17 <p>Use the Relation Aggregator operator to take as input the output of a relation, treat that output as if it were a database table, and perform an SQL Select on that table. The Relation operator issues output in the form of a relation.</p>
2.18 <p><strong>To create a Relation Aggregator operator:</strong></p>
2.19 <ol>
2.20 <li>Drag a Relation Aggregator operator from the Palette to the Design view.</li>
2.21 <li>Click the Relation Aggregator operator icon. The Property Window opens with the defaukt name of the Relation Aggregator operator and the output schema name populated. The Property Window displays the schema of the data that is input to the Distinct operator. </li>
2.22 <li>In the Select field, specify attributes from which to select. Any attribute you specify here must appear in the group-by clause. Attributes you select as expression entries must be in the form of an attribute name, a literal, or an aggregate function supported by the database you use. Examples include COUNT, MAX, MIN, AVG. </li>
2.23 <li>In the Expression field, provide a SQL expression to further delimit your Select statement. To save some typing, you can drag input attribute field names from the Inputs area into the Expression field. </li>
2.24 <li>Optionally specify a Where statement in the Where field to provide a search condition, which cannot have a subquery.</li>
2.25 <li>In the group by field, specify a comma-separated list of attribute names, indicating how you want to group the attributes in the relation that is output from this operator.</li>
2.26 <li>Click Ok.
2.27 </li>
2.28 </li>
2.29 </ol>
2.30 <dl>
2.31 <dt><a name="seealso">See Also</a></dt>
2.32 <dd> </dd>
2.33 <dd><a href="relmap_prop.html">Using the Relation Map Operator Property Window </a></dd>
2.34 </dl>
2.35 <hr>
2.36 <small><a href="credits.html">Legal Notices</a></small>
2.37 <table cellpadding="150" border="0">
2.38
2.39 <tr><td> </td></tr>
2.40 <tr><td> </td></tr>
2.41 <tr><td> </td></tr>
2.42 </table>
2.43 rel
2.44 </body>
2.45 </html>
2.46 \ No newline at end of file
2.47 +<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
2.48 +<!--
2.49 +* Copyright 2007 Sun Microsystems, Inc. All rights reserved.
2.50 +* Use is subject to license terms.
2.51 +-->
2.52 +<html>
2.53 +<head>
2.54 +<link rel="stylesheet" href="nbdocs://org.netbeans.modules.usersguide/org/netbeans/modules/usersguide/ide.css" type="text/css">
2.55 +<title>Using the Relation Aggregator Property Editor </title>
2.56 +</head>
2.57 +<body>
2.58 +<h2>Using the Relation Aggregator Operator Property Editor </h2>
2.59 +<p><small><a href="#seealso">See Also</a></small></p>
2.60 +<p>Use the Relation Aggregator operator to take as input the output of a relation, treat that output as if it were a database table, and perform an SQL Select on that table. The Relation operator issues output in the form of a relation.</p>
2.61 +<p><strong>To create a Relation Aggregator operator:</strong></p>
2.62 +<ol>
2.63 + <li>Drag a Relation Aggregator operator from the Palette to the Design view.</li>
2.64 + <li>Click the Relation Aggregator operator icon. The Property Window opens with the default name of the Relation Aggregator operator and the output schema name populated. The Property Window displays the schema of the data that is input to the Distinct operator. </li>
2.65 + <li>In the Select field, specify attributes from which to select. Any attribute you specify here must appear in the group-by clause. Attributes you select as expression entries must be in the form of an attribute name, a literal, or an aggregate function supported by the database you use. Examples include COUNT, MAX, MIN, AVG. </li>
2.66 + <li>In the Expression field, provide a SQL expression to further delimit your Select statement. To save some typing, you can drag input attribute field names from the Inputs area into the Expression field. </li>
2.67 + <li>Optionally specify a Where statement in the Where field to provide a search condition, which cannot have a subquery.</li>
2.68 + <li>In the group by field, specify a comma-separated list of attribute names, indicating how you want to group the attributes in the relation that is output from this operator.</li>
2.69 + <li>Click Ok.
2.70 + </li>
2.71 +</li>
2.72 +</ol>
2.73 +<dl>
2.74 +<dt><a name="seealso">See Also</a></dt>
2.75 +<dd> </dd>
2.76 +<dd><a href="relmap_prop.html">Using the Relation Map Operator Property Window </a></dd>
2.77 +</dl>
2.78 +<hr>
2.79 +<small><a href="credits.html">Legal Notices</a></small>
2.80 +<table cellpadding="150" border="0">
2.81 +
2.82 +<tr><td> </td></tr>
2.83 +<tr><td> </td></tr>
2.84 +<tr><td> </td></tr>
2.85 +</table>
2.86 +</body>
2.87 +</html>
3.1 --- a/iep.help/javahelp/org/netbeans/modules/iep/help/relmap_prop.html Thu Apr 19 00:41:59 2007 +0000
3.2 +++ b/iep.help/javahelp/org/netbeans/modules/iep/help/relmap_prop.html Thu Apr 19 01:10:48 2007 +0000
3.3 @@ -11,7 +11,7 @@
3.4 <body>
3.5 <h2>Using the Relation Map Operator Property Editor </h2>
3.6 <p><small><a href="#seealso">See Also</a></small></p>
3.7 -<p> The Relation Map operator performs a select on two or more incoming relations, equivalent to a SQL join view of a minmum of one relation and additional tables and relations. The Relation Map operator can take multiple inputs.</p>
3.8 +<p> 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.</p>
3.9 <p>You can use a Relation Map to join input from other operator sources, for example, two or more Tuple Based windows, or two or more Partitioned Windows. </p>
3.10 <p><strong>To create a Relation Map Operator</strong></p>
3.11 <ol>
4.1 --- a/iep.help/javahelp/org/netbeans/modules/iep/help/streamdel_propedit.html Thu Apr 19 00:41:59 2007 +0000
4.2 +++ b/iep.help/javahelp/org/netbeans/modules/iep/help/streamdel_propedit.html Thu Apr 19 01:10:48 2007 +0000
4.3 @@ -11,7 +11,7 @@
4.4 <body>
4.5 <h2>Using the Delete Stream Operator Property Editor </h2>
4.6 <p><small><a href="#seealso">See Also</a></small></p>
4.7 -<p>The Delete Stream operator converts the deleted records of a changed relation into a stream. The operator takes all records that are in a previous table but not in the currrent table and puts them into a stream with a timestamp.</p>
4.8 +<p>The Delete Stream operator converts the deleted records of a changed relation into a stream. The operator takes all records that are in a previous table but not in the current table and puts them into a stream with a timestamp.</p>
4.9 <p><strong>To create an Delete Stream operator:</strong></p>
4.10 <ol>
4.11 <li>Drag a Delete Stream operator from the Palette to the Design area.</li>
5.1 --- a/iep.help/javahelp/org/netbeans/modules/iep/help/strprj_prop.html Thu Apr 19 00:41:59 2007 +0000
5.2 +++ b/iep.help/javahelp/org/netbeans/modules/iep/help/strprj_prop.html Thu Apr 19 01:10:48 2007 +0000
5.3 @@ -25,7 +25,7 @@
5.4 <p>For example, you have information relating to an existing stock and its price, but you want to join a static SEC table to provide CEO and company size information--you are, in effect, adding a new dimension to the set of events in the input stream</p>
5.5 <p><strong>To create a Stream Projection and Filter operator:</strong></p>
5.6 <ol>
5.7 - <li>Drag a Stream Projection and Filter operator from the Palette to the Design view..</li>
5.8 + <li>Drag a Stream Projection and Filter operator from the Palette to the Design view.</li>
5.9 <li>Click the Stream Projection and Filter operator icon.The Property Editor opens. </li>
5.10 <li>In the Expression box, enter the expression for the SQL Select statement which is used to specify the value of each output attribute.Add attribute names, data types. and sizes, as applicable. </li>
5.11 <li>In the From box, define the input on which to perform the selection which table-- </li>
6.1 --- a/iep.help/javahelp/org/netbeans/modules/iep/help/timebased_propedit.html Thu Apr 19 00:41:59 2007 +0000
6.2 +++ b/iep.help/javahelp/org/netbeans/modules/iep/help/timebased_propedit.html Thu Apr 19 01:10:48 2007 +0000
6.3 @@ -11,8 +11,8 @@
6.4 <body>
6.5 <h2>Using the Time Based Aggregator Operator Property Editor </h2>
6.6 <p><small><a href="#seealso">See Also</a></small></p>
6.7 -<p>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..</p>
6.8 -<p>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 edito, and an Iincrement that specifies often you want to perform that calculation, for example, once a day. </p>
6.9 +<p>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.</p>
6.10 +<p>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. </p>
6.11 <p>Statistics you can compute via SQL statements within the Property Editor of the Tuple Based Aggregator include:</p>
6.12 <ul>
6.13 <li>Sum</li>