210 likes | 346 Views
Twin Cities Connected Systems User Group. Business Rules Execution via Managed Stored Procedures. A Data-centric Approach. Steve Cavanagh, Software Architect, Ramsey County Balaji Thiagarajan, Independent BizTalk Consultant. AGENDA.
E N D
Twin Cities Connected Systems User Group Business Rules Execution via Managed Stored Procedures A Data-centric Approach Steve Cavanagh, Software Architect, Ramsey County Balaji Thiagarajan, Independent BizTalk Consultant ©2009 S. Cavanagh, B. Thiagarajan
AGENDA Tonight’s presentation is intended to be conversational. Please ask questions. Steve and Balaji • Introduction • Business Problem • Solution Overview • Mini Demo of System • Code: Managed Stored Procedure & Rules Service • Code: Rules • Q & A ©2009 S. Cavanagh, B. Thiagarajan
Tonight’s food provided by ©2009 S. Cavanagh, B. Thiagarajan
Business Problem Create a new health care claiming system to replace a legacy system that is comprised of: • A hodgepodge of technologies: VB6, Cobol, Access • Business rules embedded in both stored procedures and VB6 code • Difficult to troubleshoot • Does not contain a good audit trail • Valuable business information is not readily accessible ©2009 S. Cavanagh, B. Thiagarajan
Goals Create a health care claiming system that is: • Accurate • Auditable • Flexible • Maintainable • Informative ©2009 S. Cavanagh, B. Thiagarajan
Claiming Solution ©2009 S. Cavanagh, B. Thiagarajan
Proof of Concept An essential aspect to the project. Steve Reed from Microsoft collaborated on design and provided technical assistance. ©2009 S. Cavanagh, B. Thiagarajan
AGENDA • Introduction • Business Problem • Solution Overview • Mini Demo of System • Code: Managed Stored Procedure & Rules Service • Code: Rules • Q & A ©2009 S. Cavanagh, B. Thiagarajan
Managed Stored Procedure/Function ©2009 S. Cavanagh, B. Thiagarajan
Rules Engine Server ©2009 S. Cavanagh, B. Thiagarajan
Rules Engine Service ©2009 S. Cavanagh, B. Thiagarajan
Enable CLR ©2009 S. Cavanagh, B. Thiagarajan
Managed Function Installation ©2009 S. Cavanagh, B. Thiagarajan
Rules Overview Static Support – Registry Key Vocabulary Upgrader Unit Testing - BizUnit ©2009 S. Cavanagh, B. Thiagarajan
Overview of Rules • Set of simple rules using Xml facts and Database calls using static method helper components. • The helper components do not implement IFactCreator. • Enterprise Library 3.1 was used for Logging, Error Handling, Caching and DB Calls. ©2009 S. Cavanagh, B. Thiagarajan
Static Support - Registry Key ©2009 S. Cavanagh, B. Thiagarajan
Vocabulary Upgrader • Problem: Upgrading to a new version of vocabulary will not automatically upgrade the vocabulary references in Rules. • Result: Multiple versions of vocabulary references present in a single version of rule. • Solution: Vocabulary Upgrader is now integrated with the Acumen Rule Manager previously available as a stand alone application. ©2009 S. Cavanagh, B. Thiagarajan
Unit Testing Used BizUnitframework to develop Test Scripts. Used NUnit to run the tests. BizUnit.BizTalkSteps.FactBasedRuleEngineStep – new on latest BizUnit release, not much documentation. ©2009 S. Cavanagh, B. Thiagarajan
Q & A • How has Ramsey County benefitted from this new system? • Found $100,000.00 in claims that were “missed” by the old system. • Changes to rules are easier to implement and verify. ©2009 S. Cavanagh, B. Thiagarajan
Thank you for attending Steve Cavanagh s.cavanagh@att.net Balaji Thiagarajan balaji@techdigitalcorp.com ©2009 S. Cavanagh, B. Thiagarajan