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
#4: A repeatedly-executed query that violates this rule, querying
the same old rows with every repeat, usually points to a
design flaw in the application, or a defect in the business processes,
or both!