A data management method and system for copper column crimping machine

By designing data management methods and systems on copper column crimping machines, the problem of traditional manual detection is solved, real-time abnormal detection and redundant information removal are achieved, and the stability of equipment operation and the reliability of production lines are improved.

CN118861948BActive Publication Date: 2024-12-06SHENZHEN XIN MAO XIN IND CO LTD
View PDF 2 Cites 0 Cited by

Patent Information

Application Number
CN202411333031.9
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2024-09-24
Publication Date
2024-12-06
Estimated Expiration
2044-09-24

AI Technical Summary

Technical Problem

The data management system of traditional copper column crimping machines relies on manual detection and is inefficient and difficult to detect and deal with abnormalities in real time, resulting in the equipment running in a non-optimal state for a long time, increasing the risk of failure and affecting product quality.

Method used

A data management method and system are designed to obtain and analyze the operation log of the copper column crimping machine by judging access rights, identifying exceptions, extracting exception information, setting levels, and performing correlation analysis to automatically eliminate redundant information and generate priority Level prompts to ensure that critical exception information is handled first.

Benefits of technology

It realizes accurate permission management, real-time abnormal detection, efficient redundant information elimination, in-depth abnormality analysis and intelligent correlation processing, reduces the probability of missed and false alarms, improves the stability of equipment operation and the continuity of production lines. .

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN118861948B_ABST
    Figure CN118861948B_ABST
Patent Text Reader

Abstract

The present invention relates to the technical field of electrical data processing, and discloses a data management method and system for a copper pillar crimping machine, the method comprising: judging access rights, terminating processing if it does not meet the permission configuration; if it meets the permission configuration, obtaining the operation log of the crimping machine, and analyzing whether there is an abnormality. If an abnormality is identified, extract the abnormal information and judge whether it meets the abnormal setting standard. If it meets, it is marked as a valid abnormality and set the level. If it does not meet, analyze the key fields, judge whether it meets the redundant elimination standard, and handle it accordingly. Analyze the correlation between the abnormal log and other logs, determine the output priority according to the correlation and the abnormal level, and generate the analysis results. Through systematic log analysis and abnormality identification, the accuracy and efficiency of the copper pillar crimping machine operation data management are effectively improved. Through authority control, standardized abnormality processing and association analysis, the accuracy of abnormality detection is ensured and the interference of redundant information is reduced.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the technical field of electrical data processing, and in particular to a data management method and system for a copper column crimping machine. Background Art

[0002] With the continuous development of industrial automation and intelligent manufacturing, copper pillar crimping machines, as key equipment in the electronic manufacturing process, undertake important connection and assembly tasks. The copper pillar crimping process has an important impact on the reliability and stability of the connected components, so it is crucial to ensure the normal operation of the copper pillar crimping machine and deal with potential failures in a timely manner.

[0003] Traditional copper pillar crimping machine data management systems usually rely on manual regular inspection and maintenance, which is not only inefficient, but also difficult to detect and handle abnormalities in real time, which may cause the equipment to run in a non-optimal state for a long time, increase the risk of failure, and affect product quality. Summary of the invention

[0004] In view of this, the present invention proposes a data management method for a copper pillar crimping machine, aiming to solve the problem of low manual inspection efficiency of the copper pillar crimping machine in the current technology.

[0005] On the one hand, the present invention provides a data management method for a copper column crimping machine, comprising:

[0006] Determine the access rights. If the access rights do not meet the preset permission configuration, output a prompt indicating insufficient permissions and terminate subsequent processing.

[0007] If the access permission meets the preset permission configuration, the operation log of the copper pillar crimping machine is obtained, and the operation log includes the crimping parameter log, the equipment status log and the fault log;

[0008] Analyze the operation log, and if an abnormality is found after analysis, obtain the corresponding abnormality type; if no abnormality is identified, record the analysis result of the operation log and end the current process;

[0009] Extracting abnormal information from the operation log that is judged to have abnormality, judging whether it meets the abnormal setting standard, if the extracted abnormal information meets the abnormal setting standard, marking the abnormal information as valid abnormal data, and setting a level for the valid abnormal data; if the abnormal information does not meet the set standard, analyzing the key fields of the abnormal information;

[0010] Determine whether the key field meets the redundant information elimination standard. If the key field meets the redundant information elimination standard, eliminate the key field; if the key field does not meet the redundant information elimination standard, continue to monitor the abnormal information without further processing;

[0011] If the key fields meet the exception setting standards, the exception inducing source and impact data are extracted from the exception information; if they do not meet the exception setting standards, no further processing is performed;

[0012] For the operation log determined to be abnormal after analysis, determine whether it is associated with other operation logs. If there is an associated log, and the access permission of the associated log meets the preset permission configuration, obtain the associated log and generate a log missing prompt item, and analyze the associated abnormal item; if there is no associated log or the access permission does not meet the preset permission configuration, analyze the associated abnormal item;

[0013] The analyzing of the associated abnormal items includes: if there are at least two associated abnormal items, setting the output priority of each associated abnormal item according to the abnormal level, and outputting the analysis result; if there is only one associated abnormal item or no associated abnormal item, directly outputting the analysis result.

[0014] Furthermore, the access rights are determined, including:

[0015] Generate an access control list, wherein the generated access control list includes the user names and accessible scopes of all users, authenticates the user based on the user name / password format, and obtains the user's accessible scope through the user name;

[0016] When the user's access content falls within the accessible range, the access permission complies with the preset permission configuration;

[0017] When the access content of the user does not belong to the accessible scope, the access permission does not comply with the preset permission configuration, and a prompt is given that the access permission is insufficient.

[0018] Furthermore, the operation log is analyzed, including:

[0019] According to the real-time and / or regularly generated operation logs of the copper pillar crimping machine, the noise data of the operation logs are removed, missing values ​​are filled, and the data format is unified; the data during normal operation of the copper pillar crimping machine is used to establish a baseline model, and the data in the operation logs are compared with the baseline model. When the data in the operation log is not within the threshold of the baseline model, it is judged that an anomaly exists, and the type of anomaly is determined based on the operation log with the anomaly.

[0020] Furthermore, the crimping parameter log includes pressure information, temperature information and corresponding time information of the copper pillar crimping machine; the equipment status log includes operating status information, vibration level information and energy consumption information of the copper pillar crimping machine; the fault log includes fault duration information;

[0021] The abnormality types correspond one-to-one to the information in the crimping parameter log, the equipment status log, and the fault log, respectively.

[0022] Furthermore, when setting the level of valid abnormal data, it includes:

[0023] Extracting abnormal information from the operation log identified as abnormal, and comparing the abnormal information with a preset abnormal setting standard, wherein the abnormal setting standard is a threshold range corresponding to the information in the operation data, and the threshold preset by the abnormal setting standard is greater than the threshold of the baseline model;

[0024] When the abnormal information is within the threshold of the abnormal setting standard, the level of the abnormal information is set to level 2 and recorded as valid abnormal data;

[0025] When the abnormal information is not within the threshold of the abnormal setting standard, the level of the abnormal information is set to level one.

[0026] Furthermore, the key fields include pressure information, temperature information, corresponding time information, operating status information, vibration level information, energy consumption information and fault duration information of the copper pillar crimping machine of abnormal information.

[0027] Furthermore, the redundant information elimination criteria include:

[0028] The length of the time window is pre-set. When there are at least two log messages of the same exception type in the same time window, it is judged that the key field meets the redundant information elimination standard. At this time, the log information farthest from the baseline model is retained, and all other log messages of the same exception type are eliminated.

[0029] Furthermore, if the key fields meet the set standards, the abnormality inducing source and impact data are extracted from the abnormal information; if they do not meet the set standards, no further processing is performed, including:

[0030] When the key field meets the abnormal setting standard, the meeting time point is recorded, the time cutoff value is preset, the operation log at the time point of the meeting minus the time cutoff value, and the operation log at the meeting time point are obtained, the fluctuation value of each information in the operation log is calculated, and the information with the largest fluctuation value is selected as the abnormality inducing source;

[0031] After the abnormality inducing source is identified, the impact data associated with the inducing source is extracted.

[0032] Furthermore, when determining whether there is a correlation with other operation logs, time correlation analysis is performed in sequence: the timestamps of the current operation log and other operation logs are compared. If it is determined that other operation logs have abnormal information at the same timestamp, it is determined that there is a correlation;

[0033] When analyzing the associated abnormal items, the abnormal types are sorted in advance, and each associated abnormal item is classified according to the abnormal type; and the output priority is assigned according to the abnormal type sort of each associated abnormal item.

[0034] On the other hand, the present invention also proposes a system for a data management method for a copper column crimping machine, the system comprising:

[0035] The authority management module is configured to verify the access rights of the user or system to the operation log; according to the preset authority configuration, determine whether the requesting party has the authority to access the operation log of the copper pillar crimping machine;

[0036] The log management module is configured to obtain, store and manage the operation log of the copper pillar crimping machine; obtain various log data of the copper pillar crimping machine, including crimping parameter log, device status log and fault log;

[0037] The data analysis module is responsible for analyzing the operation log, identifying anomalies, and extracting anomaly-related information; performing a preliminary analysis on the acquired operation log to determine whether there are anomalies; extracting anomaly information, and making judgments and processing according to the preset anomaly setting standards; if valid anomaly data is identified, it is marked as valid and an anomaly level is set for it; if no anomaly is identified, the log analysis results are recorded and the current process ends;

[0038] The exception handling module further analyzes and processes the extracted exception information; analyzes the key fields in the extracted exception information to determine whether they meet the redundant information elimination criteria; eliminates the key fields that meet the redundant criteria and continues to monitor the exception information; extracts the exception inducing source and influencing data for the key fields that meet the exception setting criteria; and passes the processed exception data to the correlation analysis module;

[0039] The correlation analysis module determines the correlation between the exception log and other logs, and analyzes multiple related exception items; checks the correlation between the exception log and other operation logs, and identifies whether there are related exception items; if there are related logs, verifies their access rights, generates log missing prompt items, analyzes multiple related exception items, sets their output priority according to the exception level, and outputs the analysis results for system display or further processing.

[0040] The data storage module is used to store all data and analysis results during the system operation process, and store operation logs, exception information, analysis results, permission configuration and other data.

[0041] Compared with the prior art, the present invention has the following beneficial effects:

[0042] Accurate permission management: Through the access control list, the user's access rights to the copper pillar crimping machine operation log are strictly controlled to ensure data security and reliable operation of the system, and prevent data leakage or misoperation caused by unauthorized access.

