Data query method and device, computer device, and readable storage medium

Abstract

The application discloses a data query method and device, computer equipment and a readable storage medium. The method comprises the following steps: in response to a login request of a user, sending a plurality of preset labels to a user terminal for display, wherein the plurality of preset labels comprise a plurality of device labels and a plurality of attribute labels; receiving a label selection result sent by the user terminal, and obtaining at least one target label included in the label selection result; determining at least one target storage path according to the at least one target label and a preset mapping relationship; and calling at least one item of device data according to the at least one target storage path. Through the electronic storage mode of the data label, the efficiency and accuracy of device data searching are improved, thereby improving the device maintenance efficiency. Meanwhile, the loss and damage of device drawings are avoided, the errors or abnormalities caused by low data clarity are reduced, the correctness of device data is ensured, and the accuracy of maintenance and troubleshooting of operation and maintenance personnel is ensured.

Description

Technical Field

[0001] This application relates to the field of power distribution technology, and in particular to a data query method, apparatus, computer equipment, and readable storage medium. Background Technology

[0002] Currently, each substation contains multiple secondary devices. The existing technology usually involves storing paper drawings of each secondary device in a document room. During the operation, maintenance, and commissioning of the secondary distribution system, staff need to find the paper drawings of the secondary devices in the document room for reference.

[0003] In the process of developing this application, the applicant discovered that the relevant technology has at least the following problems:

[0004] Because the document room contains a large number of drawings and volumes, it takes a long time for staff to find the drawings. In addition, there is no space on site to store and view the drawings, which makes it inconvenient to view the drawings at the maintenance site. Furthermore, there is usually only one copy of the paper drawings for secondary equipment, and the paper drawings for some older secondary equipment may be lost or damaged. When these pieces of equipment malfunction, maintenance personnel need to reorganize the secondary wiring, which is quite difficult and greatly affects the speed of power maintenance. Summary of the Invention

[0005] In view of this, this application provides a data query method, apparatus, computer equipment, and readable storage medium, the main purpose of which is to solve the problem that the existing method of storing paper drawings is not easy to find and is easily lost, thus greatly affecting the speed of power maintenance.

[0006] According to a first aspect of this application, a data query method is provided, the method comprising:

[0007] In response to a user's login request, multiple preset tags are sent to the user's terminal for display. These preset tags include multiple device tags and multiple attribute tags.

[0008] Receive the tag selection result sent by the user terminal, and obtain at least one target tag included in the tag selection result;

[0009] Determine at least one target storage path based on at least one target tag and a preset mapping relationship;

[0010] Retrieve at least one piece of device data based on at least one target storage path.

[0011] Optionally, the step of sending multiple preset tags to the user's terminal for display in response to the user's login request specifically includes:

[0012] In response to a user's login request, obtain multiple signal strengths between the user terminal and multiple preset devices included in the login request;

[0013] The target device is determined from multiple devices based on multiple signal strengths and preset strength thresholds;

[0014] Among multiple preset labels, the device label corresponding to the target device is marked;

[0015] Multiple pre-defined tags after marking are sent to the user's terminal for display.

[0016] Optionally, the step of determining at least one target storage path based on at least one target tag and a preset mapping relationship specifically includes:

[0017] When at least one target tag is a single tag, the target storage path corresponding to the target tag is determined according to a preset mapping relationship;

[0018] When there are multiple target tags, obtain the target device tag and at least one target attribute tag from the multiple target tags;

[0019] The target device tag is combined with each target attribute tag to generate at least one combined tag;

[0020] Based on the preset mapping relationship, determine the target storage path corresponding to each combined tag.

[0021] Optionally, after retrieving at least one piece of device data based on at least one target storage path, the method further includes:

[0022] Send at least one piece of device data to the user terminal for display.

[0023] Optionally, before sending multiple preset tags to the user's terminal for display in response to the user's login request, the method further includes:

[0024] Obtain information on multiple devices from the target manufacturer. This information includes the device name, instruction manual, electronic drawings, commissioning information, inspection precautions, and troubleshooting methods for each device.

[0025] Generate multiple device tags based on multiple device names;

[0026] Based on the equipment manual, electronic drawings, commissioning information, inspection precautions and troubleshooting methods for each piece of equipment, generate multiple attribute tags;

[0027] Based on multiple equipment tags and multiple attribute tags, the equipment manual, electronic drawings, commissioning information, inspection precautions and troubleshooting methods for each device are stored in a preset database.

[0028] Optionally, after storing the equipment manual, electronic drawings, commissioning information, inspection precautions, and troubleshooting methods for each device in a preset database based on multiple device tags and multiple attribute tags, the system also includes:

[0029] Obtain the storage path of each device's instruction manual, electronic drawings, commissioning information, inspection precautions, and troubleshooting methods;

