State Transition Constraints

Posted on Simple Talk See other posts from Simple Talk
Published on 08 October 2010 Indexed on 2010/12/06 16:58 UTC
Read the original article Hit count: 209

Filed under:
Data Validation in a database is a lot more complex than seeing if a string parameter really is an integer. A commercial world is full of complex rules for sequences of procedures, of fixed or variable lifespans, Warranties, commercial offers and bids. All this requires considerable subtlety to prevent bad data getting in, and if it does, locating and fixing the problem. Joe Celko shows how useful a State transition graph can be, and how essential it can become with the time aspect added.

© Simple Talk or respective owner

Related posts about T-SQL Programming