[0043] Real-time anomaly detection: The system can obtain and analyze the operation log of the copper pillar crimping machine in real time, quickly identify anomalies by comparing with the baseline model, and classify the anomalies according to the set standards, effectively reducing the probability of missed reports and false alarms and ensuring the stability of equipment operation.

[0044] Efficient redundant information elimination: Using the redundant information elimination standard, the system can automatically eliminate unnecessary repeated information, reduce the redundancy of data storage and processing, and improve the system's processing efficiency and resource utilization.

[0045] In-depth exception analysis: By analyzing the key fields in the exception information, the system can accurately extract the exception source and related impact data, helping operation and maintenance personnel to locate the root cause of the problem more quickly, reduce fault handling time, and improve the continuity and reliability of the production line.

[0046] Intelligent processing of associated exceptions: The system can automatically analyze the correlation between exception logs and set output priorities according to the exception level to ensure that key exception information is processed first, reducing equipment downtime or production interruptions caused by untimely processing of associated exceptions.

[0047] Comprehensive data storage and management: Through the data storage module, the system can fully record operation logs, abnormal information and analysis results, providing reliable data support for subsequent maintenance, auditing and optimization, and further improving the maintainability and scalability of the system. BRIEF DESCRIPTION OF THE DRAWINGS

[0048] Various other advantages and benefits will become apparent to those of ordinary skill in the art by reading the detailed description of the preferred embodiments below. The accompanying drawings are only for the purpose of illustrating the preferred embodiments and are not to be considered as limiting the present invention. Moreover, the same reference symbols are used throughout the accompanying drawings to represent the same components. In the accompanying drawings:

[0049] Figure 1 This is a flow chart of a data management method for a copper column crimping machine according to an embodiment of the present invention;

[0050] Figure 2 The present invention is a functional block diagram of a data management system for a copper pillar crimping machine according to an embodiment of the present invention. DETAILED DESCRIPTION

[0051] Exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although exemplary embodiments of the present disclosure are shown in the accompanying drawings, it should be understood that the present disclosure can be implemented in various forms and should not be limited by the embodiments described herein. On the contrary, these embodiments are provided in order to enable a more thorough understanding of the present disclosure and to fully convey the scope of the present disclosure to those skilled in the art. It should be noted that, in the absence of conflict, the embodiments of the present invention and the features described in the embodiments can be combined with each other. The present invention will be described in detail below with reference to the accompanying drawings and in combination with the embodiments.

[0052] See also Figure 1 As shown, an embodiment of the present invention provides a data management method for a copper column crimping machine, comprising:

[0053] Determine the access rights. If the access rights do not meet the preset permission configuration, output a prompt indicating insufficient permissions and terminate subsequent processing.

[0054] If the access permission meets the preset permission configuration, the operation log of the copper pillar crimping machine is obtained, which includes the crimping parameter log, device status log and fault log;

[0055] Analyze the operation log. If an abnormality is found after analysis, obtain the corresponding abnormality type. If no abnormality is identified, record the analysis result of the operation log and end the current process.

[0056] Extract the abnormal information in the operation log that is judged to have abnormalities, and determine whether it meets the abnormal setting standards. If the extracted abnormal information meets the abnormal setting standards, mark the abnormal information as valid abnormal data and set a level for the valid abnormal data; if the abnormal information does not meet the set standards, analyze the key fields of the abnormal information;

[0057] Determine whether the key field meets the redundant information elimination standard. If the key field meets the redundant information elimination standard, eliminate the key field; if the key field does not meet the redundant information elimination standard, continue to monitor the abnormal information without further processing;

[0058] If the key fields meet the exception setting standards, the exception inducing source and impact data are extracted from the exception information; if they do not meet the exception setting standards, no further processing is performed;

[0059] For the operation logs that are judged to be abnormal after analysis, determine whether they are associated with other operation logs. If there are related logs and the access rights of the related logs meet the preset permission configuration, obtain the related logs and generate log missing prompt items, and analyze the related abnormal items; if there are no related logs or the access rights do not meet the preset permission configuration, analyze the related abnormal items;

[0060] Analyzing the associated abnormal items includes: if there are at least two associated abnormal items, setting the output priority of each associated abnormal item according to the abnormality level, and outputting the analysis result; if there is only one associated abnormal item or no associated abnormal item, directly outputting the analysis result.

[0061] It can be explained that by verifying the user's access rights, preventing unauthorized access, and protecting the device's operation log from unauthorized reading and modification, data security is guaranteed. Log acquisition and analysis: It can obtain the operation log of the copper pillar crimping machine and analyze it to detect abnormalities in time, ensure that the equipment can operate stably, and reduce the possibility of failure. Exception handling: After the abnormality is found, the abnormal information can be further classified and processed according to the preset standards to ensure timely response to important abnormalities and filter out unnecessary alarms. Redundant information elimination: By eliminating unnecessary redundant information, the data processing process can be optimized, the waste of storage and computing resources can be reduced, and the overall efficiency can be improved. Deep abnormal analysis: It can deeply analyze abnormal information, identify key fields, and extract abnormal inducing sources and influencing data to help quickly locate the root cause of the problem and reduce the time for fault handling. Correlation abnormal analysis: By analyzing the correlation between different logs, multiple abnormal items can be comprehensively evaluated, and the processing priority can be reasonably arranged to ensure priority processing of key issues and reduce the risk of equipment downtime or production interruption.

