Caching
Business Logic in the Database
I had this relatively simple idea of storing conditions in the
database. The idea is to store the condition of the if-then-else
from your code in the database. While this will add (slightly)
more space to the database, I hope that it will do away with
processing the data over and over again as well as help
drastically speed up searches and any analytical processing you
would like to do in the future. I will try to explain with an
example..
Story:
You run an electronics store and you have sales people working in
that store. You would like to give a bonus incentive and you
decide that the rules for the bonus would be the following:
1) Sales people that sell more then average amount of money each
for at least 15 days out of a month will receive a bonus. After a
bit of calculation you …