A data screening method, device, equipment and storage medium
By automatically screening and visualizing the screening priority in the statistical process control system, the problem of large manual workload in the existing technology is solved, and user experience and efficiency are improved.
Patent Information
- Application Number
- CN202111637997.8
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2021-12-29
- Publication Date
- 2025-03-21
- Estimated Expiration
- 2041-12-29
AI Technical Summary
In the existing statistical process control system, users need to manually enter keywords and manually find the required parameter items, resulting in a large amount of manual work.
By obtaining the filter information in the statistical chart and its corresponding filter priority, filtering from high to low according to the priority. Each filter is based on the results of the previous filter until the filter priority reaches the lowest and visually display it.
This reduces the workload of manually finding required parameter items in a large number of parameters, improves the user experience, and allows users to intuitively understand the process of changing the required batch number.
Smart Images

Figure CN114296784B_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the technical field of statistical process control (SPC), and in particular to a data screening method, device, equipment and storage medium. Background Art
[0002] In the prior art, if a user wants to determine the change process of a parameter in a certain parameter item (required parameter item) in a statistical process control system, the user needs to manually input a keyword preset for the parameter in the statistical process control system to query all parameters corresponding to the keyword, and then manually search for the parameter in the required parameter item among all parameters and record it, and finally determine the change process by recording the result; for example: if a user wants to determine the change process of the batch number in the online data of Factory A, the user needs to first use the keyword LOT_ID (Identity document, unique number) to filter all batch numbers corresponding to LOT_ID from the statistical chart, and then manually find the target batch number whose parameter item is "Online data of Factory A" from all the batch numbers and record it. In this process, the user needs to manually determine the parameter item corresponding to each parameter among a large number of parameters to find the parameter whose parameter item is the required parameter item. This method makes the manual workload large. Summary of the invention
[0003] In view of this, embodiments of the present application provide a data screening method, apparatus, device and storage medium to reduce manual workload.
[0004] It mainly includes the following aspects:
[0005] In a first aspect, an embodiment of the present application provides a data screening method, which is applied to a statistical process control system, comprising:
[0006] S1: Acquire at least one filtering information in a statistical chart of the statistical process control system and a filtering priority corresponding to each filtering information, and use the filtering information with the highest filtering priority among the at least one filtering information as the first filtering information;
[0007] S2: In response to a first selection operation on a first target information in at least one first information included in the first filtering information, determining at least one second target information corresponding to the first target information in at least one second information included in the second filtering information; wherein the filtering priority corresponding to the second filtering information is adjacent to the filtering priority corresponding to the first filtering information and the filtering priority corresponding to the second filtering information is lower than the filtering priority corresponding to the first filtering information;
[0008] S3: determining whether the screening priority corresponding to the second screening information is the lowest screening priority among the at least one obtained screening priority;
[0009] S4: If it is not the lowest filtering priority, take the at least one second target information as the at least one first information included in the first filtering information, and repeat S2, S3 and S4 in sequence until the filtering priority corresponding to the second filtering information is the lowest filtering priority among the at least one obtained filtering priority; if it is the lowest filtering priority, respond to the second selection operation on the third target information in the at least one second target information, and visualize the third target information in the statistical chart.
[0010] Optionally, the first selection operation is a single selection operation, and the second selection operation is a multiple selection operation.
[0011] Optionally, the first screening information includes at least one first information corresponding to a data upgrade version, and determining at least one second target information corresponding to the first target information in at least one second information included in the second screening information includes:
[0012] Determine a target data upgrade version in at least one data upgrade version; wherein the target data upgrade version is a data upgrade version that includes the first target information in the corresponding first information;
[0013] At least one second target information corresponding to the upgraded version of the target data in the second screening information is determined.
[0014] Optionally, after determining at least one second target information corresponding to the first target information, the method further includes:
[0015] The second target information corresponding to different target data upgrade versions is displayed in different display areas of the statistical chart.
[0016] Optionally, the visually displaying the third target information in the statistical chart includes:
[0017] In the statistical chart, a line graph is created based on the unique identifier of the third target information and the parameter value of the parameter corresponding to the third target information; wherein a node on the line in the line graph is used to represent a piece of third target information;
[0018] For each of the nodes, according to the target color preset for the third target information corresponding to the node, the color of the broken line located on the left side of the node is set to the target color.
[0019] Optionally, the data screening method further includes:
[0020] In response to a second selection operation on a third target information in the at least one second target information, the remaining second target information in the at least one second target information except the third target information is visually displayed in the statistical chart.
[0021] In a second aspect, an embodiment of the present application provides a data screening device, which is applied to a statistical process control system, comprising:
[0022] An acquisition module, used for acquiring at least one filtering information in the statistical chart of the statistical process control system and the filtering priority corresponding to each filtering information, and taking the filtering information with the highest filtering priority in the at least one filtering information as the first filtering information;
[0023] an execution module, configured to respond to a first selection operation on a first target information in at least one first information included in the first filtering information, and determine at least one second target information corresponding to the first target information in at least one second information included in the second filtering information; wherein the filtering priority corresponding to the second filtering information is adjacent to the filtering priority corresponding to the first filtering information and the filtering priority corresponding to the second filtering information is lower than the filtering priority corresponding to the first filtering information;
[0024] A determination module, configured to determine whether the screening priority corresponding to the second screening information is the lowest screening priority among the at least one obtained screening priority;
[0025] a processing module, for, if it is not the lowest screening priority, using the at least one second target information as the at least one first information included in the first screening information, and repeatedly executing S2, S3 and S4 in sequence until the screening priority corresponding to the second screening information is the lowest screening priority among the at least one screening priority obtained; if it is the lowest screening priority, responding to the second selection operation on the third target information in the at least one second target information, visually displaying the third target information in the statistical chart; wherein, S2 is: responding to the first selection operation on the first target information in the at least one first information included in the first screening information, determining whether the first target information is in the at least one first information included in the second screening information at least one second target information corresponding to the second information; the S3 is: judging whether the filtering priority corresponding to the second filtering information is the lowest filtering priority among the at least one filtering priority obtained; the S4 is: if it is not the lowest filtering priority, taking the at least one second target information as the at least one first information included in the first filtering information, and repeatedly executing S2, S3 and S4 in sequence until the filtering priority corresponding to the second filtering information is the lowest filtering priority among the at least one filtering priority obtained; if it is the lowest filtering priority, responding to the second selection operation on the third target information in the at least one second target information, visually displaying the third target information in the statistical chart.
[0026] Optionally, the first selection operation is a single selection operation, and the second selection operation is a multiple selection operation.
[0027] Optionally, the first screening information includes at least one first information corresponding to a data upgrade version, and the execution module, when used to determine at least one second target information corresponding to the first target information in at least one second information included in the second screening information, is specifically used to:
[0028] Determine a target data upgrade version in at least one data upgrade version; wherein the target data upgrade version is a data upgrade version that includes the first target information in the corresponding first information;
[0029] At least one second target information corresponding to the upgraded version of the target data in the second screening information is determined.
[0030] Optionally, after determining at least one second target information corresponding to the first target information, the execution module is further used to:
[0031] The second target information corresponding to different target data upgrade versions is displayed in different display areas of the statistical chart.
[0032] Optionally, when the processing module is used to visually display the third target information in the statistical chart, it is specifically used to:
[0033] In the statistical chart, a line graph is created based on the unique identifier of the third target information and the parameter value of the parameter corresponding to the third target information; wherein a node on the line in the line graph is used to represent a piece of third target information;
[0034] For each of the nodes, according to the target color preset for the third target information corresponding to the node, the color of the broken line located on the left side of the node is set to the target color.
[0035] Optionally, the data screening device further includes:
[0036] The display module is used to respond to the second selection operation of the third target information in the at least one second target information, and visually display the remaining second target information in the at least one second target information except the third target information in the statistical chart.
[0037] In a third aspect, an embodiment of the present application provides a computer device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the steps of any data screening method described in the first aspect when executing the computer program.
[0038] In a fourth aspect, an embodiment of the present application provides a computer-readable storage medium, on which a computer program is stored. When the computer program is executed by a processor, the steps of the data screening method described in any one of the first aspects are executed.
[0039] The technical solution provided by the embodiments of the present application may have the following beneficial effects:
[0040] The data screening method provided in the embodiment of the present application obtains at least one screening information in the statistical chart and the screening priority corresponding to each screening information, and screens in descending order of the screening priority, and each screening is based on the screening result of the previous screening, that is: after the first target information is selected from the at least one first information included in the first screening information through the first selection operation, at least one second target information corresponding to the first target information is screened out from the at least one second information included in the second screening information whose screening priority is one level lower than the screening priority corresponding to the first screening information; if the second screening information is not the screening information with the lowest screening priority among the screening information, a second target information can be continuously selected from the at least one second target information, and subsequent screening operations can be performed based on the selected second target information; if the second screening information is The filtering information with the lowest filtering priority among all the filtering information can visualize the third target information selected in at least one second target information; for example: if the user wants to determine the changing process of the batch number in the online data of Factory A in the statistical chart, the required batch number in the online data of Factory A can be determined by selecting Factory A, the online data in Factory A, and the batch number data in the online data in Factory A at one time. This process does not require the user to determine the parameter item corresponding to each parameter in a large number of parameters, which is conducive to reducing manual workload. In addition, in the above process, the user can select the batch number he wants to know from the batch number finally determined, and the statistical process control system automatically visualizes the selected batch number to facilitate the user to intuitively understand the changing process of the required batch number, which is conducive to improving the user experience.
[0041] In order to make the above-mentioned objects, features and advantages of the present application more obvious and easy to understand, preferred embodiments are specifically cited below and described in detail with reference to the attached drawings. BRIEF DESCRIPTION OF THE DRAWINGS
[0042] In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings required for use in the embodiments will be briefly introduced below. It should be understood that the following drawings only show certain embodiments of the present application and therefore should not be regarded as limiting the scope. For ordinary technicians in this field, other related drawings can be obtained based on these drawings without paying creative work.
[0043] Figure 1 A flow chart of a data screening method provided in Embodiment 1 of the present application is shown;
[0044] Figure 2 An example diagram showing a visual display of third target information provided by the first embodiment of the present application is shown;
[0045] Figure 3A schematic diagram of the structure of a data screening device provided in the second embodiment of the present application is shown;
[0046] Figure 4 A schematic diagram of the structure of a computer device provided in Embodiment 3 of the present application is shown. DETAILED DESCRIPTION
[0047] To make the purpose, technical scheme and advantages of the embodiments of the present application clearer, the technical scheme in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments are only a part of the embodiments of the present application, rather than all of the embodiments. The components of the embodiments of the present application generally described and shown in the drawings here can be arranged and designed in various different configurations. Therefore, the following detailed description of the embodiments of the present application provided in the drawings is not intended to limit the scope of the application claimed for protection, but merely represents the selected embodiments of the present application. Based on the embodiments of the present application, all other embodiments obtained by those skilled in the art without making creative work belong to the scope of protection of the present application.
[0048] The embodiments of the present application provide a data screening method, apparatus, device and storage medium, which are described below through embodiments.
[0049] Embodiment 1
[0050] Figure 1 A flow chart of a data screening method provided in the first embodiment of the present application is shown. Figure 1 As shown, the data screening method is applied to a statistical process control system, and the data screening method can be implemented by the following steps S102 to S104:
[0051] Step S101: obtaining at least one filtering information in a statistical chart of the statistical process control system and a filtering priority corresponding to each filtering information, and taking the filtering information with the highest filtering priority in the at least one filtering information as the first filtering information.
[0052] Specifically, the above-mentioned statistical process control system acquires a number of process data that meet preset specifications (Spec) from the manufacturing execution system (MES) according to the electronic data capture (EDC) plan, and after performing statistical calculations on the acquired process data, stores the statistical calculation results in a statistical chart (Chart); in the statistical chart, each filtering information is the process data of each level in the statistical chart, for example: the factory identification, the statistical data category in the factory, and the process information under the statistical data category are three levels of process data respectively, and the filtering priority of the filtering information is determined according to the level of the filtering information, and the first filtering information is the filtering information with the highest filtering priority among the obtained filtering information.
[0053] For example: the filtering information is ordered from top to bottom in terms of hierarchy: factory identification, statistical data category, and process information. The three filtering information are ordered from high to low in terms of filtering priority: factory identification, statistical data category, and process information. Among these three filtering information, the factory identification has the highest filtering priority, so the factory identification is used as the first filtering information.
[0054] Step S102: In response to a first selection operation on a first target information in at least one first information included in the first filtering information, determine at least one second target information corresponding to the first target information in at least one second information included in the second filtering information; wherein the filtering priority corresponding to the second filtering information is adjacent to the filtering priority corresponding to the first filtering information and the filtering priority corresponding to the second filtering information is lower than the filtering priority corresponding to the first filtering information.
[0055] Specifically, the above-mentioned first selection operation can be an operation of the user on the above-mentioned first target information, such as: the user uses the mouse to click on the first target information in at least one first information displayed on the user graphical interface of the statistical process control system, or the user uses the keyboard to input the identification information of the first target information in the above-mentioned statistical process control system; the above-mentioned first selection operation can also be the first target information automatically selected by the statistical process control system from at least one first information, such as: random selection of the statistical process control system. Regarding the above-mentioned first selection operation, no specific limitation is made herein.
[0056] In a specific implementation, after determining the first filtering information, the first filtering information includes at least one first information, for example: the first filtering information is a factory identification, and the factory identification includes identification information of at least one factory; after determining the first target information selected from the at least one first information, according to the first filtering information and the filtering priority corresponding to the first filtering information, the second filtering information is determined in the at least one filtering information obtained above, and the characteristics of the second filtering information are: the filtering priority of the second filtering information is lower than the filtering priority of the first filtering information, and the filtering priority of the filtering information is adjacent to the filtering priority of the first filtering information, for example: three filtering information are obtained, and the three filtering information are factory identification, statistical data category, and process information in order of filtering priority from high to low. When the first filtering information is a factory, the second filtering information is obtained. When the identification is performed, the second screening information determined is the statistical data category, and when the first screening information is the statistical data category, the second screening information determined is the process information; after the second screening information is determined, the second screening information includes at least one second information, and at least one second target information corresponding to the first target information is determined in the at least one second information, for example: the second screening information is the statistical data category, and the second information included in the statistical data category are: online data corresponding to the identification of Factory A, offline data corresponding to the identification of Factory A, online data corresponding to the identification of Factory B, and offline data corresponding to the identification of Factory B. The first target information determined is the identification of Factory A, then the second target information corresponding to the identification of Factory A in each second information includes: online data corresponding to the identification of Factory A and offline data corresponding to the identification of Factory A.
[0057] Step S103: Determine whether the screening priority corresponding to the second screening information is the lowest screening priority among the at least one obtained screening priority.
[0058] Step S104: If it is not the lowest filtering priority, take the at least one second target information as the at least one first information included in the first filtering information, and repeat step S102, step S103 and step S104 in sequence until the filtering priority corresponding to the second filtering information is the lowest filtering priority among the at least one filtering priority obtained; if it is the lowest filtering priority, respond to the second selection operation on the third target information in the at least one second target information, and visualize the third target information in the statistical chart.
[0059] Specifically, after determining at least one second target information, in order to determine whether the second target information is the data of the last level, it is necessary to determine whether the filtering priority of the second filtering information is the lowest filtering priority among the filtering priorities of each filtering information obtained, that is, the filtering priorities of other filtering information except the second filtering information in each filtering information obtained are higher than the filtering priority of the second filtering information. If the filtering priority of the above-mentioned second filtering information is not the lowest filtering priority among the filtering priorities of each filtering information obtained, that is, there is filtering information in each filtering information whose filtering priority is lower than the filtering priority of the second filtering information, it is necessary to continue filtering, that is, take the at least one second target information obtained as at least one first information in the first filtering information, and then repeat the above steps S102, S103 and S104 in sequence until the filtering priority of the second filtering information is the lowest among the filtering priorities of each filtering information, that is, the second target information obtained is the data of the last level. If the filtering priority of the second filtering information is the lowest among the filtering priorities of all the filtering information, in response to the second selection operation of the third target information in the at least one second target information, the third target information selected by the second selection operation is visualized in the above-mentioned statistical chart so that the user can understand the third target information more intuitively.
[0060] It should be noted that the third target information may be one or more, and is not specifically limited here.
[0061] It needs to be explained again that, for the description of the second selection operation, please refer to the description of the first selection operation, which will not be repeated here.
[0062] Take steps S101 to S104 as an example: at least one of the filtering information in the acquired statistical chart is in descending order of filtering priority: factory identification, statistical data category, process information and process parameters. Among the four filtering information, the factory identification has the highest filtering priority, so the factory identification is used as the first filtering information. Since the filtering priority of the statistical data category is adjacent to the filtering priority of the factory identification and is lower than the filtering priority of the factory identification, when the factory identification is the first filtering information, the statistical data category is the second filtering information. The factory identification includes the identifications of two factories (i.e., two first information), namely, factory A and factory B. The second information included in the statistical data category (second screening information) is: online data (online) and offline data (inline), wherein the online data includes the online data corresponding to the identification of factory A and the online data corresponding to the identification of factory B, and the offline data includes the offline data corresponding to the identification of factory A and the offline data corresponding to the identification of factory B; in response to the first selection operation on the identification of factory A (first target information) among the identifications of these two factories, the second target information corresponding to the identification of factory A is determined in each second information, that is, the online data corresponding to the identification of factory A and the offline data corresponding to the identification of factory A. It is determined that the second screening information (i.e., statistical data category) is not the screening information with the lowest screening priority, so the online data corresponding to the identification of factory A and the offline data corresponding to the identification of factory A are used as the first information included in the first screening information. At this time, the corresponding second screening information is process information. The second information in the process information includes at least one product batch information (LOT) and at least one equipment information (EQP, Equipment). The at least one product information includes information such as a batch number (Lot ID), a batch number (Lot Type), a final finished product number (Finish Good ID), a product ID (Product ID), a product version (Product Version), and a process route (Route). The at least one equipment information includes information such as an equipment ID (EQPID), a production equipment (Process Equipment), and a measurement equipment (Measurement Equipment). Each product information includes product information corresponding to different statistical data categories (for example, the batch number includes: a batch number corresponding to the online data and a batch number corresponding to the offline data). After the online data corresponding to the identification of factory A is selected through the first selection operation, the second target information corresponding to the online data corresponding to the identification of factory A is determined in each second information, that is, at least one product batch information and at least one equipment information corresponding to the online data corresponding to the identification of factory A.By judging that the second screening information (i.e., process information) is not the screening information with the lowest screening priority, at least one product batch information and at least one equipment information corresponding to the online data corresponding to the identification of the factory A determined above are used as at least one first information in the first screening information. At this time, the process parameter is the second screening information, and the second information included in the process parameter is the specific parameter of each batch corresponding to the process information (for example, the second information corresponding to the batch number includes the specific batch numbers of all batches (for three batches): Lot_ID_1, Lot_ID_2, Lot_ID_3). After the batch number is selected in each first information through the first selection operation, at least one second target information determined in the second screening information (process parameter) is respectively: Lot_ID_1, Lot_ID_2, Lot_ID_3, and it is judged that the above process parameter is the screening information with the lowest screening priority. Therefore, after Lot_ID_1 and Lot_ID_2 are selected from the three second target information through the second selection operation, the selected Lot_ID_1 and Lot_ID_2 are visualized in the statistical chart.
[0063] Figure 1 The provided data screening method obtains at least one screening information in a statistical chart and the screening priority corresponding to each screening information, and screens in descending order of the screening priority, each screening is based on the screening result of the previous screening, that is: after selecting the first target information from at least one first information included in the first screening information through a first selection operation, at least one second target information corresponding to the first target information is screened out from at least one second information included in the second screening information whose screening priority is one level lower than the screening priority corresponding to the first screening information; if the second screening information is not the screening information with the lowest screening priority among all the screening information, a second target information can be continuously selected from at least one second target information, and subsequent screening operations can be performed based on the selected second target information; if the second screening information is the screening information with the lowest screening priority among all the screening information, For the filtered information with the lowest filtering priority in the information, the third target information selected in at least one second target information can be visualized; for example: if the user wants to determine the change process of the batch number in the online data of Factory A in the statistical chart, the required batch number in the online data of Factory A can be determined by selecting Factory A, the online data in Factory A, and the batch number data in the online data in Factory A at one time. This process does not require the user to determine the parameter item corresponding to each parameter in a large number of parameters, which is conducive to reducing manual workload. In addition, in the above process, the user can select the batch number they want to know from the batch number finally determined, and the statistical process control system automatically visualizes the selected batch number to facilitate the user to intuitively understand the change process of the required batch number, which is conducive to improving the user experience.
[0064] In a feasible implementation manner, the first selection operation is a single selection operation, and the second selection operation is a multiple selection operation.
[0065] Specifically, since different first information may correspond to the same second information in the second filtering information, for example, the identification of factory A corresponds to online data and offline data in the statistical data category, and the identification of factory B also corresponds to online data and offline data in the statistical data category. In this case, when the online data corresponding to the identification of factory A is selected in the statistical category, the online data corresponding to the identification of factory B may interfere with the selection. Similarly, the online data corresponding to the identification of factory A will also interfere with the selection of the online data corresponding to the identification of factory B. In order to avoid this mutual interference, the first selection operation is set to a single selection operation. The object of the second selection operation is the second target data with the lowest filtering priority (i.e., the data of the last level), so there will be no mutual interference. In order to be able to compare and display different second target data, the second selection operation is set to a multiple selection operation.
[0066] In a feasible implementation, the first screening information includes at least one first information corresponding to the data upgrade version, and the step S102 of determining at least one second target information corresponding to the first target information in at least one second information included in the second screening information can be implemented in the following manner:
[0067] A target data upgrade version is determined in at least one data upgrade version; wherein the target data upgrade version is a data upgrade version that includes the first target information in the corresponding first information.
[0068] At least one second target information corresponding to the upgraded version of the target data in the second screening information is determined.
[0069] Specifically, in order to optimize the process production flow, the user will upgrade and modify the process production flow for many times. Each time the upgrade is performed, the process data on the process production flow will also be changed accordingly, that is: each version of the process production flow corresponds to a data upgraded version of process data; therefore, the several process data obtained by the statistical process control system from the manufacturing execution system include at least one process data corresponding to the data upgraded version; thus, the above-mentioned first screening information includes at least one first information corresponding to the data upgraded version, and each data upgraded version corresponds to at least one first information. Similarly, the second screening information also includes at least one second information corresponding to each data upgraded version.
[0070] In specific implementation, when the first target information is selected through the first selection operation, there is a data upgrade version corresponding to the first information that does not include the first target information. Therefore, the second information corresponding to the data upgrade version in the second filtering information also does not include the second target information corresponding to the first target information. Therefore, in order to improve the screening efficiency, the target data upgrade version including the first target information in the corresponding first information is first determined in at least one data upgrade version. After the target data upgrade version is determined, at least one second information corresponding to the target data upgrade version is determined in the second filtering information. The at least one second information corresponding to the determined target data upgrade version includes the second target information corresponding to the first target information. Therefore, at least one second target information corresponding to the first target information can be determined in the at least one second information corresponding to the target data upgrade version.
[0071] For example, the first screening information is process information, which includes process information corresponding to three data upgrade versions, among which the process information corresponding to data upgrade version 1 includes: batch number and product ID, the process information corresponding to data upgrade version 2 includes: batch number, product ID and production equipment ID, and the process information corresponding to data upgrade version 3 includes: batch number and production equipment ID. When the first target data selected by the first selection operation is the production equipment ID, only the process information corresponding to data upgrade version 2 and the process information corresponding to data upgrade version 3 contain the equipment ID, so data upgrade version 2 and data upgrade version 3 are the target data upgrade versions; the second screening data is process parameters, and in the process parameters, the second target information corresponding to the equipment ID in the second information corresponding to data upgrade version 2 is: EQP_ID_1, EQP_ID_2, EQP_ID_3, and the second target information corresponding to the equipment ID in the second information corresponding to data upgrade version 3 is: EQP_ID_1, EQP_ID_2.
[0072] In another feasible implementation scheme, determining at least one second target information corresponding to the first target information in at least one second information corresponding to the target data upgrade version in the second screening information includes: determining a sequence number corresponding to the first target information in at least one first information corresponding to the target data upgrade version, and determining at least one second information in a column field corresponding to the sequence number in at least one second information corresponding to the target data upgrade version, so as to use the second information in the column field as the above-mentioned second target information.
[0073] It should be noted that, in at least one first information corresponding to different target data upgrade versions, the first target information may correspond to different sequence numbers or to the same sequence number, which is not specifically limited here.
[0074] In a feasible implementation manner, after determining at least one second target information corresponding to the first target information, the second target information corresponding to different target data upgrade versions may also be displayed in different display areas of the statistical chart.
[0075] Specifically, in order to enable users to more quickly distinguish the second target information corresponding to different data upgrade versions, the second target information corresponding to different target data upgrade versions can be displayed in different display areas of the statistical chart. It should be noted that the statistical chart is displayed on a graphical user interface.
[0076] For example, the second screening data is a process parameter, and the determined second target information includes: the second target information corresponding to the data upgrade version 2 is: EQP_ID_1, EQP_ID_2, and EQP_ID_3, and the second target information corresponding to the data upgrade version 3 is: EQP_ID_1 and EQP_ID_2; the second target information corresponding to the data upgrade version 2 (i.e., EQP_ID_1, EQP_ID_2, and EQP_ID_3) is displayed in the first display area on the statistical chart, and the second target information corresponding to the data upgrade version 3 (i.e., EQP_ID_1 and EQP_ID_2) is displayed in the second display area on the statistical chart, wherein there is no intersection area between the first display area and the second display area.
[0077] In a feasible implementation manner, the visual display of the third target information in the statistical chart in the above step S104 can be achieved by:
[0078] In the statistical chart, a line graph is created based on the unique identifier of the third target information and the parameter value of the parameter corresponding to the third target information; wherein a node on the line in the line graph is used to represent a piece of third target information.
[0079] For each of the nodes, according to the target color preset for the third target information corresponding to the node, the color of the broken line located on the left side of the node is set to the target color.
[0080] Specifically, in order to facilitate users to more intuitively understand the differences (changing trends) between the selected third target data, a line chart corresponding to each third target data is created, wherein the number of third target information is the same as the number of nodes on the line in the line chart, and for each inflection point, the inflection point is used to represent a third target information, the horizontal coordinate of the inflection point is used to represent the unique identifier of the third target information, and the vertical coordinate of the inflection point is used to represent the parameter value of the parameter corresponding to the third target information; in order to enable users to more clearly distinguish the third target data in the line chart, different colors can be set for different third target data, and then the line on the left side of the inflection point corresponding to the third target data in the line chart is set to the color corresponding to the third target data.
[0081] For example, Figure 2 An example diagram showing a visual display of the third target information provided by the first embodiment of the present application is shown in FIG. Figure 2 As shown, in the statistical chart 200, at least one second target information (LOT_ID) includes: A00200, A00201, A00208, A00210, A00212 and A00229, and the colors corresponding to each LOT_ID are: A00200 corresponds to red, A00201 corresponds to yellow, A00208 corresponds to blue, A00210 corresponds to green, A00212 corresponds to orange, and A00229 corresponds to black. When there is a black circle in the selection box corresponding to the LOT_ID, it means that the LOT_ID is the selected third target information, so A00201, A00208, A00212 and A00229 are all third target information; below the arrow is a line chart created according to the selected third target information, in which the horizontal axis represents the identifier of the third target information (ie: LOT_ID), and the vertical axis represents the parameter value of the parameter corresponding to the third target information, i.e. (Value). The difference between the dividing points on the vertical axis is 0.1 (i.e., the values represented by the dividing points are 0, 0.1, 0.2, 0.3, 0.4, 0.5, 0.6, ... from small to large); on the broken line in the line chart, the breaking point ① is used to represent the third target information A00201, so the horizontal coordinate of the breaking point ① (the corresponding position on the horizontal axis) is A00201, and the color of the broken line on the left side of the breaking point ① is yellow; the breaking point ② is used to represent the third target information A00208 , so the horizontal coordinate of breaking point ② is A00208, and the color of the broken line on the left side of breaking point ② is blue; the color of the broken line on the left side of breaking point ② is yellow; breaking point ③ is used to represent the third target information A00212, so the horizontal coordinate of breaking point ③ is A00212, and the color of the broken line on the left side of breaking point ③ is orange; breaking point ④ is used to represent the third target information A00229, so the horizontal coordinate of breaking point ④ is A00229, and the color of the broken line on the left side of breaking point ④ is black.
[0082] In another feasible implementation scheme, if the selected third target information includes third target information corresponding to at least one data upgrade version, different line graphs are used to represent the third target information corresponding to different data upgrade versions, or different lines on the same line graph are used to represent the third target information corresponding to different data upgrade versions, without specific limitation herein.
[0083] In a feasible implementation scheme, the data screening method can also be implemented in the following manner:
[0084] In response to a second selection operation on a third target information in the at least one second target information, the remaining second target information in the at least one second target information except the third target information is visually displayed in the statistical chart.
[0085] Specifically, the second selection operation may also be an operation for filtering the selected third target information. In this case, in response to the second operation, the remaining second target information in the at least one second target information except the selected third target information is visually displayed.
[0086] For example, the at least one second target information is the batch numbers of three batches, namely: LOT_ID_1, LOT_ID_2 and LOT_ID_3. After LOT_ID_2 is selected through the second selection operation, LOT_ID_1 and LOT_ID_3 are visualized in the statistical chart.
[0087] It should be noted that, for the description of the visual display of the remaining second target information, please refer to the description of the visual display of the second target information, which will not be repeated here.
[0088] Embodiment 2
[0089] Figure 3 A schematic diagram of the structure of a data screening device provided in the second embodiment of the present application is shown. Figure 3 As shown, the data screening device is applied to a statistical process control system, and the data screening device comprises:
[0090] The acquisition module 301 is used to acquire at least one filtering information in the statistical chart of the statistical process control system and the filtering priority corresponding to each filtering information, and use the filtering information with the highest filtering priority in the at least one filtering information as the first filtering information;
[0091] An execution module 302 is configured to respond to a first selection operation on a first target information in at least one first information included in the first filtering information, and determine at least one second target information corresponding to the first target information in at least one second information included in the second filtering information; wherein the filtering priority corresponding to the second filtering information is adjacent to the filtering priority corresponding to the first filtering information and the filtering priority corresponding to the second filtering information is lower than the filtering priority corresponding to the first filtering information;
[0092] A determination module 303 is used to determine whether the screening priority corresponding to the second screening information is the lowest screening priority among the at least one obtained screening priority;
[0093] The processing module 304 is used to, if it is not the lowest screening priority, use the at least one second target information as the at least one first information included in the first screening information, and repeatedly execute step S102, step S103 and step S104 in sequence until the screening priority corresponding to the second screening information is the lowest screening priority among the at least one screening priority obtained; if it is the lowest screening priority, respond to the second selection operation on the third target information in the at least one second target information, and visualize the third target information in the statistical chart; wherein, the step S102 is: respond to the first selection operation on the first target information in the at least one first information included in the first screening information, determine the first target information in the at least one first information included in the second screening information at least one second target information corresponding to the second information; the step S102 is: judging whether the filtering priority corresponding to the second filtering information is the lowest filtering priority among the at least one filtering priority obtained; the step S102 is: if it is not the lowest filtering priority, taking the at least one second target information as the at least one first information included in the first filtering information, and repeatedly executing steps S102, S103 and S104 in sequence until the filtering priority corresponding to the second filtering information is the lowest filtering priority among the at least one filtering priority obtained; if it is the lowest filtering priority, responding to the second selection operation on the third target information in the at least one second target information, visually displaying the third target information in the statistical chart.
[0094] In a feasible implementation manner, the first selection operation is a single selection operation, and the second selection operation is a multiple selection operation.
[0095] In a feasible implementation, the first screening information includes at least one first information corresponding to the data upgrade version, and the execution module 302, when used to determine at least one second target information corresponding to the first target information in at least one second information included in the second screening information, is specifically used to:
[0096] Determine a target data upgrade version in at least one data upgrade version; wherein the target data upgrade version is a data upgrade version that includes the first target information in the corresponding first information;
[0097] At least one second target information corresponding to the upgraded version of the target data in the second screening information is determined.
[0098] In a feasible implementation manner, after determining at least one second target information corresponding to the first target information, the execution module 302 is further used to:
[0099] The second target information corresponding to different target data upgrade versions is displayed in different display areas of the statistical chart.
[0100] In a feasible implementation manner, when the processing module 304 is used to visually display the third target information in the statistical chart, it is specifically used to:
[0101] In the statistical chart, a line graph is created based on the unique identifier of the third target information and the parameter value of the parameter corresponding to the third target information; wherein a node on the line in the line graph is used to represent a piece of third target information;
[0102] For each of the nodes, according to the target color preset for the third target information corresponding to the node, the color of the broken line located on the left side of the node is set to the target color.
[0103] In a feasible implementation scheme, the data screening device further includes:
[0104] The display module is used to respond to the second selection operation of the third target information in the at least one second target information, and visually display the remaining second target information in the at least one second target information except the third target information in the statistical chart.
[0105] The device provided in the embodiment of the present application can be specific hardware on the device or software or firmware installed on the device. The device provided in the embodiment of the present application, its implementation principle and the technical effect produced are the same as those in the aforementioned method embodiment. For the sake of brief description, the parts not mentioned in the device embodiment can refer to the corresponding contents in the aforementioned method embodiment. Those skilled in the art can clearly understand that for the convenience and simplicity of description, the specific working processes of the systems, devices and units described above can all refer to the corresponding processes in the aforementioned method embodiment, and will not be repeated here.
[0106] Embodiment 3
[0107] The embodiment of the present application further provides a computer device 400, Figure 4 A schematic diagram of the structure of a computer device provided in the third embodiment of the present application is shown. Figure 4 As shown, the device includes a memory 401, a processor 402, and a computer program stored in the memory 401 and executable on the processor 402, wherein the memory 401 and the processor 402 are communicatively connected via a bus, and the processor 402 implements the data screening method when executing the computer program.
[0108] Specifically, the above-mentioned memory 401 and processor 402 can be general-purpose memories and processors, which are not specifically limited here. When the processor 402 runs the computer program stored in the memory 401, it can execute the above-mentioned data screening method, solving the problem of large manual workload in the prior art.
[0109] Embodiment 4
[0110] An embodiment of the present application further provides a computer-readable storage medium, on which a computer program is stored. When the computer program is executed by a processor, the steps of the above-mentioned data screening method are executed.
[0111] Specifically, the storage medium can be a general storage medium, such as a mobile disk, a hard disk, etc. When the computer program on the storage medium is run, the above data screening method can be executed, solving the problem of large manual workload in the prior art.
[0112] In the embodiments provided in the present application, it should be understood that the disclosed devices and methods can be implemented in other ways. The device embodiments described above are merely schematic. For example, the division of the units is only a logical function division. There may be other division methods in actual implementation. For example, multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some communication interfaces, and the indirect coupling or communication connection of the devices or units can be electrical, mechanical or other forms.
[0113] The units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed on multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.
[0114] In addition, each functional unit in the embodiments provided in the present application may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit.
[0115] 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 application, 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, which is stored in a storage medium and includes 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 application. The aforementioned storage medium includes: various media that can store program codes, such as a USB flash drive, a mobile hard disk, a read-only memory (ROM), a random access memory (RAM), a magnetic disk or an optical disk.
[0116] It should be noted that similar numbers and letters represent similar items in the following figures. Therefore, once an item is defined in one figure, it does not need to be further defined and explained in subsequent figures. In addition, the terms "first", "second", "third", etc. are only used to distinguish the description and are not to be understood as indicating or implying relative importance.
[0117] Finally, it should be noted that the above-described embodiments are only specific implementation methods of the present application, which are used to illustrate the technical solutions of the present application, rather than to limit them. The protection scope of the present application is not limited thereto. Although the present application is described in detail with reference to the above-mentioned 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-mentioned embodiments within the technical scope disclosed in the present application, 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 application. They should all be included in the protection scope of the present application. Therefore, the protection scope of the present application shall be based on the protection scope of the claims.
Claims
1. A data screening method, characterized in that: Applications in statistical process control systems include: S1: Acquire at least one filtering information in the statistical chart of the statistical process control system and the filtering priority corresponding to each filtering information, and use the filtering information with the highest filtering priority in the at least one filtering information as the first filtering information; the at least one filtering information is the process data of each level in the statistical chart; the filtering priority corresponding to the filtering information is determined according to the level of the filtering information; S2: In response to a first selection operation on a first target information in at least one first information included in the first filtering information, determining at least one second target information corresponding to the first target information in at least one second information included in the second filtering information; wherein the filtering priority corresponding to the second filtering information is adjacent to the filtering priority corresponding to the first filtering information and the filtering priority corresponding to the second filtering information is lower than the filtering priority corresponding to the first filtering information; S3: Determine whether the screening priority corresponding to the second screening information is the lowest screening priority among the at least one obtained screening priority; S4: if it is not the lowest screening priority, taking the at least one second target information as the at least one first information included in the first screening information, and repeatedly executing S2, S3 and S4 in sequence until the screening priority corresponding to the second screening information is the lowest screening priority among the at least one obtained screening priority; if it is the lowest screening priority, in response to the second selection operation on the third target information in the at least one second target information, visually displaying the third target information in the statistical chart; The first screening information includes at least one first information corresponding to a data upgrade version, and the determining of at least one second target information corresponding to the first target information in at least one second information included in the second screening information includes: Determine a target data upgrade version in at least one data upgrade version; wherein the target data upgrade version is a data upgrade version that includes the first target information in the corresponding first information; Determine, in at least one second information corresponding to the target data upgrade version in the second screening information, at least one second target information corresponding to the first target information; Displaying second target information corresponding to different target data upgrade versions in different display areas of the statistical chart; The visual display of the third target information in the statistical chart includes: In the statistical chart, a line graph is created based on the unique identifier of the third target information and the parameter value of the parameter corresponding to the third target information; wherein a node on the line in the line graph is used to represent a piece of third target information; For each of the nodes, according to the target color preset for the third target information corresponding to the node, the color of the broken line located on the left side of the node is set to the target color.
2. The data screening method according to claim 1, characterized in that: The first selection operation is a single selection operation, and the second selection operation is a multiple selection operation.
3. The data screening method according to claim 1, characterized in that: The data screening method further comprises: In response to a second selection operation on a third target information in the at least one second target information, the remaining second target information in the at least one second target information except the third target information is visually displayed in the statistical chart.
4. A data screening device, characterized in that: Applications in statistical process control systems include: an acquisition module, used for acquiring at least one filtering information in the statistical chart of the statistical process control system and the filtering priority corresponding to each filtering information, and taking the filtering information with the highest filtering priority in the at least one filtering information as the first filtering information; the at least one filtering information is the process data of each level in the statistical chart; the filtering priority corresponding to the filtering information is determined according to the level of the filtering information; an execution module, configured to respond to a first selection operation on a first target information in at least one first information included in the first filtering information, and determine at least one second target information corresponding to the first target information in at least one second information included in the second filtering information; wherein the filtering priority corresponding to the second filtering information is adjacent to the filtering priority corresponding to the first filtering information and the filtering priority corresponding to the second filtering information is lower than the filtering priority corresponding to the first filtering information; A determination module, configured to determine whether the screening priority corresponding to the second screening information is the lowest screening priority among the at least one obtained screening priority; a processing module, for, if it is not the lowest screening priority, using the at least one second target information as the at least one first information included in the first screening information, and repeatedly executing S2, S3 and S4 in sequence until the screening priority corresponding to the second screening information is the lowest screening priority among the at least one screening priority obtained; if it is the lowest screening priority, responding to the second selection operation on the third target information in the at least one second target information, visually displaying the third target information in the statistical chart; wherein, S2 is: responding to the first selection operation on the first target information in the at least one first information included in the first screening information, determining whether the first target information is in the at least one first information included in the second screening information at least one second target information corresponding to the second information; said S3 is: judging whether the screening priority corresponding to the second screening information is the lowest screening priority among the at least one screening priority obtained; said S4 is: if it is not the lowest screening priority, taking the at least one second target information as the at least one first information included in the first screening information, and repeatedly executing S2, S3 and S4 in sequence until the screening priority corresponding to the second screening information is the lowest screening priority among the at least one screening priority obtained; if it is the lowest screening priority, responding to the second selection operation on the third target information in the at least one second target information, visually displaying the third target information in the statistical chart; The first screening information includes at least one first information corresponding to a data upgrade version, and the execution module, when used to determine at least one second target information corresponding to the first target information in at least one second information included in the second screening information, is specifically used to: Determine a target data upgrade version in at least one data upgrade version; wherein the target data upgrade version is a data upgrade version that includes the first target information in the corresponding first information; Determine, in at least one second information corresponding to the target data upgrade version in the second screening information, at least one second target information corresponding to the first target information; Displaying second target information corresponding to different target data upgrade versions in different display areas of the statistical chart; When the processing module is used to visually display the third target information in the statistical chart, it is specifically used to: In the statistical chart, a line graph is created based on the unique identifier of the third target information and the parameter value of the parameter corresponding to the third target information; wherein a node on the line in the line graph is used to represent a piece of third target information; For each of the nodes, according to the target color preset for the third target information corresponding to the node, the color of the broken line located on the left side of the node is set to the target color.
5. The data screening device according to claim 4, characterized in that: The first selection operation is a single selection operation, and the second selection operation is a multiple selection operation.
6. A computer device comprising a memory, a processor and a computer program stored in the memory and executable on the processor, characterized in that: When the processor executes the computer program, the steps of the data screening method described in any one of claims 1 to 3 are implemented.
7. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of the data screening method according to any one of claims 1 to 3 are executed.
Citation Information
Patent Citations
Control chart generation method and electronic equipment
CN113139078A
Process information recommendation method and device, storage medium and processor
CN113689113A