[0030] Generate a preset mapping relationship based on multiple device tags, multiple attribute tags, and storage paths.

[0031] Optionally, the multiple devices include at least one of the following: relay protection devices, fault indicators, FTUs, DTUs, and TTUs.

[0032] According to a second aspect of this application, a data query apparatus is provided, the apparatus comprising:

[0033] The sending module is used to respond to the user's login request and send multiple preset tags to the user terminal for display. These preset tags include multiple device tags and multiple attribute tags.

[0034] The acquisition module is used to receive the tag selection result sent by the user terminal and acquire at least one target tag included in the tag selection result;

[0035] The determination module is used to determine at least one target storage path based on at least one target tag and a preset mapping relationship;

[0036] The retrieval module is used to retrieve at least one piece of device data based on at least one target storage path.

[0037] According to a third aspect of this application, a computer device is provided, including a memory and a processor, wherein the memory stores a computer program, and the processor executes the computer program to implement the steps of any of the methods in the first aspect.

[0038] According to a fourth aspect of this application, a readable storage medium is provided having a computer program stored thereon, which, when executed by a processor, implements the steps of the method described in any one of the first aspects.

[0039] By employing the aforementioned technical solution, this application provides a data query method, apparatus, computer equipment, and readable storage medium. When the equipment is put into operation, operation manuals, equipment drawings, and inspection precautions for each secondary power distribution device are tagged and stored in a data storage platform, establishing a mapping relationship between equipment tags and storage paths. During maintenance and troubleshooting, maintenance personnel can select the tag corresponding to the desired equipment data on the terminal APP's display interface. The platform searches for the mapped storage path based on the selected tag, then locates the equipment data according to the storage path and sends the data to the terminal for viewing by the personnel. Compared to existing technologies that store paper drawings of secondary power distribution equipment in a document room, which suffers from time-consuming drawing searches and the vulnerability of paper drawings to damage or loss, thus affecting maintenance efficiency, this approach offers a significant advantage. This application achieves electronic management of secondary equipment data through the aforementioned methods. On the one hand, it reduces the time spent by maintenance personnel searching for drawings, facilitates on-site retrieval and use, and improves the efficiency and accuracy of equipment data retrieval, thereby improving equipment maintenance efficiency. On the other hand, electronic storage avoids the loss or damage of equipment drawings, effectively ensuring the clarity of drawing data, reducing errors or anomalies caused by low data clarity, ensuring the correctness of equipment data, and thus ensuring the accuracy of maintenance personnel in performing maintenance and troubleshooting.

[0040] The above description is only an overview of the technical solution of this application. In order to better understand the technical means of this application and to implement it in accordance with the contents of the specification, and to make the above and other objects, features and advantages of this application more obvious and understandable, the following are specific embodiments of this application. Attached Figure Description

[0041] Various other advantages and benefits will become apparent to those skilled in the art upon reading the following detailed description of preferred embodiments. The accompanying drawings are for illustrative purposes only and are not intended to limit the scope of this application. Furthermore, the same reference numerals denote the same parts throughout the drawings. In the drawings:

[0042] Figure 1 This illustration shows a schematic flowchart of a data query method provided in an embodiment of this application;

[0043] Figure 2 This illustration shows a schematic flowchart of another data query method provided in an embodiment of this application;

[0044] Figure 3 This paper illustrates a schematic diagram of multiple preset labels provided in an embodiment of this application;

[0045] Figure 4 A schematic diagram of the structure of a data query device provided in an embodiment of this application is shown. Detailed Implementation

[0046] Exemplary embodiments of the present application will now be described in more detail with reference to the accompanying drawings. While exemplary embodiments of the present application are shown in the drawings, it should be understood that the present application may be implemented in various forms and should not be limited to the embodiments set forth herein. Rather, these embodiments are provided so that this application will be thorough and complete, and will fully convey the scope of the present application to those skilled in the art.

[0047] This application provides a data query method, such as... Figure 1 As shown, the method includes:

[0048] S101. In response to the user's login request, send multiple preset tags to the user terminal for display. The multiple preset tags include multiple device tags and multiple attribute tags.

