CN112000816A - Data processing method and device - Google Patents

Abstract

The invention discloses a data processing method and device, and relates to the technical field of computers. The method is realized based on a workflow system and comprises the following steps: after receiving a data modification request, synchronizing at least part of data in a business formal data table into a business mirror image data table to obtain a business mirror image data record corresponding to the data modification request; storing the modified multimedia data when the modified data comprises modified multimedia data; writing the modified storage path information of the multimedia data into a multimedia link data table, and associating the obtained first multimedia link storage record with the service mirror image data record; and associating the first multimedia link storage record with the business formal data table after receiving the message that the modified data is approved. Through the steps, the convenience and the high efficiency of multimedia data storage and query in the workflow system can be greatly improved.

Description

Data processing method and device

Technical Field

The present invention relates to the field of computer technologies, and in particular, to a data processing method and apparatus.

Background

Workflow is the automated transfer of documents, information or tasks between multiple participants according to some predefined rules using computers to achieve some business goal, with a set of tasks organized to accomplish some business process. The workflow defines the triggering order and triggering conditions of the tasks, and each task can be completed by one or more software systems, one or a group of people, and one or more people and the software systems in cooperation.

The existing research work based on the workflow mainly aims to solve the problems of strong relevance between the workflow and the business and code coupling, and the research is rarely carried out on data processing problems such as data storage, query and the like in a workflow system.

Disclosure of Invention

In view of the above, the present invention provides a data processing method and apparatus, which can perform differentiated, independent, and separated storage on the audited data and the audited data by introducing a service data mirror copy policy and a multimedia data link storage policy, so as to facilitate differentiated display of the multimedia data audit intermediate state, optimize data storage efficiency and storage flexibility, and greatly improve convenience and efficiency of multimedia data storage and query in a workflow system.

To achieve the above object, according to a first aspect of the present invention, a data processing method is provided.

The data processing method is realized based on a workflow system, and comprises the following steps: after receiving a data modification request, synchronizing at least part of data in a business formal data table into a business mirror image data table to obtain a business mirror image data record corresponding to the data modification request; under the condition that the modified data carried by the data modification request comprises modified multimedia data, storing the modified multimedia data; writing the modified storage path information of the multimedia data into a multimedia link data table to obtain a first multimedia link storage record, and associating the first multimedia link storage record with the service mirror image data record; and associating the first multimedia link storage record with the business formal data table after receiving the message that the modified data is approved.

Optionally, the method further comprises: under the condition that the modified data carried by the data modification request also comprises modified text data, updating a service mirror image data record corresponding to the data modification request according to the modified text data; and after the message which passes the modified data auditing is received, updating the business formal data table according to the business mirror image data record corresponding to the data modification request.

Optionally, the method further comprises: confirming that the first multimedia linked storage record is not associated with the service image data record prior to said associating the first multimedia linked storage record with the service image data record.

Optionally, the confirming that the first multimedia link storage record is not associated with the service mirroring data record comprises: inquiring a multimedia link data table according to the logic primary key of the service mirror image data record; and in the case that the query result is empty, confirming that the first multimedia link storage record is not associated with the service mirror data record.

Optionally, the confirming that the first multimedia link storage record is not associated with the service mirroring data record comprises: inquiring a multimedia link data table according to the logic primary key of the service mirror image data record; under the condition that the query result is not empty, carrying out consistency comparison on the table associated field value in the first multimedia link storage record and the logic main key of the service mirror image data record; and under the condition that the table association field value in the first multimedia link storage record is inconsistent with the logic primary key of the service mirror image data record, confirming that the first multimedia link storage record is not associated with the service mirror image data record.

Optionally, the method further comprises: and under the condition that the table association field value in the first multimedia link storage record is consistent with the logic primary key of the service mirror image data record, confirming that the first multimedia link storage record is associated with the service mirror image data record.

Optionally, the method further comprises: after receiving the message that the modified data is approved, releasing the association between the second multimedia link storage record and the business formal data table; and the second multimedia link storage record is a link storage record of the multimedia data before modification corresponding to the data modification request.

Optionally, the method further comprises: and before the modified data auditing message is received, creating at least one auditing task, and sending the at least one auditing task to a terminal corresponding to an auditor so as to audit the modified data.

Optionally, the method further comprises: and after receiving an approval process data query request, querying the service mirror image data table according to the approval process data query request to obtain a corresponding query result.

Optionally, after receiving a formal data query request, querying the formal service data table according to the formal data query request to obtain a corresponding query result.

Optionally, the method further comprises: and generating a logic main key of the service mirror image data record corresponding to the data modification request before synchronizing at least part of data in the service formal data table into the service mirror image data table.

To achieve the above object, according to a second aspect of the present invention, there is provided a data processing apparatus.

The data processing device of the invention is realized based on a workflow system, and the device comprises: the data processing device comprises a creating and synchronizing module, a data processing module and a data processing module, wherein the creating and synchronizing module is used for synchronizing at least part of data in a business formal data table into a business mirror image data table after receiving a data modification request so as to obtain a business mirror image data record corresponding to the data modification request; the multimedia data storage management module is used for storing the modified multimedia data under the condition that the modified data carried by the data modification request comprises the modified multimedia data; the link data storage management module is used for writing the modified storage path information of the multimedia data into a multimedia link data table to obtain a first multimedia link storage record and associating the first multimedia link storage record with the service mirror image data record; and the link data storage management module is further configured to associate the first multimedia link storage record with the business formal data table after receiving a message that the modified data is approved.

Optionally, the apparatus further comprises: the text data storage management module is used for updating the service mirror image data record corresponding to the data modification request according to the modified text data under the condition that the modified data carried by the data modification request also comprises the modified text data; and after receiving the message that the modified data passes the audit, the text data processing module updates the business formal data table according to the business mirror image data record corresponding to the data modification request.

To achieve the above object, according to a third aspect of the present invention, there is provided an electronic apparatus.

The electronic device of the present invention includes: one or more processors; and storage means for storing one or more programs; when the one or more programs are executed by the one or more processors, the one or more processors are caused to implement the data processing method of the present invention.

To achieve the above object, according to a fourth aspect of the present invention, there is provided a computer-readable medium.

The computer-readable medium of the present invention has stored thereon a computer program which, when executed by a processor, implements the data processing method of the present invention.

One embodiment of the above invention has the following advantages or benefits: the data processing method is realized based on the workflow system, and by introducing the service data mirror image copy strategy and the multimedia data link storage strategy, the checked data and the checked data can be stored in a differentiated, independent and separated mode, so that differentiated display of the multimedia data checking intermediate state is conveniently realized, the data storage efficiency and the storage flexibility are optimized, and the convenience and the efficiency of multimedia data storage and query in the workflow system are greatly improved.

Further effects of the above-mentioned non-conventional alternatives will be described below in connection with the embodiments.

Drawings

The drawings are included to provide a better understanding of the invention and are not to be construed as unduly limiting the invention. Wherein:

fig. 1 is a main flow chart diagram of a data processing method according to a first embodiment of the present invention;

FIG. 2 is a schematic diagram of an exemplary data storage structure according to an embodiment of the present invention;

FIG. 3 is a schematic main flow chart of a data processing method according to a second embodiment of the present invention;

FIG. 4 is a schematic diagram of the main blocks of a data processing apparatus according to a third embodiment of the present invention;

FIG. 5 is a schematic diagram of the main blocks of a data processing apparatus according to a fourth embodiment of the present invention;

FIG. 6 is an exemplary system architecture diagram in which embodiments of the present invention may be employed;

FIG. 7 is a block diagram of a computer system suitable for use with the electronic device to implement an embodiment of the invention.

Detailed Description

Exemplary embodiments of the present invention are described below with reference to the accompanying drawings, in which various details of embodiments of the invention are included to assist understanding, and which are to be considered as merely exemplary. Accordingly, those of ordinary skill in the art will recognize that various changes and modifications of the embodiments described herein can be made without departing from the scope and spirit of the invention. Also, descriptions of well-known functions and constructions are omitted in the following description for clarity and conciseness.

It should be noted that the embodiments and technical features of the embodiments of the present invention may be combined with each other without affecting the implementation of the present invention.

Fig. 1 is a main flow diagram of a data processing method according to a first embodiment of the present invention. The data processing method of the embodiment of the invention is realized based on a workflow system. As shown in fig. 1, the data processing method according to the embodiment of the present invention includes:

step S101: after receiving a data modification request, synchronizing at least part of data in a business formal data table into a business mirror image data table to obtain a business mirror image data record corresponding to the data modification request.

In one exemplary scenario, a user may initiate a data modification request through a website or application program (APP) interface presented on a terminal device. After receiving a data modification request initiated by a user, triggering a workflow system to construct a workflow process task aiming at the data modification request, and starting to execute the workflow process task. The process of the workflow system executing the workflow process task is embodied in each processing step shown in the embodiment of the present invention. Illustratively, the workflow system may employ Activiti or other workflow systems. Activti is a Business Process Management (BPM) framework released by Alfresco software in 2010 at 5/17, and is an open-source, flexible and easily-extensible executable process language framework covering the fields of business process management, workflow, service collaboration and the like.

The business formal data table is mainly used for storing approved text data. In an optional implementation manner, after a data modification request initiated by a user is received, original data records in a business formal data table targeted by the user for the current modification may be synchronized to a business mirror data table, so as to obtain business mirror data records corresponding to the data modification request. For example, if the user modifies the original data record 1 in the business official data table this time, the original data record 1 is synchronized into the business mirror data table, so as to obtain the business mirror data record corresponding to the modification this time.

In another optional implementation, after receiving a data modification request initiated by a user, all original data records in the business formal data table that the user has permission to modify may be synchronized into the business mirror data table, so as to obtain the business mirror data records corresponding to the modification. For example, the user has the right to modify the original data records 1 to 10 in the business formal data table, and the user modifies the original data record 1 in the business formal data table this time, and synchronizes the original data records 1 to 10 to the business mirror image data table.

It should be noted that the above two alternative embodiments are exemplary illustrations of "synchronizing at least part of data in the business official data table to the business mirror data table", and do not constitute limitations to the scope of the present invention. Without affecting the implementation of the present invention, those skilled in the art can flexibly adjust the data that needs to be synchronized from the service positive data table to the service mirror data table.

Optionally, before step S101, the method of the embodiment of the present invention may further include the following steps: the system administrator starts a core service module of the workflow system, and the starting of the service module triggers the starting and initialization work of other modules. In addition, before step S101, the method of the embodiment of the present invention may further include the steps of: the system administrator can also configure related parameters through a preset interface, such as related parameters of workflow starting initialization and log level, multimedia data storage type configuration, storage position configuration and the like.

Step S102: and under the condition that the modified data carried by the data modification request comprises modified multimedia data, storing the modified multimedia data.

In one exemplary scenario, a user may make modifications to text data and/or multimedia data. The multimedia data may include one or more of picture, audio, and video data. After receiving a data modification request submitted by a user, the modified data submitted by the user at this time can be determined by analyzing the data modification request. If the modified data comprises multimedia data, the modified multimedia data submitted by the user at this time can be stored in the multimedia data storage module. The multimedia data storage module may be a hard disk, an optical disk, or other storage media that can be used to store multimedia data. Further, if the modified data also includes text data, the modified text data submitted by the user at this time can be updated to the service mirror image data table.

Step S103: and writing the modified storage path information of the multimedia data into a multimedia link data table to obtain a first multimedia link storage record, and associating the first multimedia link storage record with the service mirror image data record.

Illustratively, the first multimedia link storage record may include a multimedia data type (such as a type of a picture, audio, video, and the like), a multimedia data name, a storage path of the multimedia data, and the like. The storage path of the multimedia data may be specifically a URL address of the multimedia data, or other information that may be used to indicate a storage location of the multimedia data. For example, assuming that modified multimedia data uploaded by a user at a certain time is three pictures, and the unique identifiers of the three pictures are respectively represented as lgc _ sn _ media _ pic1, lgc _ sn _ media _ pic2, and lgc _ sn _ media _ pic3, after the three pictures are stored in a multimedia data storage module (such as a physical layer disk), the storage path information of the three pictures may be written into a multimedia link data table to obtain a first multimedia link storage record, and the first multimedia link storage record is associated with the service image data record corresponding to the modification request obtained in step S101.

Further, in an alternative example, the association of the multimedia-linked storage record with other data records may be accomplished by setting a table association field in the multimedia-linked storage record. In this alternative example, the association of the first multimedia linked storage record with the service mirror data record may be achieved by setting a value of a table association field in the first multimedia linked storage record to a logical primary key of the service mirror data record.

In another alternative example, the association of the multimedia linked storage record with other data records may be achieved by setting an association table of the multimedia linked storage record with the service image data record. In this alternative example, the association of the first multimedia linked storage record with the service mirror data record may be achieved by setting an association of the first multimedia linked storage record with the service mirror data record in an association table.

Step S104: and associating the first multimedia link storage record with the business formal data table after receiving the message that the modified data is approved.

In the embodiment of the present invention, step S104 is a processing step when the modified data includes multimedia data. In an alternative example, the association of the multimedia-linked storage record with other data tables may be achieved by setting a table association field in the multimedia-linked storage record. In this alternative example, the association of the first multimedia storing record with the service official data table may be achieved by inserting a first multimedia storing record associated with the service official data table in the multimedia linking data table. In specific implementation, one copy of the first multimedia link storage record obtained in step S103 is copied, a value of a table association field in the copied data is set as a logical primary key of a business official data table, and then the copied data is inserted into the multimedia link data table, so as to realize association between the first multimedia link storage record and the business official data table.

In an exemplary scenario, before step S104, the method of the embodiment of the present invention may further include the steps of: and creating at least one audit task, and sending the at least one audit task to a terminal corresponding to an auditor so as to perform manual audit on the modified data. And after the manual audit is passed, receiving a data audit passing message sent by a terminal corresponding to the auditor, and then associating the first multimedia link storage record with a business formal data table.

In another exemplary scenario, before step S104, the method of the embodiment of the present invention may further include the steps of: and creating at least one audit task, and sending the at least one audit task to an audit module so as to automatically audit the modified data. And after the automatic audit is passed, receiving a message that the data audit is passed and sent by the audit module, and then associating the first multimedia link storage record with a business formal data table.

In yet another exemplary scenario, a manual review may be combined with an automatic review prior to step S104. And after the manual audit and the automatic audit are passed, the step of associating the first multimedia link storage record with the business formal data table is executed.

In the embodiment of the present invention, a data processing flow in a workflow system is realized by the processing flow shown in fig. 1. By introducing the service data mirror image copy strategy and the multimedia data link storage strategy into the process, the difference, independence and separation type storage can be carried out on the checked data and the data in the check, so that the difference display of the multimedia data check intermediate state is conveniently realized, the data storage efficiency and the storage flexibility are optimized, and the convenience and the efficiency of the multimedia data storage and query in the workflow system are greatly improved.

FIG. 2 is a diagram of an exemplary data storage structure, according to an embodiment of the invention. As shown in fig. 2, in the embodiment of the present invention, the data storage structure adopted by the workflow system includes: a text data storage layer, a link data storage layer and a multimedia data storage layer.

The text data storage layer comprises a business formal data table and a business mirror image data table. The business formal data table is mainly used for storing the text data which are approved; the service mirror image data table is mainly used for storing text data of each auditing stage in a workflow process example, and the service mirror image data table not only comprises the text data to be audited, but also comprises the text data which is audited to be passed and not passed. In specific implementation, the number of the business official data tables in the text data storage layer may be one or more, and the number of the business mirror data tables may be one or more. For example, in an alternative example, the text data store layer includes a business official data table and a plurality of business image data tables.

The link data storage layer includes a multimedia link data storage table. The multimedia link data storage table is mainly used for storing storage path information of multimedia data, and can realize differentiated, independent and separated storage of the multimedia data in different auditing stages by being associated with the business formal data table or the business mirror image data table in different auditing stages, so that the problem of differentiated display of the multimedia data in each auditing stage is solved. In a specific implementation, the number of the multimedia link data storage tables in the link data storage layer may be one or more.

The multimedia data storage layer is used for storing multimedia data such as pictures, audio and video. Illustratively, the multimedia data storage layer may be implemented using a magnetic disk, an optical disk, or other storage media suitable for storing multimedia data.

In the embodiment of the invention, by carrying out data storage processing based on the three-layer data storage structure, the checked data and the data in the check can be stored in a differentiated, independent and separated manner, so that differentiated display of a multimedia data check intermediate state is conveniently realized, the data storage efficiency and the storage flexibility are optimized, and the convenience and the efficiency of multimedia data storage and query in a workflow system are greatly improved.

Fig. 3 is a main flow chart of a data processing method according to a second embodiment of the present invention. The data processing method of the embodiment of the invention is realized based on a workflow system. As shown in fig. 3, the data processing method according to the embodiment of the present invention includes:

step S301: after receiving a data modification request, synchronizing at least part of data in a business formal data table into the business mirror image data table to obtain a business mirror image data record corresponding to the data modification request.

In one exemplary scenario, a user may initiate a data modification request through a website or application program (APP) interface presented on a terminal device. After receiving a data modification request initiated by a user, triggering a workflow system to construct a workflow process task aiming at the data modification request, and starting to execute the workflow process task. The process of the workflow system executing the workflow process task is embodied in each processing step shown in the embodiment of the present invention.

The business formal data table is mainly used for storing approved text data. In an optional embodiment, the original data record in the business formal data table for which the user modifies the current time may be synchronized into the business mirror data table, so as to obtain the business mirror data record corresponding to the data modification request. For example, if the user modifies the original data record 1 in the business official data table this time, the logical primary key value of the business mirror data record corresponding to the data modification request may be determined first, and then the original data record 1 is synchronized to the row of the logical primary key value in the business mirror table.

In another optional embodiment, all original data records in the business formal data table, which are authorized to be modified by the user, may be synchronized into the business mirror data table to obtain the business mirror data record corresponding to the data modification request. For example, if a user has an authority to modify the original data records 1 to 10 in the business official data table, and the user modifies the original data record 1 in the business official data table, the logical primary key value of the business mirror data record corresponding to the data modification request may be determined first, and the original data records 1 to 10 are synchronized to the row of the logical primary key value in the business mirror table.

It should be noted that the above two alternative embodiments are exemplary illustrations of "synchronizing at least part of data in the business official data table to the business mirror data table", and do not constitute limitations to the scope of the present invention. Without affecting the implementation of the present invention, those skilled in the art can flexibly adjust the data that needs to be synchronized from the service positive data table to the service mirror data table.

Further, before synchronizing at least part of data in the business formal data table to the business mirror data table, the method of the embodiment of the present invention further includes: and generating a logic primary key of the service mirror image data record corresponding to the data modification request.

Illustratively, the generating the logical primary key of the business image data record corresponding to the data modification request includes: and generating a random number as a logic primary key value of the business mirror image data table corresponding to the data modification process through a random number generator. In addition, in specific implementation, the logical primary key value of the service mirror image data record corresponding to the data modification request may also be generated according to other manners. For example, the logical primary key value of the service mirror data table corresponding to the user information initiating the data modification process and the time of initiating the data modification process can be determined.

In one optional example, a user initiated data modification and a user submitted data modification may be two different operations, and a user may initiate multiple data modifications at different times before the user submits the data modification. In this alternative example, the logical primary key value of one same service mirror data record may be generated for a plurality of data modification initiation operations before the commit operation; and generating the logic primary key values of different business mirror image data records aiming at the submission operation of different data modification. For example, suppose that the same user initiates data modification three times before triggering modification submission operation; after a user initiates first modification, generating a logical primary key value 'lgc _ sn _ user _ info _ image _ 123000', and saving at least part of data in a business formal data table to a business mirror data record in which the logical primary key value 'lgc _ sn _ user _ info _ image _ 123000'; after the user initiates the second modification, the logical primary key value for modifying the corresponding service image data record at this time is still "lgc _ sn _ user _ info _ image _ 123000"; after the user initiates the third modification, the logical primary key value for modifying the corresponding service image data record at this time is still "lgc _ sn _ user _ info _ image _ 123000".

In another alternative example, the user-initiated data modification may be the same operation as the user-submitted data modification. In this optional example, a logical primary key value of one service mirror data record may be generated for one data modification commit operation of the same user; and generating the logic primary key values of different business mirror image data records aiming at different data modification submission operations of the same user.

