theory

State Transition Constraints

  • Article

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.

2010-10-27

1,942 reads

Blogs

Quick Blog: Making the Power BI PowerShell cmdlets easier to use

By

One of the top reasons I love PowerShell so much is that from the...

Trouble writing? Join the club. #JustWriteTech

By

I was talking with  a couple of excellent SQL people* recently, and we were bemoaning...

Check Query Progress with Live Query Stats

By

This is something I touched on back in 2017 a little after the Live...

Read the latest Blogs

Forums

Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

https://atozfitnesstalks.com/genbrain-??????/

By jamsishlesha

GenBrain ?????? Adults constantly because of this they like playing online-games enjoyable in their...

A Different View of Technical Debt

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Different View of Technical...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers