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!
Sorry, there are no downloads available for this session.
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.
The video is not available to view online.