CN113887874A - Factory process capability index evaluation method, device, server and storage medium - Google Patents
Factory process capability index evaluation method, device, server and storage medium Download PDFInfo
- Publication number
- CN113887874A CN113887874A CN202111034327.7A CN202111034327A CN113887874A CN 113887874 A CN113887874 A CN 113887874A CN 202111034327 A CN202111034327 A CN 202111034327A CN 113887874 A CN113887874 A CN 113887874A
- Authority
- CN
- China
- Prior art keywords
- file
- capability index
- process capability
- parameters
- downloaded
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 184
- 230000008569 process Effects 0.000 title claims abstract description 155
- 238000011156 evaluation Methods 0.000 title claims abstract description 28
- 238000003860 storage Methods 0.000 title claims abstract description 12
- 238000004364 calculation method Methods 0.000 claims abstract description 64
- 238000004140 cleaning Methods 0.000 claims abstract description 29
- 230000010354 integration Effects 0.000 claims description 7
- 238000004590 computer program Methods 0.000 claims description 5
- 239000000126 substance Substances 0.000 claims description 2
- 238000012360 testing method Methods 0.000 abstract description 23
- 238000012545 processing Methods 0.000 abstract description 21
- 238000010586 diagram Methods 0.000 description 6
- 238000013461 design Methods 0.000 description 4
- 238000012986 modification Methods 0.000 description 3
- 230000004048 modification Effects 0.000 description 3
- 238000012216 screening Methods 0.000 description 3
- 238000005406 washing Methods 0.000 description 3
- 238000001514 detection method Methods 0.000 description 2
- 238000009826 distribution Methods 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 230000002093 peripheral effect Effects 0.000 description 2
- 230000009471 action Effects 0.000 description 1
- 230000003044 adaptive effect Effects 0.000 description 1
- 238000004458 analytical method Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 239000013256 coordination polymer Substances 0.000 description 1
- 230000008676 import Effects 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000000691 measurement method Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
- 239000002994 raw material Substances 0.000 description 1
- 230000000717 retained effect Effects 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
- 239000002699 waste material Substances 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0639—Performance analysis of employees; Performance analysis of enterprise or organisation operations
- G06Q10/06393—Score-carding, benchmarking or key performance indicator [KPI] analysis
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/04—Manufacturing
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Engineering & Computer Science (AREA)
- Economics (AREA)
- Strategic Management (AREA)
- General Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Educational Administration (AREA)
- Marketing (AREA)
- Entrepreneurship & Innovation (AREA)
- Development Economics (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Game Theory and Decision Science (AREA)
- Manufacturing & Machinery (AREA)
- Health & Medical Sciences (AREA)
- General Health & Medical Sciences (AREA)
- Primary Health Care (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The embodiment of the invention relates to the field of data processing, and discloses a method and a device for evaluating a factory process capability index, a server and a storage medium. In the embodiment of the invention, the file to be downloaded is obtained according to each download address; wherein, the file to be downloaded in the download address is updated according to a preset time period; carrying out data cleaning on a file to be downloaded to obtain parameters for calculating a process capability index; loading the parameters to a database; calculating the process capability index according to the parameters in the database; and displaying the calculation result and the parameters. The embodiment of the application is not limited to that the evaluation of the factory process capability index is only in a certain specific format, supports multiple data formats and performs data cleaning, can realize batch processing and calculation of parameters, automatically downloads the mass test data increment of each factory to the local, and loads the increment to the database to integrate the calculation result and display the result by using the report.
Description
Technical Field
The embodiment of the invention relates to the field of data processing, in particular to a method and a device for evaluating a factory process capacity index, a server and a storage medium.
Background
In the process of manufacturing products, process capability (procedure) is the most basic link for ensuring the quality of the products. The process capability refers to an actual processing capability in a steady state, and is a capability of stably producing a product, that is, a processing accuracy which a process has in a steady state under standard conditions such as an operator, machine equipment, a raw material, an operation method, a measurement method, and an environment. Process capability analysis is an important technical basis for quality management. The method is beneficial to mastering the quality of each process, ensures the capability and provides necessary data and basis for product design, process, tool design and equipment maintenance, adjustment, update and modification.
The traditional evaluation of the factory process capability index is generally based on Taiyou CPK software, but when the process capability index is calculated based on the software, the method only supports the import and export of excel format data and is limited by the capacity of the excel data; after the calculation result is obtained, other data sources need to be manually integrated for comprehensive checking, so that the risk of data errors is further increased; in conclusion, the existing process of calculating the process capability index based on software has the problems of complex operation, manual intervention, single evaluation dimension, incapability of comprehensive display and the like.
Disclosure of Invention
The embodiment of the invention aims to provide a method, a device, a server and a storage medium for evaluating a factory process capacity index, so that the factory process capacity index can be automatically calculated in batches and subjected to multi-dimensional comprehensive evaluation and display.
In order to solve the above technical problem, an embodiment of the present invention provides a method for evaluating a plant process capability index, including the following steps: acquiring a file to be downloaded according to each download address; wherein, the file to be downloaded in the download address is updated according to a preset time period; carrying out data cleaning on the file to be downloaded to obtain parameters for calculating the process capability index; loading the parameters to a database; calculating a process capability index according to the parameters in the database; and displaying the calculation result and the parameters.
The embodiment of the invention also provides a plant process capability index evaluation device, which comprises: the downloading module is used for acquiring files to be downloaded according to the downloading addresses; wherein, the file to be downloaded in the download address is updated according to a preset time period; the acquisition module is used for carrying out data cleaning on the file to be downloaded and acquiring parameters for calculating the process capability index; the loading module is used for loading the parameters to a database; the calculation module is used for calculating the process capability index according to the parameters in the database; and the display module is used for displaying the calculation result and the parameters.
An embodiment of the present invention further provides a server, including: at least one processor; and a memory communicatively coupled to the at least one processor; wherein the memory stores instructions executable by the at least one processor to enable the at least one processor to perform the plant process capability index evaluation method described above.
Embodiments of the present invention also provide a computer-readable storage medium storing a computer program that, when executed by a processor, implements the plant process capability index evaluation method described above.
The embodiment of the application does not limit that the evaluation of the factory process capability index is only in a certain specific format, reduces the steps of processing the data source format of the parameters, and avoids the limitation of the data format on the processable data quantity. The efficiency of calculating and evaluating the factory process capability index is improved, and the links of manual data export processing and merging and displaying can be avoided due to the support of the input and calculation of various data formats, so that the labor cost and the time cost are reduced.
In addition, the data cleaning of the file to be downloaded to obtain parameters for calculating the process capability index includes: acquiring a file which accords with a preset format in the file to be downloaded; acquiring a readable file in the files conforming to the preset format; and classifying and integrating the data in the readable file to obtain the parameters for calculating the process capability index. And the cleaning action is executed according to the preset sequence, so that the complexity of the data cleaning process can be reduced, the data cleaning speed is increased under the condition of ensuring the completion degree of the data cleaning step, and the occupation of computing resources in the data cleaning process is reduced.
In addition, the classifying and integrating the data in the readable file to obtain the parameter for calculating the process capability index includes: classifying and integrating data in the readable file; merging the integrated data into a preset table; and acquiring parameters for calculating the process capability index according to the preset table. And the classified and integrated data are listed in a table form, so that unified standardized management can be conveniently carried out on the data.
In addition, the classifying and integrating the data in the readable file comprises: splitting the data in the readable file according to the content attribute, wherein the splitting result is in a format capable of executing calculation; and classifying the splitting result according to a work order to obtain an integration result of the data in the readable file. The cleaned files are split and integrated, so that the calculation efficiency can be improved; and classifying the split result according to the work order, so that the targeted calculation and the comprehensive display of a certain work order are facilitated.
In addition, before the file to be downloaded is obtained according to each download address, the method further includes: and acquiring the file name of each file to be downloaded according to each download address, wherein the file name is used for carrying out unified management on the files. Since the embodiment can acquire and process a plurality of files and the file formats are not necessarily uniform, acquiring the file names at first can facilitate batch and fast management of the files.
In addition, the obtaining of the file to be downloaded according to each download address includes: and acquiring the file to be downloaded according to the file name and the download address. After the file name of the file to be downloaded is acquired, the file in the download address can be downloaded according to the file name of the file to be downloaded, so as to save the download time,
in addition, the calculation of the process capability index according to the parameters comprises the following steps: if the process capability index is configured to be the default mode, calculating the process capability index according to the default mode and the parameters; and if the configuration is in the non-default mode, receiving an instruction input by a user, and calculating the process capability index according to the user instruction and the parameters. The calculation mode of the process capability index is flexible, and adaptive adjustment can be performed by combining with the user requirements, so that the user experience is improved.
Drawings
One or more embodiments are illustrated by way of example and not by way of limitation in the figures of the accompanying drawings in which elements having the same reference numeral designations represent like elements and in which the figures are not to scale unless specifically stated.
FIG. 1 is a flow chart of a method for evaluating a process capability index of a plant according to one embodiment of the present application;
FIG. 2 is a first schematic diagram of a first method for evaluating a plant process capability index according to an embodiment of the present application;
FIG. 3 is a second schematic diagram of a plant process capability index evaluation method according to an embodiment of the present application;
FIG. 4 is a third schematic diagram of a plant process capability index evaluation method according to one embodiment of the present application;
FIG. 5 is a fourth schematic diagram of a plant process capability index evaluation method according to one embodiment of the present application;
FIG. 6 is a first schematic illustration showing a method for evaluating a plant process capability index according to an embodiment of the present application;
FIG. 7 is a second schematic illustration of a plant process capability index evaluation method according to an embodiment of the present application;
FIG. 8 is a third illustration of a plant process capability index evaluation method according to an embodiment of the present application;
FIG. 9 is a fourth illustration of a plant process capability index evaluation method according to an embodiment of the present application;
FIG. 10 is a fifth illustration of a method for evaluating a plant process capability index according to an embodiment of the present application;
FIG. 11 is a schematic diagram of a plant process capability index evaluation apparatus according to one embodiment of the present application;
fig. 12 is a schematic structural diagram of a server according to an embodiment of the present application.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention more apparent, embodiments of the present invention will be described in detail below with reference to the accompanying drawings. However, it will be appreciated by those of ordinary skill in the art that numerous technical details are set forth in order to provide a better understanding of the present application in various embodiments of the present invention. However, the technical solution claimed in the present application can be implemented without these technical details and various changes and modifications based on the following embodiments. The following embodiments are divided for convenience of description, and should not constitute any limitation to the specific implementation manner of the present invention, and the embodiments may be mutually combined and cited without contradiction.
The terms "first" and "second" in the embodiments of the present application are used for descriptive purposes only and are not to be construed as indicating or implying relative importance or implicitly indicating the number of technical features indicated. Thus, a feature defined as "first" or "second" may explicitly or implicitly include at least one such feature. In the description of the present application, the terms "comprise" and "have" and any variations thereof, are intended to cover non-exclusive inclusions. For example, a system, product or apparatus that comprises a list of elements or units is not limited to only those elements or units but may alternatively include other elements or units not expressly listed or inherent to such product or apparatus. In the description of the present application, "plurality" means at least two, e.g., two, three, etc., unless explicitly specifically limited otherwise.
One embodiment of the invention relates to a plant process capability index evaluation method. The specific flow is shown in figure 1.
103, loading the parameters to a database;
104, calculating a process capability index according to the parameters in the database;
and 105, displaying the calculation result and the parameters.
In the embodiment, the evaluation of the factory process capacity index is not limited to be only in a certain specific format, the steps of processing the data source format of the parameter are reduced, the limitation on the processable data amount caused by the data format is avoided, meanwhile, in the embodiment of the application, a plurality of data formats are supported, data cleaning is carried out, the batch processing and calculation of the parameter can be realized, the mass test data increment of each factory is automatically downloaded to the local, and the increment is loaded to the database to be displayed by a report form of the result of the integrated calculation. The efficiency of calculating and evaluating the factory process capability index is improved, and the links of manual data export processing and merging and displaying can be avoided due to the support of the input and calculation of various data formats, so that the labor cost and the time cost are reduced.
The following describes implementation details of the plant process capability index evaluation method according to the present embodiment in detail, and the following is only provided for easy understanding and is not necessary for implementing the present embodiment.
In step 101, obtaining a file to be downloaded according to each download address; and updating the file to be downloaded in the download address according to a preset time period. The updating comprises adding a new file to be downloaded through automatic capture, or deleting part of the file to be downloaded according to a user instruction; the preset time period can be adaptively modified according to actual needs. The format of the file to be downloaded is not limited to be only a specific type, for example, the file supports unstructured data formats txt, CSV (character Separated Values), excel, and the like, and for the database supports sql server (Structured Query Language), mysql (relational database management system), excel, and the like, various data sources of a data acquisition channel (for example, inside a company) can be integrated, including text type and database data, so as to avoid generating a data island problem. In one example, the file to be downloaded is loaded to the designated directory according to each download address, so that subsequent centralized processing is conveniently executed.
In one example, the download address may be obtained by receiving user input; or reading path data one by one when downloading is required to be executed, wherein the path data can be a set of preset downloading addresses, and the path data supports batch management of the downloading addresses. When the download addresses are read from the path data one by one, a loop mode may be adopted, that is, after reading one by one according to a certain sequence, reading is performed from the beginning in a recirculation manner, so as to ensure that the changed download addresses, such as newly added download addresses, in the path data can be obtained.
In one example, before obtaining the file to be downloaded according to each download address, it is determined whether the download address is valid, where the valid download addresses include, but are not limited to: there are download addresses of the undeleted files, new download addresses after change, and the like. For example, after a file in a download address is downloaded, a download completion identifier is added to the downloaded file, when it is detected that the file in a download address has the download completion identifier, the download address is classified as an invalid address, and when it is detected that the file in the download address does not carry the download completion identifier, the download address is an effective address. Only the effective download address is processed, so that the download resource can be effectively utilized, the file download efficiency is improved, and the resource occupation of subsequent processing of the repeated file is avoided.
In one example, before obtaining the file to be downloaded according to each download address, the method further includes: and obtaining the file name of each file to be downloaded according to each download address, wherein the file name is used for carrying out unified management on the files. Because the embodiment can acquire and process a plurality of files and the file formats are not necessarily uniform, in order to manage the files, before downloading the files, the file names of the files can be acquired, for example, the file names to be downloaded are arranged in a table form, and the data in the table can be identified conveniently and quickly, so that the file management process can be executed in batch and quickly. In one example, the File names to be downloaded may be obtained from an FTP (File Transfer Protocol) server according to the download address, the obtained File names to be downloaded are combined into an xml File format, the xml File is stored in a specific directory (e.g., ETL _ CPK _ excel File), and the File names of the files to be downloaded are read by parsing the xml File, so as to improve the obtaining speed of the File names. In addition, it is understood that the table may also include the file names of the downloaded files, for example, the table composed of the file names to be downloaded and the table composed of the file names of the downloaded files are merged.
In one example, the obtaining the file to be downloaded according to each download address includes: and acquiring the file to be downloaded according to the file name and the downloading address. After the file name of the file to be downloaded is obtained, the file in the download address can be downloaded according to the file name of the file to be downloaded, so that the download time is saved, the re-detection on whether the file is effective or not is reduced, and the file download efficiency is improved. After the file is downloaded, the download mark of the file is updated, so that subsequent inquiry or judgment on whether the file is downloaded is facilitated. For example, the file to be downloaded may be quickly loaded to a specified directory according to the file name and the download address.
In addition, parameters such as factory names and the like for assisting in evaluating the factory process capability indexes or facilitating visual display can be obtained. The method is used for assisting in classifying and comparing and displaying the calculation results, and is shown in FIG. 2. In one example, path data, factory name, valid or invalid identifiers, etc. are first obtained as initial preparations for the calculation process; the factory name is used for identifying which factory the result obtained in the calculation process belongs to, and the effective identification can assist in judging whether the acquired path data is available, for example, if the effective identification does not indicate that no new download address is added in the path data and no new file to be downloaded is added in the existing download address, or the path data is refused to be used in combination with actual conditions; in some instances, it may be selected to receive user input or not to perform a subsequent download process. Secondly, circularly reading a download address from the path data, and immediately acquiring a file to be downloaded after the download address is read, so that the file to be downloaded can be in an incremental loading state; specifically, before the file to be downloaded is acquired, the file name of the file to be downloaded is formed into an xml format file, so that batch operation and management of the file to be downloaded are facilitated; the name of the file to be downloaded can be analyzed and read by the xml and then stored into an appointed downloading directory (such as ETL _ CPK _ excelFile), and subsequent operations are carried out on the file under the directory, so that the interference of an external file on the calculation process is avoided; when the download file is acquired, the files to be downloaded can be downloaded one by one in a circulating manner according to the download address and the file name, and the download mark of the files is updated to be downloaded after the files are downloaded.
In an example, the present embodiment can refer to SSIS (Microsoft SQL Server Integration Services, which generates a high performance data Integration solution) for execution, for example, a test log file is downloaded from an FTP Server, a download address of a file to be downloaded is read from a path of a configuration table as a result set, the result set is transferred to an internal outer loop, each download address in the result set is transferred to the internal loop through the outer loop, a file at the download address is traversed and downloaded, a download status flag corresponding to the file is updated after the file is downloaded, and the file is prevented from being repeatedly downloaded next time, so as to implement incremental downloading of the file in the same directory.
In step 102, data cleaning is performed on the file to be downloaded, and parameters for calculating the process capability index are obtained. That is, in the acquired file, there may be situations such as file error, file parameter error, or parameter failure to participate in the calculation, so the acquired source data needs to be cleaned and then participate in the calculation, thereby reducing the waste of calculation resources and improving the calculation efficiency. Among the parameters used to calculate the process capability index are, for example: maximum, minimum, sample specification upper limit USL, sample specification lower limit LSL, etc.
In one example, the data washing of the file to be downloaded to obtain parameters for calculating the process capability index includes: acquiring a file which accords with a preset format in the file to be downloaded; acquiring a readable file in the files conforming to the preset format; and classifying and integrating the data in the readable file to obtain the parameters for calculating the process capability index. In the process of partial data cleaning, cleaning is carried out in sequence according to the sequence of parameters in files after a file main body is firstly cleaned, and because unopened files are firstly screened, and then the parameters in the screened and opened files are selected, the complexity of the data cleaning process can be reduced, the data cleaning speed is increased under the condition of ensuring the completion degree of the data cleaning step, and the occupation of computing resources in the data cleaning process is reduced.
Specifically, the cleaning of the document includes but is not limited to: detecting the file name, judging whether the file is a file capable of being processed, for example, if the file name contains 'pass' marked in the downloading process, performing the next screening process on the file; and (4) attempting to open the file, and entering a screening process for parameters in the file if the file can be opened. The washing for the parameters includes: detecting parameters in the opened files, and selecting files with the parameters meeting requirements; among them, the case that meets the requirements is, for example: depending on the purpose of the calculation, the parameters in the file include sample specification upper or lower limits, and the like. Optionally, for files which cannot be processed, files which cannot be opened, files which do not meet requirements, and the like, the relevant process identifiers are updated and archived, so that subsequent process query is facilitated.
In one example, the classifying and integrating the data in the readable file comprises: splitting data in the readable file according to content attributes, wherein the splitting result is in a format capable of executing calculation; and classifying the splitting result according to the work order, the test item and the jig to obtain an integration result of the data in the readable file. For example, the content attributes include: file head (title), file main part (body), self-defined label etc. can carry out the rapid calculation after for the convenience, will be carried out the split integration by the file of washing to improve calculation efficiency, and classify the result after the split according to worksheet, test item and tool, be convenient for carry out the pertinence calculation and to the comprehensive show of certain worksheet, can also calculate and show according to test item and tool. Further, the method can also comprise classifying according to the specific number of the jig. It can be known that, this embodiment should be used in the detection calculation and the show process to factory process ability, carries out classification calculation and show according to work order, test item and tool etc. more accords with the user's demand in the practical application process, improves user experience.
In step 103, the parameters are loaded into the database. The parameters cleaned in the server are loaded into the database of the server, and the calculation process of the parameters is executed by utilizing the efficient calculation capacity of the database. If the file to be downloaded is loaded to the specified directory in the step of obtaining the file to be downloaded, the specified directory and the database are in a butt-joint relation, namely the file in the specified directory can be directly sent to the database, and the database obtains the file from the specified directory, so that the interference of an external file to the calculation process is avoided.
In one example, the classifying and integrating the data in the readable file to obtain the parameter for calculating the process capability index includes: classifying and integrating data in the readable file; merging the integrated data into a preset table; and acquiring parameters for calculating the process capability index according to the preset table. In this embodiment, multiple formats and parameters without limitation to specific numbers can be processed, and after the parameters are cleaned and classified, the classified and integrated data column can be selected to be in a table form, so as to facilitate uniform and standardized management of the data column, for example, related contents are filled into a preset table, and the contents in the preset table are loaded into a database. According to the content or the custom label in the preset table, the subsequent loading process of the newly added parameters or the parameters of the specific type to the database can be conveniently and accurately carried out.
In addition, the preset table can be divided into a temporary table and a physical table, the integrated parameters acquired in each cycle are classified into the temporary table, the contents in the established temporary table are classified into the physical table, and the data which is in error when the temporary table is established are deleted in the process of classifying the contents in the temporary table into the physical table, so that the effective rate of the data in the physical table is further ensured. The physical table comprises a work order, a file name corresponding to the work order, a splitting result corresponding to the file name and the like, after contents are all put into the physical table, the temporary table is deleted, and data loaded into the database are obtained from the physical table. In this embodiment, the preset table is divided into a temporary table and a physical table, and the integrated data is archived step by step, so that the processes of cleaning and screening the data can be further performed, and the accuracy and the availability of the data acquired by the database can be ensured.
When data in the preset table is integrated into the physical table, data which can be obtained only through identification and needs to participate in calculation, such as a maximum value, a minimum value, a sample specification upper limit USL, a sample specification lower limit LSL, and the like, may be selected to be stored.
Optionally, the files that are removed in the cleaning process are added with corresponding labels and filed in the historical data for filing, so that subsequent reference is facilitated, the correct retained data in the cleaning process can be filed and stored, and the loading condition of the files is updated after filing, for example, the file is identified which step is filed for which reason. In particular, reference may be made to the fig. 3 example. The file name is acquired first, so that management or batch operation is facilitated. Secondly, detecting whether the file format of the file to be downloaded is correct according to the file name, namely judging whether the file format is a file format which can be processed in the calculation process, if the file format is wrong, the calculation process cannot be processed, then filing the file with the wrong format, writing the file into a history record, and optionally updating the loading condition of the file with the wrong format, such as marking the file format as wrong; if the file name is correct, it means that the calculation process can process the file in the format, immediately try to open the file corresponding to the file name in the correct format, and if the file name is failed to open, perform an archiving operation on the file that is failed to open, optionally, update the loading condition of the file that is failed to open, for example, mark the file as failed to open. And then performing parameter cleaning on the successfully opened file, wherein the parameter cleaning process comprises the following steps: reading the file content, caching the read file content in the temporary table, merging the content in the temporary table into the physical table, archiving the content in the physical table (i.e., performing history archiving), and updating the loading condition of the file corresponding to the content in the physical table, for example, updating to a loading success condition. The method comprises the steps of acquiring parameters to be cleaned in the process of reading the file content, detecting the parameters in the opened file in the process of reading the file content, and selecting the file with the parameters meeting the requirements; among them, the case that meets the requirements is, for example: depending on the purpose of the calculation, the parameters in the file include sample specification upper or lower limits, and the like. The files after the archiving operation can inquire corresponding processing states or processing results in the subsequent processing process.
In addition, as shown in fig. 4, a newly added test item can be selected according to parameters in the preset table for processing, if a newly added test item has a newly added jig, the newly added test item and the jig under the newly added test item are calculated, and the calculation result is displayed; and if the newly added test item does not have a newly added jig, only calculating and displaying the newly added test item. Optionally, the calculation result is stored in the original preset table (or physical table), and besides displaying, data archiving can be performed, so that subsequent query execution is facilitated.
In an example, in the execution process of this embodiment, the SSIS may be referred to, a local test log file is loaded into the database, the downloaded test log file is circularly traversed and loaded and merged into the database, and the loaded test log file is automatically transferred to an archive directory for storage (i.e., the loaded file is archived, which is convenient for subsequent operations such as querying history information).
In step 104, a process capability index is calculated based on the parameters in the database. And according to the result required to be displayed or the preset target result, performing calculation on the parameters acquired from the database, wherein the calculation includes normal distribution value calculation, process precision, process capability index, process accuracy, specification tolerance and the like.
Specifically, the calculation can be made with reference to the following formula: for example, the standard deviation delta and the mean value are calculated according to the collected data
For sample standard deviation δ:
for mean value
Thereby obtaining the process capability index CPK,
for the process capability index CPK:
for the requirement with only the upper specification limit, the process capability index CPU without the requirement for the lower specification limit:
for the requirement with only the lower specification limit, the process capability index CPL without the requirement on the upper specification limit:
in addition, the following parameters can be calculated and subsequently displayed, and various references are provided for users:
for the sample variance v:
for group distance GroupInterval:
for group coordinate values GroupCoordinates:
for normal distribution value NormalDistribution:
for frequency frequecount:
for process precision CP:
for the specification tolerance T: t is USL-LSL;
for process accuracy CA:
TargetValue target value.
In one example, the calculation of the process capability index based on the parameters includes: if the configuration is a default mode, calculating a process capability index according to the default mode and the parameters; if the configuration is in the non-default mode, receiving an instruction input by a user, and calculating a process capability index according to the user instruction and the parameters, as shown in fig. 5. For example, in some settings, there is a default plan that sets the number of packets to 30, the sample specification upper limit USL, the sample specification lower limit LSL, and the average value as target values, δ to 3, etc.; in some settings, some values that need to participate in the calculation but cannot be directly obtained from the parameters are not specified, that is, the user needs to receive instruction input so that the calculation process can be executed.
In step 105, the calculation results and parameters are shown. For the calculation result, the table and the table can be respectively displayed, or the table and the table can be displayed in combination, as shown in the example of fig. 6, and the parameters obtained in the comprehensive calculation process are displayed together, so that the user can conveniently and comprehensively inquire and know the relevant indexes, and the user experience is improved.
In one example, the split result is classified according to a major category and a minor category, the major category may include work orders, test items, jigs, etc., and the minor category may include specific jig numbers, etc. The corresponding final presentation interface can be referred to as shown in fig. 7 to 10. Fig. 7 is a first interface displayed according to a work order, a test item, and a fixture, as shown in fig. 7, a selected test item (WB8-Tx-Power-Max) can enter a CPK comprehensive display interface for more details of the test item, and fig. 8 is a display result after the test item is selected according to the display interface of fig. 7. Fig. 9 is a second interface displayed according to the work order, the test item, and the fixture, as shown in fig. 9, the specific number of the selected fixture can enter a more detailed CPK integrated display interface of the fixture, and fig. 10 is a display result after the fixture number is selected according to the display interface of fig. 9.
In one example, the displaying step can be implemented by referring to SSRS (structured query language Reporting Services, a practical tool for developing and publishing reports), which includes developing reports based on database data, displaying the combined result, and configuring and defaulting coordinate axes of a page chart in a user-defined manner according to process capability index information counted by dimensions of factories, work orders, test items and tool numbers.
In one example, the database may be an SQL server database, and is used to obtain result data generated by SSIS calculation and store processes, and the SSRS report page shows the required storage processes.
In one example, the data can be accessed by other application terminals as a data source in addition to being directly exposed through a report page.
Additionally, historical step caching for files, identifying batch changes, transferring loaded files, etc., may be performed by DOS batching.
The steps of the above methods are divided for clarity, and the implementation may be combined into one step or split some steps, and the steps are divided into multiple steps, so long as the same logical relationship is included, which are all within the protection scope of the present patent; it is within the scope of the patent to add insignificant modifications to the algorithms or processes or to introduce insignificant design changes to the core design without changing the algorithms or processes.
In the embodiment, the evaluation of the plant process capability index is not limited to a specific format, the steps of processing the data source format of the parameter are reduced, and the limitation of the data format on the processable data amount is avoided. The efficiency of calculating and evaluating the factory process capability index is improved, and the links of manual data export processing and merging and displaying can be avoided due to the support of the input and calculation of various data formats, so that the labor cost and the time cost are reduced.
One embodiment of the present invention relates to a plant process capability index evaluation device, as shown in fig. 11, including:
a downloading module 201, configured to obtain a file to be downloaded according to each downloading address; wherein, the file to be downloaded in the download address is updated according to a preset time period;
an obtaining module 202, configured to perform data cleaning on the file to be downloaded, and obtain a parameter for calculating a process capability index;
a loading module 203, configured to load the parameter into a database;
a calculation module 204, configured to calculate a process capability index according to the parameters in the database;
a display module 205, configured to display the calculation result and the parameter.
In the downloading module 201, in an example, before obtaining the file to be downloaded according to each downloading address, the method further includes: and acquiring the file name of each file to be downloaded according to each download address, wherein the file name is used for carrying out unified management on the files.
In one example, the obtaining the file to be downloaded according to each download address includes: and acquiring the file to be downloaded according to the file name and the downloading address.
In the obtaining module 202, in an example, the data cleansing the file to be downloaded to obtain a parameter for calculating a process capability index includes: acquiring a file which accords with a preset format in the file to be downloaded; acquiring a readable file in the files conforming to the preset format; and classifying and integrating the data in the readable file to obtain the parameters for calculating the process capability index.
In one example, the classifying and integrating the data in the readable file to obtain the parameter for calculating the process capability index includes: classifying and integrating data in the readable file; merging the integrated data into a preset table; and acquiring parameters for calculating the process capability index according to the preset table.
In one example, the classifying and integrating the data in the readable file comprises: splitting data in the readable file according to content attributes, wherein the splitting result is in a format capable of executing calculation; and classifying the splitting result according to a work order to obtain an integration result of the data in the readable file.
In the calculation module 204, the calculation of the process capability index according to the parameters includes: if the process capability index is configured to be the default mode, calculating the process capability index according to the default mode and the parameters; and if the configuration is in the non-default mode, receiving an instruction input by a user, and calculating the process capability index according to the user instruction and the parameters.
The embodiment of the application does not limit that the evaluation of the factory process capability index is only in a certain specific format, reduces the steps of processing the data source format of the parameters, and avoids the limitation of the data format on the processable data quantity. The efficiency of calculating and evaluating the factory process capability index is improved, and the links of manual data export processing and merging and displaying can be avoided due to the support of the input and calculation of various data formats, so that the labor cost and the time cost are reduced.
It should be understood that this embodiment is a system example corresponding to the above embodiment, and that this embodiment can be implemented in cooperation with the above embodiment. The related technical details mentioned in the above embodiments are still valid in this embodiment, and are not described herein again in order to reduce repetition. Accordingly, the related-art details mentioned in the present embodiment can also be applied to the above-described embodiments.
It should be noted that all the modules related in this embodiment are logical modules, and in practical application, one logical unit may be one physical unit, may be a part of one physical unit, and may be implemented by a combination of multiple physical units. In addition, in order to highlight the innovative part of the present invention, elements that are not so closely related to solving the technical problems proposed by the present invention are not introduced in the present embodiment, but this does not indicate that other elements are not present in the present embodiment.
One embodiment of the invention relates to a server, as shown in fig. 12, comprising at least one processor 301; and the number of the first and second groups,
a memory 302 communicatively coupled to the at least one processor 301; wherein the content of the first and second substances,
the memory 302 stores instructions executable by the at least one processor 301 to enable the at least one processor 301 to perform the plant process capability index evaluation method described above.
Where the memory and processor are connected by a bus, the bus may comprise any number of interconnected buses and bridges, the buses connecting together one or more of the various circuits of the processor and the memory. The bus may also connect various other circuits such as peripherals, voltage regulators, power management circuits, and the like, which are well known in the art, and therefore, will not be described any further herein. A bus interface provides an interface between the bus and the transceiver. The transceiver may be one element or a plurality of elements, such as a plurality of receivers and transmitters, providing a means for communicating with various other apparatus over a transmission medium. The data processed by the processor is transmitted over a wireless medium via an antenna, which further receives the data and transmits the data to the processor.
The processor is responsible for managing the bus and general processing and may also provide various functions including timing, peripheral interfaces, voltage regulation, power management, and other control functions. And the memory may be used to store data used by the processor in performing operations.
One embodiment of the present invention relates to a computer-readable storage medium storing a computer program. The computer program realizes the above-described method embodiments when executed by a processor.
That is, as those skilled in the art can understand, all or part of the steps in the method of the embodiments described above may be implemented by a program to instruct related hardware, where the program is stored in a storage medium and includes several instructions to enable a device (which may be a single chip, a chip, etc.) or a processor (processor) to execute all or part of the steps of the method described in the embodiments of the present application. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and the like.
It will be understood by those of ordinary skill in the art that the foregoing embodiments are specific examples of implementing the invention, and that various changes in form and details may be made therein without departing from the spirit and scope of the invention in its practical application.
Claims (10)
1. A method for evaluating a plant process capability index, comprising:
acquiring a file to be downloaded according to each download address; wherein, the file to be downloaded in the download address is updated according to a preset time period;
carrying out data cleaning on the file to be downloaded to obtain parameters for calculating the process capability index;
loading the parameters to a database;
calculating a process capability index according to the parameters in the database;
and displaying the calculation result and the parameters.
2. The method for evaluating the plant process capability index according to claim 1, wherein the data cleaning the file to be downloaded to obtain the parameters for calculating the process capability index comprises:
acquiring a file which accords with a preset format in the file to be downloaded;
acquiring a readable file in the files conforming to the preset format;
and classifying and integrating the data in the readable file to obtain the parameters for calculating the process capability index.
3. The method according to claim 2, wherein the classifying and integrating the data in the readable file to obtain the parameter for calculating the process capability index comprises:
classifying and integrating data in the readable file;
merging the integrated data into a preset table;
and acquiring parameters for calculating the process capability index according to the preset table.
4. The method according to claim 2, wherein the classifying and integrating the data in the readable file comprises:
splitting data in the readable file according to content attributes, wherein the splitting result is in a format capable of executing calculation;
and classifying the splitting result according to a work order to obtain an integration result of the data in the readable file.
5. The method for evaluating the plant process capability index according to claim 1, wherein before the obtaining the file to be downloaded according to each download address, the method further comprises:
and acquiring the file name of each file to be downloaded according to each download address, wherein the file name is used for carrying out unified management on the files.
6. The method for evaluating the plant process capability index according to claim 5, wherein the obtaining the file to be downloaded according to each download address comprises:
and acquiring the file to be downloaded according to the file name and the download address.
7. The plant process capability index evaluation method of any of claims 1 to 6, wherein the calculating of the process capability index from the parameters comprises:
if the process capability index is configured to be the default mode, calculating the process capability index according to the default mode and the parameters;
and if the configuration is in the non-default mode, receiving an instruction input by a user, and calculating the process capability index according to the user instruction and the parameters.
8. A plant process capability index evaluation device, comprising:
the downloading module is used for acquiring files to be downloaded according to the downloading addresses; wherein, the file to be downloaded in the download address is updated according to a preset time period;
the acquisition module is used for carrying out data cleaning on the file to be downloaded and acquiring parameters for calculating the process capability index;
the loading module is used for loading the parameters to a database;
the calculation module is used for calculating the process capability index according to the parameters in the database;
and the display module is used for displaying the calculation result and the parameters.
9. A server, comprising:
at least one processor; and the number of the first and second groups,
a memory communicatively coupled to the at least one processor; wherein the content of the first and second substances,
the memory stores instructions executable by the at least one processor to enable the at least one processor to perform the plant process capability index evaluation method of any one of claims 1 to 7.
10. A computer-readable storage medium storing a computer program, wherein the computer program, when executed by a processor, implements the plant process capability index evaluation method of any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111034327.7A CN113887874A (en) | 2021-09-03 | 2021-09-03 | Factory process capability index evaluation method, device, server and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111034327.7A CN113887874A (en) | 2021-09-03 | 2021-09-03 | Factory process capability index evaluation method, device, server and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113887874A true CN113887874A (en) | 2022-01-04 |
Family
ID=79012341
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111034327.7A Pending CN113887874A (en) | 2021-09-03 | 2021-09-03 | Factory process capability index evaluation method, device, server and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113887874A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114676152A (en) * | 2022-04-08 | 2022-06-28 | 北京自如信息科技有限公司 | Work order management method and device and electronic equipment |
| US11797795B1 (en) | 2022-06-02 | 2023-10-24 | Soochow University | Intelligent speed regulation system of connector production apparatus |
| WO2023231197A1 (en) * | 2022-06-02 | 2023-12-07 | 苏州大学 | Intelligent speed regulation system for connector production apparatus |
-
2021
- 2021-09-03 CN CN202111034327.7A patent/CN113887874A/en active Pending
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114676152A (en) * | 2022-04-08 | 2022-06-28 | 北京自如信息科技有限公司 | Work order management method and device and electronic equipment |
| US11797795B1 (en) | 2022-06-02 | 2023-10-24 | Soochow University | Intelligent speed regulation system of connector production apparatus |
| WO2023231197A1 (en) * | 2022-06-02 | 2023-12-07 | 苏州大学 | Intelligent speed regulation system for connector production apparatus |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN113887874A (en) | Factory process capability index evaluation method, device, server and storage medium | |
| US8700671B2 (en) | System and methods for dynamic generation of point / tag configurations | |
| CN108228229B (en) | Method and system for managing Maven dependence | |
| CN110968509B (en) | Method and system for batch customizing of variables | |
| CN111385365B (en) | Processing method and device for reported data, computer equipment and storage medium | |
| CN111400288A (en) | Data quality inspection method and system | |
| CN112364024B (en) | Control method and device for automatic comparison of table data in batches | |
| CN111190792A (en) | Log storage method and device, electronic equipment and readable storage medium | |
| CN111460232A (en) | Functional module searching method, device, terminal and computer readable storage medium | |
| CN109086476B (en) | Data processing method for drawing design, PLM plug-in and computing equipment | |
| CN113220322A (en) | Test software updating method, electronic device and storage medium | |
| CN111221742A (en) | Test case updating method and device, storage medium and server | |
| CN115936590A (en) | Automatic processing system for engineering files | |
| CN106570193B (en) | Method for loading time sequence big data | |
| CN114661764A (en) | Method and device for automatically generating cable production information and storage medium | |
| CZ307278B6 (en) | The method of transferring structures and data files between the source and target system and a system for its implementation | |
| CN110866005A (en) | Internet of things data acquisition management method and system, storage medium and terminal | |
| CN115455010B (en) | Data processing method based on milvus database, electronic equipment and storage medium | |
| CN115827452B (en) | Data processing type test system, method, storage medium and equipment | |
| CN112612255B (en) | Data acquisition method and device, electronic equipment and storage medium | |
| CN112148459B (en) | Processing method, device, readable medium and equipment for node association data | |
| CN116010349B (en) | Metadata-based data checking method and device, electronic equipment and storage medium | |
| CN109905475B (en) | Method for outputting cloud computing monitoring data in specified format based on SQL | |
| CN115420944B (en) | But intelligent ammeter of electric quantity analysis and inquiry based on bluetooth communication | |
| CN114611473B (en) | Generation method of inspection execution file and electronic equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |