Automatic data analysis and report generation method, electronic device and storage medium

Abstract

An automatic data analysis and report generation method, an electronic device and a storage medium, the method comprising: uploading a plurality of logs of a plurality of test stations to a log storage directory of a log storage server through an internal network, the plurality of test stations of a production line generating the plurality of logs; according to a set screening condition, a plurality of target logs meeting the screening condition in the log storage catalog are transmitted to a process capability index (CPK) and a measurement repeatability and reproducibility (GRAMP), and a plurality of target logs meeting the screening condition in the log storage catalog are transmitted to the CPK and the GRAMP; r) a report generation server; and analyzing the plurality of target logs through the CPK and GRR report generation server, automatically generating a CPK / GRR report, and sending the CPK / GRR report to a user personal computer.

Description

Technical Field

[0001] The present invention relates to an automated data analysis and report generation method, and in particular to an automated data analysis and report generation method, an electronic device, and a storage medium. Background Art

[0002] The production process generates a vast amount of data. Process Capability Index (CPK) and Gauge Repeatability & Reproducibility (GR&R) are crucial indicators for product quality control in industrial production processes. They require identifying specific test data from this vast amount of data for analysis. Tools used for CPK and GR&R analysis are all local versions, which have the following drawbacks: 1. Manual login to the log server is required to filter and search for target test logs and copy them to a local directory; 2. There is no unified log format, requiring manual organization into a specific format before running the program for analysis; and 3. Reports generated by the program analysis are only stored in a local directory, making them inconvenient to share and view. Summary of the Invention

[0003] In view of the above, it is necessary to provide an automated data analysis and report generation method, an electronic device, and a storage medium, which can realize automated data analysis and report generation by integrating relevant data of process capability indicators (CPK) and measurement repeatability and reproducibility (GR&R) into a report generation system.

[0004] An embodiment of the present invention provides an automated data analysis and report generation method, which is applied to an electronic device, comprising: uploading multiple logs of multiple test stations to a log storage directory of a log storage server via an internal network, wherein the multiple logs are generated by multiple test stations on a production line; according to set filtering conditions, transmitting multiple target logs in the log storage directory that meet the filtering conditions to a process capability indicator (CPK) / measurement repeatability and reproducibility (GR&R) report generation server; analyzing the multiple target logs and automatically generating a CPK / GRR report by the CPK / GRR report generation server, and sending the CPK / GRR report to a user's personal computer.

[0005] An embodiment of the present invention also provides an electronic device, which includes a memory, a processor, and an automated data analysis and report generation program stored in the memory and capable of running on the processor. The electronic device also includes a log acquisition module, an analysis and generation module, and an early warning module. When the automated data analysis and report generation program is executed by the processor, the following steps are implemented: uploading multiple logs of multiple test stations to a log storage directory of a log storage server through an internal network, wherein the multiple test stations of the production line generate the multiple logs; according to set filtering conditions, transmitting multiple target logs in the log storage directory that meet the filtering conditions to a process capability indicator (CPK) / measurement repeatability and reproducibility (GR&R) report generation server; analyzing the multiple target logs and automatically generating a CPK / GRR report through the CPK / GRR report generation server, and sending the CPK / GRR report to the user's personal computer.

[0006] An embodiment of the present invention further provides a storage medium having a computer program stored thereon. When the computer program is executed, the steps of the aforementioned automated data analysis and report generation method are implemented.

[0007] The automated data analysis and report generation method, electronic device, and storage medium of the embodiments of the present invention can significantly save users' time and improve work efficiency, while also allowing users to remotely monitor product production status. BRIEF DESCRIPTION OF THE DRAWINGS

[0008] Figure 1 4 is a flowchart of the steps of the automated data analysis and report generation method according to an embodiment of the present invention.

[0009] Figure 2 Schematic diagram of an automated data analysis and report generation system according to an embodiment of the present invention.

[0010] Figure 3 FIG. 4 is a schematic diagram of the hardware architecture of an electronic device according to an embodiment of the present invention.

[0011] Figure 4 FIG. 4 is a functional block diagram of an electronic device according to an embodiment of the present invention.

[0012] Description of main component symbols

[0013] production line 110 Log storage server 130 CPK / GRR report generation server 150 User's personal computer 170 electronic devices 200 processor 210 Memory 220 Automated data analysis and report generation system 100、230 Log acquisition module 310 Analysis and Generation Module 320 Early warning module 330 step S1~S5

[0014] The following specific embodiments will further illustrate the present invention in conjunction with the above-mentioned drawings. DETAILED DESCRIPTION

[0015] In order to more clearly understand the above-mentioned objects, features and advantages of the present invention, the present invention is described in detail below with reference to the accompanying drawings and specific embodiments. It should be noted that, in the absence of conflict, the embodiments of the present application and the features therein may be combined with each other.

[0016] The following description sets forth numerous specific details to facilitate a thorough understanding of the present invention. The embodiments described are merely some, not all, of the present invention. All other embodiments derived by persons of ordinary skill in the art based on the embodiments of the present invention without inventive effort are intended to fall within the scope of protection of the present invention.

