Equipment fault interactive query maintenance method and system

Abstract

The invention discloses an equipment fault interactive query maintenance method and system. The system comprises an equipment classification module, a fault collection module, a database, a database maintenance module and a statistical analysis module. According to the method, through digital iteration, a traditional implementation method taking result management as a main method is avoided, and real-time updating and controllability of behavior data of process control are achieved.

Description

Technical Field

[0001] The invention relates to the field of fault maintenance of command and control equipment, and in particular to an equipment fault interactive query and maintenance method and system. Background Art

[0002] With the enhancement of the software functions and communication equipment of the entire command and control system, the comprehensive knowledge and skills requirements for equipment maintenance and use personnel in various aspects such as computers, networks, communications and business have also increased accordingly. It is difficult to require a large number of maintenance personnel to master the above knowledge at the same time, which has greatly increased the difficulty of command and control equipment support. Equipment maintenance and troubleshooting currently rely mainly on manual experience, and efficiency has been limited. With the development of the command and control industry, the number of equipment has increased year by year, the number of faults has also increased exponentially, and the types of faults have also shown diversity, so scientific and systematic management of equipment failures is an urgent problem to be solved.

[0003] The training cycle for equipment maintenance and use personnel is generally a three-step process of training, practical operation, and experience accumulation. The experience of personnel increases year by year with work experience. Not only is there a relatively long training cycle, but there are also some defects and deficiencies:

[0004] The experience of maintenance personnel is difficult to reuse. When solving problems, maintenance personnel mainly rely on past experience, which is difficult to be reused by others. Different people have different experiences and understandings, which can easily lead to different solutions to the same problem. At the same time, there will be inadequate understanding and incomplete solutions, which will lead to the problem still not being solved the next time it is encountered, which seriously affects the maintenance efficiency.

[0005] The existing equipment maintenance process is mainly based on top-down result management, lacking timely problem data collection and feedback. Maintenance companies are also unable to discover and solve problems in a timely manner during use, and lack effective management and control measures for the accumulation and reuse of corporate knowledge. This also leads to the evaluation of equipment being groundless and without process data support.

[0006] Fault data is discrete and not systematic. Whether it is manual experience or consulting paper data, the efficiency is very slow. Consulting drawings and locating problems will cause unnecessary delays in the construction period.

[0007] If maintenance solutions are not standardized, it is likely to bring hidden dangers to maintenance, resulting in additional construction time and economic losses. Summary of the invention

[0008] The object of the present invention is to provide an equipment fault interactive query and maintenance system, comprising an equipment classification module, a fault collection module, a database, a database maintenance module and a statistical analysis module;

[0009] The equipment classification module creates an equipment classification framework according to the equipment type and stores it in a database;

[0010] The fault collection module constructs a mapping relationship between each equipment and fault data, forms a table, and stores it in a database;

[0011] The database maintenance module is used to implement database backup and recovery, and provide data import and export functions;

[0012] The database maintenance module supports simultaneous access by multiple users;

[0013] The statistical analysis module summarizes the equipment failure data in the past t period and forms a chart.

[0014] Furthermore, the equipment classification architecture is a tree structure.

[0015] Furthermore, the equipment classification architecture includes multiple equipment types and at least one piece of equipment attribute information corresponding to each equipment type, and each equipment type is unique.

[0016] Furthermore, the fault data includes equipment fault type, fault cause, solution and fault phenomenon photo.

[0017] Further, it also includes a data entry module;

[0018] The data entry module receives the fault data uploaded by the user, and modifies, updates and stores the original fault data according to the currently received fault data.

[0019] Furthermore, the database maintenance module exports an Excel file based on the fault data selected by the user.

[0020] Furthermore, the statistical analysis module displays the number of failures of each equipment in the past t time period in the form of a chart.

[0021] Furthermore, the equipment attribute information includes equipment field and system name.

[0022] The maintenance method based on the system comprises the following steps:

[0023] 1) Create an equipment classification framework based on equipment type;

