Data management system of hydropower station oil system

Abstract

The invention discloses a data management system of a hydropower station oil system. The data management system comprises a database server, a function module, a database query module, a data calling module, a mobile terminal, a sensor unit and an image recognition device, the database server is connected with the database through the data calling module, the mobile terminal is connected with the database server, the database is in data connection with the hydropower station production management platform, and a logic device tree is constructed in the database server; the database server is used for managing and calling data stored in the database and providing a data query interface through a database query module; the database server is also connected with a hydropower station computer monitoring system through a data calling module; and the sensor unit and the image recognition device are respectively connected with the hydropower station computer monitoring system. The integration of the oil system data is realized, the data content corresponding to each functional module can be efficiently inquired, and the management efficiency of the hydropower station oil system is improved.

Description

Technical Field

[0001] The invention relates to the technical field of data management, and in particular to a data management system for an oil system of a hydropower station. Background Art

[0002] The oil system of a hydropower station has a huge number of various types of equipment. At present, during the operation and maintenance of a hydropower station, operation and maintenance personnel need to regularly carry out oil replenishment, oil drainage or oil change work in the oil system, and manually record and analyze the working conditions of the oil system. However, due to the uncertainty of the annual maintenance time of the same unit and the randomness of oil replenishment, oil drainage and oil change after the failure of the oil system equipment, the conventional method is used to record the oil system data. The data cannot be linked with the fault phenomenon and big data analysis. There are problems such as manual statistical data errors, time-consuming, incomplete information, poor information timeliness, and inconvenient query during emergencies, which brings great inconvenience to the operation and maintenance personnel in managing the oil system. Summary of the invention

[0003] In order to solve the above problems, the present invention provides a data management system for the oil system of a hydropower station. The oil system code is used as an index, and the oil system logical device tree is viewed through handheld RFID device recognition, mobile phone QR code scanning, and computer login client, so as to realize the query of the real-time status of the oil system, oil volume change trend, oil system equipment parameters, oil system operation guide, typical faults of the oil system, key points of accident handling, key points of inspection, emergency disposal plan, oil system equipment failure history, procedure drawings and other contents.

[0004] The present invention provides a data management system for the oil system of a hydropower station, and the specific technical scheme is as follows:

[0005] It includes a database server, a functional module, a database query module, a data calling module, a mobile terminal, a sensor unit and an image recognition device;

[0006] The database server is connected to the database through the data calling module, the mobile terminal is connected to the database server, the database is connected to the hydropower station production management platform data, and the timed update data is obtained according to the set time node; a logical device tree is constructed in the database server, and the fixed data and timed update data stored in the database are associated with the logical device tree;

[0007] The database server is used to manage and call the data stored in the database, and provide the mobile terminal with a data query interface through the database query module. The database stores the regularly updated data and the fixed data required by each functional module. The database server receives the instruction of the mobile terminal, retrieves the data in the database, and sends it to the mobile terminal.

[0008] The database server is also connected to the hydropower station computer monitoring system through the data calling module; the sensor unit and the image recognition device are respectively connected to the hydropower station computer monitoring system, and the real-time data received by the computer monitoring system is associated with the logical device tree;

[0009] The sensor unit and the image recognition device are used to collect and acquire real-time data and transmit them to the computer monitoring system of the hydropower station. After receiving the instruction from the mobile terminal, the database server retrieves the real-time data in the computer monitoring system of the hydropower station through the data calling module.

[0010] Furthermore, the data calling module includes a fixed part, a timed update part and a real-time part, and the data corresponding to each part is provided with a different calling path.

[0011] Furthermore, the data of the functional modules are called through the data calling module, and the functional modules corresponding to the fixed part include oil system equipment parameters, oil system operating guide, typical oil system faults, accident handling points, inspection points, emergency response plans, oil system equipment failure history and procedure drawings; the functional modules corresponding to the real-time part include the real-time status of the oil system and the oil volume change trend; the functional modules corresponding to the scheduled update part include maintenance instructions and regular work execution status.

[0012] Furthermore, the sensor unit includes an oil level sensor disposed inside the oil storage device and an oil flow sensor disposed outside the oil storage device, which monitor the oil level of the device and the oil flow outside the device respectively;

[0013] The image recognition device is arranged at the periphery of the oil storage equipment and determines whether the equipment is leaking oil through image recognition.

[0014] Furthermore, the regularly updated data includes maintenance instructions and regular work execution status;

[0015] The real-time data includes the real-time status of the oil system and the oil quantity change trend.

[0016] Furthermore, the system also includes an electronic tag generating device including an RFID radio frequency identification tag generating and producing unit and a two-dimensional code generating and producing unit, which generates an RFID identification tag and a two-dimensional code according to the code corresponding to the logical device tree.

[0017] Furthermore, the mobile terminal includes a handheld RFID device, which generates an RFID tag through radio frequency signal recognition, and after recognition, it interacts with the database server through a link;

[0018] The mobile terminal includes a mobile device with a QR code recognition APP or applet, which interacts with the database server by scanning the generated QR code.

[0019] Furthermore, the mobile terminal includes a computer client, and the computer client selects a corresponding device through the logical device tree and accesses data of the corresponding device.

[0020] Furthermore, the system also includes a firewall. A firewall is provided on the interactive access link between the database server and the mobile terminal; a firewall is provided on the data transmission link between the sensor unit and the image recognition device and the hydropower station computer monitoring system; and a firewall is provided on the transmission link for the database to receive the fixed data and periodically updated data.

[0021] Furthermore, the construction process of the logical device tree is as follows:

[0022] S1: Establish logical relationships between devices step by step based on systematic devices;

[0023] S2: according to the logical relationship of the devices, corresponding codes are set for the devices, the logical device tree is imported into the database server, and a unique electronic code is generated according to the one-to-one correspondence principle of the codes;

[0024] S3: Generates call paths for different data based on electronic codes.

[0025] The beneficial effects of the present invention are as follows:

[0026] The database is constructed by pre-writing fixed data, calling data from the hydropower station production management system and the hydropower station computer monitoring system. Through the database server and data calling module, the data required for oil system management is integrated into one system by building a logical device tree, and then different modules are distinguished for query. Fixed data, real-time data and timed update data can be queried, which improves the work efficiency of operation and maintenance personnel. RFID or QR code is generated based on the code corresponding to the logical device tree, and electronic tags are bound to the oil system equipment, which directly corresponds to each device in the oil system, making it easier for operation and maintenance personnel to obtain the required information, realizing efficient query of the corresponding data content of each functional module, and improving the management efficiency of the oil system of the hydropower station. BRIEF DESCRIPTION OF THE DRAWINGS

[0027] Figure 1 It is a schematic diagram of the system composition structure of the present invention.

[0028] Figure 2 It is a schematic diagram of the functional module composition of the present invention.

[0029] Figure 3 It is a schematic diagram of the composition of the mobile terminal of the present invention.

[0030] Figure 4 It is a schematic diagram of the sensor unit and the image recognition device of the present invention.

[0031] Figure 5 It is a schematic diagram of an example of a logical device tree structure based on an oil system of the present invention.

[0032] Figure 6 It is a schematic diagram of the system module interaction architecture of the present invention. DETAILED DESCRIPTION

[0033] The following description clearly and completely describes the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0034] In the description of the embodiments of the present invention, it should be noted that the indicated orientation or positional relationship is based on the orientation or positional relationship shown in the accompanying drawings, or the orientation or positional relationship in which the invention product is usually placed when in use, or the orientation or positional relationship commonly understood by those skilled in the art, or the orientation or positional relationship in which the invention product is usually placed when in use, which is only for the convenience of describing the present invention and simplifying the description, and does not indicate or imply that the device or element referred to must have a specific orientation, be constructed and operated in a specific orientation, and therefore cannot be understood as a limitation on the present invention. In addition, the terms "first" and "second" are only used to distinguish the description, and cannot be understood as indicating or implying relative importance.

[0035] In the description of the embodiments of the present invention, it is also necessary to explain that, unless otherwise clearly specified and limited, the terms "set" and "connection" should be understood in a broad sense, for example, it can be a fixed connection, a detachable connection, or an integral connection; it can be a direct connection, or an indirect connection through an intermediate medium. For ordinary technicians in this field, the specific meanings of the above terms in the present invention can be understood according to specific circumstances.

[0036] Example 1

[0037] Embodiment 1 of the present invention discloses a data management system for a hydropower station oil system, such as Figure 1 As shown, the details are as follows:

[0038] The system includes a database server, a functional module, a database query module, a data calling module, a mobile terminal, a sensor unit and an image recognition device;

[0039] The database server is used for database management, including system configuration and management, data access and update management, data integrity management and data security management. The database server also includes database retrieval and modification; it has database maintenance functions, including data import / export management, database structure maintenance, data recovery functions and performance monitoring; it has a parallel operation function, supports multiple users accessing the database at the same time, and handles the simultaneous occurrence of multiple events.

[0040] The database server is connected to the database through the data calling module, the mobile terminal is connected to the database server, the database is connected to the hydropower station production management platform data, and the timed update data is obtained according to the set time node;

[0041] The regularly updated data includes: maintenance instructions and regular work execution status.

[0042] A logical device tree is constructed in the database server, and the fixed data and timed update data stored in the database are associated with the logical device tree;

[0043] As a preferred embodiment, the construction process of the logical device tree is as follows:

[0044] S1: Establish logical relationships between devices step by step based on systematic devices;

[0045] Take a large hydropower station as an example. Figure 5 As shown, a logical equipment tree is set up for the oil system level by level: Level 1 equipment: turbine oil system, insulating oil system; further, the turbine oil system can be divided into: Level 2 equipment: oil storage tank, valve and pipeline, respirator, oil filter, oil level gauge, etc.; specifically, the equipment code is set with reference to the capital letter abbreviation of the Chinese name of the equipment, such as "Y" for oil system, "Y-TPY" for turbine oil system, and "Y-TPY-CYG" for oil storage tank;

[0046] S2: according to the logical relationship of the devices, corresponding codes are set for the devices, the logical device tree is imported into the database server, and a unique electronic code is generated according to the one-to-one correspondence principle of the codes;

[0047] S3: Generates call paths for different data based on electronic codes.

[0048] The database server is used to manage and call the data stored in the database, and provide the mobile terminal with a data query interface through the database query module. The database stores the regularly updated data and the fixed data required by each functional module. The database server receives the instruction of the mobile terminal, retrieves the data in the database, and sends it to the mobile terminal.

[0049] The database server is also connected to the hydropower station computer monitoring system through the data calling module; the sensor unit and the image recognition device are respectively connected to the hydropower station computer monitoring system, and the real-time data received by the computer monitoring system is associated with the logical device tree;

[0050] The sensor unit and the image recognition device are used to collect and acquire real-time data and transmit them to the computer monitoring system of the hydropower station. After receiving the instruction from the mobile terminal, the database server retrieves the real-time data in the computer monitoring system of the hydropower station through the data calling module.

[0051] The data query module is matched with the database server and supports user query. When a user initiates a query request, part of the data is retrieved from the database according to the conditions set by the user, and is provided for the user to browse in the form of tables, pictures, texts, etc.; it supports user editing and modification, and the user can edit, add and delete data in the database;

[0052] The data calling module includes a fixed part, a timed updating part and a real-time part, and the data corresponding to each part is provided with a different calling path.

[0053] As a preferred embodiment, Figure 2 As shown in the figure, each functional module is divided into the following three parts according to the different storage and calling methods of the corresponding data:

[0054] Fixed data part (data is fixed and does not change often, stored in the database, and can be modified using the modification function of the database server as needed), the corresponding functional modules include: oil system equipment parameters, oil system operation guide, oil system typical faults, accident handling points, inspection points, emergency disposal plan, oil system equipment fault history and procedure drawings;

[0055] The real-time data part (data is instantly called from the hydropower station computer monitoring system and is not stored in the database), the corresponding functional modules include: real-time status of the oil system and oil volume change trend;

[0056] The data is updated regularly (data is regularly retrieved from the hydropower station production management system, stored in the database, and can be set to be updated and overwritten at regular intervals), and the corresponding functional modules include: maintenance instructions and regular work execution status.

[0057] As a preferred embodiment, Figure 4 As shown, the sensor unit includes an oil level sensor disposed inside the oil storage device and an oil flow sensor disposed outside the oil storage device, which monitor the oil level of the device and the oil flow outside the device respectively;

[0058] The image recognition device is arranged at the periphery of the oil storage equipment and determines whether the equipment is leaking oil through image recognition.

[0059] The real-time data is provided by a sensor unit and an image recognition device, and the real-time data includes the real-time status of the oil system and the oil quantity change trend.

[0060] If the oil level sensor detects a large drop in the internal oil level in a short period of time, or the oil flow sensor detects oil flow outside the equipment, or the image recognition device identifies an oil leak on site, an alarm signal will be sent to the hydropower station monitoring system.

[0061] As a preferred embodiment, Figure 3 As shown, the system also includes an electronic tag generating device including an RFID radio frequency identification tag generating and producing unit and a two-dimensional code generating and producing unit, which generates an RFID identification tag and a two-dimensional code according to the code corresponding to the logical device tree.

[0062] The mobile terminal includes a handheld RFID device, which generates an RFID tag through radio frequency signal recognition, and interacts with the database server after recognition; the operation and maintenance personnel can use various functions on the handheld RFID device;

[0063] The mobile terminal includes a mobile device with a QR code recognition APP or applet, which interacts with the database server by scanning the generated QR code.

[0064] The mobile terminal includes a computer client, and the computer client selects a corresponding device through the logical device tree and accesses data of the corresponding device.

[0065] As a preferred embodiment, the system also includes a firewall. A firewall is provided on the interactive access link between the database server and the mobile terminal; a firewall is provided on the data transmission link between the sensor unit and the image recognition device and the hydropower station computer monitoring system; and a firewall is provided on the transmission link where the database receives the fixed data and periodically updated data.

[0066] Based on the above system, Figure 6 As shown, the data query process and data modification process are as follows:

[0067] The database server receives an access request from a mobile terminal (handheld RFID device / mobile phone / office computer);

[0068] The database server determines the function module of the access request;

[0069] The modules used for judgment belong to the fixed part: oil system equipment parameters, oil system operation guide, typical oil system failures, accident handling points, inspection points, emergency disposal plan, oil system equipment failure history, and procedure drawings;

[0070] Determine whether the module used belongs to the real-time part: real-time status of the oil system, oil volume change trend → output the required data from the database → send the data to the handheld RFID device / mobile phone / computer client;

[0071] Determine whether the module used belongs to the scheduled update part: maintenance instructions, regular work execution status → start calling module → instantly call required data from the computer monitoring system → send data to handheld RFID device / mobile phone / computer client.

[0072] If you need to modify the data, the specific process is as follows:

[0073] The database server receives a data modification request from a mobile terminal (handheld RFID device / mobile phone / office computer);

[0074] The database server receives new data from the mobile terminal (handheld RFID device / mobile phone / office computer);

[0075] The database server overwrites the old data with the new data and stores it.

[0076] The present invention is not limited to the above-mentioned specific embodiments, but extends to any new features or any new combination disclosed in this specification, as well as any new method or process steps or any new combination disclosed.

Claims

1. A data management system for the oil system of a hydropower station, characterized in that: It includes a database server, a functional module, a database query module, a data calling module, a mobile terminal, a sensor unit and an image recognition device; The database server is connected to the database through the data calling module, the mobile terminal is connected to the database server, the database is connected to the hydropower station production management platform data, and the timed update data is obtained according to the set time node; A logical device tree is constructed in the database server, and the fixed data and timed update data stored in the database are associated with the logical device tree; The database server is used to manage and call the data stored in the database, and provide a data query interface through the database query module. The database stores the regularly updated data and the fixed data required by each functional module. The database server receives the instruction of the mobile terminal, retrieves the data in the database, and sends it to the mobile terminal. The database server is also connected to the hydropower station computer monitoring system through the data calling module; the sensor unit and the image recognition device are respectively connected to the hydropower station computer monitoring system, and the real-time data received by the computer monitoring system is associated with the logical device tree; The sensor unit and the image recognition device are used to collect and acquire real-time data and transmit them to the computer monitoring system of the hydropower station. After receiving the instruction from the mobile terminal, the database server retrieves the real-time data in the computer monitoring system of the hydropower station through the data calling module.

2. The data management system for the oil system of a hydropower station according to claim 1, characterized in that: The data calling module includes a fixed part, a timed updating part and a real-time part, and the data corresponding to each part is provided with a different calling path.

3. The data management system for the oil system of a hydropower station according to claim 2, characterized in that: The data of the functional modules are called through the data calling module. The functional modules corresponding to the fixed part include oil system equipment parameters, oil system operating guide, typical oil system faults, accident handling points, inspection points, emergency response plans, oil system equipment failure history and procedure drawings; the functional modules corresponding to the real-time part include the real-time status of the oil system and the oil volume change trend; the functional modules corresponding to the scheduled update part include maintenance instructions and regular work execution status.

4. The data management system for the oil system of a hydropower station according to claim 1, characterized in that: The sensor unit includes an oil level sensor disposed inside the oil storage device and an oil flow sensor disposed outside the oil storage device, which respectively monitor the oil level of the device and the oil flow outside the device; The image recognition device is arranged at the periphery of the oil storage equipment and determines whether the equipment is leaking oil through image recognition.

5. The data management system for the oil system of a hydropower station according to claim 1, characterized in that: The regularly updated data includes maintenance instructions and regular work execution status; The real-time data includes the real-time status of the oil system and the oil quantity change trend.

6. The data management system for the oil system of a hydropower station according to claim 1, characterized in that: The system also includes an electronic tag generating device including an RFID radio frequency identification tag generating and producing unit and a two-dimensional code generating and producing unit, which generates an RFID identification tag and a two-dimensional code according to the code corresponding to the logical device tree.

7. The data management system for the oil system of a hydropower station according to claim 6, characterized in that: The mobile terminal includes a handheld RFID device, which generates an RFID tag through radio frequency signal recognition, and interacts with the database server after being recognized; The mobile terminal includes a mobile device with a QR code recognition APP or applet, which interacts with the database server by scanning the generated QR code.

8. The data management system for the oil system of a hydropower station according to claim 7, characterized in that: The mobile terminal includes a computer client, and the computer client selects a corresponding device through the logical device tree and accesses data of the corresponding device.

9. The data management system for the oil system of a hydropower station according to claim 1, characterized in that: The system also includes a firewall. A firewall is provided on the interactive access link between the database server and the mobile terminal; a firewall is provided on the data transmission link between the sensor unit and the image recognition device and the hydropower station computer monitoring system; and a firewall is provided on the transmission link where the database receives the fixed data and the regularly updated data.

10. The data management system for the oil system of a hydropower station according to any one of claims 1 to 9, characterized in that: The construction process of the logical device tree is as follows: S1: Establish logical relationships between devices step by step based on systematic devices; S2: according to the logical relationship of the devices, corresponding codes are set for the devices, the logical device tree is imported into the database server, and a unique electronic code is generated according to the one-to-one correspondence principle of the codes; S3: Generates call paths for different data based on electronic codes.

Images