Applying rules on the data in an RDBMS
by Gorantla, Bhaskar (GE Capital)
We have over 15,000 rows in the database and we need to apply the rules on
this data. We are thinking of doing the following.
a. Read the data from the database in batches
b. Create beans for the data that we just read
c. Run the rules on the beans (this results in setting some attributes
on the bean)
d. Save the beans back to the database
As you can see, there is some overhead in reading the data from the
database, performing the OR mappings, and writing the data back to the
database. Is there a way to avoid some of these steps? Can you please
suggest some techniques that we can use to improve the performance? Also, I
was wondering whether we can configure Drools to operate directly on the
data in the database.
Thanks
Bhaskar