Enforcing Workflow Through Relational Integrity

Many computer systems involve stepping through a Workflow, or State Machine.  This session will look at a number of relational database design patterns, all of which come together in a database model for enforcing Workflow within the database in a way that is fully configurable.  Along the way we will look briefly at several possible designs for recording history, giving a passing nod towards Trees and Hierarchies as well.  After throwing in some advanced relational integrity concepts, we will bring it all together with some ideas for enforcing a State Machine in the database without the use of triggers, CLR assemblies and the like.  Sounds like pure, old fashioned fun for the whole family!
Presented by Andrew Whettam at SQLBits XII
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    Andrew_Whettam.jpg
    Andrew Whettam is a Consultant for Information Management Group and has previously led the Database and Business Intelligence teams for 3M and Capital One respectively.  He works with both transactional and analytical databases and has modelled, designed and developed database systems across a variety of industry sectors.  Recent IMGROUP projects have included roles as Data Modeller for a major financial institution and Data Architect for a large conglomerate.  Past experience includes a number of high profile government projects.  He has worked with all versions of SQL Server since SQL 7.0.
    http://www.imgroup.com/blog/Pages/Blog.aspx
  • Video
    The video is not available to view online.