[0049] The data query method provided in this application is applicable to data storage platforms. In practical applications, each substation contains multiple secondary devices, and the wiring methods and operating methods of secondary devices produced by different manufacturers vary. In existing technologies, when maintenance personnel need to maintain secondary equipment, they often need to go to the document room to view drawings. However, the document room contains a large number of drawings, making the search time-consuming. In addition, there is usually no space to store and view drawings at the maintenance site, making it difficult for maintenance personnel to view the drawings, which greatly affects maintenance efficiency. Furthermore, when changing settings such as DTU (Data Terminal Unit) and FTU (Feeder Terminal Unit) power distribution automation equipment, an external computer is required to operate in the software. The software interfaces and operating methods of different manufacturers also vary. If the staff's professional knowledge is not comprehensive enough or their technical level is poor, it will lead to low accuracy in the management of secondary equipment. Based on the above problems, this application proposes that when equipment is put into operation, the manufacturer stores the operation manual, equipment drawings, and inspection precautions of its secondary equipment in a data storage platform. When the company's distribution network secondary operation and maintenance personnel want to query the equipment drawings during the maintenance process, they only need to search on the terminal APP (Application) connected to the data storage platform to access the relevant data of the secondary equipment. This effectively solves the problems of difficult operation of distribution network secondary equipment, loss of secondary drawings, and difficulty in finding drawings in the prior art.

[0050] Specifically, "user" refers to the company's secondary distribution network maintenance and repair personnel, and "user terminal" refers to the terminal APP that communicates with the data storage platform. During the maintenance process of secondary equipment, the personnel enter their login account and password on the APP's login interface. After verifying the received login account and password, the data storage platform sends multiple preset tags to the maintenance personnel's terminal for display on the terminal's screen. This allows the maintenance personnel to select the desired equipment data from the secondary equipment based on the preset tags displayed on the screen.

[0051] Compared to existing technologies that require users to manually input the content to be queried and then search through a large amount of stored data, resulting in a low matching rate between user input and stored content and slow search speed, this application improves search efficiency by setting preset tags. Maintenance personnel can select preset tags based on the search content to retrieve equipment data, thereby greatly improving search efficiency.

[0052] It should be noted that the multiple preset tags include multiple equipment tags and multiple attribute tags. Equipment tags refer to the tags corresponding to the equipment names of all secondary equipment in the company's distribution network, such as relay protection devices, fault indicators, FTUs, DTUs, and TTUs (Transformer Supervisory Terminal Units). Furthermore, for any secondary equipment, the manufacturer will provide the equipment manual and drawings upon commissioning. These drawings include primary and secondary drawings. Further, to enable inspection personnel to more accurately understand the secondary equipment, the manufacturer and company professionals can jointly customize inspection precautions and troubleshooting methods for each secondary equipment. These, combined with the equipment's commissioning information, manual, and drawings, constitute the equipment data for that secondary equipment, stored on the data storage platform. The attributes of each piece of equipment data are then extracted as attribute tags for that data item. Specifically, the multiple attribute tags include: equipment manual, primary drawings, secondary drawings, commissioning information, inspection precautions, and troubleshooting methods.

[0053] S102. Receive the tag selection result sent by the user terminal, and obtain at least one target tag included in the tag selection result.

[0054] In this step, the tag selection result sent by the user terminal is received, and at least one target tag contained in the tag selection result is obtained. It should be noted that the at least one target tag can be a device tag, or a device tag plus an attribute tag.

[0055] By employing the above methods, maintenance personnel can retrieve equipment data simply by selecting tags, eliminating the need for manual input of equipment information. This improves the ease of operation for maintenance personnel and ensures a high degree of matching between the items to be queried and the data within the platform, preventing maintenance personnel from entering irrelevant content and thus improving the efficiency of equipment data retrieval.

[0056] S103. Determine at least one target storage path based on at least one target label and a preset mapping relationship.

[0057] In step S103, due to the large amount of device content and data stored in the data storage platform, in order to quickly find the device data that maintenance personnel want to view, the platform pre-sets tags for each device and each type of data for each device. Based on the tags corresponding to each type of data for each device and the data storage path, a preset mapping relationship is generated. When at least one target tag selected by the maintenance personnel is received, the storage path of the device data can be quickly found in the preset mapping relationship based on one or more target tags selected by the maintenance personnel.

[0058] By using the above method and establishing a pre-defined mapping relationship between tags and storage paths, the tags of equipment data are matched one-to-one with their storage paths. This allows the platform to quickly determine the storage path of the tag selected by the maintenance personnel and quickly retrieve the equipment data, effectively improving the efficiency and accuracy of the search.

[0059] S104. Retrieve at least one piece of device data based on at least one target storage path.

[0060] In this step, after determining at least one target storage path corresponding to the target label selected by the maintenance personnel using the preset mapping relationship, the equipment data is retrieved sequentially in the platform according to each target storage path.

