CN109857759B - Concurrent data processing method and device, computer equipment and storage medium - Google Patents
Concurrent data processing method and device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN109857759B CN109857759B CN201811313360.1A CN201811313360A CN109857759B CN 109857759 B CN109857759 B CN 109857759B CN 201811313360 A CN201811313360 A CN 201811313360A CN 109857759 B CN109857759 B CN 109857759B
- Authority
- CN
- China
- Prior art keywords
- operation table
- version number
- metadata
- mrp
- latest version
- 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
Images
Abstract
The invention relates to a processing method and device of an operation table, computer equipment and a storage medium. The method comprises the following steps: when the material demand plan MRP operation is started, a first operation table in an idle state is inquired from a database; if the database has a first operation table, acquiring the initial version number of the metadata and the latest version number of the metadata of the first operation table; the latest version number of the metadata is a version number generated after the service data corresponding to the first operation table is updated; determining a second operation table according to the initial version number of the metadata and the latest version number of the metadata corresponding to the first operation table; and executing corresponding operation in the second operation table according to the MRP operation. The processing method of the operation table occupies less system resources and consumes less time.
Description
Technical Field
The present invention relates to the technical field of Enterprise Resource Planning (ERP), and in particular, to a method and an apparatus for processing concurrent data, a computer device, and a storage medium.
Background
With the development of business intelligence technology, more and more enterprises use the EPR system to manage the production plan of the enterprise, and in the existing ERP system, Material Requirement Planning (MRP) operation is a core technology in the ERP system.
However, the existing MRP operation involves a large number of operation tables, and the operation tables are used to store service information, intermediate data of the operation, operation results, and the like, which are needed in the MRP operation process, and the operation tables may include: MRP operation parameter table, required document information table, supply document information table, exception information table, net required information table, MRP result table, etc. When each MRP operation is started, a set of MRP operation tables is independently generated through codes, table names are returned to the MRP system, the operation tables corresponding to the MRP operation are deleted after the MRP operation is finished, and each MRP operation has a set of independent MRP operation tables, so that concurrent operation of MRP is realized.
In this scheme, the beginning and the end of the MRP operation require the creation and deletion of a whole set of MRP operation table, and under the environment of large data volume and high concurrency, the creation and deletion of the table consumes a lot of time and system resources.
Disclosure of Invention
In view of the above, it is desirable to provide an operation table processing method, an operation table processing apparatus, a computer device, and a storage medium, which can reduce time consumption and occupy less system resources.
In a first aspect, a method for processing an operation table includes:
when the material demand plan MRP operation is started, a first operation table in an idle state is inquired from a database;
if the first operation table exists in the database, acquiring the initial version number of the metadata and the latest version number of the metadata of the first operation table; the latest version number of the metadata is a version number generated after the service data corresponding to the first operation table is updated;
determining a second operation table according to the initial version number of the metadata and the latest version number of the metadata corresponding to the first operation table;
and executing corresponding operation in the second operation table according to the MRP operation.
In one embodiment, the determining the second operation table according to the initial version number of the metadata and the latest version number of the metadata corresponding to the first operation table includes:
comparing the initial version number of the metadata with the latest version number of the metadata to obtain a comparison result;
and determining the second operation table according to the comparison result.
In one embodiment, said determining said second operation table according to said comparison result comprises:
if the comparison result is that the initial version number of the metadata is consistent with the latest version number of the metadata, determining the first operation table as the second operation table;
and if the comparison result shows that the initial version number of the metadata is not consistent with the latest version number of the metadata, creating the second operation table according to the service data corresponding to the latest version number of the metadata.
In one embodiment, if the comparison result indicates that the initial version number of the metadata is not consistent with the latest version number of the metadata, the method further includes:
and deleting the first operation table, and saving the created second operation table.
In one embodiment, the method further comprises:
if the first operation table does not exist in the database, a third operation table is created according to the service data corresponding to the latest version number of the metadata;
and executing corresponding operation in the third operation table according to the MRP operation.
In one embodiment, the method further comprises:
and marking the state of the second operation table as a busy state.
In one embodiment, said performing the corresponding operation in the second operation table according to the MRP operation comprises:
and marking the state in the second operation table as an idle state.
In a second aspect, an apparatus for processing an operation table, the apparatus comprising:
the query module is used for querying a first operation table in an idle state from a database when the material demand plan MRP operation is started;
an obtaining module, configured to obtain an initial version number of metadata and a latest version number of the metadata of the first operation table if the first operation table exists in the database; the latest version number of the metadata is a version number generated after the service data corresponding to the first operation table is updated;
the determining module is used for determining a second operation table according to the initial version number of the metadata and the latest version number of the metadata corresponding to the first operation table;
and the operation module is used for executing corresponding operation in the second operation table according to the MRP operation.
In a third aspect, a computer device comprises a memory and a processor, the memory storing a computer program, the processor implementing the following steps when executing the computer program:
when the material demand plan MRP operation is started, a first operation table in an idle state is inquired from a database;
if the first operation table exists in the database, acquiring the initial version number of the metadata and the latest version number of the metadata of the first operation table; the latest version number of the metadata is a version number generated after the service data corresponding to the first operation table is updated;
determining a second operation table according to the initial version number of the metadata and the latest version number of the metadata corresponding to the first operation table;
and executing corresponding operation in the second operation table according to the MRP operation.
In a fourth aspect, a computer readable storage medium having stored thereon a computer program which when executed by a processor implements the steps of:
when the material demand plan MRP operation is started, a first operation table in an idle state is inquired from a database;
if the first operation table exists in the database, acquiring the initial version number of the metadata and the latest version number of the metadata of the first operation table; the latest version number of the metadata is a version number generated after the service data corresponding to the first operation table is updated;
determining a second operation table according to the initial version number of the metadata and the latest version number of the metadata corresponding to the first operation table;
and executing corresponding operation in the second operation table according to the MRP operation.
The application provides a processing method, a processing device, computer equipment and a storage medium of an operation table, which comprise the following steps: when the material demand plan MRP operation is started, the terminal equipment inquires a first operation table in an idle state from a database; if the database has a first operation table, acquiring the initial version number of the metadata of the first operation table and the latest version number of the metadata corresponding to the first operation table; determining a second operation table according to the initial version number of the metadata and the latest version number of the metadata corresponding to the first operation table; and executing corresponding operation in the second operation table according to the MRP operation. In the above processing procedure for the operation table, the terminal device determines the second operation table by acquiring the initial version number of the metadata and the latest version number of the metadata corresponding to the first operation table in the idle state, and finally executes corresponding operations in the second operation table. Compared with the traditional processing procedure for the operation table: the method for processing the operation table comprises the steps that a whole set of MRP operation table is required to be created and deleted every time the MRP operation is started and finished, and the second operation table is determined according to the initial version number of the metadata and the latest version number of the metadata, so that the second operation table can be reused, the MRP operation table is not required to be created every time the MRP operation is started, and the MRP operation table is not required to be deleted every time the MRP operation is finished. Therefore, the processing method of the operation table provided by the application occupies less system resources and consumes less time, and is particularly obvious in an environment with large data volume and high concurrency.
Drawings
FIG. 1 is a diagram showing an internal structure of a terminal device in one embodiment;
FIG. 2 is a flowchart of a method for processing an operation table according to an embodiment;
FIG. 3 is a flowchart of an implementation of S103 in the embodiment of FIG. 2;
FIG. 4 is a flowchart of a method for processing an operation table according to an embodiment;
FIG. 5 is a flowchart of a method for processing an operation table according to an embodiment;
FIG. 6 is a flowchart of a method for processing an operation table according to an embodiment;
FIG. 7 is a flowchart of a method for processing an operation table according to an embodiment;
FIG. 8 is a diagram illustrating an exemplary processing device for a calculation table;
FIG. 9 is a diagram illustrating an apparatus for processing an operation table according to an embodiment;
FIG. 10 is a diagram illustrating an exemplary processing device for a calculation table;
FIG. 11 is a diagram illustrating an exemplary processing device for a calculation table;
fig. 12 is a schematic diagram of a processing device of an operation table according to an embodiment.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the present application is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the present application and are not intended to limit the present application.
The processing method of the operation table provided by the embodiment of the application can be applied to the terminal device shown in fig. 1. The terminal equipment comprises a processor, a memory, a network interface, a display screen and an input device which are connected through a system bus. Wherein the processor of the terminal device is configured to provide computing and control capabilities. The memory of the terminal equipment comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The network interface of the terminal device is used for connecting and communicating with an external terminal through a network. The computer program is executed by a processor to implement a method of processing an operation table. The display screen of the terminal equipment can be a liquid crystal display screen or an electronic ink display screen, and the input device of the terminal equipment can be a touch layer covered on the display screen, a key, a track ball or a touch pad arranged on the shell of the terminal equipment, an external keyboard, a touch pad or a mouse and the like. The terminal device related to the present application may be, but is not limited to, various personal computers, notebook computers, smart phones, tablet computers, portable wearable devices, and the like, and the present application does not limit this.
Those skilled in the art will appreciate that the structure shown in fig. 1 is a block diagram of only a portion of the structure relevant to the present disclosure, and does not constitute a limitation on the terminal device to which the present disclosure applies, and that a particular terminal device may include more or less components than those shown in the drawings, or may combine certain components, or have a different arrangement of components.
The technical solution of the present invention will be described in detail below with specific examples. The following several specific embodiments may be combined with each other, and details of the same or similar concepts or processes may not be repeated in some embodiments.
Fig. 2 is a flowchart of a processing method of an operation table according to an embodiment. The embodiment relates to a processing procedure of an operation table when the terminal device executes MRP operation. The main execution body of the method is a terminal device, and the terminal device is provided with application programs of MRP operation, MRP service and MRP table management service. As shown in fig. 2, the method comprises the steps of:
s101, when the material demand plan MRP operation is started, a first operation table in an idle state is inquired from a database.
The material demand plan MRP operation is an operation for making a series of enterprise production and management related documents such as production plan documents, material purchasing documents, sales plan documents and the like according to customer demands. The first operation table is used for storing various service information required in the MRP operation process, or intermediate data and operation results of various MRP operations. For example, the first operation table may be at least one operation table of an MRP operation parameter table, a demand document information table, a supply document information table, an exception information table, a net demand information table, an MRP result table, and the like. The first operation table in the idle state means that the first operation table is not currently used by any MRP operation, and the first operation table may be a blank table for the terminal device to write related MRP operation data into the table; optionally, the first operation table may also be a table containing material information and having a reserved space, so that the terminal device reads or writes data required by the MRP operation from the table.
Optionally, when the MRP operation in the terminal device is started, the terminal device may query whether there is a first operation table in an idle state from a plurality of operation tables existing in the database, and specifically may query each operation table according to the arrangement order of addresses of each operation table to find one first operation table in the idle state; optionally, the operation tables may be queried according to the table names of the operation tables to find a first operation table in an idle state; optionally, the operation tables may be queried according to other preset rules to find a first operation table in an idle state.
S102, if a first operation table exists in the database, acquiring an initial version number of metadata and a latest version number of the metadata of the first operation table; and the latest version number of the metadata is the version number generated after the service data corresponding to the first operation table is updated.
When the service data is the latest service data, the version number generated by the latest service data is the latest version number of the metadata. Therefore, in this embodiment, the latest version number of the metadata is a version number generated after the user modifies the corresponding service data through the terminal device.
It should be noted that the initial version number of the metadata in the first operation table or the latest version number of the metadata corresponding to the first operation table are both an identifier generated by the terminal device in the process of processing the corresponding service data to generate the corresponding first operation table. The identification may be represented by a serial number or a combination of letters.
When the database has a first operation table, which is equivalent to the first operation table that is not used by any MRP operation, the terminal device obtains the initial version number of the metadata corresponding to the first operation table and the latest version number of the metadata. The terminal device can know whether the service data corresponding to the first operation table is updated or not according to the initial version number of the metadata and the latest version number of the metadata, if the service data corresponding to the first operation table is not updated, the initial version number of the metadata can be equal to the latest version number of the metadata, and if the service data corresponding to the first operation table is updated, the initial version number of the metadata and the latest version number of the metadata are two different version numbers.
S103, determining a second operation table according to the initial version number of the metadata and the latest version number of the metadata corresponding to the first operation table.
In this embodiment, when the terminal device starts an MRP operation and acquires the first operation table from the database, and the first operation table is not updated by the terminal device all the time before starting the MRP, the terminal device may determine the second operation table according to the initial version number of the metadata corresponding to the first operation table; optionally, when the terminal device starts an MRP operation and acquires the first operation table from the database, but the first operation table is updated by the terminal device before the MRP operation is started, the terminal device may determine the second operation table according to the latest version number of the metadata corresponding to the first operation table.
And S104, executing corresponding operation in the second operation table according to the MRP operation.
After the terminal device determines the second operation table, the table name of the second operation table may be obtained, so that the MRP operation may find the address of the second operation table corresponding to the table name in the database according to the table name, and then the MRP operation may perform corresponding operations in the second operation table according to the address, where the operations may specifically include data operations such as a read data operation, a write data operation, and a delete data operation.
In the above embodiment, when the material demand plan MRP operation is started, the terminal device queries the first operation table in the idle state from the database; if the database has a first operation table, acquiring the initial version number of the metadata of the first operation table and the latest version number of the metadata corresponding to the first operation table; determining a second operation table according to the initial version number of the metadata and the latest version number of the metadata corresponding to the first operation table; and executing corresponding operation in the second operation table according to the MRP operation. Compared with the traditional method for processing the operation table, the method for processing the operation table has the advantages that the whole set of MRP operation table is required to be created and deleted every time when the MRP operation is started and finished by the terminal equipment, the second operation table is determined according to the initial version number of the metadata and the latest version number of the metadata corresponding to the first operation table in the idle state, therefore, the second operation table can be repeatedly used, the whole set of MRP operation table is not required to be created every time the MRP operation is started, and the MRP operation table is not required to be deleted every time the MRP operation is finished. Therefore, the processing method of the operation table provided by the application occupies less system resources and consumes less time, and is particularly obvious in an environment with large data volume and high concurrency.
In an application scenario in which a terminal device starts a plurality of MRP operations, data operation conflicts caused by one MRP operation executing a corresponding operation on an operation table by another MRP operation when the operation table is correspondingly operated are avoided. The operation table acquired by the terminal device needs to be set as follows.
On the basis of the foregoing embodiment, optionally, after determining the second calculation table, the terminal device marks the state of the second calculation table as a busy state. When the terminal device determines the second operation table required by the MRP operation and prepares to perform a corresponding operation on the second operation table, the terminal device may modify the identifier of the idle state originally set in the second operation table into the identifier of the busy state to avoid the use of other MRP operations.
Optionally, after the MRP operation executes the corresponding operation in the second operation table, the MRP operation further includes: and marking the state in the second operation table as an idle state.
The state flag is an identifier for indicating the state of the second operation table in the database, and the identifier can be divided into an identifier for a free state and an identifier for a busy state. When the second operation table is used by one MRP operation, the terminal equipment sets the state mark in the second operation table as the identifier of a busy state so as to avoid operation conflict caused by the execution of corresponding operation on the second operation table by other MRP operations; when the second operation table is not used by any MRP operation, the terminal device sets the status flag in the second operation table to the identifier of the idle state, in which case any MRP operation can perform corresponding operation on the second operation table.
In this embodiment, after one MRP operation completes one data reading operation or data writing operation on the second operation table, it is necessary to modify the originally set identifier of the busy state in the second operation table into an identifier of the idle state, and release the resource of the second operation table, so that the terminal device can be used in the next MRP operation.
Fig. 3 is a flowchart of an implementation manner of S103 in the embodiment of fig. 2. The embodiment relates to a specific process of determining the second operation table by the terminal device. On the basis of the foregoing embodiment, as shown in fig. 3, the step S103 "determining the second operation table according to the initial version number of the metadata and the latest version number of the metadata corresponding to the first operation table" may include the following steps:
s201, comparing the initial version number of the metadata with the latest version number of the metadata to obtain a comparison result.
The comparison result may be that the initial version number of the metadata is consistent with the latest version number of the metadata, or that the initial version number of the metadata is inconsistent with the latest version number of the metadata.
Before the terminal equipment starts an MRP operation, the initial version number of the metadata of a first operation table in a database is not updated, the initial version number of the metadata is consistent with the latest version number of the metadata, and correspondingly, before the terminal equipment starts an MRP operation, a user modifies the original service data on the terminal equipment according to actual requirements or inputs a new service data, the initial version number of the metadata in the database of the terminal equipment is inconsistent with the latest version number of the metadata.
S202, determining a second operation table according to the comparison result.
If the comparison result is different, the method for determining the second operation table is different, and as shown in fig. 4, the specific determination process of the second operation table is as follows:
s301, if the initial version number of the metadata is consistent with the latest version number of the metadata as a comparison result, determining the first operation table as a second operation table.
When the initial version number of the metadata corresponding to the first operation table in the database is consistent with the latest version number of the metadata, which is equivalent to the service data corresponding to the initial version number of the metadata in the database, and is the service data required by the current user, the terminal device can directly use the first operation table established by the service data corresponding to the initial version number of the metadata, that is, the first operation table is directly used as a second operation table for the MRP operation.
S302, if the comparison result shows that the initial version number of the metadata is not consistent with the latest version number of the metadata, a second operation table is created according to the service data corresponding to the latest version number of the metadata.
When the initial version number of the metadata existing in the database is inconsistent with the latest version number of the metadata, which is equivalent to that before the MRP operation is started, a user requires to add another service data or modify the original service data, and the terminal device generates the latest version number of the metadata according to the newly added service data or the modified service data, so that the latest version number of the metadata is different from the initial version number of the metadata existing in the database.
Optionally, if the comparison result is that the initial version number of the metadata is not consistent with the latest version number of the metadata, the first operation table is deleted, and the created second operation table is saved.
When the terminal device creates the second operation table according to the latest version number of the metadata, the first operation table can be directly deleted from the database, and the second operation table is stored in a corresponding address in the database for MRP operation. Optionally, the created second operation table may directly replace the originally existing first operation table, and is stored in the original address in the database.
In the above embodiment, the terminal device compares the initial version number of the metadata with the latest version number of the metadata to obtain a comparison result; and determining a second operation table according to the comparison result. In the process of determining the second operation table, when the terminal device does not need to restart the MRP operation, the second operation table is directly created, and the second operation table is selectively created according to the comparison result.
The above embodiments are all based on an application scenario that when the terminal device queries whether there is a first operation table in an idle state, there is the first operation table in the idle state in the database, and there is another situation in practical application: when the terminal equipment queries whether the first operation table in the idle state exists, the first operation table in the idle state does not exist in the database. In this case, as shown in fig. 5, the method for processing an operation table provided by the present application further includes:
s401, if the first operation table does not exist in the database, a third operation table is created according to the service data corresponding to the latest version number of the metadata.
When the terminal device starts the MRP operation and does not query the first operation table in the idle state from the database, it needs to acquire the latest version number of the metadata corresponding to the first operation table from the database, and then creates a third operation table according to the service data corresponding to the latest version number of the metadata, so as to facilitate the MRP operation.
And S402, executing corresponding operation in a third operation table according to the MRP operation.
The step is the same as that described in step S104 in the above embodiment, and specific contents may refer to step S104, and a repeated description is not provided here.
In the above embodiment, when the terminal device queries the first operation table, if the first operation table does not exist in the database, a third operation table is created according to the service data corresponding to the latest version number of the metadata; and executing corresponding operation in the third operation table according to the MRP operation. In the process, when the first operation does not exist in the database, the terminal device dynamically creates the third operation table for the MRP operation.
In one application scenario: the terminal device comprises a client, an MRP operation service and an application program of an MRP operation table service, and the three application programs realize the processing of the operation table in the above embodiment through data interaction with each other, so as to complete the MRP operation. As shown in fig. 6, the processing procedure of the operation table is as follows: a user initiates an MRP operation instruction to the MRP operation service through a client, requires the MRP operation service to start an MRP operation, and returns an operation result of the MRP operation; when receiving the operation instruction, the MRP operation service applies a first operation table required by the MRP operation to the MRP operation table service, when receiving the application, the MRP operation table service inquires whether the first operation table in an idle state exists in a database, obtains a metadata version number and a metadata latest version number of the first operation table, determines a target operation table according to the metadata version number and the metadata latest version number of the first operation table, marks a state in the target operation table as busy, and returns a table name of the target operation table to the MRP operation service. When the MRP operation service obtains the table name of the target operation table, corresponding operation can be executed in the target operation table according to the table name of the target operation table, after the corresponding operation is executed, operation ending notification information is sent to the MRP operation table service, the MRP operation table service is notified to store the operated target operation table, and the state in the target operation table is marked as idle so as to enable the next MRP operation to be used. After the MRP operation service executes the MRP operation, the operation result of the current MRP operation can be obtained, and the operation result is returned to the client, so that the user can obtain the result of the current MRP operation through the client.
Referring to fig. 7, the specific determination process of the target calculation table involved in the above process may include the following steps:
s501, inquiring whether a first operation table in an idle state exists in a database, if so, executing S502, and if not, executing S506.
S502, acquiring the initial version number of the metadata and the latest version number of the metadata of the first operation table.
S503, comparing the initial version number of the metadata with the latest version number of the metadata, and executing S504 if the initial version number of the metadata is consistent with the latest version number of the metadata; if the initial version number of the metadata is not consistent with the latest version number of the metadata, S505 is executed.
S504, the first operation table is used as a second operation table, the table name of the second operation table is returned to the MRP operation service, and the state in the second operation table is marked as busy.
S505, creating a second operation table according to the latest version number of the metadata, deleting the first operation table, marking the state in the second operation table as busy, and returning the table name of the second operation table to the MRP operation service. In this embodiment, the second operation table is the target operation table in fig. 6.
S506, the latest version number of the metadata is obtained from the database, a third operation table is created according to the latest version number of the metadata, the state in the third operation table is marked as busy, and the table name of the third operation table is returned to MRP operation service. In this embodiment, the third operation table is the target operation table in fig. 6.
It should be understood that although the various steps in the flowcharts of fig. 2-5 are shown in order as indicated by the arrows, the steps are not necessarily performed in order as indicated by the arrows. The steps are not performed in the exact order shown and described, and may be performed in other orders, unless explicitly stated otherwise. Moreover, at least some of the steps in fig. 2-5 may include multiple sub-steps or multiple stages that are not necessarily performed at the same time, but may be performed at different times, and the order of performance of the sub-steps or stages is not necessarily sequential.
Fig. 8 is a schematic diagram of a processing apparatus for an operation table according to an embodiment, as shown in fig. 8, the apparatus includes: the device comprises a query module 11, an acquisition module 12, a determination module 13 and a first operation module 14, wherein:
the query module 11 is configured to query the first operation table in an idle state from the database when the material demand plan MRP operation is started;
an obtaining module 12, configured to obtain an initial version number of metadata and a latest version number of the metadata of the first operation table if the first operation table exists in the database; the latest version number of the metadata is a version number generated after the service data corresponding to the first operation table is updated;
a determining module 13, configured to determine a second operation table according to the initial version number of the metadata and a latest version number of the metadata corresponding to the first operation table;
a first operation module 14, configured to execute a corresponding operation in the second operation table according to the MRP operation.
In one embodiment, as shown in fig. 9, on the basis of the processing device of the operation table shown in fig. 8, the determining module 13 includes:
a comparing unit 131, configured to compare the initial version number of the metadata with the latest version number of the metadata to obtain a comparison result;
a determining unit 132, configured to determine the second operation table according to the comparison result.
In an embodiment, the determining unit 132 is specifically configured to determine the first operation table as the second operation table if the comparison result indicates that the initial version number of the metadata is consistent with the latest version number of the metadata; and if the comparison result shows that the initial version number of the metadata is not consistent with the latest version number of the metadata, creating the second operation table according to the service data corresponding to the latest version number of the metadata.
In an embodiment, as shown in fig. 10, on the basis of the processing device of the operation table shown in fig. 8, the determining module 13 further includes:
a deletion saving unit 133 configured to delete the first operation table and save the created second operation table.
In one embodiment, as shown in fig. 11, on the basis of the processing apparatus of the operation table shown in fig. 8, the processing apparatus of the operation table further includes:
a creating module 15, configured to create a third operation table according to the service data corresponding to the latest version number of the metadata if the first operation table does not exist in the database;
a second operation module 16, configured to execute a corresponding operation in the third operation table according to the MRP operation.
In one embodiment, as shown in fig. 12, on the basis of the processing apparatus of the operation table shown in fig. 8, the processing apparatus of the operation table further includes:
and a setting and marking module 17, configured to mark the state in the second operation table as an idle state.
In one embodiment, a computer device is provided, comprising a memory and a processor, the memory having a computer program stored therein, the processor implementing the following steps when executing the computer program:
when the material demand plan MRP operation is started, a first operation table in an idle state is inquired from a database;
if the first operation table exists in the database, acquiring the initial version number of the metadata and the latest version number of the metadata of the first operation table; the latest version number of the metadata is a version number generated after the service data corresponding to the first operation table is updated;
determining a second operation table according to the initial version number of the metadata and the latest version number of the metadata corresponding to the first operation table;
and executing corresponding operation in the second operation table according to the MRP operation.
In one embodiment, the processor, when executing the computer program, further performs the steps of: comparing the initial version number of the metadata with the latest version number of the metadata to obtain a comparison result; and determining the second operation table according to the comparison result.
In one embodiment, the processor, when executing the computer program, further performs the steps of: if the comparison result is that the initial version number of the metadata is consistent with the latest version number of the metadata, determining the first operation table as the second operation table; and if the comparison result shows that the initial version number of the metadata is not consistent with the latest version number of the metadata, creating the second operation table according to the service data corresponding to the latest version number of the metadata.
In one embodiment, the processor, when executing the computer program, further implements: and deleting the first operation table, and saving the created second operation table.
In one embodiment, the processor, when executing the computer program, further performs the steps of: if the first operation table does not exist in the database, a third operation table is created according to the service data corresponding to the latest version number of the metadata; and executing corresponding operation in the third operation table according to the MRP operation.
In one embodiment, the processor, when executing the computer program, further implements: and marking the state of the second operation table as a busy state.
In one embodiment, the processor, when executing the computer program, further implements: and marking the state in the second operation table as an idle state.
In one embodiment, a computer-readable storage medium is provided, having a computer program stored thereon, the computer program, when executed by a processor, further implementing the steps of:
when the material demand plan MRP operation is started, a first operation table in an idle state is inquired from a database;
if the first operation table exists in the database, acquiring the initial version number of the metadata and the latest version number of the metadata of the first operation table; the latest version number of the metadata is a version number generated after the service data corresponding to the first operation table is updated;
determining a second operation table according to the initial version number of the metadata and the latest version number of the metadata corresponding to the first operation table;
and executing corresponding operation in the second operation table according to the MRP operation.
In one embodiment, the computer program when executed by the processor further performs the steps of: comparing the initial version number of the metadata with the latest version number of the metadata to obtain a comparison result; and determining the second operation table according to the comparison result.
In one embodiment, the computer program when executed by the processor further performs the steps of: if the comparison result is that the initial version number of the metadata is consistent with the latest version number of the metadata, determining the first operation table as the second operation table; and if the comparison result shows that the initial version number of the metadata is not consistent with the latest version number of the metadata, creating the second operation table according to the service data corresponding to the latest version number of the metadata.
In one embodiment, the computer program when executed by the processor further implements: and deleting the first operation table, and saving the created second operation table.
In one embodiment, the computer program when executed by the processor further performs the steps of: if the first operation table does not exist in the database, a third operation table is created according to the service data corresponding to the latest version number of the metadata; and executing corresponding operation in the third operation table according to the MRP operation.
In one embodiment, the computer program when executed by the processor further implements: and marking the state of the second operation table as a busy state.
In one embodiment, the computer program when executed by the processor further implements: and marking the state in the second operation table as an idle state.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by hardware instructions of a computer program, which can be stored in a non-volatile computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. Any reference to memory, storage, database, or other medium used in the embodiments provided herein may include non-volatile and/or volatile memory, among others. Non-volatile memory can include read-only memory (ROM), Programmable ROM (PROM), Electrically Programmable ROM (EPROM), Electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), Dynamic RAM (DRAM), Synchronous DRAM (SDRAM), Double Data Rate SDRAM (DDRSDRAM), Enhanced SDRAM (ESDRAM), synchronous Link (Synchlink) DRAM (SLDRAM), Rambus Direct RAM (RDRAM), direct bus dynamic RAM (DRDRAM), and bus dynamic RAM (RDRAM).
The technical features of the above embodiments can be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the above embodiments are not described, but should be considered as the scope of the present specification as long as there is no contradiction between the combinations of the technical features.
The above-mentioned embodiments only express several embodiments of the present invention, and the description thereof is more specific and detailed, but not construed as limiting the scope of the invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the inventive concept, which falls within the scope of the present invention. Therefore, the protection scope of the present patent shall be subject to the appended claims.
Claims (10)
1. A method for processing an operation table, comprising:
when the material demand plan MRP operation is started, a first operation table in an idle state is inquired from a database;
if the first operation table exists in the database, acquiring the initial version number of the metadata and the latest version number of the metadata of the first operation table; the latest version number of the metadata is a version number generated after the service data corresponding to the first operation table is updated;
determining a second operation table according to the initial version number of the metadata and the latest version number of the metadata corresponding to the first operation table;
and executing corresponding operation in the second operation table according to the MRP operation.
2. The method of claim 1, wherein determining a second operation table according to the initial version number of the metadata and the latest version number of the metadata corresponding to the first operation table comprises:
comparing the initial version number of the metadata with the latest version number of the metadata to obtain a comparison result;
and determining the second operation table according to the comparison result.
3. The method of claim 2, wherein determining the second calculation table according to the comparison comprises:
if the comparison result is that the initial version number of the metadata is consistent with the latest version number of the metadata, determining the first operation table as the second operation table;
and if the comparison result shows that the initial version number of the metadata is not consistent with the latest version number of the metadata, creating the second operation table according to the service data corresponding to the latest version number of the metadata.
4. The method of claim 3, wherein if the comparison result indicates that the initial version number of the metadata is not consistent with the latest version number of the metadata, the method further comprises:
and deleting the first operation table, and saving the created second operation table.
5. The method according to any one of claims 1-4, further comprising:
if the first operation table does not exist in the database, a third operation table is created according to the service data corresponding to the latest version number of the metadata;
and executing corresponding operation in the third operation table according to the MRP operation.
6. The method of claim 1, further comprising:
and marking the state of the second operation table as a busy state.
7. The method of claim 6, wherein the performing the corresponding operation in the second operation table according to the MRP operation comprises:
and marking the state in the second operation table as an idle state.
8. An apparatus for processing an operation table, the apparatus comprising:
the query module is used for querying a first operation table in an idle state from a database when the material demand plan MRP operation is started;
an obtaining module, configured to obtain an initial version number of metadata and a latest version number of the metadata of the first operation table if the first operation table exists in the database; the latest version number of the metadata is a version number generated after the service data corresponding to the first operation table is updated;
the determining module is used for determining a second operation table according to the initial version number of the metadata and the latest version number of the metadata corresponding to the first operation table;
and the operation module is used for executing corresponding operation in the second operation table according to the MRP operation.
9. A computer device comprising a memory and a processor, the memory storing a computer program, wherein the processor implements the steps of the method of any one of claims 1 to 7 when executing the computer program.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method according to any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811313360.1A CN109857759B (en) | 2018-11-06 | 2018-11-06 | Concurrent data processing method and device, computer equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811313360.1A CN109857759B (en) | 2018-11-06 | 2018-11-06 | Concurrent data processing method and device, computer equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109857759A CN109857759A (en) | 2019-06-07 |
| CN109857759B true CN109857759B (en) | 2021-06-15 |
Family
ID=66889919
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811313360.1A Active CN109857759B (en) | 2018-11-06 | 2018-11-06 | Concurrent data processing method and device, computer equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109857759B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111105249B (en) * | 2019-12-09 | 2024-02-20 | 金蝶软件（中国）有限公司 | Supply chain data tracing method and device and computer equipment |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101510277A (en) * | 2009-02-20 | 2009-08-19 | 浪潮集团山东通用软件有限公司 | Method for rolling computation of material requirement in production management process |
| CN101582140A (en) * | 2009-06-22 | 2009-11-18 | 金蝶软件（中国）有限公司 | Method for acquiring data, device and server |
| CN102567826A (en) * | 2010-12-20 | 2012-07-11 | 金蝶软件（中国）有限公司 | Method and system for processing material bills |
| CN103559558A (en) * | 2013-11-07 | 2014-02-05 | 金蝶软件（中国）有限公司 | Material reserved supply and demand matching method and device |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20090307026A1 (en) * | 2008-06-10 | 2009-12-10 | International Business Machines Corporation | Priority-based system for netting available coverage |
-
2018
- 2018-11-06 CN CN201811313360.1A patent/CN109857759B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101510277A (en) * | 2009-02-20 | 2009-08-19 | 浪潮集团山东通用软件有限公司 | Method for rolling computation of material requirement in production management process |
| CN101582140A (en) * | 2009-06-22 | 2009-11-18 | 金蝶软件（中国）有限公司 | Method for acquiring data, device and server |
| CN102567826A (en) * | 2010-12-20 | 2012-07-11 | 金蝶软件（中国）有限公司 | Method and system for processing material bills |
| CN103559558A (en) * | 2013-11-07 | 2014-02-05 | 金蝶软件（中国）有限公司 | Material reserved supply and demand matching method and device |
Non-Patent Citations (1)
| Title |
|---|
| 中小制造企业计划管理和生产查询设计与实现;宋立涛;《中国优秀硕士学位论文全文数据库信息科技辑》;20070315;正文第30-33、46-49页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109857759A (en) | 2019-06-07 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109558404B (en) | Data storage method, device, computer equipment and storage medium | |
| US11003625B2 (en) | Method and apparatus for operating on file | |
| CN111191221B (en) | Configuration method and device of authority resources and computer readable storage medium | |
| CN104391725A (en) | Page display method and page display device | |
| EP3252592A1 (en) | Method and device for storing and reading data | |
| CN109597979B (en) | List table generation method and device, computer equipment and storage medium | |
| CN108664582B (en) | Enterprise relation query method and device, computer equipment and storage medium | |
| CN111061475B (en) | Software code generating method, device, computer equipment and storage medium | |
| CN110781214A (en) | Database reading and writing method and device, computer equipment and storage medium | |
| CN112464625B (en) | Document generation method, device, computer equipment and storage medium | |
| CN110766521A (en) | Method, device and system for generating purchase order and storage medium | |
| CN109523418A (en) | Drawing acquisition methods, device, computer equipment and storage medium | |
| CN110457401B (en) | Data storage method and device, computer equipment and storage medium | |
| CN109857759B (en) | Concurrent data processing method and device, computer equipment and storage medium | |
| CN114611481A (en) | Template configuration method and device, computer equipment and storage medium | |
| CN112785248B (en) | Human resource data cross-organization interaction method, device, equipment and storage medium | |
| CN111090701B (en) | Service request processing method, device, readable storage medium and computer equipment | |
| CN109542962B (en) | Data processing method, data processing device, computer equipment and storage medium | |
| CN109241371B (en) | Map data storage method, map data loading method, map data storage device, map data loading device and computer equipment | |
| CN111984659A (en) | Data updating method and device, computer equipment and storage medium | |
| CN108196921B (en) | Document development method and device, computer equipment and storage medium | |
| CN113377458B (en) | Plug-in management method and device, electronic equipment and storage medium | |
| CN112835886A (en) | Data table field adding method and device | |
| JP6442083B2 (en) | Information item storage method, information item storage system, information item storage device, information item storage program, and computer-readable storage medium | |
| CN111507566B (en) | Method, device, computer equipment and storage medium for generating article production list |
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 |