Systems and methods for product production management, servers and storage media

Patent metadata

Field	Value
Publication number	US-12423634-B2
Application number	US-202117764833-A
Country	US
Kind code	B2
Filing date	May 28, 2021
Priority date	May 28, 2021
Publication date	Sep 23, 2025
Grant date	Sep 23, 2025

Abstract

A system and a method for product production management, a server and a storage medium are disclosed. The system includes: a production configuration module, configured to select a plurality of process nodes according to a user's selection operations, establish a connection relationship of the plurality of process nodes according to the user's connection operations, and obtain and display configuration data of a production process flow; a data acquisition module, configured to acquire product data in the production process flow and output the product data to a data storage module; and the data storage module, configured to store 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.

First claim

The invention claimed is:

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 histor

Assignees

• Beijing Zhongxiangying Tech Co Ltd
• Boe Technology Group Co Ltd

Inventors

• Yang Haodong
• Han Yongliang
• Zhang Jiankun
• Shao Guangyu
• Li Wenjuan
• Wang Hong

Classifications

• G06F16/213

  with details for schema evolution support · CPC title

• G06F16/2379

  Updates performed during online database operations; commit processing · CPC title

• G06F16/245

  Query processing · CPC title

• G06Q10/06

  Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling · CPC title

• G06Q10/00

  Administration; Management · CPC title