Automatic inspection and detection system

Abstract

The invention belongs to the technical field of detection systems, and discloses an automatic inspection and detection system, which comprises an access layer, a storage layer connected with the access layer, and an application layer connected with the storage layer, the access layer is located at an input end and is used for collecting and inputting data; the storage layer comprises a system database, a cache database and a file database; the application layer is located at a system end and comprises a personnel management module, a project management module, an instrument management module, a standard specification management module, an inspection report management module and a statistical analysis module. The personnel management module, the project management module, the instrument management module, the standard specification management module, the inspection report management module and the statistical analysis module are arranged to sort and standardize basic data in various aspects, manual verification work is reduced, and it is ensured that an inspection report is smoothly generated.

Description

Technical Field

[0001] The present invention belongs to the technical field of detection systems, and in particular relates to an automated inspection and detection system. Background Art

[0002] With the continuous development of high-speed rail technology, railway communication systems play a key role in the process of safe vehicle control and informatization. China Railway Group has successively issued and updated TB10760 "Technical Specifications for Static Acceptance of High-Speed ​​Railway Projects" and TB10755 "Construction Quality Acceptance Standards for High-Speed ​​Railway Communication Projects", which put forward professional requirements for communication test and detection equipment and clearly require the mandatory nature of completion acceptance.

[0003] Some projects take a long time and the testing items are repeated many times throughout the entire project cycle. How to record each test process and results? From the time the project is established, the name and personnel of the testing project change. How to meet the information flow changes of CNAS-CL01 "Criteria for Accreditation of the Competence of Testing and Calibration Laboratories" (ISO / IEC17025) to achieve full process management of the project and ensure that all management elements meet the requirements? Personnel have different responsibilities in the project, so how to ensure the validity of the audit report? These problems restrict the speed of generating reports by traditional testing methods, and rely heavily on manual inspection, which reduces testing efficiency.

[0004] Therefore, an automated inspection and testing system is needed to sort out and standardize the basic data to ensure the smooth generation of inspection reports. Summary of the invention

[0005] In order to overcome the above technical problems, the present invention provides an automated inspection and testing system.

[0006] The present invention adopts the following technical solutions: The automated inspection and testing system comprises an access layer, the access layer is connected to a storage layer, and the storage layer is connected to an application layer; the access layer is located at an input end and is used for data collection and input; the storage layer comprises a system database, a cache database and a file database; the application layer is located at a system end and comprises a personnel management module, a project management module, an instrument management module, a standard and specification management module, an inspection report management module and a statistical analysis module.

[0007] Preferably, the input terminal has a manual input module, a reading input module and a report import module.

[0008] Preferably, the system database includes a SQLlite database at the input end and a MySql database at the system end. The data collected at the input end is temporarily stored in the SQLlite database and uploaded to the MySql database when the network is unobstructed.

[0009] Preferably, the cache database includes a Room database at the input end and a Redis database at the system end. The Room database is used to accelerate the display of user-filled and loaded data, and is uploaded to the Redis database when the network is unobstructed.

[0010] Preferably, the file database is located at the system end, and the file database adopts a MinIO database, which is used to store the report files after archiving is completed.

[0011] Preferably, the application layer also includes a mobile APP management module.

[0012] Preferably, the personnel management module is used to record the name, status, subordinate projects, and distribution of personnel; the project management module records the name, number, status, test content, project execution process, and archiving status of the project; the instrument management module records the instrument model, usage status, calibration reminder, user, and application project; the standard and specification management module has built-in inspection regulations and standards; the inspection report management module automatically fills in the public area of ​​the report with project details, instrument data, personnel information, and inspection basis through automatic filling and selection lists. At the same time, the system will integrate the data uploaded by the input end into the test item part of the report. The tester can edit the report through editing and previewing. After confirming that the information is correct, the generation of the inspection report will be automatically completed; the statistical analysis module is used for statistical inspection reports and provides query functions.

