<div dir="ltr">I would fist step back and ask the question if a rules engine is the right solution to your problem.<br><br>Is this data you are getting in daily in a single table, multiple tables? How complex is the data? Is the data simple enough that rules could just be some SQL statements/Stored procs? <br>
<br>How many rules are you talking about? Could there be all kinds of rules, or just a fixed set of rules with different parameters?<br><br><div class="gmail_quote">On Fri, Oct 3, 2008 at 1:55 PM, techluver <span dir="ltr"><<a href="mailto:techluver007@gmail.com">techluver007@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br>
Thanks David.<br>
I would like to give more details on my requirement. Please throw your ideas<br>
for good design using drools.<br>
<br>
1.I'll get huge amount of data in database(60 or 70 millions) daily. I would<br>
like to apply the rules on those records and store the data which satisfied<br>
the rules. So my rule engine has to run daily at specific time.<br>
<br>
2.I also have to provide the reporting GUI to business users to generate<br>
report based on rules<br>
<br>
3. users also need user friendly GUI to manage the rules something like<br>
BRMS(this would be last thing user want)<br>
<br>
4. till I develop rules manager gui, I should be able to manage the rules<br>
from the database.<br>
<br>
5. I don''t need to load and apply the rules dynamically. But If I<br>
add/remove any rule, then it should be loaded/removed during next run of<br>
rule engine.<br>
<br>
I'm not really sure whether to use drools' BRMS or not here. I think i need<br>
database driven rule engine.<br>
<br>
Please share your ideas for this requirement on what kind of design I need<br>
here.<br>
<br>
<br>
Thanks in advance.<br>
<div class="Ih2E3d"><br>
<br>
<br>
<br>
techluver wrote:<br>
><br>
> I'm new to drools world. Kindly clarify following things<br>
><br>
> My requirement is to log each data in the DB(that meets any of the<br>
> business rule) along with rule info.<br>
><br>
> if I use BRMS ( i think it maintains the rules separately in its own db<br>
> table)<br>
><br>
> How I can associate each log with the rule info?<br>
><br>
> Approach 1. Can I access BRMS's rules directly and associate it in my<br>
> logging?<br>
><br>
> Approach 2. I can't do Approach 1, then I'm thinking to have RULES table<br>
> in my app db.Then whenever any rule is added using BRMS, Then add an entry<br>
> into RULES table and use this table for my logging<br>
><br>
> Please advise me on the right approach.<br>
><br>
> Thanks in advance.<br>
><br>
<br>
--<br>
</div>View this message in context: <a href="http://www.nabble.com/BRMS-rule-info-logging-tp19766982p19802730.html" target="_blank">http://www.nabble.com/BRMS-rule-info-logging-tp19766982p19802730.html</a><br>
<div><div></div><div class="Wj3C7c">Sent from the drools - user mailing list archive at Nabble.com.<br>
<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><br>
</div></div></blockquote></div><br></div>