[0024] 2) Collect fault data corresponding to different types of equipment, including equipment type, fault cause, fault type, solution and fault phenomenon photos, and build a mapping relationship between each type of equipment and fault data;

[0025] 3) The user inputs a query field into the equipment fault interactive query and maintenance system to query corresponding fault data; the query field includes equipment attribute information;

[0026] 4) Classify and count the fault data obtained from the query to form a data analysis bar chart, and export it in the form of charts.

[0027] The technical effect of the present invention is undoubted, and the beneficial effects of the present invention are as follows:

[0028] 1) The interactive equipment fault query and maintenance system is universal and can be used in maintenance, R&D and other units, enabling horizontal enterprises to obtain interactive, comparable, queryable and reusable project knowledge;

[0029] 2) Realize the reuse and intelligent iteration of maintenance experience, improve maintenance efficiency and quality; solidify maintenance experience and troubleshooting experience, form digital results, and conduct real-time traceability and query, which can quickly avoid quality risks and indirectly improve maintenance responsibility;

[0030] 3) Fault content collection, automatic storage, statistics and analysis save maintenance time and make data collation efficient and accurate; combine informatization with maintenance business process operations, integrate knowledge and business, from bottom to top, with maintenance personnel experience as the core.

[0031] 4) Through digital iteration, the traditional implementation method based on result management is avoided, and the real-time updating and controllability of process control behavior data are achieved. BRIEF DESCRIPTION OF THE DRAWINGS

[0032] Figure 1 The block diagram of the equipment fault interactive query and maintenance system of the present invention.

[0033] Figure 2 The present invention is a flow chart of the equipment fault interactive query and maintenance method. DETAILED DESCRIPTION

[0034] The present invention is further described below in conjunction with the embodiments, but it should not be understood that the above subject matter of the present invention is limited to the following embodiments. Without departing from the above technical ideas of the present invention, various substitutions and changes are made according to the common technical knowledge and customary means in the art, which should all be included in the protection scope of the present invention.

[0035] Embodiment 1:

[0036] See also Figure 1 to Figure 2 , an equipment fault interactive query and maintenance system, comprising an equipment classification module, a fault collection module, a database, a database maintenance module and a statistical analysis module;

[0037] The equipment classification module creates an equipment classification framework according to the equipment type and stores it in a database;

[0038] The fault collection module constructs a mapping relationship between each equipment and fault data, forms a table, and stores it in a database;

[0039] The database maintenance module is used to implement database backup and recovery, and provide data import and export functions;

[0040] The database maintenance module supports simultaneous access by multiple users;

[0041] The statistical analysis module summarizes the equipment failure data in the past t period and forms a chart.

[0042] The equipment classification architecture is a tree structure.

[0043] The equipment classification framework includes multiple equipment types and at least one piece of equipment attribute information corresponding to each equipment type, and each equipment type is unique.

[0044] Fault data includes equipment fault type (i.e. common fault types in equipment history), fault cause, solution and fault phenomenon photos.

[0045] Also includes data entry module;

[0046] The data entry module receives the fault data uploaded by the user, and modifies, updates and stores the original fault data according to the currently received fault data.

[0047] The database maintenance module exports an Excel file based on the fault data selected by the user.

[0048] The statistical analysis module displays the number of failures of each equipment in the past t period of time in the form of a chart.

[0049] Equipment attribute information includes equipment field and system name.

[0050] Embodiment 2:

[0051] An equipment fault interactive query and maintenance system, comprising an equipment classification module, a fault collection module, a database, a database maintenance module and a statistical analysis module;

[0052] The equipment classification module creates an equipment classification framework according to the equipment type and stores it in a database;

[0053] The fault collection module constructs a mapping relationship between each equipment and fault data, forms a table, and stores it in a database;

[0054] The database maintenance module is used to implement database backup and recovery, and provide data import and export functions;

[0055] The database maintenance module supports simultaneous access by multiple users;

