Optimal
Data-Based Business Process Rules
•As
soon as possible… the row ends up in a state where it need never
again be touched by the database, except under rare circumstances.
–Corollary
#1: If some rows do not end up in this “closed” state, but
instead figure into reports months or years later, again and
again, then the business process has an unintended, endless
loop!
–Corollary
#2: Purging old data should have little effect on performance, if
design is ideal, because those old rows would never be touched,
anyway!