I have just completed an intra-company report, part of which researches the usability of rule based systems for data validation, and the bottom line is: yes. <br><br>There are some variations in rule authoring that might be useful or not, such as using a domain specific language, or rule templates.<br>
<br>The transition from table objects to WMEs might deserve some consideration, especially when there are OTHER columns.<br><br>Another issue might be whether the validation of one row is independent from other rows of the same or another table.<br>
<br>-W<br><br><br><div class="gmail_quote">On Wed, Apr 21, 2010 at 9:10 PM, Richard, Rene <span dir="ltr"><<a href="mailto:Rene.Richard@nrc-cnrc.gc.ca">Rene.Richard@nrc-cnrc.gc.ca</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;">
Hello,<br>
<br>
I am new to Drools (1 day of reading and watching video podcasts etc...). We have a requirement for our project where we'll have an input table HSQLDB table and some validation rules we need to apply on the data in the table. Some tables will have > 45 000 records or more. Would this kind of Batch validation be something Drools is good at? Rules can change over time and the table definition can also.<br>
<br>
It seems like Drools would be a good tool for doing the validation. I'm imagining an input table and an output table. The input table is the table we want to run validation for. The output table is a table that has had validation run against it an an extra column with a validation pass/fail status for reporting purposes...<br>
<br>
Thanks in advance<br>
<br>
Rene<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>
</blockquote></div><br>