[0062] This embodiment can improve data security: through strict permission management, unauthorized access is prevented, and the security of sensitive data is effectively protected.

[0063] Enhanced accuracy of anomaly detection: Through in-depth analysis of operation logs and anomaly classification, anomalies in equipment operation can be more accurately identified and handled, reducing false positives and missed negatives.

[0064] Optimize resource utilization: The redundant information elimination standard effectively reduces the processing of useless data, improves the efficiency of data processing, and saves storage and computing resources.

[0065] Shorten troubleshooting time: Through in-depth analysis of abnormal information, the source of the problem can be quickly located, reducing the time for maintenance and troubleshooting, and improving the normal operation time of the equipment.

[0066] Comprehensive management of multiple exceptions: Ability to comprehensively evaluate multiple related exceptions, reasonably assign processing priorities, ensure that key exceptions are handled first, and reduce the risk of equipment damage and production interruption.

[0067] Improve equipment operation stability: Through comprehensive management of equipment operation logs and exception handling, it is possible to continuously monitor and maintain the normal operation of equipment, improve production efficiency and equipment reliability.

[0068] In some embodiments of the present invention, determining access rights includes:

[0069] Generate an access control list, which includes the usernames and accessible scopes of all users, authenticate users based on username / password, and obtain the accessible scope of users through usernames;

[0070] When the user's access content falls within the accessible range, the access rights comply with the preset permission configuration;

[0071] When the user's access content does not belong to the accessible scope, the access permission does not meet the preset permission configuration, and a prompt is displayed that the access permission is insufficient.

[0072] It is understandable that generating access control lists and strictly authenticating users can effectively prevent unauthorized access, ensure the security of sensitive data and device operation logs, and avoid potential data leakage risks. By accurately defining the accessible scope of each user, it can be ensured that each user can only access data and functions related to their duties. This hierarchical access control mechanism avoids users from overstepping their authority and ensures the compliance of operations. When a user attempts to access content that is not within his or her authority, access will be immediately denied and the user will be prompted for insufficient authority. This mechanism can effectively prevent the impact of misoperation or malicious operation on the system and reduce operational risks. Through automated access control, system administrators can easily manage the permissions of different users, reduce the workload of manually configuring permissions, and improve management efficiency and accuracy. By recording each user's access rights and access behavior, all operations can be audited and traced, providing a basis for subsequent security analysis and troubleshooting.

[0073] Enhanced data protection: This method can effectively prevent unauthorized access and ensure that only authorized users can access sensitive information, thereby greatly improving data security. Accurate permission control: Through detailed access control lists, the access scope of each user can be accurately controlled to avoid unnecessary data exposure and reduce the risk of misoperation. Automated management: Automatically generate and manage access control lists, reduce human errors, improve the accuracy and consistency of permission configuration, and make permission management more efficient and reliable. Instant feedback: Instantly prompt users when permissions are insufficient, and quickly guide users to correct operations, saving time and reducing potential errors or safety hazards. Operation transparency: Through the preservation and management of user access records, system administrators can review permission settings and user behaviors at any time, increasing the transparency and traceability of operations.

[0074] During initialization or when adding a new user, permissions are preset according to user roles or responsibilities, and an access control list containing all user names and corresponding accessible ranges is generated. This list is a core data structure used to store and manage the permission information of each user. When a user tries to access the system, the system first asks the user to provide a username and password. An encryption algorithm is used to verify whether the password entered by the user matches the password hash value stored in the database to confirm the user's identity. After the user successfully logs in, the access control list is queried according to the username to obtain the accessible range of the user. Whenever a user tries to access a specific resource or data, check whether the resource is within the user's accessible range. If the access request is within the user's accessible range, access is allowed and the operation log is recorded; if it is not within the accessible range, the request is rejected and the user is prompted with "insufficient permissions" to prevent illegal access. Dynamic modification of the access control list is supported, and administrators can adjust user permissions in real time as needed. This flexible permission management method ensures that the system can adapt to changes in organizational structure and business processes. For each permission verification and access operation, the system will record logs, including information such as user name, time, access resource, and verification results. These logs are used for subsequent audit analysis to ensure the transparency and compliance of system operations.

[0075] Through this method, accurate, flexible, and secure access control management can be achieved, providing a solid security foundation for the entire data management system.

[0076] In some embodiments of the present invention, analyzing the operation log includes:

[0077] According to the real-time and / or regularly generated operation logs of the copper pillar crimping machine, the noise data of the operation logs is removed, missing values ​​are filled, and the data format is unified. The baseline model is established using the data during normal operation of the copper pillar crimping machine, and the data in the operation logs are compared with the baseline model. When the data in the operation log is not within the threshold of the baseline model, it is judged that there is an anomaly, and the type of anomaly is determined based on the operation log with the anomaly.

[0078] It is understandable that by obtaining the operation log of the copper pillar crimping machine in real time or regularly and performing comprehensive data processing on it, the high quality and consistency of the data are ensured. First, by removing noise data, filling missing values ​​and unifying data formats, the accuracy and completeness of the data are improved, thus providing a reliable basis for subsequent analysis and judgment. This process can effectively filter out invalid or misleading information and avoid misjudgments caused by data quality problems. Secondly, the baseline model is established using the data of the copper pillar crimping machine during normal operation to ensure that the model can accurately reflect the operating parameters of the equipment under ideal conditions. By comparing the real-time operation log data with this baseline model, any abnormal situation that deviates from the normal range can be detected quickly and accurately. When the data in the operation log is not within the threshold of the baseline model, it can be judged in time that there is an abnormality, and the type of abnormality can be further determined based on the abnormal log. In this way, not only can the potential failure of the equipment be discovered early, but also the root cause of the problem can be accurately located to prevent small problems from turning into major failures, greatly improving the operation reliability and production safety of the equipment. In addition, through automated data processing and anomaly detection, the burden of manual monitoring is reduced and the operation and maintenance efficiency is improved.

[0079] First, obtain the real-time and / or periodically generated operation logs of the copper pillar crimping machine, which may contain various operating parameters, status information, and historical records of the equipment. To ensure the accuracy of data analysis, the acquired log data is preprocessed to remove noise data first. This step is achieved by filtering out abnormal and meaningless data points (such as acquisition errors or instantaneous fluctuations). Then, the missing values ​​that may exist in the log are automatically filled, and the continuity of the data is ensured by methods such as interpolation, averaging, or reference to adjacent data. Next, the log data is formatted uniformly, and data from different sources or types are standardized into a consistent format to facilitate subsequent analysis and processing.

[0080] After completing the data preprocessing, a baseline model is established based on the historical normal operation data of the equipment. This model represents the reasonable range of various parameters of the copper pillar crimping machine during normal operation. The real-time collected operation log data is compared and analyzed with the baseline model to monitor the operation status of the equipment in real time. When the log data at a certain moment is not within the preset threshold range of the baseline model, it is judged that there is an abnormality at that moment, and then the type of the abnormality is further determined by the preset algorithm or rule. For example, the specific type of fault or abnormal state can be judged based on the characteristics of the abnormal data (such as abnormalities of parameters such as temperature and pressure), thereby providing accurate fault warning and diagnostic information for operation and maintenance personnel. This implementation method not only ensures the safety of equipment operation, but also greatly improves the efficiency of problem detection and processing.

[0081] In some embodiments of the present invention, the crimping parameter log includes pressure information, temperature information and corresponding time information of the copper pillar crimping machine; the equipment status log includes information on the operating status, vibration level information and energy consumption information of the copper pillar crimping machine; the fault log includes fault duration information;

[0082] The exception types correspond to the information in the crimping parameter log, equipment status log, and fault log respectively.

[0083] Specifically, the crimping parameter log records the actual pressure applied by the copper pillar crimping machine during operation. This is an important operating parameter to ensure that the crimping quality meets the design requirements. The temperature of each component of the copper pillar crimping machine during operation is recorded. This can help monitor whether the working environment of the equipment is normal and prevent failures caused by overheating. The timestamp associated with the pressure and temperature information ensures that it can be traced back to the specific moment of operation. This helps analyze the behavior of the equipment and its possible anomalies during a specific time period.

[0084] The equipment status log records the current working status of the equipment, such as whether it is in normal working mode, standby mode, or fault state. This helps to understand the overall operation of the equipment. Record the vibration level of the equipment during operation. Abnormal vibration may indicate mechanical problems or equipment imbalance. Record the energy consumption data of the equipment to monitor whether the equipment is within the normal energy consumption range. Abnormal energy consumption patterns may indicate performance problems or failures of the equipment.

[0085] The fault log records the time each fault occurs and how long it lasts. This helps assess the severity and frequency of faults and provides reference data for maintenance and repairs.

[0086] The correspondence between the abnormality type and the log information: Abnormalities in the crimping parameter log: For example, the pressure information is out of the set range or the temperature is abnormal. This usually indicates a problem in the crimping process, which may affect the quality of the final product. Abnormalities in the equipment status log: Such as abnormal operating status, excessive vibration levels, or abnormal energy consumption. These abnormalities may indicate mechanical failure, wear or other performance problems of the equipment. Abnormalities in the fault log: Including abnormally long or frequent fault duration. This usually indicates that there is a serious fault problem with the equipment and it needs to be resolved as soon as possible to resume normal operation.

[0087] In some embodiments of the present invention, when setting the level of valid abnormal data, it includes:

[0088] Extract abnormal information from the operation log identified as abnormal, and compare the abnormal information with the preset abnormal setting standard. The abnormal setting standard is a threshold range that corresponds to the information in the operation data one by one, and the threshold preset by the abnormal setting standard is greater than the threshold of the baseline model;

[0089] When the abnormal information is within the threshold of the abnormal setting standard, the level of the abnormal information is set to level 2 and recorded as valid abnormal data;

[0090] When the abnormal information is not within the threshold of the abnormal setting standard, the level of the abnormal information is set to level one.

[0091] It should be noted that the abnormal setting standards can be pre-defined by the administrator or the system, including the allowable parameter range, the severity of a specific error code, the deviation range of the equipment status from normal operation, etc. For example, the standard may stipulate that a pressure exceeding 2000psi is an abnormality, and a temperature below 50°C is an abnormality.

[0092] Extract abnormal information: Extract relevant data identified as abnormal from the operation log. This data may include abnormal values ​​of parameters such as pressure, temperature, vibration, and energy consumption.

[0093] Compare with abnormal setting standards: Compare the extracted abnormal information with the preset abnormal setting standards. The abnormal setting standards are threshold ranges set based on operating data, which are usually higher than the normal operating range defined in the baseline model.