[0017] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as those commonly understood by those skilled in the art of the present invention. The terms used in this specification of the present invention are only for the purpose of describing specific embodiments and are not intended to limit the present invention.

[0018] It should be noted that the descriptions of "first", "second", etc. in the present invention are for descriptive purposes only and should not be understood as indicating or implying their relative importance or implicitly indicating the number of the indicated technical features. Therefore, the features defined as "first" or "second" may explicitly or implicitly include at least one of the said features. In addition, the technical solutions between the various embodiments can be combined with each other, but this must be based on the fact that they can be implemented by ordinary technicians in this field. When the combination of technical solutions is contradictory or cannot be implemented, it should be deemed that such combination of technical solutions does not exist and is not within the scope of protection required by the present invention.

[0019] Figure 1 This is a flowchart of the steps in an automated data analysis and report generation method according to an embodiment of the present invention, applied to an electronic device, specifically a server for generating process capability index (CPK) and gauge repeatability and reproducibility (GR&R) reports. The order of the steps in the flowchart may be varied, and some steps may be omitted, depending on specific requirements. Figure 2 Schematic diagram of an automated data analysis and report generation system according to an embodiment of the present invention. The automated data analysis and report generation system 100 according to an embodiment of the present invention includes a production line 110, a log storage server 130, a CPK / GRR report generation server 150, and a user personal computer (PC) 170. The production line 110 also includes multiple test stations.

[0020] In step S1 , multiple test stations of the production line 110 generate logs in a format specified by the CPK / GRR report generation server 150 through a specific test framework, for example, logs in JavaScript Object Notation (JSON) format (JSON Log).

[0021] Step S2: Upload the multiple logs of the multiple test stations to the log storage directory of the log storage server 130 via the internal network. The log storage directory must meet the requirements of the CPK / GRR report generation server 150.

[0022] In step S3 , the user sets filtering conditions in the interface of the CPK / GRR report generation server 150 through the user PC 170 . Based on the filtering conditions, multiple target logs in the log storage directory that meet the filtering conditions are transmitted to the CPK / GRR report generation server 150 .

[0023] In step S4 , the CPK / GRR report generation server 150 analyzes the multiple target logs and automatically generates a CPK / GRR report, and sends the CPK / GRR report to the user PC 170 .

[0024] In step S5 , the CPK / GRR report generation server 150 automatically generates new CPK / GRR reports regularly and performs intelligent early warning according to the CPK / GRR change trend, that is, sends a warning notification to the user PC 170 .

[0025] Figure 3 Schematic diagram of the hardware architecture of an electronic device according to an embodiment of the present invention. The electronic device 200, such as, but not limited to, a CPK and GRR report generation server, can be interconnected via a system bus to communicate with a processor 210, a memory 220, and an automated data analysis and report generation system 230. Figure 3 The electronic device 200 is shown only with components 210 - 230 , but it is understood that implementing all of the illustrated components is not a requirement, and greater or fewer components may alternatively be implemented.

[0026] The memory 220 includes at least one type of readable storage medium, including flash memory, hard disk, multimedia card, card-type memory (e.g., SD or DX memory), random access memory (RAM), static random access memory (SRAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), programmable read-only memory (PROM), magnetic memory, magnetic disk, optical disk, etc. In some embodiments, the memory 220 can be an internal storage unit of the electronic device 200, such as a hard disk or memory of the electronic device 200. In other embodiments, the memory can also be an external storage device of the electronic device 200, such as a plug-in hard disk equipped on the electronic device 200, a smart memory card (SMC), a secure digital (SD) card, a flash card, etc. Of course, the memory 220 can also include both the internal storage unit of the electronic device 200 and its external storage device. In this embodiment, the memory 220 is generally used to store the operating system and various application software installed on the electronic device 200, such as the program code of the automated data analysis and report generation system 230. In addition, the memory 220 can also be used to temporarily store various data that has been output or is about to be output.

[0027] In some embodiments, the processor 210 may be a central processing unit (CPU), a controller, a microcontroller, a microprocessor, or other data processing chip. The processor 210 is generally used to control the overall operation of the electronic device 200. In this embodiment, the processor 210 is used to execute program code stored in the memory 220 or process data, for example, to execute the automated data analysis and report generation system 230.

[0028] It should be noted that Figure 3 The electronic device 200 is merely illustrated as an example. In other embodiments, the electronic device 200 may include more or fewer components, or have a different component configuration.