[0061] The data query method provided in this application involves tagging the operation manuals, equipment drawings, and inspection precautions for each secondary power distribution device when the equipment is put into operation. This data is then stored in a data storage platform, and a mapping relationship between the device tags and storage paths is established. During maintenance and troubleshooting, maintenance personnel can select the tag corresponding to the desired equipment data on the terminal APP's display interface. The platform then searches for the mapped storage path based on the selected tag, locates the equipment data according to the storage path, and sends the data to the terminal for viewing by the personnel. Compared to existing technologies that store paper drawings of secondary power distribution equipment in a document room, this method addresses the technical problems of long lead times for drawing searches, the susceptibility of paper drawings to damage and loss, and the resulting impact on maintenance efficiency. This application achieves electronic management of secondary equipment data through the aforementioned methods. On the one hand, it reduces the time spent by maintenance personnel searching for drawings, facilitates on-site retrieval and use, and improves the efficiency and accuracy of equipment data retrieval, thereby improving equipment maintenance efficiency. On the other hand, electronic storage avoids the loss or damage of equipment drawings, effectively ensuring the clarity of drawing data, reducing errors or anomalies caused by low data clarity, ensuring the correctness of equipment data, and thus ensuring the accuracy of maintenance personnel in performing maintenance and troubleshooting.

[0062] Furthermore, as a refinement and extension of the specific implementation methods of the above embodiments, and in order to fully illustrate the specific implementation process of this embodiment, this application provides another data query method, such as... Figure 2 As shown, the method includes:

[0063] S201. Obtain multiple equipment information for multiple devices from the target manufacturer. The equipment information includes the equipment name, equipment manual and electronic drawings, commissioning information, inspection precautions and troubleshooting methods for each device.

[0064] In this step, due to the large number of manufacturers of secondary distribution network equipment, the operation methods and wiring methods of the secondary equipment produced by each manufacturer are different. Furthermore, when changing settings of distribution automation equipment such as DTUs and FTUs, an external computer is required for operation in software, and the software interfaces and operation methods of each manufacturer are also different. If the maintenance personnel lack professional expertise and operate improperly, it will bring great difficulties to the operation and maintenance of the secondary distribution network. In addition, due to the loss of stored secondary drawings in some older distribution boxes, when secondary faults occur, maintenance personnel have to re-organize the secondary wiring, which is difficult and time-consuming. Based on the above problems, this application proposes that when secondary equipment manufacturers put their equipment into operation, they will provide equipment manuals and electronic drawings of their own secondary equipment. The electronic drawings include primary and secondary drawings. At the same time, manufacturers can formulate inspection precautions and troubleshooting methods for each secondary device, and send them to the platform along with the current commissioning information. This will achieve unified electronic storage of data for the secondary distribution network equipment, which can better assist the operation and maintenance personnel of the secondary distribution network in performing maintenance, fault diagnosis, and other operations.

[0065] Optionally, if the manufacturer's secondary equipment does not have electronic drawings, the paper drawings can be scanned one by one to obtain scanned copies, which can then be sent to the platform. Furthermore, after receiving the inspection precautions and troubleshooting methods from the manufacturer, the testing personnel can add or modify the content of the inspection precautions and troubleshooting methods based on their testing experience.

[0066] Optionally, the multiple devices may include at least one of the following: relay protection devices, fault indicators, FTUs, DTUs, and TTUs. The relay protection devices may include 10kV switching stations, distribution rooms, box-type switches, and box-type transformers. Further, the multiple devices may also include integrated primary and secondary intelligent switches, 0.4kV intelligent integrated terminals, etc. During equipment commissioning, the manufacturer will access a large amount of data, including equipment manuals, drawings, commissioning information, inspection precautions, and troubleshooting methods, and will store the data conveniently using data tagging. In addition, multiple devices and their data can be added and stored according to the commissioning manufacturer to assist distribution network secondary operation and maintenance personnel in performing pre-testing, maintenance, and fault diagnosis.

[0067] S202. Generate multiple device labels based on multiple device names.

[0068] S203. Generate multiple attribute tags based on the equipment manual, electronic drawings, commissioning information, inspection precautions and troubleshooting methods for each piece of equipment.

[0069] In steps S202 and S203, a corresponding device label is assigned to each device based on its device name. For example, if the secondary device is an FTU, then the corresponding device label is "FTU". Subsequently, attribute labels are assigned to different types of device data for each device. For example, the attribute label for the FTU's operation manual is "Device Manual".

[0070] S204. Based on multiple equipment tags and multiple attribute tags, store the equipment manual, electronic drawings, commissioning information, inspection precautions and troubleshooting methods for each device into a preset database.

[0071] In this step, the preset database includes multiple preset resource pools. Each preset resource pool stores one type of device data; for example, resource pool 1 stores device manuals, resource pool 2 stores drawings, etc. Based on the attribute tags of each device, the various types of device data corresponding to each device are stored in the corresponding resource pool.

[0072] By tagging each type of device data for each device in the above manner, the device data is put into the corresponding resource pool through the tags. Compared with the existing technology that uses a tree-like storage method for large amounts of data, this application simplifies the storage process, widens the storage channel, and avoids data congestion through this flat storage mode.

