CN109857759A - Processing method, device, computer equipment and the storage medium of concurrent data - Google Patents
Processing method, device, computer equipment and the storage medium of concurrent data Download PDFInfo
- Publication number
- CN109857759A CN109857759A CN201811313360.1A CN201811313360A CN109857759A CN 109857759 A CN109857759 A CN 109857759A CN 201811313360 A CN201811313360 A CN 201811313360A CN 109857759 A CN109857759 A CN 109857759A
- Authority
- CN
- China
- Prior art keywords
- operation table
- metadata
- mrp
- latest edition
- version number
- 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.)
- Granted
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention relates to a kind of processing method of operation table, device, computer equipment and storage mediums.This method comprises: inquiring the first operation table being in idle condition from database in material demand plan MRP operation starting；If there are the first operation tables in database, the metadata initial version number and metadata latest edition number of the first operation table are obtained；Metadata latest edition number is the version number that generates after the corresponding service data updating of the first operation table；According to metadata initial version number and the corresponding metadata latest edition number of the first operation table, the second operation table is determined；Corresponding operation is executed in the second operation table according to MRP operation.The system resource that the processing method for the operation table that the application proposes occupies is less, and the time consumed is less.
Description
Technical field
The present invention relates to Enterprise Resources Plan (Enterprise Resources Planning, ERP) technical fields, especially
A kind of its processing method for being related to concurrent data, device, computer equipment and storage medium.
Background technique
With the development of busincess intelligence technology, more and more enterprises are realized using EPR system now produces enterprise
The management of plan, and in existing ERP system, material demand plan (Material Requirement Planning,
MRP) operation is the core technology in ERP system.
And existing MRP operation is related to a large amount of operation table, required for operation table is for storing in MRP calculating process
Business information, the intermediate data of operation, operation result etc., operation table may include: MRP operational parameter table, demand document information
Table, supply document information table, exceptional information table, net demand information table, MRP result table etc..In each MRP operation starting, lead to
It crosses code and independently generates a set of MRP operation operation table, and return to table name and give MRP system, and after MRP operation, deleting should
Operation table corresponding to secondary MRP operation, since each MRP operation is owned by a set of independent MRP operation operation table, to realize
The concurrent operation of MRP.
In this scenario, the beginning of MRP operation and end need to create and delete a whole set of MRP operation table, in big data
Amount is in the environment of high concurrent, and the creation and deletion of table can take a substantial amount of time and system resource.
Summary of the invention
Based on this, it is necessary to which in view of the above technical problems, elapsed time, and occupying system resources can be reduced by providing one kind
Processing method, device, computer equipment and the storage medium of less operation table.
In a first aspect, a kind of processing method of operation table, comprising:
In material demand plan MRP operation starting, the first operation table being in idle condition is inquired from database；
If there are first operation tables in the database, the metadata initial version of first operation table is obtained
Number and metadata latest edition number；The metadata latest edition number is after the corresponding service data updating of first operation table
The version number of generation；
According to the metadata initial version number metadata latest edition number corresponding with first operation table, is determined
Two operation tables；
Corresponding operation is executed in second operation table according to the MRP operation.
In one embodiment, described according to the metadata initial version number first number corresponding with first operation table
According to latest edition number, the second operation table is determined, comprising:
The metadata initial version number and the metadata latest edition number are compared, comparison result is obtained；
According to the comparison result, second operation table is determined.
In one embodiment, described according to the comparison result, determine second operation table, comprising:
If the comparison result is that the metadata initial version number is consistent with the metadata latest edition number, by institute
It states the first operation table and is determined as second operation table；
If the comparison result is that the metadata initial version number and the metadata latest edition number are inconsistent, root
Second operation table is created according to the corresponding business datum of the metadata latest edition number.
In one embodiment, if the comparison result be the metadata initial version number and the metadata most
New version number is inconsistent, the method also includes:
First operation table is deleted, and saves the second operation table of creation.
In one embodiment, the method also includes:
If first operation table is not present in the database, according to the corresponding industry of the metadata latest edition number
Business data creation third operation table；
Corresponding operation is executed in the third operation table according to the MRP operation.
In one embodiment, the method also includes:
The status of second operation table is labeled as busy condition.
In one embodiment, it is described executed in second operation table according to the MRP operation corresponding operation it
Afterwards, comprising:
It is idle state by the status indication in second operation table.
Second aspect, a kind of processing unit of operation table, described device include:
Enquiry module, in material demand plan MRP operation starting, inquiry to be in idle condition from database
First operation table；
Module is obtained, if obtaining first operation table for there are first operation tables in the database
Metadata initial version number and metadata latest edition number；The metadata latest edition number is that first operation table is corresponding
The version number generated after service data updating；
Determining module, for newest according to the metadata initial version number metadata corresponding with first operation table
Version number determines the second operation table；
Operation module, for executing corresponding operation in second operation table according to the MRP operation.
The third aspect, a kind of computer equipment, including memory and processor, the memory are stored with computer journey
Sequence, the processor perform the steps of when executing the computer program
In material demand plan MRP operation starting, the first operation table being in idle condition is inquired from database；
If there are first operation tables in the database, the metadata initial version of first operation table is obtained
Number and metadata latest edition number；The metadata latest edition number is after the corresponding service data updating of first operation table
The version number of generation；
According to the metadata initial version number metadata latest edition number corresponding with first operation table, is determined
Two operation tables；
Corresponding operation is executed in second operation table according to the MRP operation.
Fourth aspect, a kind of computer readable storage medium are stored thereon with computer program, the computer program quilt
Processor performs the steps of when executing
In material demand plan MRP operation starting, the first operation table being in idle condition is inquired from database；
If there are first operation tables in the database, the metadata initial version of first operation table is obtained
Number and metadata latest edition number；The metadata latest edition number is after the corresponding service data updating of first operation table
The version number of generation；
According to the metadata initial version number metadata latest edition number corresponding with first operation table, is determined
Two operation tables；
Corresponding operation is executed in second operation table according to the MRP operation.
Processing method, device, computer equipment and the storage medium for the operation table that the application proposes, comprising: terminal device
In material demand plan MRP operation starting, the first operation table being in idle condition is inquired from database；If in database
There are the first operation tables, then metadata initial version number and the corresponding metadata of the first operation table for obtaining the first operation table are newest
Version number；According to metadata initial version number and the corresponding metadata latest edition number of the first operation table, the second operation table is determined；
Corresponding operation is executed in the second operation table according to MRP operation.The above-mentioned treatment process for operation table, terminal device pass through
The corresponding metadata initial version number of the first operation table and metadata latest edition number for obtaining idle state, determine the second operation
Table finally executes corresponding operation in second operation table.Compared to traditional treatment process for operation table: terminal is set
It is standby when each MRP operation starts and terminates, require to create and delete a whole set of MRP operation table, the operation that the application proposes
The processing method of table is to determine the second operation table according to metadata initial version number and metadata latest edition number, and therefore, this
Two operation tables can reuse, and when not needing to start MRP operation every time, all establish a whole set of MRP operation table, and without every
MRP operation table is deleted when secondary end MRP operation.So the system resource that the processing method for the operation table that the application proposes occupies
It is less, and the time consumed is less, it is particularly evident especially in the environment of big data quantity and high concurrent.
Detailed description of the invention
Fig. 1 is the internal structure chart of terminal device in one embodiment；
Fig. 2 is a kind of flow chart of the processing method for operation table that one embodiment provides；
Fig. 3 is the flow chart of the implementation of S103 in Fig. 2 embodiment；
A kind of flow chart of the processing method for operation table that Fig. 4 one embodiment provides；
A kind of flow chart of the processing method for operation table that Fig. 5 one embodiment provides；
A kind of flow chart of the processing method for operation table that Fig. 6 one embodiment provides；
A kind of flow chart of the processing method for operation table that Fig. 7 one embodiment provides；
Fig. 8 is the schematic diagram of the processing unit for the operation table that one embodiment provides；
Fig. 9 is the schematic diagram of the processing unit for the operation table that one embodiment provides；
Figure 10 is the schematic diagram of the processing unit for the operation table that one embodiment provides；
Figure 11 is the schematic diagram of the processing unit for the operation table that one embodiment provides；
Figure 12 is the schematic diagram of the processing unit for the operation table that one embodiment provides.
Specific embodiment
It is with reference to the accompanying drawings and embodiments, right in order to which the objects, technical solutions and advantages of the application are more clearly understood
The application is further elaborated.It should be appreciated that specific embodiment described herein is only to explain the application, and do not have to
In restriction the application.
A kind of processing method of operation table provided by the embodiments of the present application is applicable in terminal device as shown in Figure 1.
The terminal device includes processor, memory, network interface, display screen and the input unit connected by system bus.Wherein,
The processor of the terminal device is for providing calculating and control ability.The memory of the terminal device includes that non-volatile memories are situated between
Matter, built-in storage.The non-volatile memory medium is stored with operating system and computer program.The built-in storage is non-volatile
The operation of operating system and computer program in storage medium provides environment.The network interface of the terminal device is used for and outside
Terminal by network connection communication.A kind of processing method of operation table is realized when the computer program is executed by processor.
The display screen of the terminal device can be liquid crystal display or electric ink display screen, and the input unit of the terminal device can be with
It is the touch layer covered on display screen, is also possible to the key being arranged on terminal device shell, trace ball or Trackpad, it can be with
It is external keyboard, Trackpad or mouse etc..This application involves to terminal device can be, but not limited to be various individual calculus
Machine, laptop, smart phone, tablet computer and portable wearable device etc., the application is without limitation.
It will be understood by those skilled in the art that structure shown in Fig. 1, only part relevant to application scheme is tied
The block diagram of structure, does not constitute the restriction for the terminal device being applied thereon to application scheme, and specific terminal device can be with
Including than more or fewer components as shown in the figure, perhaps combining certain components or with different component layouts.
Technical solution of the present invention is described in detail with specifically embodiment below.These specific implementations below
Example can be combined with each other, and the same or similar concept or process may be repeated no more in certain embodiments.
Fig. 2 is a kind of flow chart of the processing method for operation table that one embodiment provides.What is involved is ends for the present embodiment
End equipment is when executing MRP operation to the treatment process of operation table.The executing subject of this method is terminal device, and in the terminal
The application program of MRP operation, MRP service and MRP table management service is installed in equipment.As shown in Fig. 2, this method packet
Include following steps:
S101, material demand plan MRP operation starting when, the first operation being in idle condition is inquired from database
Table.
Wherein, material demand plan MRP operation is a kind of for formulating various such as production plan lists according to customer demand
According to a series of operations of, and enterprise production relevant documents with management of material procurement document, marketing plan document etc..First fortune
Calculation table is for storing required various businesses information in MRP calculating process, or intermediate data, the operation knot of various MRP operations
Fruit etc..For example, the first operation table can be MRP operational parameter table, demand document information table, supply document information table, exception letter
Cease at least one of table, net demand information table, MRP result table etc. operation table.First operation table of the idle state refers to
First operation table is used currently without by any one MRP operation, and first operation table can be the table of a blank,
So that correlation MRP operational data is written into the table for terminal device；Optionally, which is also possible to one and includes
There are material information and the table with pre- space, so that terminal device reads from table or be written the number of MRP operation needs
According to.
Optionally, when the MRP operation starting in terminal device, terminal device can be from multiple fortune present in database
Whether have first operation table that is in idle condition, specifically can putting in order according to each operation table address if being inquired in calculation table
Each operation table is inquired, first operation table being in idle condition is found；It optionally, can also be according to the table name of each operation table
Each operation table is inquired, first operation table being in idle condition is found；It optionally, can also be according to other default rules
Each operation table is inquired, first operation table being in idle condition is found.
If there are the first operation tables in S102, database, the metadata initial version number and member of the first operation table are obtained
Data latest edition number；Metadata latest edition number is the version number that generates after the corresponding service data updating of the first operation table.
Wherein, terminal device can all generate a version number, work as business datum when being updated every time to business datum
When being newest business datum, then the version number that the newest business datum generates just is metadata latest edition number.Therefore, exist
In the present embodiment, metadata latest edition number is just to generate after user modifies to corresponding business datum by terminal device
Version number.
It should be noted that the metadata initial version number or the corresponding metadata of the first operation table of the first operation table
Latest edition number is all to be handled by terminal device to corresponding business datum, to generate corresponding first operation table
A kind of mark generated in the process.The mark can be indicated with sequence number, can also be shown with combination alphabet.
It is not used by any one MRP operation when, there are the first operation table, being equivalent to exist in database in database
The first operation table when, terminal device obtains the corresponding metadata initial version number of first operation table and metadata is newest
Version number.Terminal device can know that first operation table is corresponding with metadata latest edition number according to metadata initial version number
Business datum whether be updated, if the corresponding business datum of the first operation table is not updated, metadata is initial
Version number can be equal to metadata latest edition number, if the corresponding business datum of the first operation table is updated, first number
It is two different version numbers according to initial version number and metadata latest edition number.
S103, according to metadata initial version number and the corresponding metadata latest edition number of the first operation table, determine second
Operation table.
In the present embodiment, when terminal device one MRP operation of starting, and the first operation table is got from database, and
When first operation table is not updated before starting the MRP by terminal device always, terminal device can be according to the first fortune
It calculates the corresponding metadata initial version number of table and determines the second operation table；Optionally, when terminal device one MRP operation of starting, and
Get the first operation table from database, but first operation table by terminal device before starting this MRP operation
Updated, then terminal device can determine the second operation table according to the corresponding metadata latest edition number of the first operation table.
S104, corresponding operation is executed in the second operation table according to MRP operation.
After terminal device has determined the second operation table, the table name of available second operation table makes MRP operation can be with
The address of the second corresponding operation table in the database is found according to the table name, then, MRP operation can be according to the ground
Location carries out corresponding operation in the second operation table, which, which can specifically include, reads data manipulation, data writing operation, deletes number
According to data manipulations such as operations.
In above-described embodiment, for terminal device when material demand plan MRP operation starts, inquiry is in sky from database
First operation table of not busy state；If there are the first operation tables in database, the metadata initial version of the first operation table is obtained
Number and the corresponding metadata latest edition number of the first operation table；According to metadata initial version number and the corresponding member of the first operation table
Data latest edition number determines the second operation table；Corresponding operation is executed in the second operation table according to MRP operation.Compared to
Terminal device is required to create and be deleted when each MRP operation starts and terminates in traditional treatment process for operation table
Except a whole set of MRP operation table, the processing method for the operation table that the application proposes is corresponding according to the first operation table of idle state
Metadata initial version number and metadata latest edition number determine the second operation table, therefore, which can repeat
Utilize, when not needing to start MRP operation every time, all establish a whole set of MRP operation table, and without it is each terminate MRP operation when
Delete MRP operation table.So the application propose operation table processing method occupy system resource it is less, and consume when
Between it is less, it is particularly evident especially in big data quantity and in the environment of high concurrent.
In the application scenarios that terminal device starts multiple MRP operations, in order to avoid a MRP operation is to an operation
When table carries out corresponding operating, corresponding operating is also executed to the operation table by another MRP operation, and bring data manipulation is rushed
It is prominent.The operation table got to terminal device is now needed to be arranged as follows.
On the basis of the above embodiments, optionally, terminal device is after determining the second operation table, by the second operation table
Status be labeled as busy condition.When terminal device has determined the second operation table that MRP operation needs, and prepare to this
When two operation tables execute corresponding operation, terminal device can be first by the mark of the idle state set originally in second operation table
The mark for being revised as busy condition is known, to avoid other MRP operations use.
Optionally, after MRP operation executes corresponding operation in the second operation table, further includes: will be in the second operation table
Status indication be idle state.
Wherein, status indication is a kind of mark of the second operation table of characterization status in the database, which can be with
It is divided into the mark of idle state and the mark of busy condition.When the second operation table is by a MRP operation in use, terminal is set
The standby mark that status indication in second operation table can be set as busy condition, to avoid other MRP operations to second fortune
Calculation table executes corresponding operation and generates operation conflict；When the second operation table not by any one MRP operation in use, terminal
Equipment can be set as the status indication in the second operation table the mark of idle state, in this case, any one MRP fortune
Corresponding operation can be executed to second operation table by calculating.
In the present embodiment, when a MRP operation complete once to the reading data manipulation of the second operation table or write data behaviour
After work, need for the mark of the busy condition set to be revised as the mark of idle state, release second originally in the second operation table
The resource of operation table, so that terminal device can be used when carrying out MRP operation next time.
Fig. 3 is the flow chart of the implementation of S103 in Fig. 2 embodiment.What is involved is terminal devices to determine for the embodiment
The detailed process of two operation tables.On the basis of the above embodiments, as shown in figure 3, above-mentioned S103 is " according to metadata initial version
Number and the corresponding metadata latest edition number of the first operation table, determine the second operation table " may include steps of:
S201, metadata initial version number and metadata latest edition number are compared, obtain comparison result.
Wherein, it is consistent with metadata latest edition number to can be metadata initial version number for comparison result, is also possible to member
Data initial version number and metadata latest edition number are inconsistent.
Before terminal device starts a MRP operation, the initial version of the metadata of the first operation table present in database
This number when not being updated, metadata initial version number will be consistent with metadata latest edition number, correspondingly, when terminal is set
Before one MRP operation of standby starting, user according to actual needs, by modifying original business datum on the terminal device, or
Metadata initial version number and metadata latest edition when person is one new business datum of input, in the database of terminal device
This number will be inconsistent.
S202, according to comparison result, determine the second operation table.
Comparison result is different, it is determined that the method for the second operation table is different, as shown in figure 4, the second operation table is specific true
It is as follows to determine process:
If S301, comparison result are that metadata initial version number is consistent with metadata latest edition number, by the first operation
Table is determined as the second operation table.
The corresponding metadata initial version number of the first operation table present in the database and metadata latest edition number one
When cause, it is equivalent to the corresponding business datum of metadata initial version number present in database, the industry just needed for active user
When data of being engaged in, terminal device can be directly using the first operation of the corresponding business datum foundation of the metadata initial version number
Table, i.e., by first operation table directly as the second operation table, for MRP operation use.
If S302, comparison result are that metadata initial version number and metadata latest edition number are inconsistent, according to first number
The second operation table is created according to the corresponding business datum of latest edition number.
When the metadata initial version number present in the database and metadata latest edition number are inconsistent, it is equivalent to
Before MRP operation starting, user requires to increase other business datum, or the original business datum of modification, terminal device according to
The business datum newly increased, or the business datum of modification generate metadata latest edition number, then the metadata latest edition number
Will be not identical as metadata initial version number present in database, in such cases, terminal device will be according to metadata
The corresponding newest business datum of latest edition number creates the second operation table, obtains the operation table that can satisfy user demand, for
MRP operation uses.
Optionally, if comparison result is that metadata initial version number and metadata latest edition number are inconsistent, the is deleted
One operation table, and save the second operation table of creation.
After terminal device creates the second operation table according to metadata latest edition number, so that it may by the first operation table from
It is directly deleted in database, and the second operation table is saved on appropriate address in the database, for MRP operation use.
Optionally, the second operation table of creation can also directly be substituted to unborn first operation table, and saved in the database
Original address on.
In above-described embodiment, metadata initial version number and metadata latest edition number are compared by terminal device, are obtained
To comparison result；The second operation table is determined further according to comparison result.During second operation table of determination, terminal device is not
When needing to restart MRP operation, the second operation table is directly created, but according to comparison result, selective goes the second fortune of creation
Table is calculated, therefore, the method for the second operation table of determination that the present embodiment proposes, the system resource of occupancy is less, and elapsed time is few,
Terminal device further is improved to the treatment effeciency of the second operation table, and then reduces the time of terminal device MRP operation.
Above-described embodiment is all based on terminal device in inquiry whether there is or not when the first operation table of idle state, deposits in database
In the application scenarios for the first operation table being in idle condition, there is also another situations in practical applications: working as terminal device
In inquiry whether there is or not when the first operation table of idle state, there is no the first operation tables being in idle condition in database.Herein
In the case of kind, as shown in figure 5, the processing method for the operation table that the application proposes further include:
If the first operation table is not present in S401, database, according to the corresponding business datum of metadata latest edition number
Create third operation table.
When terminal device starts MRP operation, there is no the first operation table being in idle condition is inquired from database
When, need to obtain the corresponding metadata latest edition number of the first operation table from database, it is then newest further according to the metadata
The corresponding business datum of version number creates third operation table, so as to MRP operation use.
S402, corresponding operation is executed in third operation table according to MRP operation.
The step is identical as content described in the step S104 in above-described embodiment, and particular content can refer to S104,
This does not do repeated explanation.
In above-described embodiment, terminal device is when inquiring the first operation table, if the first operation table is not present in database,
Third operation table is created according to the corresponding business datum of metadata latest edition number；It is held in third operation table according to MRP operation
Row corresponding operation.In the process, when the first operation is not present in database, terminal device ability dynamic creation third operation
Table, for MRP operation use, this method is required to the operation of creation operation table compared to traditional each MRP operation, reduces
The expense of resource saves MRP operation time, further improves MRP arithmetic speed.
In a kind of application scenarios: including that client, MRP computational service, MRP operation table service are answered in terminal device
With program, and the data interaction between these three application programs pass through is realized to operation table described in above-described embodiment
MRP operation is completed in processing.As shown in fig. 6, the treatment process of the operation table are as follows: user is sent out by client to MRP computational service
Play a MRP operational order, it is desirable that MRP computational service starts a MRP operation, and returns to the operation result of MRP operation；MRP
When computational service receives the operational order, to the first operation table required for the MRP operation of MRP operation table service request, MRP
When operation table service receives this application, inquiry is obtained with the presence or absence of the first operation table being in idle condition from database
The metadata version number and metadata latest edition number of first operation table, further according to the metadata version number and member of the first operation table
Data latest edition number determines target operation table, and is busy by the status indication in the target operation table, and by the target
The table name of operation table returns to MRP computational service.It, can be according to target when MRP computational service obtains the table name of target operation table
The table name of operation table executes corresponding operation in target operation table, and after having executed corresponding operation, takes to MRP operation table
Business sends operation end notification information, and notice MRP operation table service saves the target operation table after operation, and by the target
Status indication in operation table is the free time, so that MRP operation next time uses.It, can after MRP computational service has executed MRP operation
To obtain the operation result of this MRP operation, and the operation result is returned into client, so that user can pass through client
Obtain the result of the secondary MRP operation.
The specific determination process for the target operation table being related in the above process, referring to Fig. 7, this method may include following
Step:
With the presence or absence of the first operation table being in idle condition in S501, inquiry database, if so, S502 is executed, if
It is no, then execute S506.
S502, the metadata initial version number and metadata latest edition number for obtaining first operation table.
S503, metadata initial version number and metadata latest edition number are compared, if metadata initial version number
It is consistent with metadata latest edition number, then execute S504；If metadata initial version number and metadata latest edition number are inconsistent,
Then execute S505.
S504, using the first operation table as the second operation table, and simultaneously by the table name of second operation table return to MRP fortune
Calculate service, and by the status indication in second operation table be it is busy.
S505, the second operation table is created according to metadata latest edition number, and delete the first operation table, by second operation
Status indication in table is busy, and the table name of second operation table is returned to MRP computational service.In the present embodiment,
Second operation table is the target operation table in Fig. 6.
S506, metadata latest edition number is obtained from database, create third further according to the metadata latest edition number
Operation table, and be busy by the status indication in the third operation table, and return to the third operation table to MRP computational service
Table name.In the present embodiment, third operation table is the target operation table in Fig. 6.
It should be understood that although each step in the flow chart of Fig. 2-Fig. 5 is successively shown according to the instruction of arrow,
It is these steps is not that the inevitable sequence according to arrow instruction successively executes.Unless expressly stating otherwise herein, these steps
There is no stringent sequences to limit for rapid execution, these steps can execute in other order.Moreover, in Fig. 2-Fig. 5 extremely
Few a part of step may include that perhaps these sub-steps of multiple stages or stage are not necessarily same to multiple sub-steps
Moment executes completion, but can execute at different times, and the execution sequence in these sub-steps or stage is also not necessarily
Successively carry out.
Fig. 8 is the processing unit schematic diagram for the operation table that one embodiment provides, as shown in figure 8, described device includes: to look into
It askes module 11, obtain module 12, determining module 13 and operation module 14, in which:
Enquiry module 11, for inquiring and being in idle condition from database in material demand plan MRP operation starting
The first operation table；
Module 12 is obtained, if obtaining first operation table for there are first operation tables in the database
Metadata initial version number and metadata latest edition number；The metadata latest edition number is corresponding for first operation table
Service data updating after the version number that generates；
Determining module 13 is used for according to the metadata initial version number metadata corresponding with first operation table most
New version number determines the second operation table；
First operation module 14, for executing corresponding operation in second operation table according to the MRP operation.
In one embodiment, as shown in figure 9, on the basis of the processing unit of operation table described in Fig. 8, the determining mould
Block 13, comprising:
Comparing unit 131, for the metadata initial version number and the metadata latest edition number to be compared,
Obtain comparison result；
Determination unit 132, for determining second operation table according to the comparison result.
In one embodiment, if it is that the metadata is initial that the determination unit 132, which is specifically used for the comparison result,
Version number is consistent with the metadata latest edition number, then first operation table is determined as second operation table；If institute
Stating comparison result is that the metadata initial version number and the metadata latest edition number are inconsistent, then according to the metadata
The corresponding business datum of latest edition number creates second operation table.
In one embodiment, as shown in Figure 10, on the basis of the processing unit of the operation table described in Fig. 8, the determination
Module 13, further includes:
Storage unit 133 is deleted, for deleting first operation table, and saves the second operation table of creation.
In one embodiment, as shown in figure 11, on the basis of the processing unit of the operation table described in Fig. 8, the operation
The processing unit of table further include:
Creation module 15, if for first operation table to be not present in the database, most according to the metadata
The corresponding business datum of new version number creates third operation table；
Second operation module 16, for executing corresponding operation in the third operation table according to the MRP operation.
In one embodiment, as shown in figure 12, on the basis of the processing unit of the operation table described in Fig. 8, the operation
The processing unit of table further include:
Setting flag module 17, for being idle state by the status indication in second operation table.
In one embodiment, a kind of computer equipment, including memory and processor are provided, is stored in memory
Computer program, the processor perform the steps of when executing computer program
In material demand plan MRP operation starting, the first operation table being in idle condition is inquired from database；
If there are first operation tables in the database, the metadata initial version of first operation table is obtained
Number and metadata latest edition number；The metadata latest edition number is after the corresponding service data updating of first operation table
The version number of generation；
According to the metadata initial version number metadata latest edition number corresponding with first operation table, is determined
Two operation tables；
Corresponding operation is executed in second operation table according to the MRP operation.
In one embodiment, it is also performed the steps of when processor executes computer program the metadata is initial
Version number and the metadata latest edition number are compared, and obtain comparison result；According to the comparison result, described is determined
Two operation tables.
In one embodiment, it is if processor also performs the steps of the comparison result when executing computer program
The metadata initial version number is consistent with the metadata latest edition number, then first operation table is determined as described
Two operation tables；If the comparison result is that the metadata initial version number and the metadata latest edition number are inconsistent,
Second operation table is created according to the corresponding business datum of the metadata latest edition number.
In one embodiment, it is also realized when processor executes computer program: deleting first operation table, and save
Second operation table of creation.
In one embodiment, if processor also performs the steps of in the database not when executing computer program
There are first operation tables, then create third operation table according to the corresponding business datum of the metadata latest edition number；Root
Corresponding operation is executed in the third operation table according to the MRP operation.
In one embodiment, it is also realized when processor executes computer program: by the locating shape of second operation table
State is labeled as busy condition.
In one embodiment, it is also realized when processor executes computer program: by the state in second operation table
Labeled as idle state.
In one embodiment, a kind of computer readable storage medium is provided, computer program is stored thereon with, is calculated
Machine program also performs the steps of when being executed by processor
In material demand plan MRP operation starting, the first operation table being in idle condition is inquired from database；
If there are first operation tables in the database, the metadata initial version of first operation table is obtained
Number and metadata latest edition number；The metadata latest edition number is after the corresponding service data updating of first operation table
The version number of generation；
According to the metadata initial version number metadata latest edition number corresponding with first operation table, is determined
Two operation tables；
Corresponding operation is executed in second operation table according to the MRP operation.
In one embodiment, also performing the steps of when computer program is executed by processor will be at the beginning of the metadata
Beginning version number and the metadata latest edition number be compared, obtain comparison result；According to the comparison result, determine described in
Second operation table.
In one embodiment, if also performing the steps of the comparison result when computer program is executed by processor
It is consistent with the metadata latest edition number for the metadata initial version number, then first operation table is determined as described
Second operation table；If the comparison result is that the metadata initial version number and the metadata latest edition number are inconsistent,
Second operation table is then created according to the corresponding business datum of the metadata latest edition number.
In one embodiment, it is also realized when computer program is executed by processor: deleting first operation table, and protect
Deposit the second operation table of creation.
In one embodiment, if also being performed the steps of in the database when computer program is executed by processor
There is no first operation tables, then create third operation table according to the corresponding business datum of the metadata latest edition number；
Corresponding operation is executed in the third operation table according to the MRP operation.
In one embodiment, it is also realized when computer program is executed by processor: will be locating for second operation table
Status indication is busy condition.
In one embodiment, it is also realized when computer program is executed by processor: by the shape in second operation table
State is labeled as idle state.
Those of ordinary skill in the art will appreciate that realizing all or part of the process in above-described embodiment method, being can be with
Relevant hardware is instructed to complete by computer program, the computer program can be stored in a non-volatile computer
In read/write memory medium, the computer program is when being executed, it may include such as the process of the embodiment of above-mentioned each method.Wherein,
To any reference of memory, storage, database or other media used in each embodiment provided herein,
Including non-volatile and/or volatile memory.Nonvolatile memory may include read-only memory (ROM), programming ROM
(PROM), electrically programmable ROM (EPROM), electrically erasable ROM (EEPROM) or flash memory.Volatile memory may include
Random access memory (RAM) or external cache.By way of illustration and not limitation, RAM is available in many forms,
Such as static state RAM (SRAM), dynamic ram (DRAM), synchronous dram (SDRAM), double data rate SDRAM (DDRSDRAM), increase
Strong type SDRAM (ESDRAM), synchronization link (Synchlink) DRAM (SLDRAM), memory bus (Rambus) direct RAM
(RDRAM), direct memory bus dynamic ram (DRDRAM) and memory bus dynamic ram (RDRAM) etc..
Each technical characteristic of above embodiments can be combined arbitrarily, for simplicity of description, not to above-described embodiment
In each technical characteristic it is all possible combination be all described, as long as however, the combination of these technical characteristics be not present lance
Shield all should be considered as described in this specification.
The embodiments described above only express several embodiments of the present invention, and the description thereof is more specific and detailed, but simultaneously
It cannot therefore be construed as limiting the scope of the patent.It should be pointed out that coming for those of ordinary skill in the art
It says, without departing from the inventive concept of the premise, various modifications and improvements can be made, these belong to protection of the invention
Range.Therefore, the scope of protection of the patent of the invention shall be subject to the appended claims.
Claims (10)
1. a kind of processing method of operation table characterized by comprising
In material demand plan MRP operation starting, the first operation table being in idle condition is inquired from database；
If there are first operation table in the database, obtain first operation table metadata initial version number and
Metadata latest edition number；The metadata latest edition number be the corresponding service data updating of first operation table after generate
Version number；
According to the metadata initial version number metadata latest edition number corresponding with first operation table, the second fortune is determined
Calculate table；
Corresponding operation is executed in second operation table according to the MRP operation.
2. the method according to claim 1, wherein described according to the metadata initial version number and described the
The corresponding metadata latest edition number of one operation table, determines the second operation table, comprising:
The metadata initial version number and the metadata latest edition number are compared, comparison result is obtained；
According to the comparison result, second operation table is determined.
3. according to the method described in claim 2, determining second fortune it is characterized in that, described according to the comparison result
Calculate table, comprising:
If the comparison result is that the metadata initial version number is consistent with the metadata latest edition number, by described the
One operation table is determined as second operation table；
If the comparison result is that the metadata initial version number and the metadata latest edition number are inconsistent, according to institute
It states the corresponding business datum of metadata latest edition number and creates second operation table.
4. if according to the method described in claim 3, it is characterized in that, the comparison result is the initial version of the metadata
This number is inconsistent with the metadata latest edition number, the method also includes:
First operation table is deleted, and saves the second operation table of creation.
5. method described in -4 according to claim 1, which is characterized in that the method also includes:
If first operation table is not present in the database, according to the corresponding business number of the metadata latest edition number
According to creation third operation table；
Corresponding operation is executed in the third operation table according to the MRP operation.
6. the method according to claim 1, wherein the method also includes:
The status of second operation table is labeled as busy condition.
7. according to the method described in claim 6, it is characterized in that, it is described according to the MRP operation in second operation table
After middle execution corresponding operation, comprising:
It is idle state by the status indication in second operation table.
8. a kind of processing unit of operation table, which is characterized in that described device includes:
Enquiry module, for inquiring first be in idle condition from database in material demand plan MRP operation starting
Operation table；
Module is obtained, if obtaining first number of first operation table for there are first operation tables in the database
According to initial version number and metadata latest edition number；The metadata latest edition number is the corresponding business of first operation table
The version number that data generate after updating；
Determining module, for according to the metadata initial version number metadata latest edition corresponding with first operation table
Number, determine the second operation table；
Operation module, for executing corresponding operation in second operation table according to the MRP operation.
9. a kind of computer equipment, including memory and processor, the memory are stored with computer program, feature exists
In the step of processor realizes any one of claims 1 to 7 the method when executing the computer program.
10. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that the computer program
The step of any one of claims 1 to 7 the method is realized when being executed by processor.
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 true CN109857759A (en) | 2019-06-07 |
| CN109857759B 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) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111105249A (en) * | 2019-12-09 | 2020-05-05 | 金蝶软件（中国）有限公司 | Supply chain data tracing method and device, and computer equipment |
Citations (5)
| 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 |
| US20090307026A1 (en) * | 2008-06-10 | 2009-12-10 | International Business Machines Corporation | Priority-based system for netting available coverage |
| 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 |
-
2018
- 2018-11-06 CN CN201811313360.1A patent/CN109857759B/en active Active
Patent Citations (5)
| 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 |
| 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 |
|---|
| 宋立涛: "中小制造企业计划管理和生产查询设计与实现", 《中国优秀硕士学位论文全文数据库信息科技辑》 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111105249A (en) * | 2019-12-09 | 2020-05-05 | 金蝶软件（中国）有限公司 | Supply chain data tracing method and device, and computer equipment |
| CN111105249B (en) * | 2019-12-09 | 2024-02-20 | 金蝶软件（中国）有限公司 | Supply chain data tracing method and device and computer equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109857759B (en) | 2021-06-15 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111191221B (en) | Configuration method and device of authority resources and computer readable storage medium | |
| CN111061475B (en) | Software code generating method, device, computer equipment and storage medium | |
| CN109358874B (en) | Business rule updating method, business rule updating device, computer equipment and storage medium | |
| CN111596911B (en) | Method, device, computer equipment and storage medium for generating control | |
| CN110597552B (en) | Configuration method, device, equipment and storage medium of project continuous integrated pipeline | |
| CN111241791A (en) | Editing method and device of webpage text, computer equipment and storage medium | |
| CN108418797A (en) | Web access method, device, computer equipment and storage medium | |
| CN115858213A (en) | Task scheduling checking method and device, computer equipment and storage medium | |
| CN111090701B (en) | Service request processing method, device, readable storage medium and computer equipment | |
| CN109857759A (en) | Processing method, device, computer equipment and the storage medium of concurrent data | |
| CN109213785A (en) | Bill compilation method, apparatus, computer equipment and storage medium | |
| CN114020278B (en) | Data processing method, device, equipment and storage medium | |
| Inayatullah et al. | Model-based scaffolding code generation for cross-platform applications | |
| CN113901057A (en) | Data playback method and device, computer equipment and storage medium | |
| CN106921524B (en) | Method and device for configuring command line tag | |
| CN111931010B (en) | Dynamic binding method, device, equipment and storage medium for anchor point and line | |
| CN114896335B (en) | Data dumping method and system of database | |
| US20080320447A1 (en) | Method of accessing web parameters | |
| US20240152387A1 (en) | Method, apparatus, electronic device and storage medium for application launch | |
| CN114528045B (en) | Plug-in operation method, device, computer equipment and storage medium | |
| CN116860244A (en) | Component arrangement method, device, computer equipment and storage medium | |
| CN107861997B (en) | ERP database recording method and device, computer equipment and storage medium | |
| CN114661478A (en) | File scanning method and system of electronic equipment, electronic equipment and storage medium | |
| CN118245160A (en) | Tab label updating method, device, computer equipment and storage medium | |
| CN116225426A (en) | Method and device for calling reusable module, computer equipment and storage medium |
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 |