<html>
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 10 (filtered)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p
{margin-right:0in;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";}
pre
{margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.EmailStyle19
{font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Thanks Edson</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>I read about “from” CE and understand
that it can call any external method. In the external method I can write the code
to extract the data from database.</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>I googled and found this, where its using
hibernate session and that way giving complete flexibility in writing rule on
any data set. Do you think it’s a good idea?</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>global org.hibernate.Session hibernateSession;</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>rule "hibernate_from"</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> when</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> game:Game()
from hibernateSession.createQuery("select games from Player p where p.age
>= :age").setProperties( {"age" : 18 }).list()</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> then</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> System.out.println("The
game "+game.getName() +"is owned by "+game.getPlayers());</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>end</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma'>-----Original Message-----<br>
<b><span style='font-weight:bold'>From:</span></b>
rules-users-bounces@lists.jboss.org
[mailto:rules-users-bounces@lists.jboss.org] <b><span style='font-weight:bold'>On
Behalf Of </span></b>Edson Tirelli<br>
<b><span style='font-weight:bold'>Sent:</span></b> </span></font><font size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>Monday, June
01, 2009</span></font><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma'> </span></font><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'>6:48 PM</span></font><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'><br>
<b><span style='font-weight:bold'>To:</span></b> Rules Users List<br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: [rules-users] rule
using sliding window</span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'><br>
Hi<br>
<br>
The description you have bellow is ambiguous, so I can't give you
a definitive answer. But it seems to be that you don't need sliding windows for
that. Simple temporal operators will do.<br>
<br>
> </span></font><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Secondly if the window is large and number of records coming
in is high then could there be a memory issue?<br>
Yes, Drools does not manages persistence by itself. So, if your
design must support more data than it would fit in your running environment
memory, you need to design a solution that comprises persistence.<br>
<br>
> Also since every record is getting stored in database, can I not use the
database directly instead of sliding window?</span></font><br>
Yes, you can fetch data on demand from external sources, be it
databases or anything else. Look at the "from" CE.<br>
<br>
[]s<br>
Edson<br>
<br>
</p>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>2009/6/1 Bhushan Bhangale <<a
href="mailto:bhushan_bhangale@kaleconsultants.com">bhushan_bhangale@kaleconsultants.com</a>></span></font></p>
<div link=blue vlink=purple>
<div>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>I
am using Drools 5. I am struggling to write rule for this logic -</span></font></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>If
a stock price changes more than 10% within an hour then report the change.</span></font></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>I
understand I have to use sliding window feature but unable to write the rule.</span></font></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>For
example I got an update for IBM stock @ 12:30 for price 100 and then another
update IBM stock @ 12:35 for price 111. Since the time difference is within an
hour and the change is also greater than 10% I want to report this price
change.</span></font></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'> </span></font></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Stock
class -</span></font></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'> </span></font></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Public
class Stock {</span></font></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>
Private String stock;</span></font></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>
Private double price;</span></font></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>
Private Date time;</span></font></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>
Private double priceChange;</span></font></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>
Private Boolean highlight;</span></font></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>}</span></font></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'> </span></font></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'> </span></font></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>rule
"Stock Price change more than 10% within an hour"</span></font></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'> </span></font></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>when</span></font></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'> </span></font></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>then</span></font></p>
<p style='text-indent:.5in'><font size=2 face=Arial><span style='font-size:
10.0pt;font-family:Arial'>set the priceChange attribute of Stock object</span></font></p>
<p style='text-indent:.5in'><font size=2 face=Arial><span style='font-size:
10.0pt;font-family:Arial'>set highlight to true </span></font></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>end</span></font></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'> </span></font></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'> </span></font></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Secondly
if the window is large and number of records coming in is high then could there
be a memory issue?</span></font></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'> </span></font></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Also
since every record is getting stored in database, can I not use the database
directly instead of sliding window?</span></font></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'> </span></font></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Thanks</span></font></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'> </span></font></p>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width=320
style='width:240.0pt'>
<tr>
<td style='padding:0in 0in 0in 0in'>
<p><b><font size=1 color="#4e81c4" face=Verdana><span style='font-size:8.0pt;
font-family:Verdana;color:#4E81C4;font-weight:bold'>Mr. Bhangale Bhushan</span></font></b><font
size=1 color="#4e81c4" face=Verdana><span style='font-size:8.0pt;font-family:
Verdana;color:#4E81C4'><br>
<i><span style='font-style:italic'>Associate Manager</span></i><br>
<b><span style='font-weight:bold'>Kale Consultants Ltd.</span></b><br>
<a href="mailto:bhushan_bhangale@kaleconsultants.com" target="_blank"><font
color="#4e81c4"><span style='color:#4E81C4;text-decoration:none'>bhushan_bhangale@kaleconsultants.com</span></font></a><br>
tel: <a
href="http://www.plaxo.com/click_to_call?lang=en&src=jj_signature&To=%2B91+%280%29206+608+3777&Email=bhushan_bhangale@kaleconsultants.com"
target="_blank" title="Click to call. Cheap rates & no headset required!"><font
color="#4e81c4"><span style='color:#4E81C4;text-decoration:none'>+91 (0)206
608 3777</span></font></a><br>
<a href="http://www.kaleconsultants.com" target="_blank"><font color="#4e81c4"><span
style='color:#4E81C4;text-decoration:none'>http://www.kaleconsultants.com</span></font></a>
</span></font></p>
</td>
<td style='padding:0in 0in 0in 0in'>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'> </span></font></p>
</td>
</tr>
<tr height=10 style='height:7.5pt'>
<td colspan=2 height=10 style='padding:0in 0in 0in 0in;height:7.5pt'>
<p><font size=1 face="Times New Roman"><span style='font-size:8.0pt'> </span></font></p>
</td>
</tr>
<tr>
<td colspan=2 style='padding:0in 0in 0in 0in'>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'> </span></font></p>
</td>
</tr>
</table>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'> </span></font></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> </span></font></p>
<pre><font size=2 face="Courier New"><span style='font-size:10.0pt'>Disclaimer: This email (including any attachments) is intended for the sole</span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>use of the recipient/s and may contain material that is CONFIDENTIAL. Any</span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>unauthorized disclosure / copying / distribution or forwarding of this message </span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>or part is STRICTLY PROHIBITED. If you have erroneously received this message,</span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>please delete it immediately and notify the sender. No liability is assumed for</span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>any errors and/or omissions in the contents of this message. Information in </span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>this message that does not relate to the official business of this Company</span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>shall be understood as neither given nor endorsed by it. If verification is</span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>required please request a hard-copy version. </span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'> </span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>To know more about Kale Consultants, visit <a
href="http://www.kaleconsultants.com" target="_blank">www.kaleconsultants.com</a> </span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'> </span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>----------</span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'> </span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'> </span></font></pre>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> </span></font></p>
</div>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'><br>
_______________________________________________<br>
rules-users mailing list<br>
<a href="mailto:rules-users@lists.jboss.org">rules-users@lists.jboss.org</a><br>
<a href="https://lists.jboss.org/mailman/listinfo/rules-users" target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a></span></font></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><br>
<br clear=all>
<br>
-- <br>
Edson Tirelli<br>
JBoss Drools Core Development<br>
JBoss, a division of Red Hat @ <a href="http://www.jboss.com">www.jboss.com</a></span></font></p>
</div>
<BR><PRE>
Disclaimer: This email (including any attachments) is intended for the sole
use of the recipient/s and may contain material that is CONFIDENTIAL. Any
unauthorized disclosure / copying / distribution or forwarding of this message
or part is STRICTLY PROHIBITED. If you have erroneously received this message,
please delete it immediately and notify the sender. No liability is assumed for
any errors and/or omissions in the contents of this message. Information in
this message that does not relate to the official business of this Company
shall be understood as neither given nor endorsed by it. If verification is
required please request a hard-copy version.
To know more about Kale Consultants, visit www.kaleconsultants.com
-=-=-=-=-=-=-=-=-=-
</pre><BR></body>
</html>