1 / 21

Business Rules Execution via Managed Stored Procedures

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.

tanisha
Download Presentation

Business Rules Execution via Managed Stored Procedures

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 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

  2. 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

  3. Tonight’s food provided by ©2009 S. Cavanagh, B. Thiagarajan

  4. 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

  5. Goals Create a health care claiming system that is: • Accurate • Auditable • Flexible • Maintainable • Informative ©2009 S. Cavanagh, B. Thiagarajan

  6. Claiming Solution ©2009 S. Cavanagh, B. Thiagarajan

  7. 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

  8. 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

  9. Managed Stored Procedure/Function ©2009 S. Cavanagh, B. Thiagarajan

  10. Rules Engine Server ©2009 S. Cavanagh, B. Thiagarajan

  11. Rules Engine Service ©2009 S. Cavanagh, B. Thiagarajan

  12. Enable CLR ©2009 S. Cavanagh, B. Thiagarajan

  13. Managed Function Installation ©2009 S. Cavanagh, B. Thiagarajan

  14. Rules Overview Static Support – Registry Key Vocabulary Upgrader Unit Testing - BizUnit ©2009 S. Cavanagh, B. Thiagarajan

  15. 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

  16. Static Support - Registry Key ©2009 S. Cavanagh, B. Thiagarajan

  17. 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

  18. ©2009 S. Cavanagh, B. Thiagarajan

  19. 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

  20. 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

  21. Thank you for attending Steve Cavanagh s.cavanagh@att.net Balaji Thiagarajan balaji@techdigitalcorp.com ©2009 S. Cavanagh, B. Thiagarajan

More Related