[0073] S205. Obtain the storage path of the equipment manual, electronic drawings, commissioning information, inspection precautions and troubleshooting methods for each device.

[0074] S206. Generate a preset mapping relationship based on multiple device tags, multiple attribute tags, and storage paths.

[0075] In steps S205 and S206, the storage path of each type of device data for each secondary device is obtained, and then the association between the tag and the storage path is established and summarized according to the device tag of each device and each attribute tag in turn to generate a preset mapping relationship.

[0076] The above method enables a one-to-one correspondence between device tags and storage paths, thereby achieving efficient management of device electronic data and improving the efficiency and accuracy of device data retrieval.

[0077] In practical applications, the storage path for a DTU's primary drawing is "D:\Program Files\Microsoft SQLServer\MSSQL10.MSSQLSERVER\MSSQL\DATA". The tag corresponding to the DTU's primary drawing is combined with the storage path to obtain a mapping relationship. Following this method, the association between each type of device data and its storage path is established sequentially, and then a preset mapping relationship is generated by summarizing the data.

[0078] S207. In response to the user's login request, obtain multiple signal strengths between the user terminal and multiple preset devices included in the login request.

[0079] In this process, each substation contains multiple secondary devices. If the maintenance personnel are unfamiliar with the site or have low technical skills, and given the large size of the substation and the numerous secondary devices, on-site maintenance and troubleshooting of these devices can be difficult, impacting maintenance efficiency. Therefore, this application proposes that when on-site maintenance personnel arrive at the site, they can log in to the terminal APP and click "Connect Signal" to establish connections between the terminal and multiple nearby secondary devices. This allows them to obtain the signal strength between each device and the terminal, and then transmit these signal strengths to the platform. The signal connection can be a BeiDou signal or a Bluetooth signal.

[0080] S208. Based on multiple signal strengths and preset strength thresholds, determine the target device among multiple devices.

[0081] In this step, the platform compares the strengths of multiple received signals with preset strength thresholds. If any signal strength is greater than the preset strength threshold, it indicates that the device corresponding to that signal strength is closer to the inspection personnel, and that device is designated as the target device. At this point, the maintenance personnel can first go to the nearest target device to inspect and troubleshoot it.

[0082] Optionally, the preset intensity threshold can be set by the platform according to the site conditions, and the data of the target device can be one or more. If you want to identify only the nearest device at a time, you can set the preset intensity threshold higher; if you want to identify multiple nearby devices at a time, you can set the preset intensity threshold lower. This application does not make any specific limitations here.

[0083] S209. Mark the device label corresponding to the target device among multiple preset labels.

[0084] S210. Send the marked preset tags to the user terminal for display.

[0085] In steps S209 and S210, after filtering out target devices closest to the inspector based on signal strength and a preset strength threshold, the device label corresponding to the target device is marked among multiple preset labels. Then, the marked preset labels are displayed on the terminal APP's interface. This allows the inspector to determine the name of the nearest device based on the labels, facilitating selection based on distance.

[0086] In practical applications, such as Figure 3 The image shown is a schematic diagram illustrating the display of multiple preset labels. Figure 3 This includes device tags for multiple secondary power distribution equipment, attribute tags for various data types under each device, and confirmation and cancellation indicators. The platform determines the DTU (Distributed Unit) closest to the inspector based on the signal strength of multiple devices, and then sends several preset tags to the terminal for display. The terminal bolds the identifier box corresponding to the device tag of the DTU. When the tags are displayed on the interface, the inspector can prioritize selecting the device to query based on the bolded mark. The inspector can select the corresponding tag for the desired device and click confirm. Understandably, if the inspector clicks incorrectly, they can click cancel and reselect the tag.

[0087] S211. Receive the tag selection result sent by the user terminal, and obtain at least one target tag included in the tag selection result.

[0088] In this step, the tag selection result sent by the user terminal is received, and at least one target tag contained in the tag selection result is obtained. It should be noted that the at least one target tag can be a device tag, or a device tag plus an attribute tag.

[0089] Optionally, when maintenance personnel want to view both the secondary drawings and the instruction manual of the DTU simultaneously, they can click the equipment label "DTU" in the equipment tab, and then click the "Secondary Drawings" and "Equipment Manual" tabs in the attribute tab. After clicking confirm, the equipment label "DTU" + attribute labels "Secondary Drawings" and "Equipment Manual" are sent to the data storage platform. The data storage platform then retrieves the secondary drawings and instruction manual of the DTU based on the "DTU + Secondary Drawings" and "DTU + Equipment Manual" data respectively.