[0094] Set the abnormality level: Level 2: When the value of the abnormal information is within the threshold range of the abnormal setting standard, the abnormal information is set as a level 2 abnormality. This means that the abnormal situation is relatively minor, but still needs attention, recording and processing.

[0095] Level 1: When the value of the abnormal information is not within the threshold range of the abnormal setting standard, the abnormal information is set as level 1 abnormality. This means that the abnormal situation is serious and needs to be handled immediately, and may have a significant impact on the operation of the equipment.

[0096] By classifying abnormal data into primary and secondary levels, the severity of abnormalities can be effectively distinguished. This helps prioritize more serious abnormalities and ensures that resources and attention are focused on the most critical issues. Setting clear abnormality levels makes the handling response strategy more orderly. Emergency handling and repair of primary abnormalities, while regular inspection and maintenance of secondary abnormalities optimize the maintenance and operation process of the equipment. By setting the abnormality setting standard above the baseline model threshold, false positives and false alarms can be reduced. Only when the abnormal data deviates significantly from the normal range will it be marked as a primary abnormality, thereby improving the accuracy and reliability of data analysis. By recording abnormal data of different levels, long-term trend analysis can be performed to identify potential problems with equipment or processes. This analysis helps to make improvements, reduce future abnormal events, and improve the overall stability and performance of the equipment. Clear abnormality level division helps maintenance personnel identify and respond to problems faster. The maintenance team can prioritize severe primary abnormalities, reduce equipment downtime, and improve production efficiency.

[0097] In some embodiments of the present invention, the key fields include pressure information, temperature information, corresponding time information, operating status information, vibration level information, energy consumption information and fault duration information of the copper pillar crimping machine of abnormal information.

[0098] In some embodiments of the present invention, the redundant information elimination criteria include:

[0099] The length of the time window is pre-set. When there are at least two log messages of the same abnormal type in the same time window, the key field is judged to meet the redundant information elimination criteria. At this time, the log message farthest from the baseline model is retained, and all other log messages of the same abnormal type are eliminated.

[0100] It should be noted that a time window is defined, and the log information within the window will be used to determine whether there is redundancy. The length of the time window is set according to actual needs, such as 5 minutes, 10 minutes or other appropriate durations. Within the set time window, all log information is collected, and whether there are records of the same abnormal type in these logs. The same abnormal type refers to abnormal data with similar characteristics or classifications, such as the same fault code or similar error information. When there are at least two log records of the same abnormal type within the time window, these records are judged to be redundant information. At this time, they are processed according to the redundant information elimination standard. Among the redundant logs detected, the log information with the largest deviation from the baseline model threshold (i.e., the farthest from the baseline model) is selected for retention. This is because the data farthest from the baseline model usually represents a more serious or abnormal situation. Delete the remaining log records of the same abnormal type within the time window. This can reduce duplicate data and avoid excessive redundancy of information.

[0101] This embodiment can improve data processing efficiency: by eliminating redundant exception logs, the amount of data can be reduced, storage and processing efficiency can be optimized, and the performance burden caused by processing duplicate data can be avoided.

[0102] Reduce system burden: After reducing redundant information, the system only needs to focus on and process representative or severe abnormal data, thereby reducing the burden of data processing and analysis.

[0103] Optimize fault diagnosis: Keeping logs that deviate the most from the baseline model helps identify the most serious anomalies. This makes fault diagnosis more accurate and prioritizes anomalies that have the greatest impact on the system.

[0104] Improve data quality: By eliminating redundant information, the recorded data is ensured to be more useful and accurate, and the quality and reliability of data analysis is improved.

[0105] Enhanced decision support: Reducing redundant logs while retaining the most representative exception information helps provide more effective decision support and promotes targeted problem solving and system improvement.

[0106] Promote continuous improvement: By analyzing the most serious exception records retained, potential system bottlenecks and problems can be identified to promote continuous improvement and optimization.

[0107] In some embodiments of the present invention, if the key field meets the set standard, the abnormality inducing source and the impact data are extracted from the abnormal information; if it does not meet the set standard, no further processing is performed, including:

[0108] When the key field meets the abnormal setting standard, record the time point that meets the standard, pre-set the time cutoff value, obtain the operation log at the time point that meets the standard minus the time cutoff value, and the operation log at the time point that meets the standard, calculate the fluctuation value of each information in the operation log, and select the information with the largest fluctuation value as the abnormality inducing source;

[0109] After the abnormality inducing source is identified, the impact data associated with the inducing source is extracted.

[0110] It should be noted that the impact data includes: the specific equipment status when the anomaly occurs (such as whether the equipment is working), the historical change trend of relevant parameters, other equipment components or system functions that may be affected by the anomaly inducing source, etc.

[0111] For example, if the anomaly inducing source is excessive temperature, the impact data may include the temperature rise rate, duration, and the impact that the temperature change may have on the overall performance of the crimping machine.

[0112] It is understandable that when the key field meets the abnormal setting standard, the time point when the abnormality occurs is recorded first. This time point is the benchmark for analysis. A time cutoff value is set in advance to determine the time range to be traced back from the abnormal time point. The length of this time cutoff value depends on the actual needs and the nature of the abnormality, such as 5 minutes, 10 minutes, etc. According to the set time cutoff value, trace back from the abnormal time point, obtain the operation log at the time point minus the time cutoff value and the operation log at the abnormal time point. The data of these two time points will be used for subsequent analysis. Analyze the operation logs within the traceback period and calculate the fluctuation value of each information field. The fluctuation value indicates the degree of change of the information within the time period and is an important indicator for measuring the impact of the abnormality. Select the information with the largest fluctuation value as the abnormality inducing source. The abnormal fluctuation of this information field usually represents the most significant source of problems in the system. After identifying the abnormality inducing source, extract the impact data associated with the inducing source from the operation log. These data can help further analyze the impact range and consequences of the abnormality.

