Tightening quality determination method and system based on tightening data and electronic equipment
By acquiring and analyzing the correspondence between master data and product data in the tightening controller, the accuracy and reliability of tightening quality analysis were solved, improving support for production management and the stability of the production line.
Patent Information
- Application Number
- CN202411122584.X
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-08-15
- Publication Date
- 2024-11-26
AI Technical Summary
Existing tightening controllers face complex defects such as stick-slip and jamming in automobile manufacturing, resulting in insufficient accuracy and reliability of tightening quality analysis. They are also unable to cope with the influence of different production lines and environmental factors, affecting production efficiency and product quality stability.
By acquiring the master data bound to the tightening controller, collecting tightening and product data, establishing corresponding relationships, performing steady-state data analysis, including range and normal distribution analysis, calculating process capability index and performance index, identifying abnormal data, generating tightening quality scores, and realizing tightening quality analysis under different production environments.
It improved the reliability of tightening quality analysis, enhanced support for production management, reduced rework rates, and improved the stability and efficiency of the production line.
Smart Images

Figure CN119024787A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the technical field of production management, and in particular to a method, system and electronic equipment for determining tightening quality based on tightening data. Background Art
[0002] In the precision assembly process of the automotive manufacturing industry, threaded connections play a core role in building the structural integrity and functionality of vehicles, and their quality stability is directly related to the overall performance and safety of the vehicle. As a key device in this critical link, the tightening controller is responsible for accurately regulating the operation of the tightening gun, aiming to ensure that each threaded connection can accurately reach the preset torque and angle standards to ensure the firmness and reliability of the connection. However, the challenges faced by the tightening controller in the actual production process cannot be underestimated, especially the existence of complex defects such as stick-slip and jamming, which are like undercurrents hidden in the dynamic changes of the tightening process, posing a severe challenge to the accurate assessment of the tightening quality. These defects are not only difficult to capture directly through manual visual inspection, but also because of their hidden impact on the final connection strength, making quality control particularly difficult. At the same time, although traditional tightening tools can complete basic tightening operations, they lack the necessary intelligence and data analysis capabilities to effectively identify and deal with the above potential problems. This limitation has led to a significant increase in the volatility and uncertainty of tightening quality, affecting production efficiency and product quality stability. In order to solve the above problems, higher requirements are put forward for the tightening quality analysis of tightening controllers.
[0003] At present, although the tightening data collected by the tightening controller contains rich information such as torque, angle, time, etc., providing a valuable data source for tightening quality analysis, the differences between different production lines, workstations and even product batches make the tightening process extremely susceptible to various environmental factors such as temperature, humidity, material properties and equipment status, which in turn leads to a high degree of inconsistency and complexity in the tightening data. The variability of this data makes it difficult for the current tightening quality analysis method to respond flexibly, and the accuracy and reliability of the analysis results are greatly reduced, making it difficult to provide effective guidance and support for production management. Summary of the invention
[0004] In order to provide a basic understanding of some aspects of the disclosed embodiments, a brief summary is given below. The summary is not an extensive review, nor is it intended to identify key / critical components or delineate the scope of protection of these embodiments, but rather serves as a prelude to the detailed description that follows.
[0005] In view of the above-mentioned shortcomings of the prior art, the present application discloses a method, system and electronic device for determining tightening quality based on tightening data to improve the reliability of tightening quality analysis.
[0006] The present application discloses a method for determining tightening quality based on tightening data, comprising: acquiring master data bound to a tightening controller, wherein the master data includes at least one of controller data, fastener data and deployment data; collecting tightening data corresponding to the tightening controller, and collecting product data of a target product acted on by the tightening controller, so as to establish a correspondence between the master data, the tightening data and the product data; classifying the tightening data using the master data and the product data as classification basis to obtain a target data set, wherein the tightening data in the target data set is used as target data; performing data steady-state analysis on the target data to obtain a tightening quality result corresponding to the target data, wherein the tightening quality result includes a range steady-state result and / or a mean steady-state result, wherein the range steady-state result is used to characterize whether the target data is in a stable state, and the mean steady-state result is used to characterize whether the target data is within a preset data interval.
[0007] In one embodiment of the present application, a data steady-state analysis is performed on the target data to obtain a tightening quality result corresponding to the target data, including: determining sample data from the target data, and drawing a range control chart based on the sample data, wherein the abscissa of the range control chart represents the sample data, and the ordinate of the range control chart represents the sample range; determining a data control interval based on the range control chart; and determining a range steady-state result based on a comparison result of the sample range and the data control interval.
[0008] In one embodiment of the present application, a data steady-state analysis is performed on the target data to obtain a tightening quality result corresponding to the target data, including: drawing a normal distribution graph according to the target data, wherein the abscissa of the normal distribution graph represents the tightening data, and the ordinate of the normal distribution graph represents the data frequency of the tightening data; performing calculations according to the target data to obtain a data mean and a process standard deviation, and determining a target data interval according to the data mean and the data deviation; performing a normal distribution conformity test on the target data within the target data interval according to the normal distribution graph to determine whether the target data conforms to a normal distribution, and obtaining a mean steady-state result corresponding to the target data.
[0009] In one embodiment of the present application, a data steady-state analysis is performed on the target data to obtain a tightening quality result corresponding to the target data, including at least one of the following: calculating according to the process standard deviation, data upper limit and data lower limit corresponding to the target data to obtain a process capability index, and using the process capability index as the mean steady-state result; calculating according to the data mean, process standard deviation, data upper limit and data lower limit corresponding to the target data to obtain a process capability K index, and using the process capability K index as the mean steady-state result; calculating according to the data mean, sample standard deviation, data upper limit and data lower limit corresponding to the target data to obtain a process performance K index, and using the process performance K index as the mean steady-state result.
[0010] In one embodiment of the present application, a data steady-state analysis is performed on the target data to obtain a tightening quality result corresponding to the target data, including: the tightening data includes angle data and / or torque data; the delivered products and reworked products are determined from the target products; the product qualification rate is obtained by calculation based on the quantity ratio between the delivered products and the target products; the angle abnormality data is determined from the angle data corresponding to the reworked products according to a preset angle maximum value and a preset angle minimum value, wherein the angle abnormality data includes angle over-limit data and angle lower limit data, the data value of the angle over-limit data is greater than the preset angle maximum value, and the data value of the angle lower limit data is less than the preset angle minimum value; the angle abnormality rate is obtained by calculation based on the quantity ratio between the angle abnormality data and the target data, the angle over-limit rate is obtained by calculation based on the quantity ratio between the angle abnormality data and the target data, The quantitative ratio between the target data is calculated to obtain the angle lower limit rate; the torque abnormality data is determined from the torque data corresponding to the reworked product according to the preset torque maximum value and the preset torque minimum value, wherein the torque abnormality data includes torque overlimit data and torque lower limit data, the data value of the torque overlimit data is greater than the preset torque maximum value, and the data value of the torque lower limit data is less than the preset torque minimum value; the torque abnormality rate is calculated according to the quantitative ratio between the torque abnormality data and the target data, the torque overlimit rate is calculated according to the quantitative ratio between the torque overlimit data and the target data, and the torque lower limit rate is calculated according to the quantitative ratio between the torque lower limit data and the target data; at least one of the product qualification rate, the angle abnormality rate, the angle overlimit rate, the angle lower limit rate, the torque abnormality rate, the torque overlimit rate, and the torque lower limit rate is added to the tightening quality result.
[0011] In one embodiment of the present application, after performing data steady-state analysis on the target data and obtaining the tightening quality results corresponding to the target data, the method further includes: if there are tightening controllers on multiple product production lines, generating a tightening quality score according to the tightening quality results corresponding to each of the tightening controllers; determining a qualified controller and an abnormal controller from the tightening controllers according to a comparison result between a preset score threshold and each of the tightening quality scores, wherein the tightening quality score corresponding to the abnormal controller is less than the preset score threshold; determining the product production line with the abnormal controller as an abnormal production line, establishing a maintenance plan in the production plan of the abnormal production line, and displaying a warning message to the management personnel corresponding to the abnormal production line; determining the product production line other than the abnormal production line as a qualified production line, calculating the production line score corresponding to each of the qualified production lines according to the tightening quality score, and determining the number of work orders corresponding to each of the qualified production lines according to the production line score, wherein the production line score and the number of work orders are positively correlated.
[0012] In one embodiment of the present application, the master data includes: the controller data, including at least one of a controller brand, a controller type, and a controller identification; a tightening program for executing tightening tasks and / or collecting tightening data; the fastener data, including at least one of fastener specifications, fastener lengths, fastener materials, and torque requirements; and deployment data, including at least one of factory data, production line data, and workstation data.
[0013] In one embodiment of the present application, the tightening data corresponding to the tightening controller is collected, and the product data of the tightening controller acting on the target product is collected, including: establishing an ETL process that is executed regularly; in response to the execution instruction corresponding to the ETL process, obtaining the tightening data corresponding to the tightening controller and the tightening time period corresponding to the tightening data from the IOT system through the Kafka platform to form a tightening data stream; obtaining the product data of the tightening controller acting on the target product and the product production time corresponding to the product data through the MES system, wherein the product data includes the product identification and / or the work order to which the product belongs; matching the tightening time period and the product production time through the BI system to obtain a time matching result, and establishing a corresponding relationship between the tightening data and the product data according to the time matching result.
[0014] The present application discloses an electronic device, comprising: a processor and a memory; the memory is used to store a computer program, and the processor is used to execute the computer program stored in the memory, so that the electronic device executes the above method.
[0015] Beneficial effects of this application:
[0016] By acquiring the master data bound to the tightening controller, collecting the tightening data corresponding to the tightening controller, and collecting product data, a corresponding relationship between the master data, tightening data, and product data is established, so that the master data and product data are used as the classification basis to classify the tightening data, obtain the target data set, and perform data steady-state analysis on the target data in the target data set to obtain the tightening quality result corresponding to the target data. In this way, compared with directly performing quality analysis on the tightening data, by establishing a corresponding relationship between the tightening data and the controller, fastener, controller attribution, and product, a strong correlation between the tightening data and the production environment is achieved, and then tightening quality analysis is performed on the target data under different production environments, thereby improving the reliability of tightening quality analysis and providing support for production management. BRIEF DESCRIPTION OF THE DRAWINGS
[0017] Figure 1 is a structural schematic diagram of an application environment of a tightening quality determination platform for implementing tightening data in an embodiment of the present invention;
[0018] Figure 2 is a flow chart of a method for determining tightening quality based on tightening data in an embodiment of the present invention;
[0019] Figure 3 is a flow chart of a method for establishing a corresponding relationship between tightening data and product data in an embodiment of the present invention;
[0020] Figure 4 is a flow chart of another method for determining tightening quality based on tightening data in an embodiment of the present invention;
[0021] Figure 5 is a flow chart of another method for determining tightening quality based on tightening data in an embodiment of the present invention;
[0022] Figure 6 is a structural schematic diagram of a tightening quality determination system based on tightening data in an embodiment of the present invention;
[0023] Figure 7 It is a schematic diagram of the structure of an electronic device in an embodiment of the present invention. DETAILED DESCRIPTION
[0024] The following describes the embodiments of the present invention through specific examples, and those skilled in the art can easily understand other advantages and effects of the present invention from the contents disclosed in this specification. The present invention can also be implemented or applied through other different specific embodiments, and the details in this specification can also be modified or changed in various ways based on different viewpoints and applications without departing from the spirit of the present invention. It should be noted that the following embodiments and sub-samples in the embodiments can be combined with each other without conflict.
[0025] It should be noted that the illustrations provided in the following embodiments are only schematic illustrations of the basic concept of the present invention, and thus the drawings only show components related to the present invention rather than being drawn according to the number, shape and size of components in actual implementation. In actual implementation, the type, quantity and proportion of each component may be changed arbitrarily, and the component layout may also be more complicated.
[0026] In the following description, numerous details are discussed to provide a more thorough explanation of the embodiments of the present invention. However, it is obvious to those skilled in the art that the embodiments of the present invention can be implemented without these specific details. In other embodiments, well-known structures and devices are shown in the form of block diagrams rather than in detail to avoid making the embodiments of the present invention difficult to understand.
[0027] The terms "first", "second", etc. in the specification and claims of the embodiments of the present disclosure and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence. It should be understood that the terms used in this way can be interchanged where appropriate, so that the embodiments of the embodiments of the present disclosure described herein. In addition, the terms "including" and "having" and any variations thereof are intended to cover non-exclusive inclusions.
[0028] Unless otherwise stated, the term "plurality" means two or more.
[0029] In the embodiment of the present disclosure, the character " / " indicates that the preceding and following objects are in an "or" relationship. For example, A / B indicates: A or B.
[0030] The term "and / or" is a description of the association relationship between objects, indicating that three relationships can exist. For example, A and / or B means: A or B, or, A and B.
[0031] Combination Figure 1 As shown, an embodiment of the present disclosure provides an application environment for implementing a tightening quality determination platform for tightening data, including a tightening controller and a server, wherein the tightening controller is connected to the server via a network.
[0032] The tightening controller is provided with master data, wherein the master data includes at least one of a tightening program, controller data, fastener data and deployment data.
[0033] In some embodiments, a tightening program is used to perform tightening tasks, wherein the tightening program provides preset and customized tightening programs to meet the needs of different production tasks. The tightening program can be adjusted according to different bolt specifications and application scenarios to ensure the accuracy and consistency of each tightening.
[0034] In some embodiments, the tightening program is also used to collect tightening data, wherein the tightening program collects and records the execution status and parameters of each tightening program to provide data support to optimize and adjust the tightening program and improve production quality and efficiency.
[0035] In some embodiments, the controller data includes at least one of a controller brand, a controller type, and a controller identification, wherein the controller brand supports a variety of mainstream controller brands on the market, ensuring flexibility and adaptability in different production environments through brand compatibility.
[0036] In some embodiments, the fastener data includes at least one of fastener specifications, fastener length, fastener material and torque requirements, wherein the fastener is typically a bolt, and detailed bolt information management is provided through master data to ensure that each bolt is properly handled during the installation process, thereby reducing failure and rework rates.
[0037] In some embodiments, the deployment data includes at least one of plant data, production line data, and workstation data; the plant data is used to support multi-plant information management, provide detailed plant information records, and is applicable to cross-plant production management and scheduling; the production line data is used to support information binding of production lines, ensure the continuity and efficiency of the production process, provide line status monitoring, and track production progress in real time; the workstation data is used to provide detailed workstation information management, including workstation number, workstation location, and workstation task. Ensure the standardization of operations at each workstation and improve production quality.
[0038] The server side is used to implement a tightening quality determination method based on tightening data, including at least one of the following parts: obtaining master data bound to a tightening controller, wherein the master data includes at least one of controller data, fastener data and deployment data; when the tightening controller performs a tightening task on a target product, collecting tightening data corresponding to the tightening controller, and collecting product data of the tightening controller acting on the target product, so as to establish a corresponding relationship between the master data, the tightening data and the product data; classifying the tightening data using the master data and the product data as a classification basis to obtain a target data set, wherein the tightening data in the target data set is used as the target data; performing a data steady-state analysis on the target data to obtain a tightening quality result corresponding to the target data, wherein the tightening quality result includes a mean steady-state result and / or a range steady-state result, wherein the mean steady-state result is used to characterize whether the target data is within a preset data interval, and the range steady-state result is used to characterize whether the target data is in a stable state.
[0039] Combination Figure 2 As shown, the embodiment of the present disclosure provides a method for determining tightening quality based on tightening data, comprising:
[0040] Step S201, obtaining the master data bound to the tightening controller;
[0041] wherein the master data includes at least one of controller data, fastener data, and deployment data;
[0042] Step S202, when the tightening controller performs a tightening task on a target product, the tightening data corresponding to the tightening controller is collected, and the product data of the tightening controller acting on the target product is collected to establish a corresponding relationship between the master data, the tightening data and the product data;
[0043] Step S203, classifying the tightening data using the master data and the product data as classification basis to obtain a target data set;
[0044] Wherein, the tightening data in the target data set is used as the target data;
[0045] Step S204, performing data steady-state analysis on the target data to obtain a tightening quality result corresponding to the target data;
[0046] The tightening quality results include extreme steady-state results and / or mean steady-state results;
[0047] Among them, the extreme steady-state result is used to characterize whether the target data is in a stable state;
[0048] Among them, the mean steady-state result is used to characterize whether the target data is within the preset data interval.
[0049] The tightening quality determination method based on tightening data provided by the embodiment of the present disclosure obtains the master data bound to the tightening controller, collects the tightening data corresponding to the tightening controller, and collects the product data to establish a correspondence between the master data, the tightening data, and the product data, so as to classify the tightening data using the master data and the product data as the classification basis to obtain the target data set, and perform data steady-state analysis on the target data in the target data set to obtain the tightening quality result corresponding to the target data. In this way, compared with directly performing quality analysis on the tightening data, by establishing a correspondence between the tightening data and the controller, fastener, controller attribution, and product, a strong correlation between the tightening data and the production environment is achieved, and then tightening quality analysis is performed on the target data under different production environments, thereby improving the reliability of the tightening quality analysis and providing support for production management.
[0050] Optionally, the tightening data corresponding to the tightening controller is collected, and the product data of the tightening controller acting on the target product is collected, including: establishing an ETL process (data extraction, transformation, and loading process) that is executed regularly; in response to the execution instruction corresponding to the ETL process, obtaining the tightening data corresponding to the tightening controller and the tightening time period corresponding to the tightening data from the IOT (Internet Of Things) system through the Kafka platform to form a tightening data stream; obtaining the product data of the tightening controller acting on the target product and the product production time corresponding to the product data through the MES (Manufacturing Execution System) system, wherein the product data includes a product identification and / or a work order to which the product belongs; matching the tightening time period and the product production time through a BI (Business Intelligence System) system to obtain a time matching result, and establishing a corresponding relationship between the tightening data and the product data according to the time matching result.
[0051] In some embodiments, in addition to the torque data, force data and angle data collected by the tightening program, the tightening data also includes the controller version and controller number of the tightening controller; the collected controller version is used to ensure the accuracy and timely update of the production equipment software version, thereby ensuring the torque and force of the stable operation of the production line; the collected controller number is used to accurately collect and manage the tightening controller, provide detailed tightening controller usage records, and facilitate tracking of the tightening controller usage and maintenance needs.
[0052] In some embodiments, the Kafka platform is a distributed stream processing platform for high-performance and reliable processing of real-time data streams. It can transmit data streams from one or more producers to one or more consumers while ensuring low latency and high throughput of data. It is widely used in log collection, event-driven architecture, real-time analysis, indicator monitoring and other scenarios. It is an important tool for building real-time data pipelines and stream processing applications. Data conversion and transmission are performed through the Kafka platform to ensure efficient flow and real-time processing of data, and it can provide powerful data stream processing capabilities to adapt to the data requirements of large-scale production environments. While ensuring seamless integration of data between different systems, it realizes cross-platform data sharing and analysis.
[0053] Combination Figure 3 As shown, the embodiment of the present disclosure provides a method for establishing a corresponding relationship between tightening data and product data, including:
[0054] Step S301, collecting tightening data from the tightening program in the tightening controller through the IOT system;
[0055] Step S302, forming a tightening data stream according to the collected tightening data through the Kafka platform;
[0056] The tightening data stream includes a plurality of tightening data nodes, and the tightening data nodes include a tightening time period and tightening data within the tightening time period;
[0057] Step S303, determining any tightening data node as a target node, and generating a first asynchronous event according to the target node;
[0058] Step S304, sending the first asynchronous event to the MES system, triggering the MES system to collect product data of the tightening controller acting on the target product and the product production time corresponding to the product data;
[0059] Step S305, generating a second asynchronous event according to the first asynchronous event, product data and product production time;
[0060] Step S306, sending the second asynchronous event to the BI system, triggering the BI system to match the tightening time period with the product production time, obtaining a time matching result, and establishing a corresponding relationship between the tightening data and the product data according to the time matching result.
[0061] Optionally, a data steady-state analysis is performed on the target data to obtain a tightening quality result corresponding to the target data, including: determining sample data from the target data, and drawing a range control chart based on the sample data, wherein the abscissa of the range control chart represents the sample data, and the ordinate of the range control chart represents the sample range; determining a data control interval based on the range control chart; and determining a range steady-state result based on a comparison result of the sample range and the data control interval.
[0062] In some embodiments, the range R is also called the range error or the range, which refers to the difference between the maximum value and the minimum value in a set of data, that is, the data obtained by subtracting the maximum value from the minimum value. It is an important indicator used to represent the measure of variation in statistical data, used to characterize the maximum range of the change of the mark value, and is the simplest indicator for measuring the change of the mark.
[0063] In some embodiments, the abscissa of the range control chart represents the number of groups of sample data, and the ordinate of the range control chart represents the range of torque data; the standard factor D3 and the standard factor D4 are determined according to the range control chart, wherein the standard factor D3 represents a coefficient of the standard deviation of the range of N observations in a normal distribution (standard deviation is 1), and is used to adjust the standard deviation of the moving range (or range) when calculating the control limit of the control chart. As the number of groups of sample data (sample size n) increases, the value of D3 usually decreases because more data points can more accurately estimate the standard deviation of the population. The standard factor D4 is another coefficient related to the calculation of the control limit, and is used to set the upper and lower control limits of the control chart. The standard factor D4 also changes with the change of the number of groups of sample data (sample size n); the data control interval is determined by the range R, the standard factor D3 and the standard factor D4, for example, the upper control limit UCL of the data control interval = range R × standard factor D4, and the lower control limit LCL of the data control interval = range R × standard factor D3, wherein, for a small sample size (n≤6), the standard factor D3 = 0.
[0064] In some embodiments, if all sample extreme values are within the data control interval, the target data is considered to be under control; if there are sample extreme values outside the data control interval, it indicates that the target data has abnormal variation and corrective measures need to be taken.
[0065] Optionally, a data steady-state analysis is performed on the target data to obtain a tightening quality result corresponding to the target data, including: drawing a normal distribution graph based on the target data, wherein the abscissa of the normal distribution graph represents the tightening data, and the ordinate of the normal distribution graph represents the data frequency of the tightening data; performing calculations based on the target data to obtain a data mean and a process standard deviation, and determining a target data interval based on the data mean and the data deviation; performing a normal distribution conformity test on the target data within the target data interval based on the normal distribution graph to determine whether the target data conforms to the normal distribution, and obtaining a mean steady-state result corresponding to the target data.
[0066] In some embodiments, statistics are performed on the tightening data classification, including calculating indicators such as the data mean, process standard deviation and coefficient of variation, which will be used for subsequent sigma level calculations; based on the data classification and statistical indicators, a corresponding data distribution diagram (histogram) is drawn, wherein the horizontal axis represents the range or classification of the data, and the vertical axis represents the frequency or percentage of the data; based on the shape of the data distribution diagram and the statistical indicators, the sigma level of the execution data is calculated. Generally speaking, based on the normal distribution, the relationship between the mean and the process standard deviation can be used to calculate the sigma level; based on the calculated sigma level, it is compared and interpreted with the classification standards of the Six Sigma system. Generally speaking, the Six Sigma level ranges from 1 Sigma to 6 Sigma, and the higher the value, the higher the quality level of the process.
[0067] In some embodiments, in the Six Sigma theory system, the indicator data should all obey the normal distribution, that is, the value of the indicator data is within the positive or negative three sigma (corresponding to the abnormal threshold) range of the mean of the indicator data. For example, the upper control limit UCL of the target data interval = data mean + 3× process standard deviation, and the lower control limit LCL of the target data interval = data mean - 3× process standard deviation. In the normal distribution rule, 99.73% of the data will fall between the UCL and LCL of the target data interval; draw a histogram or a probability density function graph to observe the data distribution pattern. The tightening data is symmetrically distributed in a bell shape, with the mean at the center and the data on both sides gradually decreasing; the Kolmogorov-Smirnov test is used to determine whether the data conforms to the normal distribution. If the data conforms to the normal distribution, it indicates that the process is controlled and stable. Otherwise, there may be abnormalities and further observation is required. Therefore, the mean steady-state result corresponding to the target data is obtained through the normal distribution graph, which can characterize whether the target data is within the preset data interval.
[0068] Optionally, a data steady-state analysis is performed on the target data to obtain a tightening quality result corresponding to the target data, including at least one of the following: calculating according to the process standard deviation, data upper limit and data lower limit corresponding to the target data to obtain a process capability index, and using the process capability index as the mean steady-state result; calculating according to the data mean, process standard deviation, data upper limit and data lower limit corresponding to the target data to obtain a process capability K index, and using the process capability K index as the mean steady-state result; calculating according to the data mean, sample standard deviation (Sample Standard Deviation), data upper limit and data lower limit corresponding to the target data to obtain a process performance K index, and using the process performance K index as the mean steady-state result.
[0069] In some embodiments, the process capability index (CP) is a characteristic of the inherent fluctuation state of the process, that is, the technical level. It is the degree to which the process capability meets the product quality standard requirements when the average value μ of the process coincides with the target value M. The larger the CP value, the smaller the product's discreteness relative to the tolerance range of the technical standard, and thus the higher the process capability.
[0070] In some embodiments, torque data is extracted from the sample data and grouped, for example, into 40 groups, each with 25 torque data; the process capability index is calculated as follows: Where CP is the process capability index and δ is the process standard deviation.
[0071] In some embodiments, the process standard deviation δ is calculated by the following formula:
[0072]
[0073] In formula (1), δ is the process standard deviation, R i is the range of the i-th group of sample data subset, X i (max) is the maximum value of the data in the i-th group of sample data subsets, X i (min) is the minimum value of the data in the i-th group of sample data subsets, is the mean of the range, and d2 is the center line coefficient in the range control chart.
[0074] In some embodiments, the process capability K ratio (CPK) is a process capability index that takes into account the deviation between the process average and the target value. It combines process accuracy and process precision and is the product of CP and process accuracy Ca. The larger the CPK value, the higher the process capability and the closer the process average is to the target value.
[0075] In some embodiments, torque data is extracted from the sample data and grouped, for example, into 40 groups, each with 25 torque data; the calculation formula of the process capability K index is: Where CPK is the process capability K index.
[0076] In some embodiments, the Process Performance K Ratio (PPK) evaluates the performance of a process by calculating the relationship between specification limits and process performance, and can be used to evaluate the performance and reliability of a process, and to predict quality trends in future production.
[0077] In some embodiments, torque data is extracted from the sample data and grouped, for example, into 40 groups, each with 25 torque data; the calculation formula of the process performance K index is: Where PPK is the process capability K index and s is the sample standard deviation.
[0078] In some embodiments, the sample standard deviation s is calculated by the following formula:
[0079]
[0080] In formula (2), s is the sample standard deviation, N is the number of observations (i.e. the total number of sample data subsets), j is the number of sample data in the i-th group of sample data subsets, is the observed value corresponding to the i-th group of sample data subset, is the sample data mean, It is the sum of the squares of the differences between each observation and the mean of the sample data, that is, the sum of squared deviations (Sum of Squared Deviations). When calculating the sample standard deviation, the denominator is N-1 instead of N. This is to adjust the degrees of freedom, because one degree of freedom among the N data points has been used when calculating the sample mean. This adjustment makes the sample standard deviation an unbiased estimator of the process standard deviation.
[0081] Optionally, a data steady-state analysis is performed on the target data to obtain a tightening quality result corresponding to the target data, including: the tightening data includes angle data and / or torque data; the delivered products and reworked products are determined from the target products; the product qualification rate is obtained by calculation based on the quantity ratio between the delivered products and the target products; the angle abnormality data is determined from the angle data corresponding to the reworked products according to the preset angle maximum value and the preset angle minimum value, wherein the angle abnormality data includes angle over-limit data and angle lower-limit data, the data value of the angle over-limit data is greater than the preset angle maximum value, and the data value of the angle lower-limit data is less than the preset angle minimum value; the angle abnormality rate is obtained by calculation based on the quantity ratio between the angle abnormality data and the target data, the angle over-limit rate is obtained by calculation based on the quantity ratio between the angle abnormality data and the target data, and the angle lower-limit data is obtained by calculation based on the quantity ratio between the angle abnormality data and the target data. The torque abnormality data is determined from the torque data corresponding to the reworked product according to the preset maximum torque value and the preset minimum torque value, wherein the torque abnormality data includes torque overlimit data and torque underlimit data, the data value of the torque overlimit data is greater than the preset maximum torque value, and the data value of the torque underlimit data is less than the preset minimum torque value; the torque abnormality rate is calculated according to the quantitative ratio between the torque abnormality data and the target data, the torque overlimit rate is calculated according to the quantitative ratio between the torque overlimit data and the target data, and the torque underlimit rate is calculated according to the quantitative ratio between the torque underlimit data and the target data; at least one of the product qualified rate, angle abnormality rate, angle overlimit rate, angle underlimit rate, torque abnormality rate, torque overlimit rate and torque underlimit rate is added to the tightening quality result.
[0082] In some embodiments, product qualification rate=(number of delivered products / number of target products)×100%.
[0083] In some embodiments, angle anomaly rate=(number of angle anomaly data / number of target data)×100%.
[0084] In some embodiments, the angle exceeding limit rate=(the number of angle abnormal data greater than the preset maximum angle value / the number of target data)×100%.
[0085] In some embodiments, the angle lower limit rate=(the number of angle abnormal data less than the preset minimum angle value / the number of target data)×100%.
[0086] In some embodiments, torque abnormality rate=(number of torque abnormality data / number of target data)×100%.
[0087] In some embodiments, the torque excess rate=(the number of torque abnormality data greater than the preset maximum torque value / the number of target data)×100%.
[0088] In some embodiments, the torque low limit rate=(the number of torque abnormality data less than the preset minimum torque value / the number of target data)×100%.
[0089] Combination Figure 4 As shown, the embodiment of the present disclosure provides a method for determining tightening quality based on tightening data, comprising:
[0090] Step S401, checking the tightening controller corresponding to the master data;
[0091] Step S402, checking the fastener information corresponding to each tightening controller;
[0092] Step S403, determining whether tightening data is collected within a preset time period, if yes, jump to step S404, if no, jump to step S401;
[0093] Step S404, establishing a corresponding relationship between the master data, tightening data and product data;
[0094] Step S405, determining target data from the tightening data according to the master data and the product data;
[0095] Step S406, calculating the process capability K index CPK, the process performance K index PPK, etc. according to the target data, so as to perform data steady-state analysis on the target data and obtain the tightening quality results corresponding to the target data.
[0096] Optionally, after performing data steady-state analysis on the target data and obtaining the tightening quality results corresponding to the target data, the method further includes: if there are tightening controllers on multiple product production lines, generating a tightening quality score according to the tightening quality results corresponding to each tightening controller; determining a qualified controller and an abnormal controller from the tightening controllers according to a comparison result between a preset score threshold and each tightening quality score, wherein the tightening quality score corresponding to the abnormal controller is less than the preset score threshold; determining the product production line with the abnormal controller as an abnormal production line, establishing a maintenance plan in the production plan of the abnormal production line, and displaying warning information to the management personnel corresponding to the abnormal production line; determining the product production lines other than the abnormal production line as qualified production lines, calculating the production line scores corresponding to each qualified production line according to the tightening quality scores, and determining the number of work orders corresponding to each qualified production line according to the production line scores, wherein the production line score and the number of work orders are positively correlated.
[0097] In some embodiments, an automobile manufacturer has multiple production lines, each of which is responsible for the production of different models. In order to improve product quality and production efficiency, the company installs a tightening controller on each production line to monitor and record the tightening torque of key bolts to ensure the tightening quality of parts. After the daily production is completed, the system automatically collects tightening quality data from the tightening controllers of each production line, including the actual tightening torque of each tightening point, the preset target torque, and the tightening time, etc. For each production line, the system calculates the tightening quality score based on the collected data, wherein the scoring algorithm includes performing a data steady-state analysis on the target data; setting a preset scoring threshold (e.g., 85 points), and comparing the score of each tightening controller with the preset threshold. If the score is higher than or equal to the threshold, it is considered a qualified controller; if the score is lower than the threshold, it is marked as an abnormal controller; the system identifies the production line containing abnormal controllers as abnormal production lines; for these abnormal production lines, the system automatically inserts maintenance plans into their production plans, and recommends Specific maintenance content may include calibration of tightening controllers, replacement of damaged parts or software updates, etc. At the same time, the system sends warning information to managers of abnormal production lines through e-mail, text messages or internal communication software to remind them to pay attention to and deal with related issues. For production lines without abnormal controllers, that is, qualified production lines, the system further calculates production line scores based on the tightening quality scores of each production line. Production line scores may not only consider tightening quality, but may also be combined with other factors such as production efficiency and equipment utilization for comprehensive evaluation. The system determines the number of work orders that each qualified production line should receive in the next production cycle based on the production line score. Production lines with higher scores will receive more work orders to improve the compliance rate when work orders are completed. After a period of implementation, the company evaluates the effectiveness of the system, including product quality improvements, changes in production line maintenance costs, and improvements in production efficiency. Based on the evaluation results, the company may adjust the preset scoring thresholds, optimize the scoring algorithm, or improve the maintenance plan to achieve more precise control and more efficient optimization.
[0098] Combination Figure 5 As shown, the embodiment of the present disclosure provides a method for determining tightening quality based on tightening data, comprising:
[0099] Step S501, data source preparation;
[0100] Among them, the connection information of the data source (such as the uniform resource locator URL, port, authentication code, etc.) is obtained, and by identifying and determining the data source, it is determined whether the data source can be accessed and whether there is corresponding authority, so as to ensure the availability of the data source and prepare for subsequent data extraction. Among them, the data source includes database, file system, API (Application Programming Interface), etc.;
[0101] Step S502, collecting tightening data;
[0102] When the data source is successfully connected and the data structure is known, the query statement or API request parameters are obtained, and data is extracted from various data sources regularly through the ETL process by SQL (Structured Query Language, standard programming language) query, API call or file reading to form a data set;
[0103] Step S503, pre-processing the tightening data;
[0104] Among them, after determining that the extracted tightening data can be parsed, the data format definition and conversion rules are obtained, and the extracted data is preliminarily processed, including data type conversion, basic formatting, etc., to ensure the consistency and basic availability of the data;
[0105] Step S504, cleaning the tightening data;
[0106] After data preprocessing, cleaning rules and methods, missing value processing strategies (such as filling, deletion, etc.) are obtained, and errors, duplications and missing values in the data are cleaned up through rule engines or machine learning methods, thereby improving data quality and ensuring data accuracy and completeness.
[0107] Step S505, performing data conversion on the tightening data;
[0108] Among them, the conversion rules and algorithms are obtained, and the cleaned data is transformed, including normalization, aggregation, calculation of derived values, etc., to generate the target data structure required for analysis.
[0109] Step S506, performing data aggregation on the tightening data;
[0110] Among them, the aggregation rules and dimensions are obtained to summarize and count the tightening data, such as sum, count, average and other operations, so as to generate the target data set for business decision-making;
[0111] Step S507, loading data;
[0112] Among them, the database connection information and loading strategy (full loading, incremental loading, etc.) are obtained, and the master data, product data, tightening data, tightening quality results, etc. are loaded into the target data warehouse or database for use by downstream applications.
[0113] Step S508, verifying the data;
[0114] Among them, validation rules and benchmark data are obtained, and the loaded data is validated to ensure the integrity and accuracy of the data;
[0115] Step S509, generating data monitoring and reporting, including: after the ETL process of tightening data is regularly executed, obtaining monitoring indicators, alarm thresholds and report templates, continuously monitoring the ETL process and data quality, generating reports and alarms, and predicting possible ETL failure points by introducing an alarm-driven monitoring system to timely discover and solve data problems and maintain the stable operation of the ETL process.
[0116] The tightening quality determination method based on tightening data provided by the embodiment of the present disclosure obtains the master data bound to the tightening controller, collects the tightening data corresponding to the tightening controller, and collects the product data to establish a correspondence between the master data, the tightening data, and the product data, so as to classify the tightening data using the master data and the product data as the classification basis to obtain the target data set, and perform data steady-state analysis on the target data in the target data set to obtain the tightening quality result corresponding to the target data. In this way, compared with directly performing quality analysis on the tightening data, by establishing a correspondence between the tightening data and the controller, fastener, controller attribution, and product, a strong correlation between the tightening data and the production environment is achieved, and then tightening quality analysis is performed on the target data under different production environments, thereby improving the reliability of the tightening quality analysis and providing support for production management.
[0117] Combination Figure 6 As shown, the embodiment of the present disclosure provides a tightening quality determination system based on tightening data, including an acquisition module 601 , a collection module 602 , a classification module 603 and an analysis module 604 .
[0118] The acquisition module 601 is used to acquire the master data bound to the tightening controller, wherein the master data includes at least one of controller data, fastener data and deployment data.
[0119] The acquisition module 602 is used to acquire the tightening data corresponding to the tightening controller when the tightening controller performs a tightening task on the target product, and to acquire the product data of the tightening controller acting on the target product, so as to establish a corresponding relationship among the master data, the tightening data and the product data.
[0120] The classification module 603 is used to determine to classify the tightening data using the master data and the product data as the classification basis to obtain a target data set, wherein the tightening data in the target data set is used as the target data.
[0121] The analysis module 604 is used to perform data steady-state analysis on the target data to obtain the tightening quality results corresponding to the target data. The tightening quality results include mean steady-state results and / or extreme steady-state results, wherein the mean steady-state result is used to characterize whether the target data is within a preset data interval, and the extreme steady-state result is used to characterize whether the target data is in a stable state.
[0122] The tightening quality determination system based on tightening data provided by the embodiment of the present disclosure obtains the master data bound to the tightening controller, collects the tightening data corresponding to the tightening controller, and collects the product data to establish a correspondence between the master data, the tightening data, and the product data, so as to classify the tightening data using the master data and the product data as the classification basis to obtain the target data set, and perform data steady-state analysis on the target data in the target data set to obtain the tightening quality result corresponding to the target data. In this way, compared with directly performing quality analysis on the tightening data, by establishing a correspondence between the tightening data and the controller, fastener, controller attribution, and product, a strong correlation between the tightening data and the production environment is achieved, and then tightening quality analysis is performed on the target data under different production environments, thereby improving the reliability of the tightening quality analysis and providing support for production management.
[0123] An embodiment of the present disclosure further provides an electronic device, including: a processor and a memory; the memory is used to store a computer program, and the processor is used to execute the computer program stored in the memory, so that the electronic device executes the above method.
[0124] Figure 7 The structure diagram of the computer system suitable for implementing the electronic device of the embodiment of the present application is shown. It should be noted that: Figure 7 The computer system 700 of the electronic device shown is only an example and should not bring any limitation to the functions and scope of use of the embodiments of the present application.
[0125] like Figure 7 As shown, the computer system 700 includes a central processing unit (CPU) 701, which can perform various appropriate actions and processes according to the program stored in the read-only memory (ROM) 702 or the program loaded from the storage part 708 to the random access memory (RAM) 703, such as executing the method in the above embodiment. In the random access memory 703, various programs and data required for system operation are also stored. The central processing unit 701, the read-only memory 702 and the random access memory 703 are connected to each other through a bus 704. An input / output (I / O) interface 705 is also connected to the bus 704.
[0126] The following components are connected to the input / output interface 705: an input section 706 including a keyboard, a mouse, etc.; an output section 707 including a cathode ray tube (CRT), a liquid crystal display (LCD), etc., and a speaker, etc.; a storage section 708 including a hard disk, etc.; and a communication section 709 including a network interface card such as a LAN (Local Area Network) card, a modem, etc. The communication section 709 performs communication processing via a network such as the Internet. A drive 710 is also connected to the input / output interface 705 as needed. A removable medium 711, such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, etc., is installed on the drive 710 as needed so that a computer program read therefrom is installed into the storage section 708 as needed.
[0127] In particular, according to an embodiment of the present application, the process described above with reference to the flowchart can be implemented as a computer software program. For example, an embodiment of the present application includes a computer program product, which includes a computer program carried on a computer-readable medium, and the computer program includes a computer program for executing the method shown in the flowchart. In such an embodiment, the computer program can be downloaded and installed from a network through a communication section 709, and / or installed from a removable medium 711. When the computer program is executed by a central processing unit (CPU) 701, various functions defined in the system of the present application are executed.
[0128] The above description and accompanying drawings fully illustrate the embodiments of the present disclosure so that those skilled in the art can practice them. Other embodiments may include structural, logical, electrical, process and other changes. The embodiments represent possible changes only. Unless explicitly required, separate components and functions are optional, and the order of operation may vary. Parts and subsamples of some embodiments may be included in or replace parts and subsamples of other embodiments. Moreover, the words used in this application are only used to describe the embodiments and are not used to limit the claims. As used in the description of the embodiments and claims, unless the context clearly indicates, the singular forms of "a", "an" and "the" are intended to include plural forms as well. Similarly, the term "and / or" as used in this application refers to any and all possible combinations of listings containing one or more associated ones. In addition, when used in the present application, the term "comprise" and its variants "comprises" and / or comprising refer to the presence of a stated sub-sample, whole, step, operation, element, and / or component, but do not exclude the presence or addition of one or more other sub-samples, wholes, steps, operations, elements, components and / or groups of these. In the absence of further restrictions, the elements defined by the sentence "comprising a ..." do not exclude the presence of other identical elements in the process, method or device comprising the elements. In this article, each embodiment may focus on the differences from other embodiments, and the same and similar parts between the various embodiments may refer to each other. For the methods, products, etc. disclosed in the embodiments, if they correspond to the method part disclosed in the embodiments, then the relevant parts can refer to the description of the method part.
[0129] Those skilled in the art will appreciate that the units and algorithm steps of each example described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, or a combination of computer software and electronic hardware. Whether these functions are performed in hardware or software may depend on the specific application and design constraints of the technical solution. Technicians can use different methods to implement the described functions for each specific application, but such implementation should not be considered to be beyond the scope of the embodiments of the present disclosure. Technicians can clearly understand that for the convenience and simplicity of description, the specific working process of the above-described system, device and unit can refer to the corresponding process in the aforementioned method embodiment, and will not be repeated here.
[0130] In the embodiments disclosed herein, the disclosed methods and products (including but not limited to devices, equipment, etc.) can be implemented in other ways. For example, the device embodiments described above are only schematic. For example, the division of units can be only a logical function division. There may be other division methods in actual implementation, such as multiple units or components can be combined or integrated into another system, or some sub-samples can be ignored or not executed. In addition, the coupling or direct coupling or communication connection between each other shown or discussed can be through some interfaces, indirect coupling or communication connection of devices or units, which can be electrical, mechanical or other forms. The units described as separate components may or may not be physically separated, and the components displayed as units may or may not be physical units, that is, they may be located in one place, or they may be distributed on multiple network units. Some or all of the units may be selected according to actual needs to implement this embodiment. In addition, each functional unit in the embodiment of the present disclosure may be integrated in a processing unit, or each unit may exist physically alone, or two or more units may be integrated in one unit.
[0131] The flowchart and block diagram in the accompanying drawings show the possible architecture, functions and operations of the system, method and computer program product according to the embodiment of the present disclosure. In this regard, each box in the flowchart or block diagram can represent a module, a program segment or a part of the code, and a part of the module, program segment or code contains one or more executable instructions for realizing the specified logical function. In some alternative implementations, the functions marked in the box can also occur in a different order from the order marked in the accompanying drawings. For example, two consecutive boxes can actually be executed substantially in parallel, and they can sometimes be executed in the opposite order, which can depend on the functions involved. In the description corresponding to the flowchart and block diagram in the accompanying drawings, the operations or steps corresponding to different boxes can also occur in a different order from the order disclosed in the description, and sometimes there is no specific order between different operations or steps. For example, two consecutive operations or steps can actually be executed substantially in parallel, and they can sometimes be executed in the opposite order, which can depend on the functions involved. Each block in the block diagrams and / or flowcharts, and combinations of blocks in the block diagrams and / or flowcharts, may be implemented by a dedicated hardware-based system that performs the specified functions or actions, or may be implemented by a combination of dedicated hardware and computer instructions.
Claims
1. A method for determining tightening quality based on tightening data, characterized in that: include: Acquire master data bound to the tightening controller, wherein the master data includes at least one of controller data, fastener data, and deployment data; Collecting tightening data corresponding to the tightening controller and collecting product data of the target product acted on by the tightening controller to establish a corresponding relationship between the master data, the tightening data and the product data; Classifying the tightening data using the master data and the product data as classification basis to obtain a target data set, wherein the tightening data in the target data set is used as target data; A data steady-state analysis is performed on the target data to obtain a tightening quality result corresponding to the target data, wherein the tightening quality result includes an extreme steady-state result and / or a mean steady-state result, wherein the extreme steady-state result is used to characterize whether the target data is in a stable state, and the mean steady-state result is used to characterize whether the target data is within a preset data interval.
2. The method according to claim 1, characterized in that Performing data steady-state analysis on the target data to obtain tightening quality results corresponding to the target data includes: Determine sample data from the target data, and draw a range control chart based on the sample data, wherein the abscissa of the range control chart represents the sample data, and the ordinate of the range control chart represents the sample range; Determine the data control interval according to the range control chart; The range steady-state result is determined according to the comparison result of the sample range and the data control interval.
3. The method according to claim 1, characterized in that: Performing data steady-state analysis on the target data to obtain tightening quality results corresponding to the target data includes: Draw a normal distribution graph according to the target data, wherein the abscissa of the normal distribution graph represents the tightening data, and the ordinate of the normal distribution graph represents the data frequency of the tightening data; Calculating according to the target data to obtain a data mean and a process standard deviation, and determining a target data interval according to the data mean and the data deviation; A normal distribution conformity test is performed on the target data within the target data interval according to the normal distribution graph to determine whether the target data conforms to the normal distribution, and a mean steady-state result corresponding to the target data is obtained.
4. The method according to claim 1, characterized in that: Performing data steady-state analysis on the target data to obtain a tightening quality result corresponding to the target data includes at least one of the following: Calculate the process capability index according to the process standard deviation, the data upper limit and the data lower limit corresponding to the target data, and use the process capability index as the mean steady-state result; Calculate the process capability K index according to the data mean, process standard deviation, data upper limit and data lower limit corresponding to the target data, and use the process capability K index as the mean steady-state result; The process performance K index is obtained by calculating the data mean, sample standard deviation, data upper limit and data lower limit corresponding to the target data, and the process performance K index is used as the mean steady-state result.
5. The method according to claim 1, characterized in that Performing data steady-state analysis on the target data to obtain tightening quality results corresponding to the target data includes: The tightening data includes angle data and / or torque data; determining delivered products and reworked products from the target products; Calculate the product qualification rate based on the quantity ratio between the delivered product and the target product; Determine angle abnormality data from the angle data corresponding to the reworked product according to a preset angle maximum value and a preset angle minimum value, wherein the angle abnormality data includes angle over-limit data and angle under-limit data, the data value of the angle over-limit data is greater than the preset angle maximum value, and the data value of the angle under-limit data is less than the preset angle minimum value; Calculate the angle abnormality rate according to the quantity ratio between the angle abnormal data and the target data, calculate the angle excessive rate according to the quantity ratio between the angle excessive data and the target data, and calculate the angle low limit rate according to the quantity ratio between the angle low limit data and the target data; Determining torque abnormality data from the torque data corresponding to the reworked product according to a preset maximum torque value and a preset minimum torque value, wherein the torque abnormality data includes torque overlimit data and torque underlimit data, the data value of the torque overlimit data is greater than the preset maximum torque value, and the data value of the torque underlimit data is less than the preset minimum torque value; Calculate the torque abnormality rate according to the quantitative ratio between the torque abnormality data and the target data, calculate the torque excessive rate according to the quantitative ratio between the torque excessive data and the target data, and calculate the torque low limit rate according to the quantitative ratio between the torque low limit data and the target data; At least one of the product qualification rate, the angle abnormality rate, the angle over-limit rate, the angle lower limit rate, the torque abnormality rate, the torque over-limit rate, and the torque lower limit rate is added to the tightening quality result.
6. The method according to any one of claims 1 to 5, characterized in that: After performing data steady-state analysis on the target data to obtain a tightening quality result corresponding to the target data, the method further includes: If tightening controllers are present on multiple product production lines, a tightening quality score is generated according to the tightening quality results corresponding to each of the tightening controllers; Determine a qualified controller and an abnormal controller from the tightening controllers according to a comparison result between a preset scoring threshold and each of the tightening quality scores, wherein the tightening quality score corresponding to the abnormal controller is less than the preset scoring threshold; Determine the product production line with the abnormal controller as an abnormal production line, establish a maintenance plan in the production plan of the abnormal production line, and display a warning message to the management personnel corresponding to the abnormal production line; The product production lines other than the abnormal production lines are determined as qualified production lines, the production line scores corresponding to each of the qualified production lines are calculated according to the tightening quality scores, and the number of work orders corresponding to each of the qualified production lines is determined according to the production line scores, wherein the production line scores and the number of work orders are positively correlated.
7. The method according to any one of claims 1 to 5, characterized in that: The master data includes: The controller data includes at least one of a controller brand, a controller type, and a controller identifier; A tightening program for executing tightening tasks and / or collecting tightening data; The fastener data includes at least one of fastener specifications, fastener length, fastener material and torque requirements; The deployment data includes at least one of factory data, production line data and workstation data.
8. The method according to any one of claims 1 to 5, characterized in that: Collecting tightening data corresponding to the tightening controller and collecting product data of the tightening controller acting on the target product, including: Establish a regularly executed ETL process; In response to the execution instruction corresponding to the ETL process, the tightening data corresponding to the tightening controller and the tightening time period corresponding to the tightening data are obtained from the IOT system through the Kafka platform to form a tightening data stream; Acquire, through the MES system, product data of the tightening controller acting on the target product and the product production time corresponding to the product data, wherein the product data includes a product identification and / or a work order to which the product belongs; The BI system matches the tightening time period with the product production time to obtain a time matching result, and establishes a corresponding relationship between the tightening data and the product data based on the time matching result.
9. A tightening quality determination system based on tightening data, characterized in that: include: An acquisition module, used to acquire master data bound to the tightening controller, wherein the master data includes at least one of controller data, fastener data and deployment data; A collection module, used for collecting tightening data corresponding to the tightening controller when the tightening controller performs a tightening task on a target product, and collecting product data of the tightening controller acting on the target product, so as to establish a corresponding relationship between the master data, the tightening data and the product data; A classification module, used for determining to classify the tightening data using the master data and the product data as classification basis to obtain a target data set, wherein the tightening data in the target data set is used as the target data; An analysis module is used to perform data steady-state analysis on the target data to obtain a tightening quality result corresponding to the target data, wherein the tightening quality result includes a mean steady-state result and / or a range steady-state result, wherein the mean steady-state result is used to characterize whether the target data is within a preset data interval, and the range steady-state result is used to characterize whether the target data is in a stable state.
10. An electronic device, characterized in that: include: Processor and memory; The memory is used to store a computer program, and the processor is used to execute the computer program stored in the memory, so that the electronic device executes the method according to any one of claims 1 to 8.
