基于动态SQL的审核工作流

Auditing Workflow Based on Dynamic SQL

大多数业务系统的审核流程基本相近,但往往需要开发人员重复设计,并且现有工作流引擎的设计强调普适性,而对于审核流程处理的针对性不强。为此,设计了轻量级的审核工作流模型。该模型不仅可以动态定义审核流程,而且可以监控工作流实例的运行。同时在模型设计上,除了考虑到审核业务特性之外,还以逻辑复用性为原则,采用了动态SQL,增强审核流程的灵活性与可控性。并且通过嵌入在实际系统中的运行,从实践角度证明了该模型的有效性。

Most business review process system is basically similar,but often requires developers to reuse design,and the existing workflow engine design emphasizes the universality,not targeted for audit workflow process.In this respect,the paper gives an auditing workflow model which is lightweight.The model not only can define the auditing flows but also can detect the run of workflow instances.In addition to the business features of auditing,considering the principal of logic reusability,the solution of the model adopts the dynamic SQL to enhance the flexibility and controllability of auditing flows.Through the running of the systems embedded in the model engine,it is proved that the model is effective.