[0113] This embodiment can accurately locate the main source of the anomaly by calculating the fluctuation value of each field and selecting the field with the largest fluctuation value. This helps to quickly find the root cause of the problem and improve the efficiency of fault handling. After determining the source of the anomaly, resources can be concentrated to optimize or repair the source, thereby improving the overall performance and stability of the system. Extracting the impact data related to the anomaly-inducing source can more comprehensively understand the impact of the anomaly on the system, enhance the accuracy of fault diagnosis, and help formulate more effective solutions. By screening key fields that meet the anomaly setting standards, the processing of abnormal data that does not meet the standards is reduced, the false alarm rate of the system is reduced, and the pertinence of the analysis is improved. Detailed anomaly analysis based on actual data is provided to support data-driven decision-making processes and help engineers and managers make more scientific decisions. Identifying anomaly-inducing sources and related impact data helps to discover potential problems, promote improvements and upgrades, and enhance long-term reliability and efficiency.

[0114] In some embodiments of the present invention, when determining whether there is a correlation with other operation logs, time correlation analysis is performed in sequence: comparing the timestamps of the current operation log and other operation logs, if it is determined that there is abnormal information in other operation logs at the same timestamp, it is determined that there is a correlation;

[0115] When analyzing the associated abnormal items, the abnormal types are sorted in advance, and each associated abnormal item is classified according to the abnormal type; and the output priority is assigned according to the abnormal type sort of each associated abnormal item.

[0116] See also Figure 2 As shown, an embodiment of the present invention further provides a data management system for a copper column crimping machine, comprising:

[0117] The authority management module is configured to verify the access rights of the user or system to the operation log; according to the preset authority configuration, determine whether the requesting party has the authority to access the operation log of the copper pillar crimping machine;

[0118] The log management module is configured to obtain, store and manage the operation log of the copper pillar crimping machine; obtain various log data of the copper pillar crimping machine, including crimping parameter log, device status log and fault log;

[0119] The data analysis module is responsible for analyzing the operation log, identifying anomalies, and extracting anomaly-related information; performing a preliminary analysis on the acquired operation log to determine whether there are anomalies; extracting anomaly information, and making judgments and processing according to the preset anomaly setting standards; if valid anomaly data is identified, it is marked as valid and an anomaly level is set for it; if no anomaly is identified, the log analysis results are recorded and the current process ends;

[0120] The exception handling module further analyzes and processes the extracted exception information; analyzes the key fields in the extracted exception information to determine whether they meet the redundant information elimination criteria; eliminates the key fields that meet the redundant criteria and continues to monitor the exception information; extracts the exception inducing source and influencing data for the key fields that meet the exception setting criteria; and passes the processed exception data to the correlation analysis module;

[0121] The correlation analysis module determines the correlation between the exception log and other logs, and analyzes multiple related exception items; checks the correlation between the exception log and other operation logs, and identifies whether there are related exception items; if there are related logs, verifies their access rights, generates log missing prompt items, analyzes multiple related exception items, sets their output priority according to the exception level, and outputs the analysis results for system display or further processing.

[0122] The data storage module is used to store all data and analysis results during the system operation process, and store operation logs, exception information, analysis results, permission configuration and other data.

[0123] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention rather than to limit it. Although the present invention has been described in detail with reference to the above embodiments, ordinary technicians in the relevant field should understand that the specific implementation methods of the present invention can still be modified or replaced by equivalents. Any modification or equivalent replacement that does not depart from the spirit and scope of the present invention should be covered within the scope of protection of the claims of the present invention.

Claims