[0029] If the modules / units integrated in the electronic device 200 are implemented as 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 present invention can implement all or part of the processes in the above-mentioned method embodiments by instructing the relevant hardware through a computer program. The computer program can be stored in a computer-readable storage medium. When the computer program is executed by a processor, it can implement the steps of each of the above-mentioned method embodiments. The computer program includes computer program code, which can be in source code form, object code form, executable file, or some intermediate form. The computer-readable medium can include: any entity or device capable of carrying the computer program code, recording medium, USB flash drive, mobile hard disk, magnetic disk, optical disk, computer memory, read-only memory, random access memory, electric carrier signal, telecommunication signal, and software distribution medium. It should be noted that the content contained in the computer-readable medium can be appropriately increased or decreased according to the requirements of legislation and patent practice in the jurisdiction. For example, in some jurisdictions, according to legislation and patent practice, computer-readable media does not include electric carrier signals and telecommunication signals.

[0030] Figure 4 2 is a functional block diagram of an electronic device according to an embodiment of the present invention, which is configured to perform an automated data analysis and report generation method. The automated data analysis and report generation method according to the embodiment of the present invention can be implemented by a computer program stored in a storage medium, such as memory 220 of electronic device 200. When the computer program implementing the method according to the present invention is loaded into memory 220 by processor 210, processor 210 of electronic device 200 is driven to execute the automated data analysis and report generation method according to the embodiment of the present invention.

[0031] The electronic device 200 according to the embodiment of the present invention includes a log acquisition module 310 , an analysis and generation module 320 , and an early warning module 330 .

[0032] See Figure 2 , multiple test stations of the production line 110 generate logs in a format specified by the CPK / GRR report generation server 150 through a specific test framework, for example, JSON Log.

[0033] The log acquisition module 310 acquires the logs of the test stations through the internal network and stores the logs in a log storage directory that meets the requirements of the CPK / GRR report generation server 150 .

[0034] The user sets filtering conditions in the interface of the CPK / GRR report generation server 150 via the user PC 170. Based on the filtering conditions, the analysis and generation module 320 retrieves multiple target logs from the log storage directory that meet the filtering conditions, analyzes the multiple target logs, automatically generates a CPK / GRR report, and sends the CPK / GRR report to the user PC 170.

[0035] The analysis and generation module 320 automatically generates new CPK / GRR reports regularly, and the warning module 330 performs intelligent warnings based on the CPK / GRR change trend, that is, sends warning notifications to the user PC 170.

[0036] It is understood that the module division described above is only a logical functional division, and other division methods may be used in actual implementation. In addition, the functional modules in the various embodiments of the present application can be integrated into the same processing unit, or each module can exist physically separately, or two or more modules can be integrated into the same unit. The above-mentioned integrated modules can be implemented in the form of hardware or in the form of hardware plus software functional modules.

[0037] For ordinary technicians in this field, they can make other corresponding changes or adjustments based on actual needs generated by combining the technical solutions and technical concepts provided by the embodiments of the present invention, and these changes and adjustments should fall within the scope of protection of the claims of the present invention.

Claims

1. An automated data analysis and report generation method, applied to an electronic device, characterized in that: The method comprises: Uploading multiple logs of multiple test stations of the production line to a log storage directory of a log storage server through an internal network, wherein the multiple logs are generated by the multiple test stations of the production line; According to the set screening conditions, multiple target logs in the log storage directory that meet the screening conditions are transmitted to a process capability index (CPK) / gauge repeatability and reproducibility (GRR) report generation server; and The CPK / GRR report generating server analyzes the plurality of target logs and automatically generates a CPK / GRR report, and sends the CPK / GRR report to a user personal computer.

2. The automated data analysis and report generation method according to claim 1, wherein: Also includes: The multiple logs comply with the JavaScript Object Notation format (JSONLog).

3. The automated data analysis and report generation method according to claim 1, wherein: Also includes: The CPK / GRR report generation server automatically generates new CPK / GRR reports regularly and automatically sends warning notifications to the user's personal computer based on the CPK / GRR change trend.

4. An electronic device, characterized in that: The electronic device includes a memory, a processor, and an automated data analysis and report generation program stored in the memory and executable on the processor. The electronic device also includes a log acquisition module, an analysis and generation module, and an early warning module. When the automated data analysis and report generation program is executed by the processor, the following steps are implemented: Uploading multiple logs of multiple test stations of the production line to a log storage directory of a log storage server through an internal network, wherein the multiple logs are generated by the multiple test stations of the production line; According to the set screening conditions, multiple target logs in the log storage directory that meet the screening conditions are transmitted to a process capability index (CPK) / measurement repeatability and reproducibility (GRR) report generation server; and The CPK / GRR report generating server analyzes the plurality of target logs and automatically generates a CPK / GRR report, and sends the CPK / GRR report to a user personal computer.

5. The electronic device according to claim 4, wherein: The multiple logs comply with the JavaScript Object Notation (JSON Log) format.

6. The electronic device according to claim 4, wherein: in, When the processor executes the automated data analysis and report generation program, the processor further implements the following steps: The CPK / GRR report generation server automatically generates new CPK / GRR reports regularly and automatically sends warning notifications to the user's personal computer based on the CPK / GRR change trend.

7. A storage medium having at least one computer instruction stored thereon, characterized in that: The instructions are loaded by the processor and executed by the automated data analysis and report generation method according to any one of claims 1 to 3.

Images