Abstract: To address the shortcomings in equipment fault management, a database-based voice alarm system for equipment faults was developed. This system provides equipment managers with accurate fault characteristic information and clearly alerts them to the specific faults via voice. Based on the fault characteristics and current maintenance resources, maintenance plans and solutions can be quickly formulated. Seamless connection between the underlying equipment control and upper-level enterprise management is achieved via Ethernet, realizing integrated enterprise-level equipment management. Keywords: equipment fault; phonic alarm; integration Abstract: According to the shortages of equipment management, the fault alarm system of workshop equipment was developed by adopting database. The accurate fault was provided and was alarmed by voice. The maintenance strategy and planning were fast established based on the current maintenance resource state. An seamless integrated approach was provided between industry control and enterprise management by adopting industrial internet. The information management goal of enterprise was realized. Key words: equipment fault; phonic alarm; integration 1 Introduction Equipment is the direct production material of an enterprise. There are many methods for diagnosing its faults, such as the development of a general fault diagnosis expert system based on COM components [1], the current status and prospect of knowledge-based fault diagnosis methods [2]. In order to improve the timeliness of response to equipment faults, many enterprises have developed workshop equipment fault voice systems, and some have even developed configuration software to realize equipment process monitoring, parameter display and fault alarm functions. When equipment fails, the fault alarm system horn sounds to report the equipment failure and displays the fault location information on the host computer. Although existing fault alarm systems provide convenience for equipment maintenance personnel to a certain extent, there are still some shortcomings, such as (1) the horn of the existing alarm system can only indicate that the equipment has malfunctioned, but cannot clearly indicate the fault information. If not handled in time, it will become "noise" pollution; (2) the fault information is only stored on the host computer, without further data analysis and mining, and lacks the ability to provide information for subsequent maintenance management. Therefore, this paper studies and develops an improved equipment fault alarm system to address the shortcomings of the existing fault voice alarm system. 2 Business Process The system business process is shown in Figure 1, which is mainly divided into three parts, including the device end, the host computer end and the server end. The device end is the source of fault information. Each device corresponds to a host computer. The host computer hardware includes a sound card, a network card and a touch screen. The host computer must not only display the fault information on the screen, but also drive the sound equipment to alarm the equipment management personnel with accurate fault information, rather than just staying at the stage of horn sounding. The server end realizes the fault management function of the equipment. Through data sorting, statistics and analysis, it plays a decision support role for equipment management. [align=center]Figure 1: System Business Process[/align] 3. Logical Processing The system's logical processing is as follows: When a fault occurs during equipment operation, fault information is immediately collected. On one hand, the equipment fault parameter information is displayed on the host computer; on the other hand, the system queries the database for voice files based on the fault code, matches the voice files, and drives the voice files to implement the fault voice alarm function, accurately alerting the system to the fault. The fault information is then uploaded to the server, entering the equipment fault follow-up management function to formulate maintenance plans, such as maintenance personnel plans, maintenance tool plans, and spare parts plans. 3.1 The fault information collection system's data input end completes process monitoring and collects equipment fault information in real time. 3.2 The voice alarm module queries the audio library for corresponding fault audio files based on the real-time collected equipment fault codes, matches the audio files, drives the corresponding audio equipment, and outputs the fault audio files, accurately indicating what fault has occurred in the equipment. This allows equipment administrators to accurately know what problem has occurred even when they are not near the host computer. 3.3 The fault management module automatically writes the equipment number and fault code information into the fault preprocessing after a fault occurs, realizing functions such as equipment fault management, historical fault query, and statistical reports. Provide timely information on equipment maintenance resources, such as maintenance tools, maintenance personnel status and spare parts inventory, formulate reasonable maintenance plans, ensure the feasibility of maintenance plans, eliminate faults as soon as possible, and restore production. 4 Fault Repair Implementation Equipment maintenance is an abbreviation for equipment maintenance and repair, which refers to the technical activities taken to maintain and restore the ability of equipment to perform specified functions [3]. At present, most enterprises' equipment management and maintenance resource management are independent of each other, and there is a tendency for equipment management and maintenance resource management to be disconnected. When formulating maintenance plans, there is no actual maintenance resource data for reference. In fact, this information is the basis for formulating maintenance plans, which leads to the inability to implement maintenance plans due to the shortage of maintenance resources. On the other hand, the randomness of current equipment failures also requires that equipment maintenance must be guaranteed by absolute maintenance resources. These internal and external factors require that the equipment bottom management must be effectively linked with the enterprise resource management. According to the fault repair plan, combined with the production operation plan, balance the equipment maintenance capacity and formulate a maintenance plan. The maintenance plan generates a maintenance resource demand plan, including spare parts demand, manpower demand and tool demand, etc. The fault repair implementation process is shown in Figure 2. To solve the decision support problem of maintenance schemes, the system adopts a case-based reasoning mechanism for maintenance schemes. Case-based reasoning is a reasoning method that has emerged in the field of artificial intelligence in recent years. It solves new problems by modifying the successful results of similar problems [4]. It does not require explicit application of domain knowledge models. It learns by acquiring new knowledge as cases. Through the learning function, the case library becomes richer and the reasoning effect becomes better. [align=center] Figure 2 Fault maintenance implementation process[/align] 5 System design and implementation 5.1 System integration With the advent of the information age, there are many forms of networks and many network communication protocols. However, the most successful network in the field of industrial control is Ethernet based on the TCP/IP protocol. Its typical characteristics are (1) openness and the ability to form an integrated enterprise-level management and underlying control; (2) simple structure and low operating cost; (3) reliable operation. This paper adopts an enterprise information network that achieves efficient communication based on Ethernet communication, as shown in Figure 3. [align=center] Figure 3: System Integration Scheme[/align] 5.2 Software Implementation 5.2.1 Database Establishment The database design of the system mainly includes a maintenance solution library and a basic database. (1) Maintenance Solution Library The maintenance solution library is a maintenance knowledge base, which mainly includes typical cases of various fault repairs. (2) Basic Database There are many manufacturing resources in the workshop. The main content of this paper is to establish a library of all equipment and their corresponding spare parts, a library of maintenance personnel and tools, etc.; to create a library of audio files corresponding to all faults; and to establish a library of equipment faults, etc. When establishing the equipment fault table structure in this article, the audio file path is used as a field attribute, as shown in the following example: create table EquipFaults ( vcFaultsNo varchar2(3) not null, ——fault code vcFaultsName varchar2(50) not null, ——fault name vcFaultsDescribe varchar2(50) not null, ——fault description…… vcFaultsPath varchar2(50) not null, ——fault audio file path constraint pk_ EquipFaults primary key (vcFaultsNo) ) 5.2.2 Fault voice matching select vcBreaksPath from EquipFaults where vcFaultsNo = '”+strFailNO+”'”; 6 Conclusion In order to improve the manufacturing execution capability of the production workshop, one of the important factors is to ensure the continuity of production. It is necessary to have the ability to respond quickly to random faults and effectively improve the timeliness and continuity of equipment management. This paper realizes accurate alarm of fault information, solves the current situation of unclear fault alarm information, and quickly formulates maintenance plans and strategies based on the current status of maintenance resources, ensuring the feasibility of maintenance plans. Seamless information integration between the bottom control and the upper management is realized through Ethernet, realizing enterprise-level equipment fault management informatization. The innovation of this paper is: First, in view of the current situation that the existing equipment fault alarm system only sounds the horn, or even becomes "noise" pollution, the database technology is used to realize accurate voice alarm of equipment faults, clearly informing what equipment has failed and the type of fault; Second, the database technology, computer technology and network technology are used to realize seamless connection of information between the bottom control of equipment and the upper enterprise equipment management, realizing the integration of enterprise management and control; Third, the equipment management is integrated with the enterprise resource management to ensure the feasibility of maintenance plans. References [1] Sang Qingbing, Yang Xing, Shi Hui. Development of a general fault diagnosis expert system based on COM components. Microcomputer Information, 2006, No. 2-1, P190-192. [2] Wang Rongjie, Hu Qing. Development status and prospects of knowledge-based fault diagnosis methods. Microcomputer Information, No. 3-1, 2006, P218-220. [3] Equipment Management Engineering, Wu Shijing. Beijing: China Electric Power Press, 2005. [4] Yang Jun, Feng Zhensheng, Huang Kaoli et al. Intelligent Fault Diagnosis Technology for Equipment. Beijing: National Defense Industry Press, 2004.8.