Systems and Methods for Product Production Management, Servers and Storage Media

1. A method for product production management, applied to an electronic device, comprising: selecting, by a processor of the electronic device, a plurality of process nodes according to a user's selection operations and establishing, by the processor, connection relationship of the plurality of process nodes according to the user's connection operations, obtaining and displaying, by the processor, configuration data of a production process flow; acquiring, by the processor, product data corresponding to the plurality of process nodes in the production process flow; storing, by the processor, the product data in a current data table and/or a historical data table according to a preset storage strategy when the product data matches the configuration data; and in response to determining, by the processor, that data amount in a current historical data table stored in a memory exceeds a preset data amount threshold, changing a creation rule for creating a data table to increase a number of the historical data table; and reducing data amount corresponding to a single historical data table.

2. The method according to claim 1, wherein storing the product data in the current data table and/or the historical data table according to the preset storage strategy comprises: acquiring time of the product data; and simultaneously storing the product data in the current data table and the historical data table, and clearing data of a previous storage period in the current data table when a new storage period begins, wherein the current data table and the historical data table are both sized according to a set period, and the set period is greater than the storage period.

3. The method according to claim 1, wherein storing the product data in the current data table and/or the historical data table according to the preset storage strategy comprises: acquiring the product data and storing the product data in the current data table; determining whether production of a product has been completed according to the product data; determining a table name of a historical data table corresponding to product ID data of the product when the production of the product has been completed, wherein the completion of the production of the product means that all production process flows of a single product have been completed and all production process flows for a batch including the single product have been completed; and when set time is reached, storing the product data in the historical data table corresponding to the table name and deleting the product data from the current data table at the same time.

4. The method according to claim 3, wherein determining the table name of the historical data table corresponding to the product ID data of the product comprises: acquiring a first numerical value at a first preset position in the product ID data; converting the first numerical value to a second numerical value; and taking data at a second preset position in the second numerical value as a suffix of the historical data table, so as to obtain the historical data table corresponding to the product ID data.

5. The method according to claim 1, wherein storing the product data in the current data table and/or the historical data table according to the preset storage strategy comprises: reducing a storage period for deleting the product data from the current data table when data amount in a current current data table exceeds a first data amount threshold.

6. The method of claim 1, further comprising: in a product traceability process, querying for product data in the current data table according to product ID data; and querying a corresponding historical data table according to the product ID data and the preset storage strategy when the query fails, so as to obtain a traceability result.

7. The method of claim 1, further comprising: in a process of Working In Process (WIP) query, querying for product data corresponding to product ID data in the current data table.

8. The method of claim 1, further comprising: in a historical query process, querying for product data in the current data table according to query conditions, and returning the found product data; and when the product data is not found, determining a historical data table in which product data is included, querying for the product data in the historical data table according to the query conditions, and returning the found product data.

9. A non-transitory computer readable storage medium, wherein when an executable computer program in the non-transitory computer readable storage medium is executed by a processor of an electronic device, the method for product production management according to claim 1 is realized.

10. A server, comprising: a processor; and a memory configured to store a computer program executable by the processor, wherein the processor is configured to execute the computer program in the memory to perform the following operations: selecting a plurality of process nodes according to a user's selection operations, establishing a connection relationship of the plurality of process nodes according to the user's connection operations, and obtaining and displaying configuration data of a production process flow; acquiring product data corresponding to the plurality of process nodes in the production process flow; storing the product data in a current data table and/or a historical data table according to a preset storage strategy when the product data matches the configuration data; and in response to determining that data amount in a current historical data table stored in a memory exceeds a preset data amount threshold, changing a creation rule for creating a data table to increase a number of the historical data table; and reducing data amount corresponding to a single historical data table.

11. The server according to claim 10, wherein the processor performs storing the product data in the current data table and/or the historical data table according to the preset storage strategy when the product data matches the configuration data comprises: acquiring time of the product data; and simultaneously storing the product data in the current data table and the historical data table, and clearing data of a previous storage period in the current data table when a new storage period begins, wherein the current data table and the historical data table are both sized according to a set period, and the set period is greater than the storage period.

12. The server according to claim 10, wherein the processor performs storing the product data in the current data table and/or the historical data table according to the preset storage strategy when the product data matches the configuration data comprises: acquiring the product data and storing the product data in the current data table; determining whether production of a product has been completed according to the product data; determining a table name of a historical data table corresponding to product ID data of the product when the production of the product has been completed, wherein the completion of the production of the product means that all production process flows of a single product have been completed and all production process flows for a batch including the single product have been completed; and when set time is reached, storing the product data in the historical data table corresponding to the table name and deleting the product data from the current data table at the same time.

13. The server according to claim 12, wherein the processor performs determining the table name of the historical data table corresponding to the product ID data of the product comprises: acquiring a first numerical value at a first preset position in the product ID data; converting the first numerical value to a second numerical value; and taking data at a second preset position in the second numerical value as a suffix of the historical data table, so as to obtain the historical data table corresponding to the product ID data.

14. The server according to claim 10, wherein the processor performs storing the product data in the current data table and/or the historical data table according to the preset storage strategy when the product data matches the configuration data comprises: reducing a storage period for deleting the product data from the current data table when data amount in a current current data table exceeds a first data amount threshold.

15. The server according to claim 10, wherein the processor is configured to execute the computer program to further perform: in a product traceability process, querying for product data in the current data table according to product ID data; and querying a corresponding historical data table according to the product ID data and the preset storage strategy when the query fails, so as to obtain a traceability result.

16. The server according to claim 10, wherein the processor is configured to execute the computer program to further perform: in a process of Working In Process (WIP) query, querying for product data corresponding to product ID data in the current data table.

17. The server according to claim 10, wherein the processor is configured to execute the computer program to further perform: in a historical query process, querying for product data in the current data table according to query conditions, and returning the found product data; and when the product data is not found, determining a historical data table in which product data is included, querying for the product data in the historical data table according to the query conditions, and returning the found product data.