Design And Implementation Of A Workflow System Based On Relational Database

In recent years,Internet technology has been widely used and developed in various fields.But the most striking achievement is still a variety of business and work patterns derived from the Internet.At the same time,online office systems,electronic commerce systems and other products based on the Internet are gradually affecting the real life of the public.The offline business offline system involves the mapping of offline business process and online business process,which are inseparable from the management of workf low.Most of the current workflow management systems are limited to API prepared by workflow engine,unable to properly handle unexpected unexpected problems in daily processes,or process workers spend a lot of time thinking about all the problems that ma y arise.In addition,the development process requires the use of an abundant and complex workflow engine API interface,which leads to a continuous increase in the workload of the staff.Based on the above deficiencies,this paper makes a comprehensive an alysis of the workflow management system in three parts.We explore the following: first,using the business and logic tight coupling model,we try to reduce the number of related staff tasks,Properly complete the development and planning of the workflow.Second,it is mainly to open the workflow data to the programmer so that users can interfere with the business logic in accordance with their own needs.Third,the use of efficient and scientific solutions to properly handle the current workflow model can not be expressed,and in reality is a frequent occurrence of sudden problems.Based on the relational database,this paper develops a workflow management system which can handle many kinds of business independently and properly,and has carried on the inspection in the safety production system.The conclusion is that the workflow management system developed in this paper can fully meet the practical needs of production safety system.The mainstream workflow concept is now represented by the XML file,but because the above presentation pattern is open to the system manager.In addition,a simple SQL statement can not be used to manage and operate a business process with a relational database.So this paper uses relational database tables to represent workflow,and develops a workflow management system that can handle many kinds of business independently,It has been tested in the safety production system,and the conclusion is that the workflow management system developed in this paper can fully meet the practical needs of the safety production system.