Step S302: and updating the service mirror image data record corresponding to the modification request according to the modified text data.

In embodiments of the present invention, a user may modify text data and/or multimedia data. The multimedia data may include one or more of picture, audio, and video data. Upon receiving a data modification request from a user, the modified data involved in the modification may be determined by parsing the data modification request. Wherein, the modified data related to the modification can comprise modified text data and modified multimedia data. In step S302, the modified text data related to the modification may be updated to the service image data record obtained in step S301.

Step S303: and storing the modified multimedia data.

In this step, the modified multimedia data submitted by the user this time may be stored to the multimedia data storage module. The multimedia data storage module may be a hard disk, an optical disk, or other storage media that can be used to store multimedia data.

Step S304: and writing the modified storage path information of the multimedia data into a multimedia link data table to obtain a first multimedia link storage record, and associating the first multimedia link storage record with the service mirror image data record.

In this step, the storage path information of the multimedia data stored through step S303 may be written into the multimedia link data table to obtain a first multimedia link storage record, and the first multimedia link storage record may be associated with the service image data record created through step S301. The first multimedia link storage record may include a multimedia data type (such as a type of a picture, audio, video, etc.), a multimedia data name, a storage path of the multimedia data, and the like. The storage path of the multimedia data may be specifically a URL address of the multimedia data, or other parameters that may be used to indicate a storage location of the multimedia data.

Further, the first multimedia link storage record may be associated with the service image data record by: and setting the value of the table association field in the first multimedia link storage record as a logic main key of the service mirror image data record so as to realize the association between the first multimedia link storage record and the service mirror image data record.

For example, assuming that the modified multimedia data uploaded by the user at a time is three pictures, and the unique identifiers of the three pictures are respectively represented as lgc _ sn _ media _ pic1, lgc _ sn _ media _ pic2 and lgc _ sn _ media _ pic3, the three pictures can be stored in a multimedia data storage module (such as a physical layer disk) through step S303. Further, assume that storage paths of lgc _ sn _ media _ pic1, lgc _ sn _ media _ pic2, and lgc _ sn _ media _ pic3 are: home/userA/picture/lgc _ sn _ media _ pic1.jpg,/home/userA/picture/lgc _ sn _ media _ pic2.jpg,/home/userA/picture/lgc _ sn _ media _ pic3.jpg, the storage path information of the three pictures can be written into the multimedia link data table to get the first multimedia link storage record corresponding to the picture lgc _ sn _ media _ pic1, the first multimedia link storage record corresponding to the picture lgc _ sn _ media _ pic2, and the first multimedia link storage record corresponding to the picture lgc _ sn _ media _ pic3, and the values of the table association fields in the three first multimedia link storage records are set as the logical primary key of the service mirror data record, to enable association of the three first multimedia link storage records with the service image data record created by step S301.

Optionally, before the step of associating the first multimedia link storage record with the service image data record is performed, the data processing method according to the embodiment of the present invention further includes: confirming that the first multimedia linked storage record is not associated with the service mirror data record. That is, before the step of associating the first multimedia linked storage record with the service mirror data record is performed, it is determined whether the first multimedia linked storage record is not associated with the service mirror data record, and the determination result is yes.

In an alternative embodiment, it may be determined whether the first multimedia linked storage record is not associated with the service mirror data record according to the following process:

step a, inquiring a multimedia link data table according to the logic primary key recorded by the service mirror image data.

For example, assuming that the logical primary key of the service image data record is "lgc _ sn _ user _ info _ image _ 123456", the multimedia link data table (such as represented by file _ store) may be queried according to the sql statement as follows; link _ lgc _ sn ═ lgc _ sn _ user _ info _ image _ 123456'.

Under the condition that the query result of the step a is empty, the service mirror image data record is not associated with any multimedia link storage record in a multimedia link data table, and then the first multimedia link storage record is confirmed not to be associated with the service mirror image data record; and b, under the condition that the query result of the step a is not empty, indicating that the service mirror image data record is associated with at least one multimedia link storage record in a multimedia link data table, and further executing the step b.

And step b, carrying out consistency comparison on the table associated field value in the first multimedia link storage record and the logic primary key of the service mirror image data record.

For example, if the table association field (e.g., indicated by link _ lgc _ sn) in the first multimedia link storage record is "lgc _ sn _ user _ info _ image _ 123456" and the logical primary key of the service image data record is "lgc _ sn _ user _ info _ image _ 123000", the two records are determined to be inconsistent through consistency comparison; assuming that the table association field (e.g. indicated by link _ lgc _ sn) in the first multimedia link storage record is "lgc _ sn _ user _ info _ image _ 123456", and the logical primary key of the service image data record is "lgc _ sn _ user _ info _ image _ 123456", the two are determined to be consistent through consistency comparison.

B, under the condition that the table association field value in the first multimedia link storage record is judged to be inconsistent with the logic primary key of the service mirror image data record through the step b, confirming that the first multimedia link storage record is not associated with the service mirror image data record; and b, under the condition that the table association field value in the first multimedia link storage record is judged to be consistent with the logic primary key of the service mirror image data record through the step b, confirming that the first multimedia link storage record is associated with the service mirror image data record.

In specific implementation, if there are a plurality of modified multimedia data submitted by the user at a time, step 304 may be executed for each multimedia data, and step S305 is executed after the storage path information of all the modified multimedia data is written into the multimedia link data table and associated with the service mirror data record.

Step S305: and creating at least one audit task, and sending the at least one audit task to a terminal corresponding to an auditor so as to audit the modified data.

In an alternative embodiment, a one-level review may be performed on the modified data that the user submitted this time. For example, one or more audit tasks can be created simultaneously, and all created audit tasks are sent to a terminal corresponding to a designated auditor, so as to perform manual audit on modified data.

In another alternative embodiment, multiple levels of review may be performed on the modified data that the user has submitted this time. For example, one or more primary audit tasks may be created first, and all the created primary audit tasks are sent to terminals corresponding to primary auditors, so as to perform preliminary audit on modified data. And after the first-level audit is passed, one or more second-level audit tasks are created, and all the created second-level audit tasks are sent to terminals corresponding to second-level auditors so as to perform re-audit on the modified data.

Step S306: and after receiving the message that the modified data passes the audit, updating the business formal data table according to the business mirror image data record.

After the message that the modified data is finally approved is received, the data of the user in the service mirror image data record can be synchronized into a service formal data table. The user data needing to be synchronized at this time comprises the modified text data submitted by the user at this time and approved by the user.

Step S307: and releasing the association between the second multimedia link storage record and the business formal data table.

