Here's a somewhat retrospective paper on the applications of triggers
and constraints in database systems; nothing fundamentally new, but
it's interesting to see an overview of all sorts of ways triggers have
been used, and how things have progressed since the concept was first
proposed for SQL

Practical Applications of Triggers and Constraints: Successes and
Lingering Issues
http://www.vldb.org/conf/2000/P254.pdf