[rules-users] Using Drools for Batch Data Validation

[Wolfgang Laun]

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.

There are some variations in rule authoring that might be useful or not,
such as using a domain specific language, or rule templates.

The transition from table objects to WMEs might deserve some consideration,
especially when there are OTHER columns.

Another issue might be whether the validation of one  row is independent
from other rows of the same or another table.

-W


On Wed, Apr 21, 2010 at 9:10 PM, Richard, Rene
<Rene.Richard at nrc-cnrc.gc.ca>wrote:

> Hello,
>
> 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.
>
> 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...
>
> Thanks in advance
>
> Rene
> _______________________________________________
> rules-users mailing list
> rules-users at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/rules-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/rules-users/attachments/20100422/edb8a33f/attachment.html