And the second multimedia link storage record is a link storage record of the multimedia data before modification corresponding to the data modification request. For example, a user modifies and uploads three relatively clear personal portrait photos, namely, picture _ good _1, picture _ good _2 and picture _ good _3, to replace the original three relatively fuzzy pictures, namely, picture _ bad _1, picture _ bad _2 and picture _ bad _3, so that the three first multimedia link storage records are multimedia link storage records corresponding to the picture _ good _1, multimedia link storage records corresponding to the picture _ good _2 and multimedia link storage records corresponding to the picture _ good _3, and the three second multimedia link storage records are multimedia link storage records corresponding to the picture _ bad _1, multimedia link storage records corresponding to the picture _ bad _2 and multimedia link storage records corresponding to the picture _ bad _ 3.

In this step, the logical primary key of the business formal data table may be obtained through data information related to the workflow, and then the second multimedia link storage record associated with the logical primary key (i.e., the link storage record of the multimedia data before modification) is deleted, thereby implementing the release of the association relationship between the second multimedia link storage record and the business formal data table.

Step S308: and associating the first multimedia link storage record with the business formal data table.

The association of the first multimedia storing record with the service official data table may be realized by inserting a first multimedia storing record associated with the service official data table in the multimedia linking data table, for example.

Specifically, the association between the first multimedia link storage record and the service official data table can be realized by copying one copy of the first multimedia link storage record obtained in step S304, setting a value of a table association field in the copied data as a logical main key of the service official data table, and then inserting the copied data into the multimedia link data table.

For example, assuming that modified multimedia data uploaded by a user at a time is three pictures, the unique identifiers of the three pictures are represented as lgc _ sn _ media _ pic1, lgc _ sn _ media _ pic2 and lgc _ sn _ media _ pic3, and the first multimedia link storage record corresponding to the picture lgc _ sn _ media _ pic1, the first multimedia link storage record corresponding to the picture lgc _ sn _ media _ pic2 and the first multimedia link storage record corresponding to the picture lgc _ sn _ media _ pic3 are established through step S304, the following operations may be performed on the three first multimedia link storage records respectively: copying the first multimedia link storage record, setting the value of a table association field in the copied data as a logic main key of a business formal data table, and then reinserting the copied data into a multimedia link data table.

Optionally, the method of the embodiment of the present invention may further include the steps of: after receiving an approval process data query request, querying the service mirror image data table according to the approval process data query request to obtain a corresponding query result; and after receiving a formal data query request, querying the formal business data table according to the formal data query request to obtain a corresponding query result.

For example, suppose that a user initiates a data modification process to upload three clear pictures, i.e., picture _ good _1, picture _ good _2, and picture _ good _3, to replace the original three blurred pictures, i.e., picture _ bad _1, picture _ bad _2, and picture _ bad _ 3. Before the modified data of the user is audited, if the user initiates an approval process data query request, three clear pictures, namely, picture _ good _1, picture _ good _2 and picture _ good _3, can be queried, and if the user initiates a formal data query request, three fuzzy pictures, namely, picture _ bad _1, picture _ bad _2 and picture _ bad _3, can be queried; after the modified data of the user passes the audit, if the user initiates an approval process data query request, three clear pictures, namely, picture _ good _1, picture _ good _2 and picture _ good _3, can be queried, and if the user initiates a formal data query request, three clear pictures, namely, picture _ good _1, picture _ good _2 and picture _ good _3, can be queried.

Further, if the user initiates the picture modification process again, the picture is modified from the clear pictures picture _ good _1 to picture _ good _3 to the better pictures picture _ beta _1 to picture _ beta _ 3. If the modification is approved at a future time, two modification approval records are inquired on an approval process inquiry menu interface: pictures corresponding to an earlier historical approval record are picture _ good _ 1-picture _ good _3, and pictures corresponding to a new historical approval record are picture _ beta _ 1-picture _ beta _ 3; the latest approved pictures, picture _ beta _1 to picture _ beta _3, are queried in the data maintenance query menu interface.

In the embodiment of the invention, the problems of differential display of the auditing intermediate state of the multimedia process data, updating and synchronization of the auditing data in any modification intermediate stage in the auditing whole process and historical auditing operation are solved through the processing steps; by introducing a business data mirror copy strategy, differential, independent and separated storage is carried out on the checked data and the text data in the checking process; through a link storage strategy, differentiated, independent, separated and link storage is carried out on the audited data and the multimedia data in the auditing flow instead of physical copy storage, so that the storage efficiency and the storage flexibility are optimized; the convenience and the high efficiency of storing, associating and querying the multimedia data in the workflow system are greatly improved, so that the expandability, the modular capacity of assembly and the convenience of large-scale commercial implementation of the workflow system are further enhanced.

Fig. 4 is a schematic diagram of main blocks of a data processing apparatus according to a third embodiment of the present invention. The data processing apparatus 400 according to the embodiment of the present invention is implemented based on a workflow system, and includes: a synchronization module 401, a multimedia data storage management module 402, and a link data storage management module 403.

The synchronization module 401 is configured to synchronize at least part of data in the business formal data table to the business mirror data table after receiving the data modification request, so as to obtain a business mirror table data record corresponding to the data modification request.

In one exemplary scenario, a user may initiate a data modification request through a website or application program (APP) interface presented on a terminal device. After receiving a data modification request of a user, triggering a workflow system to construct a workflow process task aiming at the data modification request, and starting to execute the workflow process task.

The business formal data table is mainly used for storing approved text data. In an optional embodiment, after receiving a data modification request of a user, the synchronization module 401 may synchronize an original data record in a business formal data table for which the user modifies the current time to a business mirror data table, so as to obtain a business mirror table data record corresponding to the data modification request. For example, if the user modifies the original data record 1 in the business official data table this time, the original data record 1 is synchronized into the business mirror data table.

In another optional embodiment, after receiving a data modification request from a user, the synchronization module 401 may synchronize all original data records in the business formal data table that the user has permission to modify into the business mirror data table. For example, the user has the right to modify the original data records 1 to 10 in the business formal data table, and the user modifies the original data record 1 in the business formal data table this time, and synchronizes the original data records 1 to 10 to the business mirror image data table.

It should be noted that the above two alternative embodiments are exemplary illustrations of "the synchronization module 401 synchronizes at least part of data in the business official data table to the business mirror data table", and do not constitute a limitation to the scope of the present invention. Without affecting the implementation of the present invention, those skilled in the art can flexibly adjust the data that needs to be synchronized from the service positive data table to the service mirror data table.

A multimedia data storage management module 402, configured to store the modified multimedia data in a case that the modified data carried in the data modification request includes multimedia data.

In one exemplary scenario, a user may make modifications to text data and/or multimedia data. The multimedia data may include one or more of picture, audio, and video data. After receiving a data modification request submitted by a user, the modified data submitted by the user at this time can be determined by analyzing the data modification request. If the modified data includes multimedia data, the multimedia data storage management module 402 may save the modified multimedia data submitted by the user this time to the multimedia data storage module. The multimedia data storage module may be a hard disk, an optical disk, or other storage media that can be used to store multimedia data.

A link data storage management module 403, configured to write the modified storage path information of the multimedia data into a multimedia link data table to obtain a first multimedia link storage record, and associate the first multimedia link storage record with the service mirror data record.

Illustratively, the first multimedia link storage record may include a multimedia data type (such as a type of a picture, audio, video, and the like), a multimedia data name, a storage path of the multimedia data, and the like. The storage path of the multimedia data may be specifically a URL address of the multimedia data, or other information that may be used to indicate a storage location of the multimedia data. For example, assuming that modified multimedia data uploaded by a user at a time is three pictures, and the unique identifiers of the three pictures are respectively represented as lgc _ sn _ media _ pic1, lgc _ sn _ media _ pic2 and lgc _ sn _ media _ pic3, after the three pictures are stored in a multimedia data storage module (such as a physical layer disk), the storage path information of the three pictures can be written into a multimedia link data table to obtain a first multimedia link storage record, and the first multimedia link storage record is associated with a service mirror data record.

Further, in an alternative example, the association of the multimedia-linked storage record with other data records may be accomplished by setting a table association field in the multimedia-linked storage record. In this alternative example, the link data storage management module 403 may implement the association of the first multimedia linked storage record with the service mirror data record by setting a value of a table association field in the first multimedia linked storage record as a logical primary key of the service mirror data record.

In another alternative example, the association of the multimedia linked storage record with other data records may be achieved by setting an association table of the multimedia linked storage record with the service image data record. In this alternative example, the link data storage management module 403 may implement the association of the first multimedia link storage record with the service mirror data record by setting an association relationship of the first multimedia link storage record with the service mirror data record in the association relationship table.

The link data storage management module 403 is further configured to associate the first multimedia link storage record with the business formal data table after receiving the message that the modified data is approved.

In an alternative example, the association of the multimedia-linked storage record with other data tables may be achieved by setting a table association field in the multimedia-linked storage record. In this alternative example, the link data storage management module 403 may implement association of the first multimedia link storage record with the service official data table by inserting the first multimedia link storage record associated with the service official data table into the multimedia link data table.

Specifically, the link data storage management module 403 may copy a copy of the previously obtained first multimedia link storage record, set a value of a table association field in the copied data as a logical primary key of a business official data table, and then insert the copied data into the multimedia link data table, so as to implement association between the first multimedia link storage record and the business official data table.

In the embodiment of the invention, the data processing flow in the workflow system is realized through the device. By introducing the service data mirror image copy strategy and the multimedia data link storage strategy into the process, the difference, independence and separation type storage can be carried out on the checked data and the data in the check, so that the difference display of the multimedia data check intermediate state is conveniently realized, the data storage efficiency and the storage flexibility are optimized, and the convenience and the efficiency of the multimedia data storage and query in the workflow system are greatly improved.

Fig. 5 is a schematic diagram of main blocks of a data processing apparatus according to a fourth embodiment of the present invention. The data processing device of the embodiment of the invention is realized based on a workflow system. As shown in fig. 5, a data processing apparatus 500 according to an embodiment of the present invention includes: a synchronization module 501, a text data storage management module 502, a multimedia data storage management module 503, and a link data storage management module 504.

The synchronization module 501 is configured to synchronize at least part of data in a business formal data table to the business mirror data table after receiving the data modification request, so as to obtain a business mirror data record corresponding to the data modification request.

In one exemplary scenario, a user may initiate and submit a data modification request through a website or application program (APP) interface presented on a terminal device. After receiving a data modification request of a user, triggering a workflow system to construct a workflow process task aiming at the data modification request, and starting to execute the workflow process task.

The business formal data table is mainly used for storing approved text data. In an alternative embodiment, the synchronization module 501 may synchronize the original data record in the business formal data table for which the user modifies this time to the business mirror data table. For example, if the user modifies the original data record 1 in the business official data table this time, the original data record 1 is synchronized into the business mirror data table.

In another alternative embodiment, after creating the service mirror data table, the synchronization module 501 may synchronize all original data records in the service formal data table, which are authorized to be modified by the user, into the service mirror data table. For example, the user has the right to modify the original data records 1 to 10 in the business formal data table, and the user modifies the original data record 1 in the business formal data table this time, and synchronizes the original data records 1 to 10 to the business mirror image data table.

It should be noted that the above two alternative embodiments are exemplary illustrations of "the synchronization module 501 synchronizes at least part of data in the business official data table to the business mirror data table", and do not constitute a limitation to the scope of the present invention. Without affecting the implementation of the present invention, those skilled in the art can flexibly adjust the data that needs to be synchronized from the service positive data table to the service mirror data table.

Further, before synchronizing at least a part of data in the business formal data table to the business mirror data table, the synchronization module 501 may be further configured to generate a logical primary key of a business mirror data record corresponding to the data modification request.

Illustratively, the generating the logical primary key of the service mirroring data record corresponding to the data modification request by the synchronization module 501 includes: the synchronization module 501 generates a random number as a logical primary key value of the service mirror data table corresponding to the data modification process through a random number generator. In addition, in specific implementation, the synchronization module 501 may also generate the logical primary key value of the service mirror data record corresponding to the data modification request according to other manners. For example, the synchronization module 501 may determine the logical primary key value of the service mirror data table corresponding to the user information initiating the data modification process and the time of initiating the data modification process.

In one optional example, a user initiated data modification and a user submitted data modification may be two different operations, and a user may initiate multiple data modifications at different times before the user submits the data modification. In this alternative example, the synchronization module 501 may generate a logical primary key value of one same service mirror data record for multiple data modification initiation operations before the commit operation; for the commit operation of different data modifications, the synchronization module 501 generates logical primary key values of different business mirror data records. For example, suppose that the same user initiates data modification three times before triggering modification submission operation; after the user initiates the first modification, the synchronization module 501 generates a logical primary key value "lgc _ sn _ user _ info _ image _ 123000", and stores at least part of data in the business formal data table into a business mirror data record in which the logical primary key value "lgc _ sn _ user _ info _ image _ 123000" is located; after the user initiates the second modification, the logical primary key value for modifying the corresponding service image data record at this time is still "lgc _ sn _ user _ info _ image _ 123000"; after the modification initiated by the user for the third time, the logical primary key value for modifying the corresponding service image data record for this time is still "lgc _ sn _ user _ info _ image _ 123000".

In another alternative example, the user-initiated data modification may be the same operation as the user-submitted data modification. In this optional example, the synchronization module 501 may generate a logical primary key value of one service mirror data record for one data modification commit operation of the same user; for different data modification submission operations of the same user, the synchronization module 501 generates logical primary key values of different service mirror data records.

A text data storage management module 502, configured to update the service mirror data record according to the modified text data when the modified data carried in the data modification request includes the text data.

In embodiments of the present invention, a user may modify text data and/or multimedia data. The multimedia data may include one or more of picture, audio, and video data. After receiving a data modification request submitted by a user, the modified data related to the modification can be determined by analyzing the data modification request. When the modified data related to the modification includes modified text data, the text data storage management module 502 may update the service image data record corresponding to the modification request according to the modified text data related to the modification.

The multimedia data storage management module 503 is configured to, when the modified data carried in the data modification request includes multimedia data, store the modified multimedia data submitted by the user at this time to the multimedia data storage module. The multimedia data storage module may be a hard disk, an optical disk, or other storage media that can be used to store multimedia data.

The link data storage management module 504 is configured to write storage path information of the modified multimedia data corresponding to the data modification request into a multimedia link data table to obtain a first multimedia link storage record, and associate the first multimedia link storage record with the service mirror data record.

For example, the link data storage management module 504 may write the storage path information of the modified multimedia data corresponding to the data modification request into the multimedia link data table to obtain a first multimedia link storage record, and associate the first multimedia link storage record with the service mirror data record. The first multimedia link storage record may include a multimedia data type (such as a type of a picture, audio, video, etc.), a multimedia data name, a storage path of the multimedia data, and the like. The storage path of the multimedia data may be specifically a URL address of the multimedia data, or other parameters that may be used to indicate a storage location of the multimedia data.

Further, the link data store management module 504 may associate the first multimedia link storage record with the service image data record by: the link data storage management module 504 sets a value of a table association field in the first multimedia link storage record as a logical primary key value of the service mirror data record to implement association of the first multimedia link storage record and the service mirror data record.

For example, assuming that the modified multimedia data uploaded by the user at a time is three pictures, and the unique identifiers of the three pictures are respectively represented as lgc _ sn _ media _ pic1, lgc _ sn _ media _ pic2 and lgc _ sn _ media _ pic3, the three pictures can be stored in a multimedia data storage module (such as a physical layer disk). Further, assume that storage paths of lgc _ sn _ media _ pic1, lgc _ sn _ media _ pic2, and lgc _ sn _ media _ pic3 are: home/userA/picture/lgc _ sn _ media _ pic1.jpg,/home/userA/picture/lgc _ sn _ media _ pic2.jpg,/home/userA/picture/lgc _ sn _ media _ pic3.jpg, the link data storage management module 504 may write the storage path information of the three pictures into the multimedia link data table, to obtain a first multimedia link storage record corresponding to picture lgc _ sn _ media _ pic1, a first multimedia link storage record corresponding to picture lgc _ sn _ media _ pic2, and a first multimedia link storage record corresponding to picture lgc _ sn _ media _ pic3, and the values of the table association fields in the three first multimedia link storage records are set as the logical primary key of the service mirror data record, to enable association of the three first multimedia link storage records with the service image data record obtained through step S301.

Optionally, before performing the step of associating the first multimedia linked storage record with the service image data record, the linked data storage management module 504 may be further configured to: confirming that the first multimedia linked storage record is not associated with the service mirror data record. That is, before the step of associating the first multimedia linked storage record with the service mirror data record is performed, the linked data storage management module 504 determines whether the first multimedia linked storage record is not associated with the service mirror data record, and the determination result is yes.

The link data storage management module 504 is further configured to associate the first multimedia link storage record with the business formal data table after receiving the message that the modified data is approved.

In an alternative example, the association of the multimedia-linked storage record with other data tables may be achieved by setting a table association field in the multimedia-linked storage record. In this alternative example, the link data storage management module 504 may implement the association of the first multimedia link storage record with the service official data table by inserting the first multimedia link storage record associated with the service official data table into the multimedia link data table.

Specifically, the link data storage management module 504 may copy a copy of the previously obtained first multimedia link storage record, set a value of a table association field in the copied data as a logical primary key of a business official data table, and then insert the copied data into the multimedia link data table, so as to implement association between the first multimedia link storage record and the business official data table.

In the embodiment of the invention, the data processing flow in the workflow system is realized through the device. By introducing the service data mirror image copy strategy and the multimedia data link storage strategy into the process, the difference, independence and separation type storage can be carried out on the checked data and the data in the check, so that the difference display of the multimedia data check intermediate state is conveniently realized, the data storage efficiency and the storage flexibility are optimized, and the convenience and the efficiency of the multimedia data storage and query in the workflow system are greatly improved.

Fig. 6 shows an exemplary system architecture 600 of a data processing method or data processing apparatus to which embodiments of the present invention may be applied.

As shown in fig. 6, the system architecture 600 may include terminal devices 601, 602, 603, a network 604, and a server 605. The network 604 serves to provide a medium for communication links between the terminal devices 601, 602, 603 and the server 605. Network 604 may include various types of connections, such as wire, wireless communication links, or fiber optic cables, to name a few.

A user may use the terminal devices 601, 602, 603 to interact with the server 605 via the network 604 to receive or send messages or the like. Various communication client applications, such as shopping applications, web browser applications, search applications, instant messaging tools, mailbox clients, social platform software, and the like, may be installed on the terminal devices 601, 602, and 603.

The terminal devices 601, 602, 603 may be various electronic devices having a display screen and supporting web browsing, including but not limited to smart phones, tablet computers, laptop portable computers, desktop computers, and the like.

The server 605 may be a server that provides various services, such as a background management server that provides support for data modification requests issued by users using the terminal devices 601, 602, 603. The background management server may perform operations such as service processing on the data modification request after receiving the data modification request, and return a processing result (for example, a modification result) to the terminal device.

It should be noted that the data processing method provided by the embodiment of the present invention may be executed by the server 605, and accordingly, the data processing apparatus is disposed in the server 605.

It should be understood that the number of terminal devices, networks, and servers in fig. 6 is merely illustrative. There may be any number of terminal devices, networks, and servers, as desired for implementation.

Referring now to FIG. 7, shown is a block diagram of a computer system 700 suitable for use with the electronic device implementing an embodiment of the present invention. The computer system illustrated in FIG. 7 is only an example and should not impose any limitations on the scope of use or functionality of embodiments of the invention.

As shown in fig. 7, the computer system 700 includes a Central Processing Unit (CPU)701, which can perform various appropriate actions and processes in accordance with a program stored in a Read Only Memory (ROM)702 or a program loaded from a storage section 708 into a Random Access Memory (RAM) 703. In the RAM703, various programs and data necessary for the operation of the system 700 are also stored. The CPU 701, the ROM 702, and the RAM703 are connected to each other via a bus 704. An input/output (I/O) interface 705 is also connected to bus 704.

The following components are connected to the I/O interface 705: an input portion 706 including a keyboard, a mouse, and the like; an output section 707 including a display such as a Cathode Ray Tube (CRT), a Liquid Crystal Display (LCD), and the like, and a speaker; a storage section 708 including a hard disk and the like; and a communication section 709 including a network interface card such as a LAN card, a modem, or the like. The communication section 709 performs communication processing via a network such as the internet. A drive 710 is also connected to the I/O interface 705 as needed. A removable medium 711 such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, or the like is mounted on the drive 710 as necessary, so that a computer program read out therefrom is mounted into the storage section 708 as necessary.

In particular, according to the embodiments of the present disclosure, the processes described above with reference to the flowcharts may be implemented as computer software programs. For example, embodiments of the present disclosure include a computer program product comprising a computer program embodied on a computer readable medium, the computer program comprising program code for performing the method illustrated in the flow chart. In such an embodiment, the computer program can be downloaded and installed from a network through the communication section 709, and/or installed from the removable medium 711. The computer program performs the above-described functions defined in the system of the present invention when executed by the Central Processing Unit (CPU) 701.

It should be noted that the computer readable medium shown in the present invention can be a computer readable signal medium or a computer readable storage medium or any combination of the two. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples of the computer readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the present invention, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. In the present invention, however, a computer readable signal medium may include a propagated data signal with computer readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to: wireless, wire, fiber optic cable, RF, etc., or any suitable combination of the foregoing.

The flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present invention. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams or flowchart illustration, and combinations of blocks in the block diagrams or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.

The modules described in the embodiments of the present invention may be implemented by software or hardware. The described modules may also be provided in a processor, which may be described as: a processor includes a synchronization module, a multimedia data storage management module, and a linked data storage management module. The names of these modules do not in some cases form a limitation on the modules themselves, and for example, a synchronization module may also be described as a "module that synchronizes at least part of data in a business official data table to a business mirror data table".

As another aspect, the present invention also provides a computer-readable medium that may be contained in the apparatus described in the above embodiments; or may be separate and not incorporated into the device. The computer readable medium carries one or more programs which, when executed by a device, cause the device to perform the following: after receiving a data modification request, synchronizing at least part of data in a business formal data table into a business mirror image data table to obtain a business mirror image data record corresponding to the data modification request; under the condition that the modified data carried by the data modification request comprises modified multimedia data, storing the modified multimedia data; writing the modified storage path information of the multimedia data into a multimedia link data table to obtain a first multimedia link storage record, and associating the first multimedia link storage record with the service mirror image data record; and associating the first multimedia link storage record with the business formal data table after receiving the message that the modified data is approved.

According to the technical scheme of the embodiment of the invention, by introducing the service data mirror image copy strategy and the multimedia data link storage strategy, the difference, independence and separation type storage can be carried out on the checked data and the data in the check, so that the difference display of the multimedia data check intermediate state is conveniently realized, the data storage efficiency and the storage flexibility are optimized, and the convenience and the high efficiency of the multimedia data storage and query in the workflow system are greatly improved.

The above-described embodiments should not be construed as limiting the scope of the invention. Those skilled in the art will appreciate that various modifications, combinations, sub-combinations, and substitutions can occur, depending on design requirements and other factors. Any modification, equivalent replacement, and improvement made within the spirit and principle of the present invention should be included in the protection scope of the present invention.

Claims (15)

1. A data processing method is realized based on a workflow system and comprises the following steps:

after receiving a data modification request, synchronizing at least part of data in a business formal data table into a business mirror image data table to obtain a business mirror image data record corresponding to the data modification request;

under the condition that the modified data carried by the data modification request comprises modified multimedia data, storing the modified multimedia data;

writing the modified storage path information of the multimedia data into a multimedia link data table to obtain a first multimedia link storage record, and associating the first multimedia link storage record with the service mirror image data record;

and associating the first multimedia link storage record with the business formal data table after receiving the message that the modified data is approved.

2. The method of claim 1, further comprising:

under the condition that the modified data carried by the data modification request also comprises modified text data, updating a service mirror image data record corresponding to the data modification request according to the modified text data; and after the message which passes the modified data auditing is received, updating the business formal data table according to the business mirror image data record corresponding to the data modification request.

3. The method of claim 1, further comprising:

confirming that the first multimedia linked storage record is not associated with the service image data record prior to said associating the first multimedia linked storage record with the service image data record.

4. The method of claim 3, wherein the confirming that the first multimedia link storage record is not associated with the service image data record comprises:

inquiring a multimedia link data table according to the logic primary key of the service mirror image data record; and in the case that the query result is empty, confirming that the first multimedia link storage record is not associated with the service mirror data record.

5. The method of claim 3, wherein said confirming that the first multimedia link storage record is not associated with the service image data record further comprises:

inquiring a multimedia link data table according to the logic primary key of the service mirror image data record; under the condition that the query result is not empty, carrying out consistency comparison on the table associated field value in the first multimedia link storage record and the logic main key of the service mirror image data record; and under the condition that the table association field value in the first multimedia link storage record is inconsistent with the logic primary key of the service mirror image data record, confirming that the first multimedia link storage record is not associated with the service mirror image data record.

6. The method of claim 5, further comprising:

and under the condition that the table association field value in the first multimedia link storage record is consistent with the logic primary key of the service mirror image data record, confirming that the first multimedia link storage record is associated with the service mirror image data record.

7. The method of claim 1, further comprising:

after receiving the message that the modified data is approved, releasing the association between the second multimedia link storage record and the business formal data table; and the second multimedia link storage record is a link storage record of the multimedia data before modification corresponding to the data modification request.

8. The method of claim 1, further comprising:

and before the modified data auditing message is received, creating at least one auditing task, and sending the at least one auditing task to a terminal corresponding to an auditor so as to audit the modified data.

9. The method of claim 1, further comprising:

and after receiving an approval process data query request, querying the service mirror image data table according to the approval process data query request to obtain a corresponding query result.

10. The method of claim 1, further comprising:

and after receiving a formal data query request, querying the formal business data table according to the formal data query request to obtain a corresponding query result.

11. The method of claim 1, further comprising:

and generating a logic main key of the service mirror image data record corresponding to the data modification request before synchronizing at least part of data in the service formal data table into the service mirror image data table.

12. A data processing apparatus, wherein the apparatus is implemented based on a workflow system, comprising:

the synchronization module is used for synchronizing at least part of data in the business formal data table to a business mirror image data table after receiving a data modification request so as to obtain a business mirror image data record corresponding to the data modification request;

the multimedia data storage management module is used for storing the modified multimedia data under the condition that the modified data carried by the data modification request comprises the modified multimedia data;

the link data storage management module is used for writing the modified storage path information of the multimedia data into a multimedia link data table to obtain a first multimedia link storage record and associating the first multimedia link storage record with the service mirror image data record;

and the link data storage management module is further configured to associate the first multimedia link storage record with the business formal data table after receiving a message that the modified data is approved.

13. The apparatus of claim 12, further comprising:

the text data storage management module is used for updating the service mirror image data record corresponding to the data modification request according to the modified text data under the condition that the modified data carried by the data modification request also comprises the modified text data; and after the message which passes the modified data auditing is received, the text data processing module updates the business formal data table according to the business mirror image data table.

14. An electronic device, comprising:

one or more processors;

a storage device for storing one or more programs,

when executed by the one or more processors, cause the one or more processors to implement the method of any one of claims 1-11.

15. A computer-readable medium, on which a computer program is stored, which, when being executed by a processor, carries out the method according to any one of claims 1-11.

Images