CN109615554B - Synchronous data system based on intelligent manufacturing and operation method and synchronization method thereof - Google Patents
Synchronous data system based on intelligent manufacturing and operation method and synchronization method thereof Download PDFInfo
- Publication number
- CN109615554B CN109615554B CN201811485947.0A CN201811485947A CN109615554B CN 109615554 B CN109615554 B CN 109615554B CN 201811485947 A CN201811485947 A CN 201811485947A CN 109615554 B CN109615554 B CN 109615554B
- Authority
- CN
- China
- Prior art keywords
- data
- transaction
- entity
- state
- work
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 120
- 238000004519 manufacturing process Methods 0.000 title claims abstract description 45
- 230000001360 synchronised effect Effects 0.000 title claims abstract description 36
- 238000012545 processing Methods 0.000 claims abstract description 51
- 230000008569 process Effects 0.000 claims description 92
- 238000000605 extraction Methods 0.000 claims description 24
- 238000012423 maintenance Methods 0.000 claims description 7
- 238000004458 analytical method Methods 0.000 claims description 6
- 238000007405 data analysis Methods 0.000 claims description 6
- 230000026676 system process Effects 0.000 claims description 5
- 238000013467 fragmentation Methods 0.000 claims description 4
- 238000006062 fragmentation reaction Methods 0.000 claims description 4
- 238000012216 screening Methods 0.000 claims description 3
- 238000003672 processing method Methods 0.000 claims description 2
- 230000002596 correlated effect Effects 0.000 abstract 2
- 230000000875 corresponding effect Effects 0.000 abstract 2
- 238000010586 diagram Methods 0.000 description 5
- 238000002360 preparation method Methods 0.000 description 5
- 230000008901 benefit Effects 0.000 description 4
- 239000000284 extract Substances 0.000 description 3
- 238000009826 distribution Methods 0.000 description 2
- 238000007726 management method Methods 0.000 description 2
- 230000000295 complement effect Effects 0.000 description 1
- 238000004883 computer application Methods 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 230000003111 delayed effect Effects 0.000 description 1
- 239000006185 dispersion Substances 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000002708 enhancing effect Effects 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000005457 optimization Methods 0.000 description 1
- 230000008520 organization Effects 0.000 description 1
- 238000013468 resource allocation Methods 0.000 description 1
- 230000033772 system development Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/04—Manufacturing
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0633—Workflow analysis
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Engineering & Computer Science (AREA)
- Strategic Management (AREA)
- Economics (AREA)
- Entrepreneurship & Innovation (AREA)
- Tourism & Hospitality (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- Marketing (AREA)
- Physics & Mathematics (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Game Theory and Decision Science (AREA)
- Educational Administration (AREA)
- Development Economics (AREA)
- Manufacturing & Machinery (AREA)
- Health & Medical Sciences (AREA)
- General Health & Medical Sciences (AREA)
- Primary Health Care (AREA)
- Data Mining & Analysis (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a synchronous data system based on intelligent manufacturing and an operation method and a synchronization method thereof, wherein the system comprises an upper layer, a middle layer and a bottom layer; wherein the bottom layer comprises: basic parameter data, project entity data; the upper layer comprises: data entity table, state fact data; an intermediate layer: the method comprises a transaction linked list, wherein basic parameter information and entity project information of a transaction are correlated and displayed on the transaction linked list through a link code, corresponding working templates are correlated through the link code according to transaction processing flow nodes, work is carried out, and working states are recorded through state fact data to form a record. The synchronous data system provided by the invention takes the transaction link table as the middle layer, and links the related data of the upper layer and the bottom layer by the link codes respectively, so that the system automatically reads the processed transaction information, automatically applies the corresponding templates of the upper layer and the bottom layer according to the information content, expands the working template and records the state, thereby reducing the processing time of the system and saving the labor cost.
Description
Technical Field
The invention relates to a synchronous data system based on intelligent manufacturing and an operation method and a synchronization method thereof.
Background
Workflow (Workflow) refers to "automation of a portion or the whole of a business process in a computer application environment". The method is an abstract and general description of the workflow and the business rules among the operation steps of the workflow. In computers, workflows are part of Computer Supported Collaborative Work (CSCW). The latter is a general study on how a group can achieve cooperative work with the help of computers.
The main problems mainly solved by the workflow are as follows: to achieve a business goal, documents, information, or tasks are automatically communicated between multiple participants using a computer according to some predetermined rule.
The workflow concept originates from the field of production organization and office automation, is a concept provided aiming at the fixed program activities in daily work, and aims to decompose the work into well-defined tasks or roles, execute the tasks according to certain rules and processes and monitor the tasks, so that the aims of improving the work efficiency, better controlling the process, enhancing the service to customers, effectively managing the business process and the like are fulfilled. Although workflows have achieved considerable success, the definition of workflows has not been unified and unambiguous.
A data stream refers to a set of ordered bytes having a start point and an end point, and can be used by a program to receive data from a keyboard or write data to a file, and to perform data reading and writing operations over a network connection.
As far as this is concerned, the interaction between workflow and data flow is becoming more and more powerful with the construction of informatization. The data not only comprises basic data, but also is often more valuable to the work of different enterprises, the data is generated in the work, and ideally, the data flow is accumulated through the workflow, and the workflow is optimized through the data flow. The smoother the workflow is, the more the connection is, the more the obtained data can be, and the greater the benefit of guiding the optimization of the workflow can be. The more powerful and optimized the data flow, the smoother the possible work, and the better the performance of the workflow, which is itself an complementary process.
However, in the current modeling enterprises, the workflows used in each link of the internal production of the enterprise are deployed and used at different periods. The mutual integration of work and work can not be realized, which causes the problems of system dispersion, respective administration and high system maintenance and management cost, an enterprise management layer can not control the whole production progress globally, flexible compilation and adjustment of various plans are limited, the feedback of plan execution is delayed, the resource allocation of an enterprise can not be optimized in the global scope, and the overall production efficiency of the enterprise is reduced.
Disclosure of Invention
The purpose of the invention is as follows: in view of the above problems, an object of the present invention is to provide a synchronous data system based on intelligent manufacturing, which establishes parallel data stream distribution on a serial workflow system to realize cooperative operation of each node of the workflow.
The other objective of the present invention is to provide an implementation procedure of a synchronous data system, which presets a serial rule of a workflow according to the interrelation between process nodes, and the system automatically controls the workflow according to the serial rule according to the status identifier of each record in the transaction linked list, and forms the workflow by overlapping each record in the transaction linked list.
It is still another object of the present invention to provide a method for creating a synchronization database with a simple structure and a wide adaptability.
The technical scheme is as follows: in order to achieve the above object, the present invention provides a synchronous data system, which is a hierarchical structure and includes an upper layer, a middle layer, and a bottom layer;
wherein, the bottom layer includes: basic parameter data for standardizing and defining basic parameters of system processing affairs; project entity data, which is used for defining entity projects in the transaction processed by the system in a standardized way;
the upper layer comprises: the data entity table is used for setting a working template of each node of the system processing affair working process and storing working data, and each working process node forms a data entity table;
the state fact data is used for storing the finishing identification of each node of the system transaction processing workflow in the data entity table, and one data entity table corresponds to one state fact data;
an intermediate layer: the system comprises a transaction linked list, wherein basic parameter information and entity project information of a processed transaction are associated and displayed on the transaction linked list through a link code, a corresponding working template is associated through the link code according to a transaction processing flow node, the work is carried out, and the working state is recorded through state fact data. The invention establishes a system which takes a transaction link table as an intermediate layer and links basic parameter data and project entity data of a bottom layer through a link code; and linking the data entity table and the state fact data of the upper layer through a link code to form a hierarchical structure. When the system processes a transaction, the basic parameter information and the entity project information of the processed transaction are automatically associated and displayed on a transaction link table through information reading, corresponding working templates are associated according to implementation steps of transaction processing flow nodes, work is carried out, and working states are recorded through state fact data. The synchronous data system provided by the invention can automatically read information according to the affairs processed by the system, automatically apply the template according to the information content, expand the working template and record the state, reduce the processing time of the system and greatly save the labor cost.
The basic parameter data can be stored in the forms of data tables, pictures, text documents and the like;
project entity data is a set of parameters that describe a project entity and its entities.
The system processes several transactions, and several records corresponding to the transactions are formed in the transaction linked list.
In the system, the underlying basic parameter data and the project entity data are respectively linked with a transaction link table by using the dimension data and the entity project data as link codes.
In the system, an upper layer data entity table is linked with a transaction link table by taking a service main key as a link code, and a state fact table is linked with the transaction link table through an agent key.
The system comprises an extracting unit and an updating unit,
the extraction unit is specifically a system function fragmentation unit and is used for extracting the data of the transaction processed by the system, fragmenting the data according to the function and storing the data in a transaction link table, and the extraction unit also maintains basic parameter data and project entity data;
the updating unit is a system function fragmentation unit, divides the transaction data processed by the system into working templates according to functions, analyzes and processes the working templates and forms records in a data entity table, and after the transaction data is analyzed and processed, the updating unit records the ending identifier in the state fact data. Different data entity tables correspond to different data analysis processing methods;
the extraction unit includes: an extraction module and a maintenance module;
the extraction module is used for extracting the data of the transaction processed by the system, dividing the data into data of different process nodes according to functions and storing the data in a transaction link table;
the maintenance module checks the data obtained by the extraction module for duplication in the basic parameter data and the project entity data, judges whether the data is new data or not, and automatically adds the data if the data is the new data; if the data is not new data, the data is not added.
The update unit includes: the device comprises an analysis module and a processing module;
the analysis module is used for analyzing the transaction data in the transaction link table and storing the transaction data in the data entity table;
and the processing module is used for storing the finishing identifier after the transaction data analysis processing is finished in the state fact data.
The implementation steps of the system comprise the following steps:
(1) establishing basic parameter data for standardizing and defining system processing transaction parameters in advance according to system processing transaction contents; project entity data used for standardizing entity projects in transactions processed by a definition system are established in advance;
(2) presetting a working template aiming at different process nodes based on the working process of system processing affairs, wherein the working template of each working process node forms a data entity table;
(3) defining a finishing identifier of state fact data according to each process node based on the system processing transaction workflow; presetting a serial rule of a workflow according to the interrelation among the process nodes to specify the execution steps of the workflow;
(4) each data entity table corresponds to one state fact data according to each node of the system processing transaction workflow, and each process node shows the node state through the data entity table or the state fact data;
(5) after the transaction information is input into the transaction linked list, each process node sequentially expands related work according to a serial rule, and an analysis module expands a corresponding work template in a data entity table after analyzing the transaction information to complete work and form records, and updates the state of the transaction linked list;
(6) after the work of one process node is finished, the processing module of the updating unit updates the record ending identifier in the state fact data, the work is ended, the record of the update ending identifier forms archive data which is stored in an archive database, and the transaction link table updates the state;
(7) and 6, after the work is finished, updating a finishing mark, wherein the finishing mark is an initial mark of the next work, so that the next work template is automatically unfolded for work, and the work flow is automatically controlled by combining the serial rule of the business work flow.
The transaction link table records the work flow of the system processing transaction, and each record in the transaction link table corresponds to one transaction processed by the system;
after a plurality of items of transaction information are input into the transaction link table, the same working template is expanded based on the same flow node to complete corresponding work, and records are respectively formed to realize the state update of each transaction.
The serial rule of the combined transaction workflow in the step (7) is specifically that the ending mark of one piece of work is the starting condition of the next piece of work in the serial rule, and after the state of one piece of work is updated to be ending, the next piece of work can be automatically started, so that the automatic control of the workflow is realized.
The state fact data of the system establishes a data link with a data entity table through an agent key, and the data entity table establishes a data link with a transaction link table through a service main key to realize data integrity constraint;
and screening the data entity table and the transaction link table through the completion identifier by the state fact data, forming archived data for the data with the completion identifier, and storing the archived data in an archived database.
The synchronization method of the system comprises the following steps:
(1) each work flow node forms a data entity table, each data entity table establishes data link with the business key of the transaction link table through the business key, the same data are shared, and the data of each flow node are synchronous;
(2) each process node forms a data record and a finishing identifier of state fact data by a one-way output stream to form an open-loop system;
(3) the working template of each workflow node forms a data entity table, and the data entity table respectively completes related work and completes the update of the working state; each process node of the transaction linked list shows the state of the corresponding data entity table;
updating the state of the data entity table, updating the state of the corresponding process node in real time, and updating the state of the transaction link table accordingly to realize the state synchronization of the work process node;
(4) each record in the transaction link table corresponds to a transaction processed by the system, a plurality of items of transaction information can expand the same working template based on the same process node to complete corresponding work, and records are formed respectively to realize the state updating of each transaction;
the related work of each transaction at each process node realizes work cooperation.
An intelligent manufacturing-based synchronous data system, the creation method comprises the following steps:
(1) establishing an index according to the entity items of the transaction processed by the system, forming a parameter data set of the entity items, and converting the parameter data set into item entity data;
(2) setting transaction process nodes according to the transaction process processed by the system, and establishing working templates corresponding to the nodes according to the process nodes to form a data entity table;
(3) extracting basic parameter information from the system transaction processing data extracted by the extraction module to establish an index, forming a parameter data set, and converting the parameter data set into basic parameter data;
(4) forming a system processing transaction data set by the system processing transaction data extracted by the extraction module, and converting the system processing transaction data set into a transaction linked list;
(5) and (3) setting each flow node according to the step (2), setting ending marks of transaction data analysis processing results, taking the ending mark of one work as the start of the other work, and converting the ending marks into state fact data.
The working principle is as follows: the synchronous data system establishes a transaction link table as a middle layer, and links basic parameter data and project entity data of a bottom layer through link codes; and the data entity table on the upper layer is linked through the link code, and the state fact data is connected with the data entity table through the surrogate key to form a hierarchical structure. When the system processes a transaction, the extraction unit automatically associates the basic parameter information and the entity item information of the processed transaction with the basic parameter data and the item entity data by extracting the transaction information; and developing the flow nodes required by processing the project by taking the entity project name as a link key; combining the basic parameter data, the project entity data and the process node to form a piece of data in a transaction linked list;
associating corresponding work templates to carry out work according to the implementation steps of the transaction process nodes, changing the state of the process nodes through data generated by the work, and automatically controlling the work process by referring to serial rules preset by a system by the state of the process nodes;
the synchronous system only displays the working state by the process node, the data entity table corresponding to the node implements specific work, and the data entity table is sequentially opened and executed according to the serial rule by the process node state, so that the system only executes a certain node in the serial rule to work all the time, the system operation amount is reduced, the operation efficiency is improved, and the cooperative operation of data and work is realized.
Has the advantages that: compared with the prior art, the invention has the following advantages:
1. and (3) working cooperation: according to the invention, through a synchronous data system based on intelligent manufacturing, parallel data stream distribution is established on a serial workflow system, and the cooperative operation of each node of the workflow is realized.
2. Data synchronization: in the invention, on a serial workflow system, each workflow node of the system forms a data entity table, and each data entity table establishes data connection with a business main key of a transaction linked list through the business main key, thereby realizing parallel publishing of data streams and sharing the same data.
3. And (3) state synchronization: the work templates of each work flow node form a data entity table, so that the work of the work flow nodes can be asynchronously paralleled, the related work and the update state are processed respectively, and the states of the work flow nodes are synchronous.
4. And (3) real-time feedback: according to the method, each process node forms a data record of a data entity table and a finishing identifier of state fact data through a one-way output stream to form an open loop feedback system, and the process nodes realize real-time feedback through displaying the data record or the finishing identifier; the problem of data asynchronism caused by backward feedback of the data flow to the input point is avoided, and the system operation efficiency is improved.
5. The system is simplified: the invention screens the data of the data entity table and the transaction link table by defining the ending mark in the state fact data and referring to the ending mark, and forms archived data for the existing ending mark, and the archived data is stored in an archived database, does not participate in system operation, and reduces the system operation workload.
6. The establishing method is simple: the invention can pre-establish basic parameter data and project entity data according to different projects, pre-establish serial rules for presetting the working process according to the interrelation among the process nodes, define the ending mark of the state fact data according to the serial rules, automatically control the working process according to the serial rules by the system according to the ending mark, and has the advantages of simple establishing method, low system development and maintenance cost and wide application range.
7. Labor cost is saved: the synchronous data system provided by the invention establishes a synchronous data system which takes a transaction link table as a middle layer and links basic parameter data and project entity data of a bottom layer through link codes; and linking the data entity table and the state fact data of the upper layer through a link code to form a hierarchical structure. When the system processes a transaction, the basic parameter information and the entity project information of the processed transaction are automatically associated and displayed on a transaction link table through information reading, corresponding working templates are associated according to implementation steps of transaction processing flow nodes, work is carried out, and working states are recorded through state fact data. The synchronous data system provided by the invention can automatically read information according to the affairs processed by the system, automatically apply the template according to the information content, expand the working template and record the state, reduce the processing time of the system and greatly save the labor cost.
Drawings
FIG. 1 is a logical block diagram of the present invention;
FIG. 2 is a data flow diagram of the present invention;
FIG. 3 is a block diagram of a cell level according to the present invention;
FIG. 4 is a block diagram of a module level of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Example 1
An intelligent manufacturing-based synchronous data system, the creation method comprises the following steps:
(1) an entity A and an entity B … … entity N of a project processed by the system take an entity name as an index, and attribute parameters such as the number, the type, the project attribution and the like of the entity A and the entity B … … entity N are respectively defined in a standardized way to be used as parameter data sets to form project entity data;
(2) respectively presetting serial rules of the work flow according to the interrelation between each process node of the entity A and the entity B … … in the transaction processing of the entity N, setting work templates corresponding to each process node, and forming a data entity table;
setting the ending mark of the transaction data analysis processing result, taking the ending mark of one work as the starting condition of the other work, and converting the ending mark into state fact data.
(3) Each process node sets a data entity table, and when the entity project transactions are processed differently, the same process node sets the same working template and forms the same entity table;
(3) the extraction module extracts data from system processing transaction information, wherein the processing transaction information comprises: order number, entity name, entity number, type, item attribution, item type, item characteristic parameter, quantity and other parameters, extracting information such as item attribution, item type, item characteristic parameter and the like as basic parameter data, taking the basic parameter data as an index, defining the basic parameter data in a standardized manner to form a parameter data set, and establishing basic parameter data;
(4) the extraction module extracts data from the system processing transaction information, takes the item order number as an index, and attribute parameter data such as the entity name of an order item, the attribution of the order item and the like are linked with the item entity data and the basic parameter data by taking the item entity name and the item attribution as link keys and are expanded in a transaction link table;
expanding flow nodes required for processing the entity project by using the entity project name as an index, wherein one flow node corresponds to one data entity table;
the project order number is used as an index, and the associated project entity data, basic parameter data and workflow nodes are combined to form a record of the transaction linked list.
The status fact data establishes a data link with the order number of the data entity table through the order number,
the flow node information, the data entity table work record corresponding to the flow node and the finishing mark in the state fact data which are sequentially displayed by each flow node in the transaction linked list respectively represent three states of waiting, running and finishing of the node.
The above constitutes a data flow diagram as shown in fig. 2.
Example 2
An intelligent manufacturing-based synchronized data system, the implementation steps comprising:
(1) an entity A and an entity B … … entity N of a project processed by the system take an entity name as an index, and attribute parameters such as the number, the type, the project attribution and the like of the entity A and the entity B … … entity N are respectively defined in a standardized way to be used as parameter data sets to form project entity data;
(2) respectively presetting serial rules of the work flow according to the interrelation between each process node of the entity A and the entity B … … in the transaction processing of the entity N, setting work templates corresponding to each process node, and forming a data entity table;
(3) each process node sets a data entity table, and when different entity project transactions are processed, the same process node sets the same working template and forms the same entity table;
(4) the extraction module extracts data from system processing transaction information, wherein the processing transaction information comprises: order number, entity name, entity number, type, item attribution, item category, item characteristic parameter, quantity and other parameters, extracting information such as item attribution, item category, item characteristic parameter (basic parameters are a little less, some basic parameter content can be added) and the like as basic parameter data, taking the basic parameter data as an index, defining the basic parameter data in a standardized way to form a parameter data set, and establishing basic parameter data;
(5) after the system receives the transaction information of the project order A, as shown in fig. 3 and 4, the system automatically acquires the transaction data in the order through the extraction module in the extraction unit, wherein the transaction data comprises the transaction data; order number, order item entity name A, order quantity, order item attribution, item category, item characteristic parameter and other attribute parameters, wherein the order item attribution is linked with the transaction link table by taking the item attribution as a link key; the item category is linked with the transaction link table by a category name called a link key; the project characteristic parameters are linked with the transaction link table by taking the characteristic names as link keys; the entity name of the order item is respectively linked with the transaction connection table by taking the entity name as a link key;
meanwhile, for the order item entity, the order item attribution, the item category and the item characteristic parameter data obtained by the extraction module, the maintenance module of the extraction unit checks the data for duplication in the item entity data and the basic parameter data to judge whether the data is new data or not,
if the data is new, automatically adding the new data to corresponding basic parameter data or project entity data;
if the data is not new data, the data is not added.
The project order number is used as an index, and the associated project entity data, basic parameter data and project entity A workflow node are combined to form a record of a transaction linked list.
(6) Each process node of the project entity A transaction processing comprises purchasing, production and shipment, serial rules of a work process are preset according to the mutual relation among the process nodes, specifically, the ending mark of one process node is the starting condition of the work of the lower process node in the serial rules, and after the work state of a certain process node is updated to be ending, the work of the next process node is automatically started;
namely, when the purchase is started, the production enters a preparation state; after the purchase is finished, production is started, the shipment work enters a preparation state, and after the production is finished, the shipment work is started;
(7) after the extraction unit inputs order transaction information into a transaction link table, an updating module of an updating unit expands corresponding working templates of purchasing, production, shipment and the like according to a serial rule, each process node corresponds to a data entity table, when purchasing work starts, the corresponding purchasing working template is used for finishing work in the corresponding data entity table, purchasing records are formed, the updating module of the updating unit updates the transaction state to be a purchasing starting state, and meanwhile, production and shipment enter a preparation state;
(8) after the purchasing work is finished, a processing module of the updating unit records the purchasing completion identifier in the state fact data, meanwhile, the purchasing process node of the transaction linked list shows that the purchasing is completed, and according to the serial rule, the next process node is produced, meets the starting condition and automatically starts to produce;
the ending mark of one process node is the starting condition of the work of the lower process node in the serial rule, and after the work state of one process node is updated to be the ending, the work of the next process node is automatically started, so that the automatic control of the system on the work flow is realized; the data of each node in the working process is synchronized, and the cooperative operation of work and data is realized.
(9) The state fact data establishes a data link with the data entity table through the order number, and the order number of the data entity table establishes a data link with the transaction link table to realize data integrity constraint; after the purchase completion identifier is generated, the order transaction data, the purchase data and the purchase completion identifier form a data integrity constraint together, and the order transaction data and the purchase data cannot be modified/deleted after the purchase completion identifier is generated; production and shipment and other physical operations.
(10) Screening data of the data entity table and the transaction link table according to the ending identifier in the state fact data, forming archived data for the existing ending identifier, and storing the archived data in an archived database, wherein the archived data does not participate in system operation, and the operation workload of the system is reduced;
for example, after the purchasing completion identifier is generated, the completed purchasing record forms a archived data storage and archiving database, and when purchasing is inquired, the completed purchasing data is not inquired, so that the operation workload of the system is reduced; production and shipment and other physical operations.
Example 3
A synchronous data system based on intelligent manufacturing comprises a synchronous implementation method and a synchronous implementation device, wherein the synchronous implementation method comprises the following steps:
1. aiming at a project order A, each work flow node of purchase, production and shipment forms a data entity table respectively, each data entity table shares the same order data and the data entity table data of the process nodes of purchase, production, shipment and the like with the project order A in a transaction link table through order numbers, and project order data, real-time purchase condition, real-time production condition and real-time shipment condition can be checked at any node to realize the data synchronization of each process node;
2. the working template of each workflow node forms a data entity table, and the data entity table respectively completes related work and completes the update of the working state;
updating the state of the data entity table, updating the state of the corresponding process node in real time, and updating the state of the transaction link table accordingly to realize the state synchronization of the work process node;
the working templates of the purchasing, production and shipment process nodes respectively form a purchasing data entity table, a production data entity table and a shipment data entity table, each data entity table establishes data connection with a transaction link table through an order number, and each process node of the transaction link table shows the state of the corresponding data entity table;
updating the state of the data entity table, updating the state of the corresponding process node in real time, and updating the state of the transaction link table accordingly to realize the state synchronization of the work process node;
for example, if the order status is queried by the production node to be the purchasing working status, the production preparation related work can be started;
after the purchasing work is finished, the purchasing state is updated to purchasing completion, the transaction state is automatically updated to purchasing completion to be produced, the production node automatically starts the production work, and meanwhile, the system prompts the shipment node to enter the preparation state.
3. Each process node forms a data record and a finishing identifier of state fact data by a unidirectional output stream to form an open loop system, and the process node of the transaction linked list shows the data record or the finishing identifier;
for example: after the project order information is generated, nodes such as purchasing, production, shipment and the like can expand a working template to inquire based on the project order information to form real-time feedback of order prompt;
after the purchasing node develops purchasing work based on the purchasing work template, a purchasing record is formed in the purchasing data entity table, the purchasing state in the transaction link table is updated accordingly, and real-time feedback of the purchasing state of the order is formed;
because the purchasing record is generated in the purchasing entity table by adopting the unidirectional output stream, the order information record in the transaction link table is not influenced, and the problem of data asynchronism caused by data stream reverse feedback input is avoided;
after the purchase is finished, because a one-way output stream is adopted to generate a purchase completion identifier in the purchase state data, the purchase state in the transaction link table is updated to a purchase completion state, and the real-time update of the purchase order state is formed; the purchase record in the purchase entity table is not influenced, the problem of data asynchronism caused by data flow reverse feedback input is avoided, and the system operation efficiency is improved.
4. Each record in the transaction link table corresponds to one transaction processed by the system;
if the transaction information of the project order A … … N is processed and the projects all contain the process node production, the same production work template can be expanded based on the same process node to complete the corresponding work and respectively form records to realize the update of the state of each transaction.
5. Each record in the transaction link table corresponds to one transaction processed by the system, for example, N project orders exist in the transaction link table, the states of the N project orders can be inquired at each node of purchase, production, shipment and the like, and related work is expanded through a work template in the corresponding data entity table by combining respective serial rules to form records respectively, so that the state update of each transaction is realized; the related work of each transaction at each process node realizes work cooperation.
The above embodiments are merely illustrative of the technical concepts and features of the present invention, and the purpose of the embodiments is to enable those skilled in the art to understand the contents of the present invention and implement the present invention, and not to limit the protection scope of the present invention. All equivalent changes or modifications made according to the spirit of the present invention should be covered within the protection scope of the present invention.
Claims (12)
1. A synchronous data system based on intelligent manufacturing is characterized in that: the system is of a hierarchical structure and comprises an upper layer, a middle layer and a bottom layer;
wherein, the bottom layer includes: basic parameter data for standardizing and defining basic parameters of system processing affairs; project entity data, which is used for defining entity projects in the transaction processed by the system in a standardized way;
the upper layer comprises: the data entity table is used for setting a working template of each node of the system processing affair working process and storing working data, and each working process node forms a data entity table;
the state fact data is used for storing the finishing identification of each node of the system transaction processing workflow in the data entity table, and one data entity table corresponds to one state fact data;
an intermediate layer: the system associates basic parameter data and project entity data through a link code according to transaction basic parameter information and entity project information and displays the data and the project entity data on the transaction link table, associates a corresponding working template through the link code according to a transaction processing flow node, and associates state fact data with a data entity table through an agent key.
2. The synchronized data system based on intelligent manufacturing of claim 1, wherein: the system processes several transactions, and several records corresponding to the transactions are formed in the transaction linked list.
3. The synchronized data system based on intelligent manufacturing of claim 1, wherein: in the system, the underlying basic parameter data and the project entity data are respectively linked with a transaction link table by using the dimension data and the entity project data as link codes.
4. The synchronized data system based on intelligent manufacturing of claim 1, wherein: in the system, an upper data entity table of the system is linked with a transaction link table by taking a service main key as a link code; the state fact data is connected with the data entity table by taking the surrogate key as a link code.
5. An intelligent manufacturing-based synchronized data system according to any of claims 1-4, wherein: the system comprises an extraction unit and an updating unit;
the extraction unit is specifically a system function fragmentation unit and is used for extracting the data of the transaction processed by the system, fragmenting the data according to the function and storing the data in a transaction link table, and the extraction unit also maintains basic parameter data and project entity data;
the updating unit is a system function fragmentation unit, divides the transaction data processed by the system into working templates according to functions, analyzes and processes the working templates and forms records in the data entity table, and after the transaction data is analyzed and processed, the updating unit records the finishing identification in the state fact data, and different data entity tables correspond to different data analysis and processing methods.
6. The synchronized data system based on intelligent manufacturing of claim 5, wherein: the extraction unit includes: an extraction module and a maintenance module;
the extraction module is used for extracting the data of the transaction processed by the system, dividing the data into data of different process nodes according to functions and storing the data in a transaction link table;
the maintenance module checks the data obtained by the extraction module for duplication in the basic parameter data and the project entity data, judges whether the data is new data or not, and automatically adds the data if the data is the new data; if the data is not new data, the data is not added.
7. The synchronized data system based on intelligent manufacturing of claim 5, wherein: the update unit includes: the device comprises an analysis module and a processing module;
the analysis module is used for analyzing the transaction data in the transaction link table and storing the transaction data in the data entity table;
and the processing module is used for storing the finishing identifier after the transaction data analysis processing is finished in the state fact data.
8. A synchronized data system based on intelligent manufacturing according to claim 1 or 3, wherein: the state fact data of the system establishes a data link with a data entity table through an agent key, and the data entity table establishes a data link with a transaction link table through a service main key to realize data integrity constraint;
and screening the data entity table and the transaction link table through the completion identifier by the state fact data, forming archived data for the data with the completion identifier, and storing the archived data in an archived database.
9. An operation method of a synchronous data system based on intelligent manufacturing is characterized in that: the method comprises the following steps:
(1) establishing basic parameter data for standardizing and defining system processing transaction parameters in advance according to system processing transaction contents; project entity data used for standardizing entity projects in transactions processed by a definition system are established in advance;
(2) presetting a working template aiming at different process nodes based on the working process of system processing affairs, wherein the working template of each working process node forms a data entity table;
(3) defining a finishing identifier of state fact data according to each process node based on the system processing transaction workflow; presetting a serial rule of a workflow according to the interrelation among the process nodes so as to specify the execution steps of the workflow;
(4) according to each node of the system processing transaction workflow, each data entity table corresponds to one state fact data, and each process node displays the node state through the data entity table or the state fact data;
(5) after the transaction information is input into the transaction linked list, each process node sequentially expands related work according to a serial rule, and an analysis module expands a corresponding work template in a data entity table after analyzing the transaction information to complete work and form records, and updates the state of the transaction linked list;
(6) after the work of one process node is finished, the processing module of the updating unit updates the record ending identifier in the state fact data, the work is ended, the record of the update ending identifier forms archive data which is stored in an archive database, and the transaction link table updates the state;
(7) and 6, updating a finish mark after the work is finished, wherein the finish mark is an initial mark of the next work, so that the next work template is automatically unfolded for work, and the work flow is automatically controlled by combining the serial rule of the work flow.
10. The method of claim 9, wherein the method comprises: the transaction link table records the work flow of the system processing transaction, and each record in the transaction link table corresponds to one transaction processed by the system;
after a plurality of items of transaction information are input into the transaction link table, the same working template is expanded based on the same flow node to complete corresponding work, and records are respectively formed to realize the state update of each transaction.
11. The method of claim 9, wherein the method comprises: the serial rule of the combined transaction workflow in the step (7) is specifically that the ending mark of one piece of work is the starting condition of the next piece of work in the serial rule, and after the state of one piece of work is updated to be ending, the next piece of work is automatically started, so that the automatic control of the workflow is realized.
12. A synchronous data system synchronization method based on intelligent manufacturing is characterized in that: the method comprises the following steps:
(1) based on any transaction processed by the system, each work flow node forms a data entity table, each data entity table establishes data link with the business main key of the transaction link table through the business main key, the same data is shared, and the data of each flow node is synchronous;
(2) the working template of each workflow node forms a data entity table, and the data entity table respectively completes related work and completes the update of the working state; establishing data connection between each data entity table and the transaction link table through the order number;
each process node of the transaction linked list shows the state of the corresponding data entity table;
updating the state of the data entity table, updating the state of the corresponding process node in real time, and updating the state of the transaction link table along with the update of the state of the data entity table to realize the state synchronization of the work process node;
(3) each process node forms a data record and a finishing identifier of state fact data by a one-way output stream to form an open-loop system; the flow node of the transaction linked list shows the data record or the ending identifier;
(4) each record in the transaction link table corresponds to a transaction processed by the system, a plurality of items of transaction information can expand the same working template based on the same process node to complete corresponding work, and records are formed respectively to realize the state updating of each transaction;
the related work of each transaction at each flow node realizes the work cooperation.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811485947.0A CN109615554B (en) | 2018-12-06 | 2018-12-06 | Synchronous data system based on intelligent manufacturing and operation method and synchronization method thereof |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811485947.0A CN109615554B (en) | 2018-12-06 | 2018-12-06 | Synchronous data system based on intelligent manufacturing and operation method and synchronization method thereof |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109615554A CN109615554A (en) | 2019-04-12 |
| CN109615554B true CN109615554B (en) | 2022-08-02 |
Family
ID=66006240
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811485947.0A Active CN109615554B (en) | 2018-12-06 | 2018-12-06 | Synchronous data system based on intelligent manufacturing and operation method and synchronization method thereof |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109615554B (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112149963B (en) * | 2020-08-28 | 2023-11-24 | 苏州伽顿全盛信息科技有限公司 | System state synchronization method and device based on data structure cross collaboration |
| CN114780506B (en) * | 2022-06-17 | 2022-10-21 | 希维科技(广州)有限公司 | Processing method of process file and electronic equipment |
| CN115423444B (en) * | 2022-08-03 | 2023-10-13 | 杭州新中大科技股份有限公司 | Heterogeneous system workflow integration method and system |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JPH07160636A (en) * | 1993-12-07 | 1995-06-23 | Toshiba Corp | Work flow system |
| CN101567068A (en) * | 2009-05-18 | 2009-10-28 | 北京方正春元科技发展有限公司 | Data-processing system used for financial information management |
| JP2010122908A (en) * | 2008-11-19 | 2010-06-03 | Ns Solutions Corp | Information processor, information processing method and program |
| CN104184595A (en) * | 2009-04-01 | 2014-12-03 | 高通股份有限公司 | managing transmissions among nodes communicating over a shared communication medium |
| CN104850665A (en) * | 2015-06-12 | 2015-08-19 | 江苏中威科技软件系统有限公司 | Method and system for realizing flow circulation based on flow embedding |
| CN105208090A (en) * | 2015-08-19 | 2015-12-30 | 江苏农牧人电子商务股份有限公司 | Zookeeper-based Leader selection method |
| CN108460511A (en) * | 2017-12-29 | 2018-08-28 | 陈菡 | A kind of workflow engine system and its implementation |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2017048907A1 (en) * | 2015-09-15 | 2017-03-23 | Skytree, Inc. | Federation and inter-organization collaboration in data analysis |
-
2018
- 2018-12-06 CN CN201811485947.0A patent/CN109615554B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JPH07160636A (en) * | 1993-12-07 | 1995-06-23 | Toshiba Corp | Work flow system |
| JP2010122908A (en) * | 2008-11-19 | 2010-06-03 | Ns Solutions Corp | Information processor, information processing method and program |
| CN104184595A (en) * | 2009-04-01 | 2014-12-03 | 高通股份有限公司 | managing transmissions among nodes communicating over a shared communication medium |
| CN101567068A (en) * | 2009-05-18 | 2009-10-28 | 北京方正春元科技发展有限公司 | Data-processing system used for financial information management |
| CN104850665A (en) * | 2015-06-12 | 2015-08-19 | 江苏中威科技软件系统有限公司 | Method and system for realizing flow circulation based on flow embedding |
| CN105208090A (en) * | 2015-08-19 | 2015-12-30 | 江苏农牧人电子商务股份有限公司 | Zookeeper-based Leader selection method |
| CN108460511A (en) * | 2017-12-29 | 2018-08-28 | 陈菡 | A kind of workflow engine system and its implementation |
Non-Patent Citations (2)
| Title |
|---|
| Synchronization Schedule and Date Sharing of Activity Multi-Instance Based on Workflow;Liu Lin-lan等;《2009 Second International Symposium on Electronic Commerce and Security》;20091023;第441-445页 * |
| 基于采购全流程贯通的大数据分析体系构建;王静等;《数码设计》;20170323(第06期);第12-21页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109615554A (en) | 2019-04-12 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109101652B (en) | Label creating and managing system | |
| US6952660B1 (en) | Collaboration session recording model | |
| US8429527B1 (en) | Complex data merging, such as in a workflow application | |
| US9037535B2 (en) | System of centrally managing core reference data associated with an enterprise | |
| US6122633A (en) | Subscription within workflow management systems | |
| US8443036B2 (en) | Exchanging project-related data in a client-server architecture | |
| CN109615554B (en) | Synchronous data system based on intelligent manufacturing and operation method and synchronization method thereof | |
| US7836103B2 (en) | Exchanging project-related data between software applications | |
| CN109035060A (en) | A kind of structured processes management system and management method | |
| CN108376065A (en) | The system for building the avionics software development environment of model-driven | |
| AU2012327168B2 (en) | Amethod and structure for managing multiple electronic forms and their records using a static database | |
| CN111176613A (en) | Collaborative task automatic decomposition system based on architecture model | |
| CN113919680A (en) | Method for constructing management information system based on general tasks | |
| van Dongen et al. | EMiT: A process mining tool | |
| CN109214776A (en) | A kind of thermoelectricity EPC general contract of civil engineering management overall process total factor control platform | |
| Castellanos et al. | Automating the loading of business process data warehouses | |
| US7076779B2 (en) | System for controlling and monitoring a process | |
| CN106020801A (en) | Graphic fourth-generation language (4GL) and application generation system thereof | |
| CN113407230B (en) | Intelligent main model management system based on data driving | |
| CN115564397A (en) | Automatic model management method suitable for three-dimensional collaborative design platform | |
| CN114782008A (en) | BIM project cooperation method and system developed based on SketchUp and other related equipment | |
| CN115169891A (en) | Workflow engine comprising multi-starting-point multi-branch flow | |
| KR20180072889A (en) | Method for generating user-defined Enterprise Resource Planning function and computing system performing the same | |
| Weygandt | Getting the MES model—methods for system analysis | |
| CN109634606A (en) | A kind of method and device of defined function menu |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |