A series of posts exploring the use of assertions to enforce group composition rules. This first post uses literal rules to generate assertions, for example “a university department must have faculty members”. Several design patterns of literal group composition assertions are explored. read more

In the previous post (Temporal SQL Assertions I: Unconditional and Unvalidated) we explored a naive solution that used SQL assertions to validate customer discounts for a customer loyalty program. The basic idea was sound, but did not adapt to the requirements for customer… read more

In this series of posts we will explore using assertions to enforce business rules in a changing data landscape. This first article explores the limitations of a simplistic approach to a problem that is more complex than it first appears to be.… read more