CN103745310A - Workflow data modeling method - Google Patents
Workflow data modeling method Download PDFInfo
- Publication number
- CN103745310A CN103745310A CN201310727460.XA CN201310727460A CN103745310A CN 103745310 A CN103745310 A CN 103745310A CN 201310727460 A CN201310727460 A CN 201310727460A CN 103745310 A CN103745310 A CN 103745310A
- Authority
- CN
- China
- Prior art keywords
- work order
- node
- layer service
- interface
- mapping
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a workflow data modeling method. The method comprises the following steps: according to demand analysis of an upper layer service, based on a work order, constructing a rule construction work order; mapping nodes in the constructed work order to fields in a bottom layer original database in a one-to-one mode, and providing an application interface for the upper layer service; and binding the nodes in the constructed work order with the activity nodes of the workflow of the upper layer service. The method provided by the invention can realize visualized design of workflow data and facilitates data operation of a user.
Description
Technical field
The present invention relates to technical field of data processing, be specifically related to a kind of method of Work stream data modeling.
Background technology
Office automation (being called for short OA) is by modern office and computer structure a kind of novel working way altogether, is a technical applications of very enlivening and have very strong vitality.The office automation system is to use computer technology, and various human activities are completed under artificial assistance; Thereby the large step that reaches the making full use of of fully the sharing of information, resource, efficiency improves and the very fast lifting of office quality.The in the situation that of the general depression of global economy, market competition is fiercer; For enterprise is defeated one's opponents in keen competition, improve office efficiency and level of decision-making and just seem very important.The office automation system is exactly to realize the important means of this platform.Meanwhile, office automation system Ye Shi enterprise realizes modern important symbol.
Traditional office automation system is made to measure for business demand, and the function of system is fairly perfect over a period to come, can meet preferably in theory user's demand.But under actual conditions, enterprise is in order to adapt to the variation in market and to meet user's demand; The operation flow of enterprise is often to change.
Traditional office automation system dirigibility is bad, cannot tackle the operation flow of frequent variation.If each operation flow changes, all again the office automation system developed and encode; Can cause so a large amount of man power and materials' waste.And the just independent workflow modeling that uses of traditional modeling method, namely structurized modeling, does not consider the variation of data.
Summary of the invention
(1) technical matters solving
For the deficiencies in the prior art, the invention provides a kind of method of Work stream data modeling, can realize the data-centered workflow design work of carrying out, the modeling of structure-oriented and data-oriented modeling are combined, according to the mapping relations automatically generated data storehouse operation code of work order and bottom data database data.
(2) technical scheme
For realizing above object, the present invention is achieved by following scheme:
A method for Work stream data modeling, the method comprises:
According to the demand analysis of upper-layer service, based on work order formation rule structure work order;
Field in node in the work order of structure and basic primary data storehouse is shone upon one by one, and provide application interface for upper-layer service;
The active node of the workflow of the node in the work order of structure and upper-layer service is bound.
Wherein, described according to the demand analysis of upper-layer service, based on work order formation rule structure work order, comprising:
According to the demand analysis of upper-layer service, adopt work order formation rule to obtain work order and construct required node;
Required node is added to work order node, and work order nodal community is set;
According to the attribute of node, generate work order tree structure.
Wherein, described field in node in the work order of structure and basic primary data storehouse is shone upon one by one, comprising:
Obtain the information of original bottom Service Database, and the field of selecteed database table is wherein listed;
Utilize mapping algorithm that work order node and database table field are shone upon, and generating mapping file.
Wherein, described mapping algorithm is Mapping algorithm.
Wherein, the described active node by the node in the work order of structure and workflow is bound, and comprising:
According to upper-layer service, formulate workflow diagram;
Select the task node in workflow diagram, and by the node binding of itself and work order, and generate XML binding file.
Wherein, described application interface comprises: the connecting interface in basic primary data storehouse, node mapping interface, mapping relations are checked interface, mapping relations edition interface, service logic access interface and mapping relations saving interface.
(3) beneficial effect
The present invention at least has following beneficial effect:
In method provided by the invention, by work order, data and upper-layer service flow process are combined, realized the data-centered modeling of carrying out Work stream data, the method has made up the defect that common Workflow system can only design effort flow structure, realizes the visual design to Work stream data.And work order, by for upper-layer service provides application interface, has shielded the difference of basic primary data storehouse multilist and has connected the loaded down with trivial details of table, facilitates user to operate data.User, when work order is operated, does not need to consider the database of bottom completely.
Accompanying drawing explanation
In order to be illustrated more clearly in the embodiment of the present invention or technical scheme of the prior art, to the accompanying drawing of required use in embodiment or description of the Prior Art be briefly described below, apparently, accompanying drawing in the following describes is only some embodiments of the present invention, for those of ordinary skills, do not paying under the prerequisite of creative work, can also obtain according to these figure other accompanying drawing.
Fig. 1 is the process flow diagram of the method for a kind of Work stream data modeling of providing of the embodiment of the present invention;
Fig. 2 is the process flow diagram of the method for the present invention's a kind of Work stream data modeling that preferably embodiment provides;
Fig. 3 is the schematic diagram that structure heating installation that the embodiment of the present invention provides reports work order flow process for repairment;
Fig. 4 is the schematic diagram that heating installation that the embodiment of the present invention provides reports work order and underlying database mapping flow process for repairment;
Fig. 5 is the schematic diagram that heating installation that the bright embodiment of this law provides reports the flow process that work order and jBPM Task node bind for repairment.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present invention, the technical scheme in the embodiment of the present invention is clearly and completely described, obviously, described embodiment is only the present invention's part embodiment, rather than whole embodiment.Based on the embodiment in the present invention, those of ordinary skills, not making the every other embodiment obtaining under creative work prerequisite, belong to the scope of protection of the invention.
Referring to Fig. 1, the embodiment of the present invention provides a kind of method of Work stream data modeling, and the method comprises the steps:
Step 101: the demand analysis of putting according to upper-layer service, based on work order formation rule structure work order;
Step 102: the field in the node in the work order of structure and basic primary data storehouse is shone upon one by one, and provide application interface for upper-layer service;
Step 103: the active node of the workflow of the node in the work order of structure and upper-layer service is bound.
In the method that the embodiment of the present invention provides, by work order, data and upper-layer service flow process are combined, realized the data-centered modeling of carrying out Work stream data, the method has made up the defect that common Workflow system can only design effort flow structure, realizes the visual design to Work stream data.And work order is for upper-layer service provides unified application interface, is in order to utilize work order unit shield the difference of basic primary data storehouse multilist and connect the loaded down with trivial details of table, to facilitate user to operate data.User, when work order is operated, does not need to consider the database of bottom completely.Interface adopts command mode design, also facilitates user to expand work order operating function, and user only need to be provided by this interface providing just can realize required function.
Below by an example more specifically, the implementation procedure of a preferred embodiment of the present invention is described, referring to Fig. 2, the step of the method is as follows:
Step 201: according to the demand analysis of upper-layer service, adopt work order formation rule to obtain work order and construct required node.
In this step, work order formation rule is as follows: (1) work order unique existence, and it is self-described, indivisible; Can be used for indicating its position in whole operation flow.(2) the life cycle accessibility of work order, each work order, from producing in the whole life-cycle processes of filing, experiences different life cycle phases.(3) work order has persistence, and it produces, changes, files in operation flow implementation, in this life cycle, should not disappear.
Step 202: required node is added to work order node, and nodal community is set.
In this step, nodal community is set and comprises: the setting of major key, external key, atom belonging, aggregate attribute etc.
Step 203: according to nodal community, generate work order tree structure.
Step 204: obtain original bottom business datum library information, and the field of selecteed database table is wherein listed.
Step 205: utilize mapping algorithm that the field of work order node and database table is shone upon, and generating mapping file.
In this step, the mapping of work order and underlying database needs some principles, in work order, be set to Primary Key attribute node can only with database in major key field shine upon, other node just can arbitrarily shine upon, and the required algorithm of mapped file generating is Mapping algorithm
Step 206: formulate workflow diagram according to operation flow.
Step 207: select the task node in workflow, and nodal community binding with work order by it, generation XML binding file.
With heating installation repair reporting system, be designed to example below, the modeling method of the embodiment of the present invention has been done to further detailed description.
Referring to Fig. 3, the structure heating installation providing for the embodiment of the present invention reports the schematic diagram of work order for repairment, comprises the following steps:
Step 301: the detailed demand analysis document of carefully understanding repair reporting system;
Step 302: adopt work order formation rule to carry out the checking of work order structure;
The work order that can be released native system key by step 301 and 302 is repairSheet; The data that repairSheet work order comprises have repairing information (report people's information for repairment, report place for repairment, report the time for repairment, report reason for repairment), repair message (maintenance people, maintenance materials, servicing time, fault photo) and return visit information (paying a return visit people, repay time, return visit result).
Step 303: add work order node according to step 301 and 302;
Step 304: delete work order node according to step 301 and 302;
Step 305: according to step 301 and 302 editor's work order nodes;
Step 306: PrimaryKey and Relationship attribute in work order are set;
The repair_ID arranging in repairSheet work order is PrimaryKey; Repair message and maintenance materials information are the relation of one to many.
Step 307: generate work order tree structure;
Step 308: work order data are saved as to XML file;
In repairSheet.xml, write static part, comprise work order head statement < xml version=" 1.0 " encoding=" UTF-8 " ><Artifact>LEss T.LTssT.LT/Artifact>.Then traveling through work order tree will be such as: <Node><levelGrea tT.GreaT.GT0</level>LEssT.LTs sT.LTvalue>repair_ID</valueGr eatT.GreaT.GT<parent>nullLEss T.LTssT.LT/parent><limitGreat T.GreaT.GTunLimit</limit>LEss T.LTssT.LT/Node> adds in <Artifact> label.
The heating installation that Fig. 4 provides for the embodiment of the present invention reports the schematic diagram of work order and underlying database mapping for repairment, comprises the following steps:
Step 401: obtain repairSheet.xml file from the file directory of specifying;
Step 402: will select work order repairSheet.xml file and resolve to tree structure by engine;
Step 403: the information of obtaining original bottom Service Database;
Step 404: select database table in the database table list of specifying, its field is listed;
Step 405: the Mapping mapping algorithm of being introduced by mapping block, shines upon work order node and database table field
In repairSheet work order, repair_ID is PrimaryKey, thus can only with database in major key field shine upon; Other node just can be according to the random mapping of corresponding relation.But the mapped file generating needs an algorithm: Mapping algorithm.
Map algorithm (pseudo-code):
Void?map(ANode?a,TNode?t)
Step 406: by mapping algorithm generating mapping file repair_map.xml.
In repair_map.xml, write static part, comprise work order head statement < xml version=" 1.0 " encoding=" UTF-8 " ><map>LEssT.LTs sT.LT/map>.Then adopt mapping algorithm by repairSheet node and database table field generate mapping relations such as: <relation><artif act>repair_ID</artifactGreatT .GreaT.GT<tableName>repairLEs sT.LTssT.LT/tableName><fieldG reatT.GreaT.GTId</field>LEssT .LTssT.LT/relation> adds in <map> label.
The heating installation that Fig. 5 provides for the embodiment of the present invention reports the schematic diagram that work order and jBPM Task node are bound for repairment, comprises the following steps:
Step 501: obtain repairSheet.xml file from the file directory of specifying;
Step 502: will select work order repairSheet.xml file and resolve to tree structure by engine;
Step 503: make jBPM according to operation flow and report process flow diagram for repairment;
Step 504: from jBPM, report process flow diagram for repairment and select Task node,
Step 505: by work order node with report process flow diagram for repairment and select Task node to bind;
Step 904, from repairSheet work order tree structure, select the node-attribute corresponding with Task node, generation XML binding file.
In repair_binding.xml, write static part, comprise work order head statement < xml version=" 1.0 " encoding=" UTF-8 " ><Binding>LEssT .LTssT.LT/Binding>.Then the Task node of repairSheet node and jBPM is bound such as: <Field><artifact >repair_ID</artifactGreatT.Gr eaT.GT<info>1000LEssT.LTssT.L T/info></Field> adds in <Binding> label.Preferably, wherein the content in <info> label is the storage developer extraneous information additional to each field: reading and writing, modification, other etc.Automatic production of HTML page reference after these information are available to.
Above embodiment only, in order to technical scheme of the present invention to be described, is not intended to limit; Although the present invention is had been described in detail with reference to previous embodiment, those of ordinary skill in the art is to be understood that; Its technical scheme that still can record aforementioned each embodiment is modified, or part technical characterictic is wherein equal to replacement; And these modifications or replacement do not make the essence of appropriate technical solution depart from the spirit and scope of various embodiments of the present invention technical scheme.
Claims (6)
1. a method for Work stream data modeling, is characterized in that, the method comprises:
According to the demand analysis of upper-layer service, based on work order formation rule structure work order;
Field in node in the work order of structure and basic primary data storehouse is shone upon one by one, and provide application interface for upper-layer service;
The active node of the workflow of the node in the work order of structure and upper-layer service is bound.
2. according to the method described in claim 1, it is characterized in that, described according to the demand analysis of upper-layer service, based on work order formation rule structure work order, comprising:
According to the demand analysis of upper-layer service, adopt work order formation rule to obtain work order and construct required node;
Required node is added to work order node, and work order nodal community is set;
According to the attribute of work order node, generate work order tree structure.
3. method according to claim 2, is characterized in that, described field in node in the work order of structure and basic primary data storehouse is shone upon one by one, comprising:
Obtain the information of original bottom Service Database, and the field of selecteed database table is wherein listed;
Utilize mapping algorithm that work order node and database table field are shone upon, and generating mapping file.
4. method according to claim 3, is characterized in that, described mapping algorithm is Mapping algorithm.
5. method according to claim 4, is characterized in that, the described active node by the node in the work order of structure and workflow is bound, and comprising:
According to upper-layer service, formulate workflow diagram;
Select the task node in workflow diagram, by the node binding of itself and work order, and generate XML binding file.
6. method according to claim 1, it is characterized in that, described application interface comprises: the connecting interface in basic primary data storehouse, node mapping interface, mapping relations are checked interface, mapping relations edition interface, service logic access interface and mapping relations saving interface.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310727460.XA CN103745310A (en) | 2013-12-25 | 2013-12-25 | Workflow data modeling method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310727460.XA CN103745310A (en) | 2013-12-25 | 2013-12-25 | Workflow data modeling method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103745310A true CN103745310A (en) | 2014-04-23 |
Family
ID=50502327
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310727460.XA Pending CN103745310A (en) | 2013-12-25 | 2013-12-25 | Workflow data modeling method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103745310A (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104077669A (en) * | 2014-07-23 | 2014-10-01 | 中国科学院自动化研究所 | General self-customizing and driven execution method for computer workflow |
| CN104504547A (en) * | 2014-12-15 | 2015-04-08 | 北京京东尚科信息技术有限公司 | Work order generating method and system supporting goods physical distribution |
| CN107122171A (en) * | 2017-03-23 | 2017-09-01 | 北京邮电大学 | Automatically generate the method and system of data manipulation in operation flow |
| CN107943457A (en) * | 2017-11-17 | 2018-04-20 | 中山大学 | A kind of workflow modeling method and system of service-oriented object |
| CN109670767A (en) * | 2018-09-25 | 2019-04-23 | 深圳壹账通智能科技有限公司 | Processing method, device, terminal device and the storage medium of workflow |
| CN111861100A (en) * | 2020-06-03 | 2020-10-30 | 广东电网有限责任公司 | Work order processing method and device based on process scoring |
| CN114781328A (en) * | 2022-06-21 | 2022-07-22 | 成都中科合迅科技有限公司 | Method for visually arranging business process based on plaintext file |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040133660A1 (en) * | 2002-10-15 | 2004-07-08 | International Business Machines Corporation | Dynamic portal assembly |
| CN101013488A (en) * | 2007-01-15 | 2007-08-08 | 浪潮集团有限公司 | Method for implementing knowledge exhibition of knowledge management software |
| CN102136109A (en) * | 2011-04-14 | 2011-07-27 | 西安电子科技大学 | Product structure tree-based design flow dynamic modeling method |
| CN103150344A (en) * | 2013-02-06 | 2013-06-12 | 湖北微驾技术有限公司 | Driving training examination system data access method based on ORM (object relational mapping) framework |
-
2013
- 2013-12-25 CN CN201310727460.XA patent/CN103745310A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040133660A1 (en) * | 2002-10-15 | 2004-07-08 | International Business Machines Corporation | Dynamic portal assembly |
| CN101013488A (en) * | 2007-01-15 | 2007-08-08 | 浪潮集团有限公司 | Method for implementing knowledge exhibition of knowledge management software |
| CN102136109A (en) * | 2011-04-14 | 2011-07-27 | 西安电子科技大学 | Product structure tree-based design flow dynamic modeling method |
| CN103150344A (en) * | 2013-02-06 | 2013-06-12 | 湖北微驾技术有限公司 | Driving training examination system data access method based on ORM (object relational mapping) framework |
Non-Patent Citations (1)
| Title |
|---|
| 高云鹏: "基于JBPM的呼叫中心服务子系统的设计与实现", 《中国优秀硕士学位论文全文数据库 信息科技辑》 * |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104077669A (en) * | 2014-07-23 | 2014-10-01 | 中国科学院自动化研究所 | General self-customizing and driven execution method for computer workflow |
| CN104077669B (en) * | 2014-07-23 | 2017-10-17 | 中国科学院自动化研究所 | The universal method that a kind of autonomous customization of computer operation stream is performed with driving |
| CN104504547A (en) * | 2014-12-15 | 2015-04-08 | 北京京东尚科信息技术有限公司 | Work order generating method and system supporting goods physical distribution |
| CN104504547B (en) * | 2014-12-15 | 2017-10-20 | 北京京东尚科信息技术有限公司 | A kind of work order generation method and system supported for kinds of goods logistics |
| CN107122171A (en) * | 2017-03-23 | 2017-09-01 | 北京邮电大学 | Automatically generate the method and system of data manipulation in operation flow |
| CN107943457A (en) * | 2017-11-17 | 2018-04-20 | 中山大学 | A kind of workflow modeling method and system of service-oriented object |
| CN109670767A (en) * | 2018-09-25 | 2019-04-23 | 深圳壹账通智能科技有限公司 | Processing method, device, terminal device and the storage medium of workflow |
| CN111861100A (en) * | 2020-06-03 | 2020-10-30 | 广东电网有限责任公司 | Work order processing method and device based on process scoring |
| CN114781328A (en) * | 2022-06-21 | 2022-07-22 | 成都中科合迅科技有限公司 | Method for visually arranging business process based on plaintext file |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103745310A (en) | Workflow data modeling method | |
| CN102663103B (en) | Configurable method for automatically generating database and accessing data | |
| CN101794226B (en) | Service software construction method and system adapting to multiple business abstraction levels | |
| CN105094818B (en) | Natural resources integrated application construction method and system based on SOA | |
| CN106445536B (en) | Automatic business design management system | |
| CN104598376A (en) | Data driving layered automation test system and method | |
| CN104866426A (en) | Software test integrated control method and system | |
| CN103049251B (en) | A kind of data base persistence layer device and database operation method | |
| CN111984709A (en) | Visual big data middle station-resource calling and algorithm | |
| CN105808428A (en) | Method for performing unified performance test on distributed file system | |
| CN104049957A (en) | Rapid modeling frame of general business model based on star structure | |
| CN106873974A (en) | Smart code generates automotive engine system and method | |
| CN103455591A (en) | Standard data exchange interface method of parallel cooperative system | |
| CN103425468A (en) | Method and device for integrating plug-in type software | |
| CN113204329A (en) | Control method for driving business application by unified data model and application system thereof | |
| CN106127401B (en) | Enterprise information system modeling method and device | |
| CN103699746B (en) | CADDS5 piping three-dimensional design method based on data base and system | |
| CN116029648A (en) | Relationship modeling management method, device and system based on product BOM structure | |
| CN116257636A (en) | Unified management method and device for enumerated data dictionary, electronic equipment and storage medium | |
| CN105260821A (en) | Method for rapidly constructing energy efficiency evaluation service for high-energy-consumption electricity enterprise | |
| CN106843825A (en) | A kind of software configuration management method based on Temporal Model | |
| Guo et al. | A data-driven software testing tools integration system | |
| CN107844639B (en) | Project standard structure automatic generation method and system | |
| CN101458709B (en) | Complex test data retroactive method | |
| Huang et al. | Research on intelligent cloud test platform |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20140423 |