[0090] Furthermore, for maintenance personnel with limited professional knowledge and lower technical skills, they may want to retrieve more comprehensive DTU equipment data. Therefore, maintenance personnel can select only the "DTU" tag and, after clicking confirm, send "DTU" to the data storage platform. The data storage platform then retrieves all equipment data for the DTU based on the received tag selection results and the target tag "DTU". Optionally, to further reduce data retrieval time and improve the accuracy of equipment data retrieval, if the inspector selects only one attribute tag and clicks confirm, a prompt message is sent to guide the inspector to select the corresponding equipment tag to view.

[0091] In practical applications, when maintenance personnel want to query the secondary drawings of a DTU during maintenance, they log in to the terminal APP, click the "DTU" tab and the "Secondary Drawings" tab on the display interface, and after confirming, send the equipment tag "DTU" + attribute tag "Secondary Drawings" to the data storage platform. The data storage platform then retrieves the secondary drawings of the DTU based on the target tag "DTU" + "Secondary Drawings" in the tag selection results.

[0092] By employing the above methods, maintenance personnel can retrieve equipment data simply by selecting tags, eliminating the need for manual input of equipment information. This improves the ease of operation for maintenance personnel and ensures a high degree of matching between the items to be queried and the data within the platform, preventing maintenance personnel from entering irrelevant content and thus improving the efficiency of equipment data retrieval.

[0093] S212. Determine whether at least one target label is a single one. If yes, proceed to step S213; otherwise, proceed to step S214.

[0094] In this step, at least one target label selected by the inspector is analyzed to determine whether it is a single label. This allows for targeted association of data storage paths based on the label, ensuring the accuracy of equipment data retrieval.

[0095] S213. When at least one target label is a single tag, determine the target storage path corresponding to the target label according to the preset mapping relationship.

[0096] In this step, if at least one target label is a single one, it means that the inspector has only selected the device label, that is, the inspector wants to view all the device data corresponding to the device. At this time, the storage path of all types of device data under the device corresponding to the target label is determined by using the preset mapping relationship, and is used as the target storage path.

[0097] In practical applications, maintenance personnel who want to view comprehensive data of the equipment DTU can select only the "DTU" tab in the display interface and click OK. After the platform receives the "DTU" tab, it uses preset mapping relationships to determine the storage paths for the equipment manual, primary drawings, secondary drawings, commissioning information, inspection precautions, and troubleshooting methods of the "DTU," and uses these as the target storage paths.

[0098] S214. When there are multiple target tags, obtain the target device tag and at least one target attribute tag from the multiple target tags.

[0099] S215. Combine the target device tag with each target attribute tag to generate at least one combined tag.

[0100] S216. Determine the target storage path for each combined tag according to the preset mapping relationship.

[0101] In steps S214 to S216, if it is determined that the inspector has selected at least one target label or multiple target labels, it means that after selecting a device label, the inspector also selected an attribute label corresponding to the data type they wish to view. At this point, the target device label selected by the inspector is sequentially combined with each target attribute label to generate one or more combined labels. Subsequently, a preset mapping relationship is used to determine the target storage path corresponding to each combined label.

[0102] In practical applications, when maintenance personnel want to query the primary and secondary drawings of the DTU equipment, they can click the "DTU" tab and the "Primary Drawings" and "Secondary Drawings" attributes in the terminal display interface and confirm. At this time, based on the tab selected by the maintenance personnel, two combination tabs "DTU" + "Primary Drawings" and "DTU" + "Secondary Drawings" are determined. Then, in the preset mapping relationship, the storage path corresponding to each combination tab is found as the target storage path, that is, the storage path of the DTU primary drawing and the storage path of the DTU secondary drawing.

[0103] S217. Retrieve at least one piece of device data based on at least one target storage path.

[0104] In this step, after determining at least one target storage path corresponding to the target tag selected by the maintenance personnel using a preset mapping relationship, the device data is retrieved sequentially from the platform according to each target storage path. It can be understood that if there is only one target storage path, the corresponding device data can be retrieved based on that target storage path; if there are multiple target storage paths, the corresponding device data is retrieved sequentially according to the display order of the multiple target attribute tags.

[0105] S218. Send at least one piece of device data to the user terminal for display.

[0106] In this step, after retrieving one or more device data, the retrieved device data is sent sequentially to the user terminal for display by the testing personnel.

[0107] Furthermore, as Figure 1 To specifically implement the method, this application provides a data query device 300, such as... Figure 4 As shown, the device includes:

[0108] The sending module 301 is used to respond to the user's login request and send multiple preset tags to the user terminal for display. The multiple preset tags include multiple device tags and multiple attribute tags.

[0109] The acquisition module 302 is used to receive the tag selection result sent by the user terminal and acquire at least one target tag included in the tag selection result;

[0110] The determining module 303 is used to determine at least one target storage path based on at least one target tag and a preset mapping relationship;

