Achieving consistency in active databases
Klaus‐Dieter Schewe, Bernhard Thalheim · 2002
Consistency is an important property of database application systems. Given some integrity constraint on a database schema the problem is to guarantee that all transactions preserve this constraint. We regard rule triggering systems and provide a theoretical analysis of their power with respect to the enforcement of constraints. We show that for certain constraint sets the effect of the rules is equivalent to canonically specializing transactions. Moreover, we present a theoretical extension of this specialization idea that captures also critical sets of constraints. However, the price for this generality is high, since linguistic reflection seems to be the only reasonable implementation technique.>