[0056] The statistical analysis module summarizes the equipment failure data in the past t period and forms a chart.

[0057] Embodiment 3:

[0058] An equipment fault interactive query and maintenance system, the technical content of which is the same as that of Example 2, and further, the equipment classification architecture is a tree structure.

[0059] Embodiment 4:

[0060] An equipment fault interactive query and maintenance system, the technical content of which is the same as any one of Examples 2-3. Furthermore, the equipment classification architecture includes multiple equipment types and at least one equipment attribute information corresponding to each equipment type, and each equipment type is unique.

[0061] Embodiment 5:

[0062] An equipment fault interactive query and maintenance system, the technical content of which is the same as any one of embodiments 2-4, and further, the fault data includes the fault type, fault cause, solution and fault phenomenon photos.

[0063] Embodiment 6:

[0064] An equipment fault interactive query and maintenance system, the technical content of which is the same as any one of Embodiments 2-5, and further includes a data entry module;

[0065] The data entry module receives the fault data uploaded by the user, and modifies, updates and stores the original fault data according to the currently received fault data.

[0066] Embodiment 7:

[0067] An interactive query and maintenance system for equipment faults, the technical content of which is the same as any one of embodiments 2-6, and further, the database maintenance module exports an Excel file based on the fault data selected by the user.

[0068] Embodiment 8:

[0069] An interactive query and maintenance system for equipment failures, the technical content of which is the same as any one of embodiments 2-7, and further, the statistical analysis module displays the number of failures of each equipment in the past t time period in the form of a chart.

[0070] Embodiment 9:

[0071] An equipment fault interactive query and maintenance system, the technical content of which is the same as any one of embodiments 2-8, and further, the equipment attribute information includes equipment field and system name.

[0072] Embodiment 10:

[0073] The maintenance method of the system according to any one of embodiments 1 to 9 comprises the following steps:

[0074] 1) Create an equipment classification framework based on equipment type;

[0075] 2) Collect fault data corresponding to different types of equipment, including equipment type, fault cause, fault type, solution and fault phenomenon photos, and build a mapping relationship between each type of equipment and fault data;

[0076] 3) The user inputs a query field into the equipment fault interactive query and maintenance system to query corresponding fault data; the query field includes equipment attribute information;

[0077] 4) Classify and count the fault data obtained from the query to form a data analysis bar chart, and export it in the form of charts.

[0078] Embodiment 11:

[0079] An equipment fault interactive query and maintenance system, comprising:

[0080] Equipment classification module: According to the equipment type, the equipment classification framework is created in the database server in a tree structure. Each classification is unique, and the queried equipment can be quickly found according to each classification.

[0081] Fault collection module: classify faults by type and equipment level; collect problems and form a form to interact with users in the form; automatically and quickly locate the fault location through the form and synchronize it to the database; update the fault classification, fault cause, solution and fault phenomenon photos after modification. The forms, data in modules (1) and (2), fault phenomenon photos in the local disk and other data are automatically stored in the database server.

[0082] Database maintenance module: Multiple users can log in to the interactive fault query system at the same time, and the database provides database services in the form of server / client. The database maintenance module not only provides database backup and recovery, but also provides one-click import and export functions of Excel to facilitate user maintenance of the database. The database maintenance module can perform incremental identification import based on the imported Excel table. The database can export files according to the sorting options such as fault classification, fault cause, and solution selected by the user to form an Excel file.

[0083] Statistical analysis module: Equipment fault information, problem data are automatically summarized, and data analysis bar charts are automatically formed according to information categories. With the fault information in the entire database as data support, the number of faults under each equipment is displayed in the form of charts, which is convenient for users to query common faults, equipment with the highest fault rate, and other information, forming a ranking list for easy learning and comprehensive evaluation.

[0084] Embodiment 12:

[0085] The equipment fault interactive query and maintenance method comprises the following steps:

[0086] 1. Equipment library creation: Equipment is classified by category, which not only covers the current equipment categories, but also covers the newly added equipment categories. By searching for key content such as equipment attributes (such as equipment field, system name), etc., you can quickly query all equipment corresponding to the attributes in the database and view the specific content of equipment failures. This step is the data cornerstone of the interactive query and maintenance method of equipment failures.

[0087] 2. Equipment fault collection: Based on the established equipment library architecture, equipment faults are collected, sorted, merged and displayed. The equipment fault content includes data elements such as vehicle number, fault phenomenon, fault cause, troubleshooting method and on-site photos. Functions such as addition, deletion, query and modification all achieve data synchronization between the interface and the database server. When viewing the fault content again, the updated content will be displayed.

[0088] 21. Collect equipment failure content: Users can customize and add new equipment failure records and update them to the database server synchronously.

[0089] 22. A merging function is provided for similar faults to modify or delete records to avoid redundant entries.

[0090] 23. Fault content query: Users can query the current form content, or query a field in the entire database, using fuzzy query to increase the query hit rate. Display the total number of records and record details. And by double-clicking, you can quickly return to the record editing interface to quickly switch between query and editing states.

[0091] 24. Deletion of faulty content: Users can manually delete faulty content.

[0092] Automatic data storage: Data is interacted in the form of a form. When any data in the form is modified, it can be stored in the background. There is no need to click "Save" after editing. This design is conducive to real-time update of the database, ensuring that when multiple clients access the database server, they can refresh to the latest data.

[0093] 3. Histogram analysis

[0094] According to equipment fields, system information, equipment information and other items, classified statistics are formed to form a data analysis bar chart, which can intuitively view the failure rate, maintenance measures and other information, and export information charts for further in-depth analysis and evaluation through other means.

Claims

1. An interactive query and maintenance system for equipment failures, characterized in that: It includes equipment classification module, fault collection module, database, database maintenance module and statistical analysis module; The equipment classification module creates an equipment classification framework according to the equipment type and stores it in a database; The fault collection module constructs a mapping relationship between each equipment and fault data, forms a table, and stores it in a database; The database maintenance module is used to implement database backup and recovery, and provide data import and export functions; The database maintenance module supports simultaneous access by multiple users; The statistical analysis module summarizes the equipment failure data in the past t period and forms a chart.

2. The interactive query and maintenance system for equipment failure according to claim 1, characterized in that: The equipment classification architecture is a tree structure.

3. The interactive query and maintenance system for equipment failure according to claim 1, characterized in that: The equipment classification framework includes multiple equipment types and at least one piece of equipment attribute information corresponding to each equipment type, and each equipment type is unique.

4. The interactive query and maintenance system for equipment failure according to claim 1, characterized in that: Fault data includes equipment fault type, fault cause, solution and fault phenomenon photos.

5. The interactive query and maintenance system for equipment failure according to claim 4 is characterized by: Also includes data entry module; The data entry module receives the fault data uploaded by the user, and modifies, updates and stores the original fault data according to the currently received fault data.

6. The interactive query and maintenance system for equipment failure according to claim 1, characterized in that: The database maintenance module exports an Excel file based on the fault data selected by the user.

7. The interactive query and maintenance system for equipment failure according to claim 1, characterized in that: The statistical analysis module displays the number of failures of each equipment in the past t period of time in the form of a chart.

8. The interactive query and maintenance system for equipment failure according to claim 1, characterized in that: Equipment attribute information includes equipment field and system name.

9. A maintenance method for the system according to any one of claims 1 to 8, characterized in that: The following steps are involved: 1) Create an equipment classification framework based on equipment type; 2) Collect fault data corresponding to different types of equipment, including equipment type, fault cause, fault type, solution and fault phenomenon photos, and build a mapping relationship between each type of equipment and fault data; 3) The user inputs a query field into the equipment fault interactive query and maintenance system to query corresponding fault data; the query field includes equipment attribute information; 4) Classify and count the fault data obtained from the query to form a data analysis bar chart, and export it in the form of charts.

Images