[0111] The retrieval module 304 is used to retrieve at least one piece of device data based on at least one target storage path.

[0112] Optionally, the sending module 301 is specifically used for:

[0113] In response to a user's login request, obtain multiple signal strengths between the user terminal and multiple preset devices included in the login request;

[0114] The target device is determined from multiple devices based on multiple signal strengths and preset strength thresholds;

[0115] Among multiple preset labels, the device label corresponding to the target device is marked;

[0116] Multiple pre-defined tags after marking are sent to the user's terminal for display.

[0117] Optionally, module 303 is specifically used for:

[0118] When at least one target tag is a single tag, the target storage path corresponding to the target tag is determined according to a preset mapping relationship;

[0119] When there are multiple target tags, obtain the target device tag and at least one target attribute tag from the multiple target tags;

[0120] The target device tag is combined with each target attribute tag to generate at least one combined tag;

[0121] Based on the preset mapping relationship, determine the target storage path corresponding to each combined tag.

[0122] Optionally, the sending module 301 is also used to send at least one piece of device data to the user terminal for display.

[0123] Optionally, the acquisition module 302 is also used to acquire multiple equipment information of multiple devices from the target manufacturer, wherein the equipment information includes the equipment name, equipment manual and electronic drawings of each device, commissioning information, inspection precautions and troubleshooting methods.

[0124] Optionally, the device further includes:

[0125] The first generation module 305 is used to generate multiple device tags based on multiple device names;

[0126] The second generation module 306 is used to generate multiple attribute tags based on the equipment manual, electronic drawings, commissioning information, inspection precautions and troubleshooting methods for each device.

[0127] Storage module 307 is used to store the equipment manual, electronic drawings, commissioning information, inspection precautions and troubleshooting methods of each device into a preset database based on multiple device tags and multiple attribute tags.

[0128] Optionally, the acquisition module 302 is also used to acquire the storage path of the equipment manual, electronic drawings, commissioning information, inspection precautions and troubleshooting methods for each device.

[0129] Optionally, the device further includes:

[0130] The third generation module 308 is used to generate a preset mapping relationship based on multiple device tags, multiple attribute tags and storage paths.

[0131] Optionally, the multiple devices include at least one of the following: relay protection devices, fault indicators, FTUs, DTUs, and TTUs.

[0132] The data query device 300 provided in this application embodiment, when the equipment is put into operation, tags the operation manuals, equipment drawings, and inspection precautions for each secondary power distribution device, puts them into the data storage platform, and establishes a mapping relationship between equipment tags and storage paths. During maintenance and troubleshooting, maintenance personnel can select the tag corresponding to the equipment data they want to find on the display interface of the terminal APP. The platform finds the mapped storage path according to the tag selected by the maintenance personnel, and then finds the equipment data according to the storage path, and sends the equipment data to the terminal for inspection personnel to view. Compared with the existing technology, which uses paper drawings of secondary power distribution equipment to store in a document room, there are technical problems such as long time to find drawings, and paper drawings are easily damaged or lost, affecting maintenance efficiency. This application achieves electronic management of secondary equipment data through the aforementioned methods. On the one hand, it reduces the time spent by maintenance personnel searching for drawings, facilitates on-site retrieval and use, and improves the efficiency and accuracy of equipment data retrieval, thereby improving equipment maintenance efficiency. On the other hand, electronic storage avoids the loss or damage of equipment drawings, effectively ensuring the clarity of drawing data, reducing errors or anomalies caused by low data clarity, ensuring the correctness of equipment data, and thus ensuring the accuracy of maintenance personnel in performing maintenance and troubleshooting.

[0133] In an exemplary embodiment, this application also provides a computer device, including a memory and a processor. The memory stores a computer program, and the processor executes the program stored in the memory to perform the data query method described in the above embodiments.

[0134] In an exemplary embodiment, this application also provides a readable storage medium having a computer program stored thereon, which, when executed by a processor, implements the steps of the data query method.

[0135] Through the above description of the embodiments, those skilled in the art can clearly understand that this application can be implemented in hardware or by using software plus necessary general-purpose hardware platforms. Based on this understanding, the technical solution of this application can be embodied in the form of a software product, which can be stored in a non-volatile storage medium (such as a CD-ROM, USB flash drive, external hard drive, etc.) and includes several instructions to cause a computer device (such as a personal computer, server, or network device, etc.) to execute the methods described in the various embodiments of this application.

[0136] Those skilled in the art will understand that the accompanying drawings are merely schematic diagrams of a preferred embodiment, and the modules or processes shown in the drawings are not necessarily essential for implementing this application.

[0137] Those skilled in the art will understand that the modules in the apparatus of the implementation scenario can be distributed within the apparatus of the implementation scenario as described, or they can be located in one or more apparatuses different from this implementation scenario, with corresponding changes. The modules of the above-described implementation scenario can be combined into one module, or they can be further divided into multiple sub-modules.

[0138] The serial numbers in this application are for descriptive purposes only and do not represent the superiority or inferiority of the implementation scenario.

[0139] The above disclosures are only a few specific implementation scenarios of this application. However, this application is not limited to these. Any variations that can be conceived by those skilled in the art should fall within the protection scope of this application.

Claims

1. A data query method, characterized by, include: In response to a user's login request, multiple preset tags are sent to the user's terminal for display, wherein the multiple preset tags include multiple device tags and multiple attribute tags; Receive the tag selection result sent by the user terminal, and obtain at least one target tag included in the tag selection result; Based on the at least one target tag and the preset mapping relationship, at least one target storage path is determined; Retrieve at least one piece of device data based on the at least one target storage path; The step of sending multiple preset tags to the user's terminal for display in response to the user's login request specifically includes: In response to the user's login request, obtain multiple signal strengths between the user terminal and multiple preset devices included in the login request; Based on the multiple signal strengths and a preset strength threshold, a target device is determined among multiple devices, wherein the number of target devices can be one or more; Among the plurality of preset tags, the device tag corresponding to the target device is marked; The marked preset tags are sent to the user terminal for display; The step of determining at least one target storage path based on the at least one target tag and the preset mapping relationship specifically includes: When the at least one target tag is a single tag, the target storage path corresponding to the target tag is determined according to a preset mapping relationship; When there are multiple target tags, obtain the target device tag and at least one target attribute tag from the multiple target tags; The target device tag is combined with each target attribute tag to generate at least one combined tag; Based on the preset mapping relationship, the target storage path corresponding to each combined tag is determined.

2. The method of claim 1, wherein, After retrieving at least one piece of device data according to the at least one target storage path, the process further includes: The data of at least one device is sent to the user terminal for display.

3. The method according to claim 1, characterized in that, Before sending multiple preset tags to the user terminal for display in response to the user's login request, the method further includes: Obtain information on multiple devices from the target manufacturer. This information includes the device name, instruction manual, electronic drawings, commissioning information, inspection precautions, and troubleshooting methods for each device. Generate multiple device tags based on multiple device names; Based on the equipment manual, electronic drawings, commissioning information, inspection precautions, and troubleshooting methods for each device, generate multiple attribute tags; Based on the multiple device tags and the multiple attribute tags, the device manual, electronic drawings, commissioning information, inspection precautions and troubleshooting methods for each device are stored in a preset database.

4. The method according to claim 3, characterized in that, After storing the equipment manual, electronic drawings, commissioning information, inspection precautions, and troubleshooting methods for each device into a preset database based on the multiple device tags and the multiple attribute tags, the process further includes: Obtain the storage path of each device's instruction manual, electronic drawings, commissioning information, inspection precautions, and troubleshooting methods; A preset mapping relationship is generated based on the multiple device tags, the multiple attribute tags, and the storage path.

5. The method according to any one of claims 1 to 4, characterized in that, Multiple devices include at least one of the following: relay protection devices, fault indicators, FTUs, DTUs, and TTUs.

6. A data query device, characterized in that, include: The sending module is used to respond to the user's login request and send multiple preset tags to the user terminal for display, wherein the multiple preset tags include multiple device tags and multiple attribute tags; The acquisition module is used to receive the tag selection result sent by the user terminal and acquire at least one target tag included in the tag selection result; The determining module is used to determine at least one target storage path based on the at least one target tag and a preset mapping relationship; The retrieval module is used to retrieve at least one piece of device data according to the at least one target storage path; The sending module is specifically used for: In response to a user's login request, obtain multiple signal strengths between the user terminal and multiple preset devices included in the login request; Based on multiple signal strengths and a preset strength threshold, a target device is determined from multiple devices, wherein the number of target devices can be one or more; Among multiple preset labels, the device label corresponding to the target device is marked; Send the marked preset tags to the user terminal for display; The module is specifically used for: When at least one target tag is a single tag, the target storage path corresponding to the target tag is determined according to a preset mapping relationship; When there are multiple target tags, obtain the target device tag and at least one target attribute tag from the multiple target tags; The target device tag is combined with each target attribute tag to generate at least one combined tag; Based on the preset mapping relationship, determine the target storage path corresponding to each combined tag.

7. A computer device comprising a memory and a processor, wherein the memory stores a computer program, characterized in that, When the processor executes the computer program, it implements the steps of the method according to any one of claims 1 to 5.

8. A readable storage medium having a computer program stored thereon, characterized in that, When the computer program is executed by a processor, it implements the steps of the method according to any one of claims 1 to 5.

Images