Method and system for improving production line data uploading efficiency
By deploying the MES system sites in the cloud and using message queues and multi-consumer services to process data, the problem of high data access and maintenance costs in traditional MES systems is solved, real-time upload of production line data and multi-factory data interoperability are realized. Improves data upload efficiency and system flexibility.
Patent Information
- Application Number
- CN202411278162.1
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-09-12
- Publication Date
- 2024-12-06
AI Technical Summary
In traditional MES systems, production data can only be accessed within the local area network, and the latest production status cannot be obtained in real time. Site updates require engineers to maintain on-site, which increases costs and cannot meet the interoperability of multi-factory data.
Deploy the site in the cloud, use message queues and multi-consumer services to process data, store test data in a cloud database, and realize real-time upload and statistics of data through cloud interface services and message queues.
Real-time production line data and multi-factory data interoperability are realized, maintenance costs are reduced, data upload efficiency is improved, and data interoperability and real-time access are supported in different factories.
Smart Images

Figure CN119094568A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of software technology, and in particular to a method and system for improving the efficiency of uploading production line data. Background Art
[0002] In traditional MES systems, in order to achieve data statistics, station pass card control and other functions, limited by factory network conditions and system security considerations, a LAN site is deployed in the factory and the test data is stored in the LAN server. This solution has the following problems:
[0003] 1) Production data can only be accessed on computers connected to the local area network, and customers cannot obtain the latest production status in real time.
[0004] 2) Site updates need to be performed in the local area network, requiring engineers to go on-site, which increases the cost of service updates.
[0005] 3) It is not possible to use the same system in multiple factories and exchange data. That is, the test data produced in Factory A cannot be imported and used in Factory B, so Factory B needs to add additional workstations to randomly test the products produced in Factory A. Summary of the invention
[0006] In view of this, the purpose of the present invention is to provide a method and system for improving the efficiency of uploading production line data, deploying the site in the cloud, using message queues and multi-consumer services to efficiently process data, storing test data in a cloud database, and accessing it from the cloud database when the test data is needed, which can meet the requirements of real-time and data interoperability between different factories.
[0007] In a first aspect, an embodiment of the present invention provides a method for improving the efficiency of uploading production line data, the method comprising:
[0008] When the product passes the station test, the host computer reads the product information that has passed the station;
[0009] The host computer calls the cloud process start interface in the cloud interface service according to the in-station product information, and receives the process ID assigned by the cloud interface service;
[0010] If all test steps under the current product process are completed, the host computer will bind the corresponding step data with the process ID, and store the process ID, the step data, the process test results and the end time in the local database;
[0011] The host computer calls the cloud work step upload interface in the cloud interface service, and uploads the work step data stored in the local database to the cloud interface service, so that the cloud interface service sends the work step data to the message queue, and the message queue pushes the work step data to the idle cloud consumer service, and the idle cloud consumer service counts and calculates the work step data and stores them in different tables of the cloud database;
[0012] The host computer calls the cloud process end interface in the cloud interface service, and uploads the process ID, the process test result and the end time to the cloud interface service, so that the cloud interface service sends the process test result to the message queue, and the message queue pushes the process test result to the idle cloud consumer service. The cloud consumer service performs statistics and calculations on the process test results and stores them in different tables of the cloud database.
[0013] Furthermore, if all test steps under the current product process are completed, the host computer will bind the corresponding step data with the process ID, including:
[0014] If the first step of the test is completed, the host computer stores the first step in the local database and binds it to the process ID;
[0015] If the second step of the test is completed, the host computer stores the second step in the local database and binds it to the process ID.
[0016] Further, the host computer calls the cloud work step upload interface in the cloud interface service to upload the work step data stored in the local database to the cloud interface service, so that the cloud interface service sends the work step data to the message queue, and the message queue pushes the work step data to the idle cloud consumer service, and the idle cloud consumer service counts and calculates the work step data and stores it in different tables of the cloud database, including:
[0017] The host computer calls the cloud work step upload interface in the cloud interface service, and uploads the first work step stored in the local database to the cloud interface service, so that the cloud interface service sends the first work step to the message queue and returns the call completion. After the first cloud consumer service registers the consumer service with the message queue, the message queue pushes the first work step to the idle first cloud consumer service. The idle first cloud consumer service counts and calculates the first work step and stores it in different tables of the cloud database.
[0018] Further, the host computer calls the cloud work step upload interface in the cloud interface service to upload the work step data stored in the local database to the cloud interface service, so that the cloud interface service sends the work step data to the message queue, and the message queue pushes the work step data to the idle cloud consumer service, and the idle cloud consumer service counts and calculates the work step data and stores it in different tables of the cloud database, including:
[0019] The host computer calls the cloud work step upload interface in the cloud interface service, and uploads the second work step stored in the local database to the cloud interface service, so that the cloud interface service sends the second work step to the message queue and returns the call completion. After the second cloud consumer service registers the consumer service with the message queue, the message queue pushes the second work step to the idle second cloud consumer service. The idle second cloud consumer service counts and calculates the second work step and stores it in different tables of the cloud database.
[0020] Furthermore, the local database also stores pictures, logs and files during the test process.
[0021] Furthermore, the passed product information includes MAC information, and the work steps are each key test step in the test station.
[0022] In a second aspect, an embodiment of the present invention provides a system for improving the efficiency of uploading production line data, the system comprising:
[0023] The reading module is used for the host computer to read the product information when the product passes the station test;
[0024] A calling module, used for the host computer to call the cloud process start interface in the cloud interface service according to the in-station product information, and receive the process ID assigned by the cloud interface service;
[0025] A binding module, which is used for binding the corresponding step data with the process ID after completing all the test steps under the current product process, and storing the process ID, the step data, the process test result and the end time in the local database;
[0026] A first uploading module is used for the host computer to call the cloud work step upload interface in the cloud interface service to upload the work step data stored in the local database to the cloud interface service, so that the cloud interface service sends the work step data to a message queue, and the message queue pushes the work step data to an idle cloud consumer service, and the idle cloud consumer service performs statistics and calculations on the work step data and stores them in different tables of the cloud database;
[0027] The second uploading module is used for the host computer to call the cloud process end interface in the cloud interface service, and upload the process ID, the process test result and the end time to the cloud interface service, so that the cloud interface service sends the process test result to the message queue, and the message queue pushes the process test result to the idle cloud consumer service. The cloud consumer service performs statistics and calculations on the process test results and stores them in different tables of the cloud database.
[0028] Furthermore, the binding module is specifically used for:
[0029] If the first step of the test is completed, the host computer stores the first step in the local database and binds it to the process ID;
[0030] If the second step of the test is completed, the host computer stores the second step in the local database and binds it to the process ID.
[0031] In a third aspect, an embodiment of the present invention provides an electronic device, including a memory and a processor, wherein the memory stores a computer program executable on the processor, and the processor implements the method described above when executing the computer program.
[0032] In a fourth aspect, an embodiment of the present invention provides a computer-readable medium having a non-volatile program code executable by a processor, wherein the program code enables the processor to execute the method as described above.
[0033] The embodiment of the present invention provides a method and system for improving the efficiency of uploading production line data, including: when a product passes a station test, the host computer reads the passing product information; the host computer calls the cloud process start interface in the cloud interface service according to the passing product information, and receives the process ID assigned by the cloud interface service; if all test steps under the current product process are completed, the host computer binds the corresponding step data to the process ID, and stores the process ID, step data, process test results and end time in the local database; the host computer calls the cloud step upload interface in the cloud interface service, and uploads the step data stored in the local database to the cloud interface service, so that the cloud interface service sends the step data to the message queue, and the message queue pushes the step data to idle cloud consumers The idle cloud consumer service counts and calculates the work step data, and stores them in different tables of the cloud database; the upper computer calls the cloud process end interface in the cloud interface service, and uploads the process ID, process test results and end time to the cloud interface service, so that the cloud interface service sends the process test results to the message queue, and the message queue pushes the process test results to the idle cloud consumer service. The cloud consumer service counts and calculates the process test results, and stores them in different tables of the cloud database; the site is deployed in the cloud, and the message queue and multi-consumer service are used to efficiently process data. The test data is stored in the cloud database. When the test data is needed, it is accessed from the cloud database, which can meet the requirements of real-time and data interoperability between different factories.
[0034] Other features and advantages of the present invention will be described in the following description, and partly become apparent from the description, or understood by practicing the present invention. The purpose and other advantages of the present invention are realized and obtained by the structures particularly pointed out in the description, claims and drawings.
[0035] In order to make the above-mentioned objects, features and advantages of the present invention more obvious and easy to understand, preferred embodiments are given below and described in detail with reference to the accompanying drawings. BRIEF DESCRIPTION OF THE DRAWINGS
[0036] In order to more clearly illustrate the specific implementation methods of the present invention or the technical solutions in the prior art, the drawings required for use in the specific implementation methods or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are some implementation methods of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.
[0037] Figure 1 A flow chart of a method for improving the efficiency of uploading production line data provided in the first embodiment of the present invention;
[0038] Figure 2A signaling diagram of a method for improving production line data upload efficiency provided in Embodiment 1 of the present invention;
[0039] Figure 3 A schematic diagram of a system for improving production line data uploading efficiency provided in Embodiment 2 of the present invention. DETAILED DESCRIPTION
[0040] In order to make the purpose, technical solution and advantages of the embodiments of the present invention clearer, the technical solution of the present invention will be clearly and completely described below in conjunction with the accompanying drawings. Obviously, the described embodiments are part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.
[0041] In order to address the shortcomings of the existing technology and meet production and customer needs, this application adopts the method of deploying the site in the cloud consumer service and storing the test data in the cloud database; when the test data is needed, it is accessed from the cloud database, which can meet the requirements of real-time and data interoperability between different factories.
[0042] To facilitate understanding of this embodiment, the embodiment of the present invention is described in detail below.
[0043] Embodiment 1:
[0044] Figure 1 A flow chart of a method for improving production line data uploading efficiency provided in Example 1 of the present invention.
[0045] Reference Figure 1 , the method comprises the following steps:
[0046] Step S101, when a product passes a station test, the host computer reads the passing product information;
[0047] Here, when the product passes the station test, a serial port line is used to connect the product and the PC, and the host computer reads the passing product information through the serial port protocol, where the passing product information includes MAC information. The passing test refers to all processes in the product production test process.
[0048] Step S102, the host computer calls the cloud process start interface in the cloud interface service according to the in-station product information, and receives the process ID assigned by the cloud interface service; wherein the process ID is used as the unique index of the MAC in the current test record of the current process;
[0049] Step S103: if all test steps under the current product process are completed, the host computer will bind the corresponding step data with the process ID, and store the process ID, step data, process test results and end time in the local database;
[0050] Step S104, the host computer calls the cloud work step upload interface in the cloud interface service, and uploads the work step data stored in the local database to the cloud interface service, so that the cloud interface service sends the work step data to the message queue, and the message queue pushes the work step data to the idle cloud consumer service, and the idle cloud consumer service counts and calculates the work step data and stores them in different tables of the cloud database;
[0051] In step S105, the host computer calls the cloud process end interface in the cloud interface service, and uploads the process ID, process test results and end time to the cloud interface service, so that the cloud interface service sends the process test results to the message queue, and the message queue pushes the process test results to the idle cloud consumer service. The cloud consumer service counts and calculates the process test results and stores them in different tables of the cloud database.
[0052] Here, the cloud interface service sends the process test results to the message queue, and the message queue pushes the process test results to the idle first cloud consumer service. The first cloud consumer service counts and calculates the process test results and stores them in different tables of the cloud database.
[0053] First, the cloud consumer service needs to count the time consumed by the entire process, the number of steps, and the yield rate of the steps; and store them in different tables according to the process test results. For example, good products are stored in the good product table, and defective products are stored in the defective product table, so that other services can count the production data of good and defective products.
[0054] Among them, the process test result is a complete test process of a product at a certain workstation, so it is defined as a process. In each process, there can be many test items, so it is defined as a work step. The process test result here also refers to a complete test process.
[0055] Specifically, in the actual production process, the product test data will be uploaded to the cloud consumer service through the host computer calling the cloud interface service and saved in the cloud database. In this application, in order to record all the data and time consumption in the test process in detail, the following method is used for recording, that is, when the product passes the station test, the cloud process start interface is called to record the start of production of the product in the current process. At each key step in the test station, the cloud step upload interface needs to be called to record the test step and the data generated by the test step, such as files, pictures, etc.; when the test is completed, the cloud process end interface is called.
[0056] In the case of poor factory network conditions, in order to improve the efficiency of data upload to the cloud and save production hours. In this application, firstly, the host computer stores the data in the local database first, and then uploads the local data to the cloud database asynchronously through offline upload; secondly, the message queue technology is used in the cloud, the data is first stored in the message queue, and then the cloud consumer service obtains the data from the message queue, so as to improve the efficiency of cloud data storage.
[0057] Further, step S103 includes the following steps:
[0058] Step S201, if the first step of the test is completed, the host computer stores the first step in the local database and binds it to the process ID;
[0059] Step S202: If the second process step is completed, the host computer stores the second process step in the local database and binds it to the process ID.
[0060] Further, step S104 includes:
[0061] The host computer calls the cloud work step upload interface in the cloud interface service, and uploads the first work step stored in the local database to the cloud interface service, so that the cloud interface service sends the first work step to the message queue and returns the call completion. After the first cloud consumer service registers the consumer service with the message queue, the message queue pushes the first work step to the idle first cloud consumer service. The idle first cloud consumer service counts and calculates the first work step and stores it in different tables of the cloud database.
[0062] Here, the work step uploads are generally test basic data, and the first cloud consumer service will group the test basic data according to data storage needs. For example, it can be divided into work step result data, work step parameter data, and work step file data. If the work step test result is not passed, it will be stored in the defect detail table.
[0063] Furthermore, step S104 further includes:
[0064] The host computer calls the cloud work step upload interface in the cloud interface service, and uploads the second work step stored in the local database to the cloud interface service, so that the cloud interface service sends the second work step to the message queue and returns the call completion. After the second cloud consumer service registers the consumer service with the message queue, the message queue pushes the second work step to the idle second cloud consumer service. The idle second cloud consumer service counts and calculates the second work step and stores it in different tables of the cloud database.
[0065] Here, the statistical and calculation process of the second cloud consumer service is similar to that of the first cloud consumer service, and will not be elaborated here.
[0066] Furthermore, the local database also stores pictures, logs and files during the test process. The work step is each key test step in the test station.
[0067] Figure 2 This is a signaling diagram of a method for improving production line data upload efficiency provided in Example 1 of the present invention.
[0068] Reference Figure 2 , the method comprises the following steps:
[0069] Step S1, when the product passes the station test, use a serial port line to connect the product to the PC, and the host computer reads the product MAC information through the serial port protocol;
[0070] Step S2, calling the cloud interface service and recording the start of the process;
[0071] Step S3, the cloud interface service assigns a process ID as the unique index of the MAC in the current test record of the current process;
[0072] Step S4, after the host computer completes the test of the first process step, the first process step is stored in the local database and bound to the process ID;
[0073] Step S5, after the host computer completes the test of the second process step, the second process step is stored in the local database and bound to the process ID;
[0074] Step S6, after the host computer completes all test steps under this process, the process ID, process test results, and end time are stored in the local database. The host computer completes this test and can proceed to the next product test;
[0075] Step S7, the host computer activates the background thread, calls the cloud work step upload interface, and uploads the first work step stored in the local database to the cloud interface service;
[0076] Step S8, after receiving the first work step, the cloud interface service sends the first work step to the message queue and returns the call completion to avoid the host computer waiting;
[0077] Step S9, the first cloud consumer service registers the consumer service with the message queue, ready to receive and process messages at any time;
[0078] Step S10, the message queue pushes the first work step to the idle first cloud consumer service;
[0079] Step S11, the first cloud consumer service starts to process the first process step, performs statistics and calculations on the first process step, and stores the statistics in different tables of the cloud database;
[0080] Step S12, the host computer background thread calls the cloud work step upload interface to upload the second work step stored in the local database to the cloud interface service;
[0081] Step S13, the cloud interface service receives the second step, sends the second step to the message queue, and returns the call completion to avoid the host computer waiting;
[0082] Step S14, the second cloud consumer service registers the consumer service with the message queue, ready to receive and process messages at any time;
[0083] Here, registering the consumer service is an initialization operation using the message queue, that is, telling the message queue that this service exists. As long as the service is idle, messages that need to be processed can be pushed to it.
[0084] Step S15, the message queue pushes the second process step data to the idle second cloud consumer service;
[0085] Step S16, the second cloud consumer service starts to process the second process step, performs statistics and calculations on the second process step, and stores the statistics in different tables of the cloud database;
[0086] Step S17, the host computer background thread calls the cloud process end interface and uploads the process ID, process test results, and end time to the cloud interface service;
[0087] Step S18, after receiving the process test result, the cloud interface service sends the process test result to the message queue and returns the call completion to avoid the host computer waiting;
[0088] Step S19, the message queue pushes the process test result to the idle first cloud consumer service;
[0089] In step S20, the first cloud consumer service starts to process the process test results, performs statistics and calculations on the process test results, and stores them in different tables of the cloud database.
[0090] The data of this application is stored in a cloud interface service, which supports customers and factory managers to view production data in real time; the site service is deployed in the cloud, which supports engineers to remotely maintain and update services, saving maintenance costs; data from different factories are interoperable, which can achieve perfect connection between upstream and downstream factory data; data is first stored offline, and then multiple cloud consumer services are used to store data. The storage efficiency is higher than storage in a LAN server, and the production rhythm is not limited by network conditions and server performance.
[0091] Embodiment 2:
[0092] Figure 3 A schematic diagram of a system for improving production line data uploading efficiency provided in Embodiment 2 of the present invention.
[0093] Reference Figure 3 The system comprises:
[0094] The reading module is used for the host computer to read the product information when the product passes the station test;
[0095] The calling module is used for the host computer to call the cloud process start interface in the cloud interface service according to the information of the passing product, and receive the process ID assigned by the cloud interface service;
[0096] The binding module is used for binding the corresponding step data with the process ID after completing all the test steps under the current product process, and storing the process ID, step data, process test results and end time in the local database;
[0097] The first upload module is used for the host computer to call the cloud work step upload interface in the cloud interface service, and upload the work step data stored in the local database to the cloud interface service, so that the cloud interface service sends the work step data to the message queue, and the message queue pushes the work step data to the idle cloud consumer service, and the idle cloud consumer service counts and calculates the work step data and stores it in different tables of the cloud database;
[0098] The second upload module is used for the host computer to call the cloud process end interface in the cloud interface service, and upload the process ID, process test results and end time to the cloud interface service, so that the cloud interface service sends the process test results to the message queue, and the message queue pushes the process test results to the idle cloud consumer service. The cloud consumer service counts and calculates the process test results and stores them in different tables of the cloud database.
[0099] Furthermore, the binding module is specifically used for:
[0100] If the first step of the test is completed, the host computer stores the first step in the local database and binds it to the process ID;
[0101] If the second step of the test is completed, the host computer will store the second step in the local database and bind it to the process ID.
[0102] An embodiment of the present invention also provides an electronic device, including a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the computer program, the steps of the method for improving the efficiency of uploading production line data provided in the above embodiment are implemented.
[0103] An embodiment of the present invention also provides a computer-readable medium having a non-volatile program code executable by a processor, wherein a computer program is stored on the computer-readable medium, and when the computer program is executed by the processor, the steps of the method for improving the production line data uploading efficiency of the above embodiment are executed.
[0104] The computer program product provided in the embodiment of the present invention includes a computer-readable storage medium storing program code. The instructions included in the program code can be used to execute the method described in the previous method embodiment. The specific implementation can be found in the method embodiment and will not be repeated here.
[0105] Those skilled in the art can clearly understand that, for the convenience and brevity of description, the specific working process of the system and device described above can refer to the corresponding process in the aforementioned method embodiment, and will not be repeated here.
[0106] In addition, in the description of the embodiments of the present invention, unless otherwise clearly specified and limited, the terms "installed", "connected", and "connected" should be understood in a broad sense, for example, it can be a fixed connection, a detachable connection, or an integral connection; it can be a mechanical connection or an electrical connection; it can be a direct connection or an indirect connection through an intermediate medium, or it can be the internal communication of two components. For ordinary technicians in this field, the specific meanings of the above terms in the present invention can be understood according to specific circumstances.
[0107] If the functions are implemented in the form of software functional units and sold or used as independent products, they can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present invention, or the part that contributes to the prior art or the part of the technical solution, can be embodied in the form of a software product. The computer software product is stored in a storage medium, including several instructions for a computer device (which can be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the methods described in each embodiment of the present invention. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), disk or optical disk, etc., which can store program codes.
[0108] In the description of the present invention, it should be noted that the terms "center", "upper", "lower", "left", "right", "vertical", "horizontal", "inner", "outer", etc., indicating the orientation or positional relationship, are based on the orientation or positional relationship shown in the drawings, and are only for the convenience of describing the present invention and simplifying the description, rather than indicating or implying that the device or element referred to must have a specific orientation, be constructed and operated in a specific orientation, and therefore cannot be understood as limiting the present invention. In addition, the terms "first", "second", and "third" are used for descriptive purposes only, and cannot be understood as indicating or implying relative importance.
[0109] Finally, it should be noted that the above-described embodiments are only specific implementations of the present invention, which are used to illustrate the technical solutions of the present invention, rather than to limit them. The protection scope of the present invention is not limited thereto. Although the present invention is described in detail with reference to the above-described embodiments, ordinary technicians in the field should understand that any technician familiar with the technical field can still modify the technical solutions recorded in the above-described embodiments within the technical scope disclosed by the present invention, or can easily think of changes, or make equivalent replacements for some of the technical features therein; and these modifications, changes or replacements do not make the essence of the corresponding technical solutions deviate from the spirit and scope of the technical solutions of the embodiments of the present invention, and should be included in the protection scope of the present invention. Therefore, the protection scope of the present invention shall be based on the protection scope of the claims.
Claims
1. A method for improving the efficiency of uploading production line data, characterized in that: The method comprises: When the product passes the station test, the host computer reads the product information that has passed the station; The host computer calls the cloud process start interface in the cloud interface service according to the in-station product information, and receives the process ID assigned by the cloud interface service; If all test steps under the current product process are completed, the host computer will bind the corresponding step data with the process ID, and store the process ID, the step data, the process test results and the end time in the local database; The host computer calls the cloud work step upload interface in the cloud interface service, and uploads the work step data stored in the local database to the cloud interface service, so that the cloud interface service sends the work step data to the message queue, and the message queue pushes the work step data to the idle cloud consumer service, and the idle cloud consumer service counts and calculates the work step data and stores them in different tables of the cloud database; The host computer calls the cloud process end interface in the cloud interface service, and uploads the process ID, the process test result and the end time to the cloud interface service, so that the cloud interface service sends the process test result to the message queue, and the message queue pushes the process test result to the idle cloud consumer service. The cloud consumer service performs statistics and calculations on the process test results and stores them in different tables of the cloud database.
2. The method for improving the efficiency of uploading production line data according to claim 1, characterized in that: If all test steps under the current product process are completed, the host computer will bind the corresponding step data with the process ID, including: If the first step of the test is completed, the host computer stores the first step in the local database and binds it to the process ID; If the second step of the test is completed, the host computer stores the second step in the local database and binds it to the process ID.
3. The method for improving the efficiency of uploading production line data according to claim 2, characterized in that: The host computer calls the cloud work step upload interface in the cloud interface service, and uploads the work step data stored in the local database to the cloud interface service, so that the cloud interface service sends the work step data to the message queue, and the message queue pushes the work step data to the idle cloud consumer service, and the idle cloud consumer service counts and calculates the work step data and stores it in different tables of the cloud database, including: The host computer calls the cloud work step upload interface in the cloud interface service, and uploads the first work step stored in the local database to the cloud interface service, so that the cloud interface service sends the first work step to the message queue and returns the call completion. After the first cloud consumer service registers the consumer service with the message queue, the message queue pushes the first work step to the idle first cloud consumer service. The idle first cloud consumer service counts and calculates the first work step and stores it in different tables of the cloud database.
4. The method for improving the efficiency of uploading production line data according to claim 2, characterized in that: The host computer calls the cloud work step upload interface in the cloud interface service, and uploads the work step data stored in the local database to the cloud interface service, so that the cloud interface service sends the work step data to the message queue, and the message queue pushes the work step data to the idle cloud consumer service, and the idle cloud consumer service counts and calculates the work step data and stores it in different tables of the cloud database, including: The host computer calls the cloud work step upload interface in the cloud interface service, and uploads the second work step stored in the local database to the cloud interface service, so that the cloud interface service sends the second work step to the message queue and returns the call completion. After the second cloud consumer service registers the consumer service with the message queue, the message queue pushes the second work step to the idle second cloud consumer service. The idle second cloud consumer service counts and calculates the second work step and stores it in different tables of the cloud database.
5. The method for improving the efficiency of uploading production line data according to claim 1, characterized in that: The local database also stores pictures, logs and files during the test.
6. The method for improving production line data uploading efficiency according to claim 1, characterized in that: The product information passing the station includes MAC information, and the work step is each key test step in the test station.
7. A system for improving the efficiency of uploading production line data, characterized in that: The system comprises: The reading module is used for the host computer to read the product information when the product passes the station test; A calling module, used for the host computer to call the cloud process start interface in the cloud interface service according to the in-station product information, and receive the process ID assigned by the cloud interface service; A binding module, which is used for binding the corresponding step data with the process ID after completing all the test steps under the current product process, and storing the process ID, the step data, the process test result and the end time in the local database; A first uploading module is used for the host computer to call the cloud work step upload interface in the cloud interface service to upload the work step data stored in the local database to the cloud interface service, so that the cloud interface service sends the work step data to a message queue, and the message queue pushes the work step data to an idle cloud consumer service, and the idle cloud consumer service performs statistics and calculations on the work step data and stores them in different tables of the cloud database; The second uploading module is used for the host computer to call the cloud process end interface in the cloud interface service, and upload the process ID, the process test result and the end time to the cloud interface service, so that the cloud interface service sends the process test result to the message queue, and the message queue pushes the process test result to the idle cloud consumer service. The cloud consumer service performs statistics and calculations on the process test results and stores them in different tables of the cloud database.
8. The system for improving production line data uploading efficiency according to claim 7, characterized in that: The binding module is specifically used for: If the first step of the test is completed, the host computer stores the first step in the local database and binds it to the process ID; If the second step of the test is completed, the host computer stores the second step in the local database and binds it to the process ID.
9. An electronic device comprising a memory and a processor, wherein the memory stores a computer program that can be run on the processor, wherein: When the processor executes the computer program, the method according to any one of claims 1 to 6 is implemented.
10. A computer readable medium having a non-volatile program code executable by a processor, characterized in that: The program code enables the processor to execute the method according to any one of claims 1 to 6.