1. A data management method for a copper column crimping machine, characterized in that: include: Determine the access rights. If the access rights do not meet the preset permission configuration, output a prompt indicating insufficient permissions and terminate subsequent processing. If the access permission meets the preset permission configuration, the operation log of the copper pillar crimping machine is obtained, and the operation log includes the crimping parameter log, the equipment status log and the fault log; Analyze the operation log, and if an abnormality is found after analysis, obtain the corresponding abnormality type; If no abnormality is identified, the analysis result of the operation log is recorded and the current process ends; Extracting abnormal information from the operation log that is judged to have abnormality, judging whether it meets the abnormal setting standard, if the extracted abnormal information meets the abnormal setting standard, marking the abnormal information as valid abnormal data, and setting a level for the valid abnormal data; if the abnormal information does not meet the set standard, analyzing the key fields of the abnormal information; Determine whether the key field meets the redundant information elimination standard. If the key field meets the redundant information elimination standard, eliminate the key field; if the key field does not meet the redundant information elimination standard, continue to monitor the abnormal information without further processing; If the key fields meet the exception setting standards, the exception inducing source and impact data are extracted from the exception information; if they do not meet the exception setting standards, no further processing is performed; For the operation log determined to be abnormal after analysis, determine whether it is associated with other operation logs. If there is an associated log, and the access permission of the associated log meets the preset permission configuration, obtain the associated log and generate a log missing prompt item, and analyze the associated abnormal item; If there is no associated log or the access rights do not meet the preset permission configuration, analyze the associated abnormal items; The analyzing the associated abnormal items includes: if there are at least two associated abnormal items, setting the output priority of each of the associated abnormal items according to the abnormality level, and outputting the analysis result; if there is only one associated abnormal item or no associated abnormal item, directly outputting the analysis result; Among them, judging access rights includes: Generate an access control list, wherein the generated access control list includes the user names and accessible scopes of all users, authenticates the user based on the user name / password format, and obtains the user's accessible scope through the user name; When the user's access content falls within the accessible range, the access permission complies with the preset permission configuration; When the user's access content does not belong to the accessible scope, the access rights do not meet the preset permission configuration, and a prompt is displayed that the access rights are insufficient; Analyzing the operation log includes: According to the copper pillar crimping machine, real-time and / or periodically generated operation logs are obtained, and noise data is removed, missing values ​​are filled, and data formats are unified for the operation log data; a baseline model is established using data during normal operation of the copper pillar crimping machine, and the data in the operation log is compared with the baseline model. When the data in the operation log is not within the threshold of the baseline model, it is determined that an abnormality exists, and the type of abnormality is determined according to the operation log with the abnormality; The crimping parameter log includes the pressure information, temperature information and corresponding time information of the copper pillar crimping machine; the equipment status log includes the operating status information, vibration level information and energy consumption information of the copper pillar crimping machine; the fault log includes fault duration information; The abnormality types correspond one-to-one to the information in the crimping parameter log, the equipment status log and the fault log respectively; When setting levels for valid exception data, include: Extracting abnormal information from the operation log identified as abnormal, and comparing the abnormal information with a preset abnormal setting standard, wherein the abnormal setting standard is a threshold range corresponding to the information in the operation data, and the threshold preset by the abnormal setting standard is greater than the threshold of the baseline model; When the abnormal information is within the threshold of the abnormal setting standard, the level of the abnormal information is set to level 2 and recorded as valid abnormal data; When the abnormal information is not within the threshold of the abnormal setting standard, the level of the abnormal information is set to level one; The key fields include pressure information, temperature information, corresponding time information, operation status information, vibration level information, energy consumption information and fault duration information of the copper pillar crimping machine of abnormal information; The redundant information elimination criteria include: The length of the time window is preset. When there are at least two log messages of the same abnormal type in the same time window, it is determined that the key field meets the redundant information elimination standard. At this time, the log message farthest from the baseline model is retained, and all other log messages of the same abnormal type are eliminated. If the key fields meet the set standards, the abnormality-inducing source and impact data are extracted from the abnormal information; if they do not meet the set standards, no further processing is performed, including: When the key field meets the abnormal setting standard, the meeting time point is recorded, the time cutoff value is preset, the operation log at the time point of the meeting minus the time cutoff value, and the operation log at the meeting time point are obtained, the fluctuation value of each information in the operation log is calculated, and the information with the largest fluctuation value is selected as the abnormality inducing source; After identifying the abnormality inducing source, extracting the impact data associated with the inducing source; When determining whether there is a correlation with other operation logs, time correlation analysis is performed in sequence: the timestamps of the current operation log and other operation logs are compared. If it is determined that other operation logs have abnormal information at the same timestamp, it is determined that there is a correlation; When analyzing the associated abnormal items, the abnormal types are sorted in advance, and each associated abnormal item is classified according to the abnormal type; and the output priority is assigned according to the abnormal type sort of each associated abnormal item.

2. A data management system for a copper column crimping machine, characterized in that: Used to implement the data management method for a copper column crimping machine according to claim 1, the system comprises: The authority management module is configured to verify the access rights of the user or system to the operation log; according to the preset authority configuration, determine whether the requesting party has the authority to access the operation log of the copper pillar crimping machine; The log management module is configured to obtain, store and manage the operation log of the copper pillar crimping machine; obtain various log data of the copper pillar crimping machine, including crimping parameter log, device status log and fault log; The data analysis module is responsible for analyzing the operation log, identifying anomalies, and extracting anomaly-related information; performing a preliminary analysis on the acquired operation log to determine whether there are anomalies; extracting anomaly information, and making judgments and processing according to the preset anomaly setting standards; if valid anomaly data is identified, it is marked as valid and an anomaly level is set for it; if no anomaly is identified, the log analysis results are recorded and the current process ends; The exception handling module further analyzes and processes the extracted exception information; analyzes the key fields in the extracted exception information to determine whether they meet the redundant information elimination criteria; eliminates the key fields that meet the redundant criteria and continues to monitor the exception information; extracts the exception inducing source and influencing data for the key fields that meet the exception setting criteria; and passes the processed exception data to the correlation analysis module; The correlation analysis module determines the correlation between the abnormal log and other logs, and analyzes multiple related abnormal items; checks the correlation between the abnormal log and other operation logs, and identifies whether there are related abnormal items; if there are related logs, verifies their access rights, generates log missing prompt items, analyzes multiple related abnormal items, sets their output priority according to the abnormal level, and outputs the analysis results for system display or further processing; The data storage module is used to store all data and analysis results during the system operation process, and store operation logs, exception information, analysis results, permission configuration and other data.

Citation Information

Patent Citations

  • Abnormal log reporting method and system, terminal equipment and storage medium

    CN116909838A

  • Fault analysis apparatus, fault analysis method, and recording medium

    US20100325489A1