[0013] Compared with the prior art, the present invention has the following beneficial effects: The present invention sets up personnel management module, project management module, instrument management module, standard specification management module, inspection report management module, and statistical analysis module to sort out and standardize basic data in various aspects to ensure smooth generation of inspection reports; The present invention uses the input terminal to accurately obtain inspection data, conducts comprehensive quality inspection on the equipment and its application system, and automatically generates a detailed inspection report, which minimizes the reliance on manual inspection, reduces production costs and error rates, and improves production efficiency and the accuracy of inspection results; The input end can use mobile APP to obtain input data, complete testing anytime and anywhere, and automatically generate inspection reports, which significantly improves work efficiency, reduces dependence on manual labor, and greatly reduces the error rate. BRIEF DESCRIPTION OF THE DRAWINGS

[0014] Figure 1 It is a system architecture diagram of the present invention. DETAILED DESCRIPTION

[0015] The embodiments of the present invention are described in detail below. Examples of the embodiments are shown in the accompanying drawings, wherein the same or similar reference numerals throughout represent the same or similar elements or elements having the same or similar functions. Unless otherwise specified, the raw materials and equipment used can be purchased from the market or are commonly used in the art. The methods in the embodiments are conventional methods in the art unless otherwise specified. The embodiments described below with reference to the accompanying drawings are exemplary and are only used to explain the present invention, and cannot be understood as limiting the present invention.

[0016] The automated inspection and testing system includes an access layer, the access layer is connected to a storage layer, and the storage layer is connected to an application layer; The access layer is located at the input end and is used for data collection and input; the input end has a manual input module, a reading input module and a report import module; the manual input module can be filled in online through a mobile APP, and the data includes various physical parameters such as temperature, humidity, pressure, current, etc.; the reading input module interfaces with the instrument equipment to automatically generate and record data; the report import module provides an inspection report upload interface for inspection personnel to upload inspection reports.

[0017] The storage layer includes the system database, cache database and file database; the system database includes the SQLlite database at the input end and the MySql database at the system end. The data collected at the input end is temporarily stored in the SQLlite database and uploaded to the MySql database when the network is unblocked. The MySql database is used to store the management data of the management system, the test item data of each test instrument and the report template data. The cache database includes the Room database at the input end and the Redis database at the system end. The Room database is used to speed up the display of user filling and loading data and is uploaded to the Redis database when the network is unblocked. The Redis database is a system-side cache technology used to improve page loading efficiency. The file database is located at the system end and uses the MinIO database. The MinIO database is used to store report files after archiving.

[0018] The application layer is located at the system end, including personnel management module, project management module, instrument management module, inspection report management module, statistical analysis module, standard and specification management module, and mobile APP management module.

[0019] The storage layer includes the data processing layer and the persistence layer.

[0020] Access Layer Automatic generation: The system interfaces with instrumentation to automatically generate and record experimental data.

[0021] Online filling: You can fill in the form online through the mobile APP, including various physical parameters such as temperature, humidity, pressure, current, etc.

[0022] Manual upload: Provides an inspection report upload interface for inspectors to upload the generated inspection reports.

[0023] Transport Layer Use standard transmission protocols (such as HTTP, ModBus, IO-Link, etc.) for data transmission to ensure data integrity and security.

[0024] Data processing layer Data cleaning: remove noise and outliers from the data and handle missing values.

[0025] Feature extraction: Extract useful features from the data to parse the data uploaded by the instrument.

[0026] Anomaly detection: Use anomaly detection algorithms (such as LoF, Isolation Forest) to identify outliers in the data and ensure the reliability of the data.

[0027] Data aggregation: Aggregate data based on data type and business requirements for data display and statistical analysis at the application layer.

[0028] Persistence layer: MySql: used to store management data of the management system, test item data of each test instrument, report template data, etc.

[0029] Redis: System-side caching technology used to improve page loading efficiency.

[0030] MinIO: File database used to store report files after archiving is completed.

[0031] Application Layer The personnel management module is used to record the personnel's attribute information, including personnel name, status, subordinate projects, personnel distribution and other attribute information; The project management module records project attribute information, including project name, number, status, inspection content, project execution process and filing status, and provides query and statistics functions; The instrument management module records the attribute information of the instrument, including: instrument model, usage status, calibration reminder, user, application project, etc. The standard and specification management module prefabricates regulatory standard data to provide standards for inspection; The inspection report management module automatically fills in project details, instrument data, personnel information, and inspection basis into the public area of ​​the report through automatic filling and selection lists. At the same time, the system will integrate the data uploaded by the input end into the test item part of the report. The tester can edit the report through editing and previewing. After confirming that the information is correct, the system will automatically complete the generation of the inspection report. The statistical analysis module is used to compile statistics and analyze inspection reports and provide query functions.

[0032] Personnel statistics: Statistical analysis can be performed on personnel, including the projects they are in, workload, and other information.

[0033] Instrument statistics: Instruments can be statistically analyzed, including instrument usage, instrument detection status and other information.

[0034] Performance Analysis: Evaluate the performance of laboratory personnel through test records and project management.

[0035] Project statistics: You can perform statistical analysis on projects, including project completion rate, status of projects under test, status of completed projects, and other information.

[0036] Report statistics: Statistical analysis can be performed on the inspection reports, including the archiving status of the inspection reports, the status of the inspection reports and other information.

[0037] Abnormal alarm: Through the equipment management early warning function, equipment failures can be discovered and handled in a timely manner, including instrument maintenance expiration alarms and equipment operating status alarms.

[0038] Through the above-mentioned architecture design, the automated inspection and testing system can realize the comprehensive management of projects, personnel, instrumentation and equipment, and inspection reports. The system supports the parallel design of automated inspection and manual inspection, multiple inspection record generation methods (manual entry, reading entry, and report import), and supports offline data storage and data upload through APP client application design.

[0039] In the future, with the development of AI and IoT technologies, this system will become more intelligent and efficient, further improving user experience and system performance.

[0040] Although the embodiments of the present invention have been shown and described, those skilled in the art will appreciate that various changes, modifications, substitutions and variations may be made to the above embodiments without departing from the principles and spirit of the present invention, and that the scope of the present invention is defined by the claims and their equivalents.

Claims

1. Automated inspection and testing system, characterized in that: comprising an access layer, the access layer being connected to a storage layer, and the storage layer being connected to an application layer; The access layer is located at the input end and is used for data collection and input; The storage layer includes a system database, a cache database and a file database; The application layer is located at the system end, and includes a personnel management module, a project management module, an instrument management module, a standard specification management module, an inspection report management module, and a statistical analysis module.

2. The automated inspection and testing system according to claim 1, characterized in that: The input end has a manual input module, a reading input module and a report import module.

3. The automated inspection and testing system according to claim 2, characterized in that: The system database includes the SQLlite database on the input side and the MySql database on the system side. The data collected on the input side is temporarily stored in the SQLlite database and uploaded to the MySql database when the network is unobstructed.

4. The automated inspection and testing system according to claim 2, characterized in that: The cache database includes the Room database on the input side and the Redis database on the system side. The Room database is used to speed up the display of user-filled and loaded data, and upload it to the Redis database when the network is unobstructed.

5. The automated inspection and testing system according to claim 2, characterized in that: The file database is located on the system side and uses the MinIO database, which is used to store report files after archiving is completed.

6. The automated inspection and testing system according to claim 1, characterized in that: The application layer also includes a mobile APP management module.

7. The automated inspection and testing system according to claim 1, characterized in that: The personnel management module is used to record personnel names, status, subordinate projects, and distribution; The project management module records the project name, number, status, test content, project execution process and filing status; The instrument management module records the instrument model, usage status, calibration reminder, user, and application project; The standard and specification management module has built-in inspection regulations and standards; The inspection report management module automatically fills in the public area of ​​the report with project details, instrument data, personnel information and inspection basis by means of automatic filling and selection lists. At the same time, the system will integrate the data uploaded by the input end into the test item part of the report. The tester can edit the report by editing and previewing. After confirming that the information is correct, the generation of the inspection report will be automatically completed. The statistical analysis module is used for statistical inspection reports and provides query functions.

Images