CN113918775A - Data query method and device and electronic equipment - Google Patents
Data query method and device and electronic equipment Download PDFInfo
- Publication number
- CN113918775A CN113918775A CN202111495312.0A CN202111495312A CN113918775A CN 113918775 A CN113918775 A CN 113918775A CN 202111495312 A CN202111495312 A CN 202111495312A CN 113918775 A CN113918775 A CN 113918775A
- Authority
- CN
- China
- Prior art keywords
- energy consumption
- index
- topological graph
- indexes
- searching
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/901—Indexing; Data structures therefor; Storage structures
- G06F16/9024—Graphs; Linked lists
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/903—Querying
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Software Systems (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Debugging And Monitoring (AREA)
Abstract
The application discloses a data query method and device and electronic equipment. Wherein, the method comprises the following steps: establishing a topological graph, wherein the topological graph is used for representing the incidence relation among different energy consumption indexes, and the energy consumption indexes are obtained by calculating bit numbers acquired by energy consumption equipment in an energy consumption equipment set; determining whether the energy consumption index in the topological graph is in a preset range according to a preset time period; and searching for an abnormal bit number corresponding to the energy consumption index according to the incidence relation under the condition that the energy consumption index is not in the preset range. The method and the device solve the technical problem that only the calculation result is emphasized, and the intermediate calculation process is omitted, so that the abnormal tracing is neglected.
Description
Technical Field
The application relates to the field of data query, in particular to a data query method, a data query device and electronic equipment.
Background
Usually, a plurality of devices are arranged in a factory, each device is provided with a plurality of production units, energy consumption media of each device are various, the data calculation period is divided into hours, shifts, days, months, years and the like, and a large amount of time and server resources are consumed for counting the complicated energy consumption indexes. Because the number of devices, equipment and metering points is large, the energy structure and the system are complex, the energy consumption of each device in different periods needs to be calculated and analyzed, the prior art only focuses on the calculation result and ignores the intermediate calculation process, and the unreasonable method is unreasonable for simply calculating the final result and neglecting the abnormal tracing.
In view of the above problems, no effective solution has been proposed.
Disclosure of Invention
The embodiment of the application provides a data query method, a data query device and electronic equipment, and aims to at least solve the technical problem that only calculation results are emphasized, and an intermediate calculation process is omitted, so that abnormal tracing is neglected.
According to an aspect of an embodiment of the present application, there is provided a data query method, including: establishing a topological graph, wherein the topological graph is used for representing the incidence relation among different energy consumption indexes, and the energy consumption indexes are obtained by calculating the bit numbers acquired by energy consumption equipment in an energy consumption equipment set; determining whether the energy consumption index in the topological graph is in a preset range according to a preset time period; and under the condition that the energy consumption index is not in the preset range, searching for an abnormal bit number corresponding to the energy consumption index according to the incidence relation.
Optionally, before the topology is established, the method includes: acquiring the bit number of each energy consumption device in the energy consumption device set, and determining the association relationship among the bit numbers of the energy consumption devices, wherein the bit number is data acquired by the energy consumption devices; calculating the bit number according to the incidence relation to obtain an energy consumption index; establishing an energy consumption index library according to the energy consumption indexes, wherein the energy consumption index library at least stores the association relation among the energy consumption indexes; and establishing a topological graph according to the incidence relation among the energy consumption indexes.
Optionally, determining whether the energy consumption index in the topological graph is within a preset range according to a preset time period includes: determining the index type of any energy consumption index in the topological graph; searching a preset range corresponding to the index type; and comparing the energy consumption index with a preset range corresponding to the index type, and determining whether the energy consumption index is in the preset range according to the comparison result.
Optionally, the energy consumption index includes a first energy consumption index and a second energy consumption index, where the first energy consumption index is a value obtained by calculating a bit number through an association relationship, and the second energy consumption index is a value obtained by calculating the first energy consumption index through an association relationship.
Optionally, the first energy consumption indicator and the second energy consumption indicator are determined by: determining energy consumption indexes with correlation from the topological graph; calculating the energy consumption index with the relationship, wherein the calculation comprises at least one of the following steps: difference, average, maximum, minimum, initial, final, and real-time values.
Optionally, searching for the abnormal bit number corresponding to the energy consumption index according to the association relationship includes: selecting a first route in the topological graph to search layer by layer until the first route is searched; switching a second route in the topological graph, and searching layer by layer until the second route is searched; and after the first route and the second route are searched, searching other routes in the topological graph until the abnormal bit numbers of all the routes in the topological graph are searched, wherein when all the nodes in the topological graph are searched once, the searching process is ended.
Optionally, after the search process is ended, the method further includes: and sending the abnormal bit number to the terminal and generating alarm information.
According to another aspect of the embodiments of the present application, there is also provided a data query apparatus, including: the energy consumption index is obtained by calculating the bit number acquired by the energy consumption equipment in the energy consumption equipment set; the determining module is used for determining whether the energy consumption index in the topological graph is in a preset range according to a preset time period; and the searching module is used for searching the abnormal bit number corresponding to the energy consumption index according to the incidence relation under the condition that the energy consumption index is not in the preset range.
According to another aspect of the embodiments of the present application, there is also provided an electronic device, including: a memory for storing program instructions; a processor coupled to the memory for executing program instructions that implement the functions of: establishing a topological graph, wherein the topological graph is used for representing the incidence relation among different energy consumption indexes, and the energy consumption indexes are obtained by calculating the bit numbers acquired by energy consumption equipment in an energy consumption equipment set; determining whether the energy consumption index in the topological graph is in a preset range according to a preset time period; and under the condition that the energy consumption index is not in the preset range, searching for an abnormal bit number corresponding to the energy consumption index according to the incidence relation.
According to still another aspect of the embodiments of the present application, there is also provided a non-volatile storage medium, which includes a stored program, wherein when the program runs, a device in which the non-volatile storage medium is located is controlled to execute the above data query method.
In the embodiment of the application, the association relationship between the bit numbers and the indexes is displayed through the topological graph in a topological graph constructing mode, all abnormal bit numbers in the topological graph are found through searching the topological graph layer by layer, and the purpose of quickly searching the bit numbers in the indexes is achieved, so that the technical effect of sending the abnormal bit numbers to the terminal and generating alarm information is achieved, the technical problem that only calculation results are emphasized, the intermediate calculation process is omitted is solved, and the technical problem of abnormal tracing is neglected.
Drawings
The accompanying drawings, which are included to provide a further understanding of the application and are incorporated in and constitute a part of this application, illustrate embodiment(s) of the application and together with the description serve to explain the application and not to limit the application. In the drawings:
fig. 1 is a block diagram of a hardware structure of a computer terminal for implementing a data query method according to an embodiment of the present application;
FIG. 2 is a flow chart of a data query method according to an embodiment of the application;
FIG. 3a is a flow chart for establishing a topology graph according to an embodiment of the present application;
FIG. 3b is a schematic diagram of an energy consumption target with infinite loops according to an embodiment of the present application;
FIG. 4 is a flowchart of determining whether an energy consumption index in a topology map is within a predetermined range according to an embodiment of the present disclosure;
FIG. 5 is a flow chart of a manner of determining an energy consumption indicator according to an embodiment of the present application;
FIG. 6a is a flowchart illustrating an exemplary method for finding an abnormal bit number corresponding to an energy consumption indicator according to an association relationship according to an embodiment of the present disclosure;
FIG. 6b is a schematic diagram of a directed graph established according to the energy consumption index calculation relationship according to an embodiment of the present application;
fig. 7 is a block diagram of a data query apparatus according to an embodiment of the present application.
Detailed Description
In order to make the technical solutions better understood by those skilled in the art, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only partial embodiments of the present application, but not all embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
It should be noted that the terms "first," "second," and the like in the description and claims of this application and in the drawings described above are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used is interchangeable under appropriate circumstances such that the embodiments of the application described herein are capable of operation in sequences other than those illustrated or described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
First, some terms or terms appearing in the description of the embodiments of the present application are applicable to the following explanations:
indexes are as follows: an abstraction and description of the production business statistics.
DCS: a Distributed Control System belongs to an instrument Control System.
Bit number: instrument data collected by the instrument control system.
DFS: depth First Search, Depth First Search.
In accordance with an embodiment of the present application, there is provided an embodiment of a data query method, it should be noted that the steps shown in the flowchart of the drawings may be executed in a computer system such as a set of computer executable instructions, and that although a logical order is shown in the flowchart, in some cases, the steps shown or described may be executed in an order different from that here.
The data query method provided by the embodiment of the application can be executed in a mobile terminal, a computer terminal or a similar operation device. Fig. 1 shows a hardware configuration block diagram of a computer terminal (or electronic device) for implementing the data query method. As shown in fig. 1, the computer terminal 10 (or electronic device 10) may include one or more (shown as 102a, 102b, … …, 102 n) processors 102 (the processors 102 may include, but are not limited to, a processing device such as a microprocessor MCU or a programmable logic device FPGA), a memory 104 for storing data, and a transmission module 106 for communication functions. Besides, the method can also comprise the following steps: a display, an input/output interface (I/O interface), a Universal Serial Bus (USB) port (which may be included as one of the ports of the I/O interface), a network interface, a power source, and/or a camera. It will be understood by those skilled in the art that the structure shown in fig. 1 is only an illustration and is not intended to limit the structure of the electronic device. For example, the computer terminal 10 may also include more or fewer components than shown in FIG. 1, or have a different configuration than shown in FIG. 1.
It should be noted that the one or more processors 102 and/or other data processing circuitry described above may be referred to generally herein as "data processing circuitry". The data processing circuitry may be embodied in whole or in part in software, hardware, firmware, or any combination thereof. Further, the data processing circuit may be a single stand-alone processing module, or incorporated in whole or in part into any of the other elements in the computer terminal 10 (or electronic device). As referred to in the embodiments of the application, the data processing circuit acts as a processor control (e.g. selection of a variable resistance termination path connected to the interface).
The memory 104 may be used to store software programs and modules of application software, such as program instructions/data storage devices corresponding to the data query method in the embodiment of the present application, and the processor 102 executes various functional applications and data processing by running the software programs and modules stored in the memory 104, so as to implement the data query method described above. The memory 104 may include high speed random access memory, and may also include non-volatile memory, such as one or more magnetic storage devices, flash memory, or other non-volatile solid-state memory. In some examples, the memory 104 may further include memory located remotely from the processor 102, which may be connected to the computer terminal 10 via a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.
The transmission module 106 is used to receive or transmit data via a network. Specific examples of the network described above may include a wireless network provided by a communication provider of the computer terminal 10. In one example, the transmission device 106 includes a Network adapter (NIC) that can be connected to other Network devices through a base station to communicate with the internet. In one example, the transmission device 106 can be a Radio Frequency (RF) module, which is used to communicate with the internet in a wireless manner.
The display may be, for example, a touch screen type Liquid Crystal Display (LCD) that may enable a user to interact with a user interface of the computer terminal 10 (or electronic device).
It should be noted here that in some alternative embodiments, the computer device (or electronic device) shown in fig. 1 may include hardware elements (including circuitry), software elements (including computer code stored on a computer-readable medium), or a combination of both hardware and software elements. It should be noted that fig. 1 is only one example of a particular specific example and is intended to illustrate the types of components that may be present in the computer device (or electronic device) described above.
Under the operating environment, the embodiment of the application provides a data query method as shown in fig. 2. Fig. 2 is a flowchart of a data query method according to an embodiment of the present application, and as shown in fig. 2, the method includes the following steps:
step S202, a topological graph is established, wherein the topological graph is used for representing the incidence relation among different energy consumption indexes, and the energy consumption indexes are obtained by calculating the bit numbers collected by energy consumption equipment in an energy consumption equipment set;
step S204, determining whether the energy consumption index in the topological graph is in a preset range according to a preset time period;
and step S206, under the condition that the energy consumption index is not in the preset range, searching for an abnormal bit number corresponding to the energy consumption index according to the association relation.
Through the steps, the association relation between the bit numbers and the indexes is displayed through the topological graph in a topological graph constructing mode, all abnormal bit numbers in the topological graph are found through searching the topological graph layer by layer, the purpose of quickly searching the bit numbers in the indexes is achieved, the technical effect that the abnormal bit numbers are sent to the terminal and alarm information is generated is achieved, the technical problem that only calculation results are emphasized, the middle calculation process is omitted, and abnormal tracing is omitted is solved.
Optionally, before the step S202 of establishing the topology map, as shown in the flowchart of fig. 3a, the method specifically includes the following steps:
step S302, acquiring the bit numbers of all energy consumption devices in an energy consumption device set, and determining the association relationship among the bit numbers of all the energy consumption devices, wherein the bit numbers are data collected by the energy consumption devices;
step S304, calculating the bit number according to the association relation to obtain an energy consumption index;
step S306, establishing an energy consumption index library according to the energy consumption indexes, wherein the energy consumption index library at least stores the incidence relation among the energy consumption indexes;
and step S308, establishing a topological graph according to the incidence relation among the energy consumption indexes.
In steps S302 to S308, because different energy consumption devices are in a factory, all the energy consumption devices form an energy consumption device set, and each energy consumption device has a certain connection relationship, when energy consumption statistics needs to be performed on devices and devices in the factory, data displayed by the energy consumption devices acquired by the DCS, that is, bit numbers, are used to determine an association relationship between bit numbers of each energy consumption device, that is, determine a calculation manner between bit numbers, different energy consumption indexes are obtained by calculating the acquired bit numbers, four arithmetic formulas can be defined, configured energy consumption indexes can be used in the formulas, for example, the bit number 1 and the bit number 2 are defined to obtain an energy consumption index 1 by an addition manner, and the energy consumption index 1 and the energy consumption index 2 are defined to obtain an energy consumption index 3 by an addition manner.
And establishing an energy consumption index library according to the incidence relation among the energy consumption indexes or the incidence relation among the bit numbers, wherein the incidence relation among the energy consumption indexes also refers to the calculation relation among the energy consumption indexes. The energy consumption index library includes, but is not limited to, a name of an energy consumption index, an index type to which the energy consumption index belongs, a code corresponding to the energy consumption index, and an association relationship between the energy consumption indexes.
In the energy consumption index library, the calculation relationship between each energy consumption index can be freely combined, so that an infinite loop condition exists, as shown in fig. 3b, the energy consumption index C is referred to when calculating the energy consumption index C, so that a topological graph needs to be established, the energy structure is convenient to clearly understand, and the association relationship between the energy consumption indexes is visually observed through the topological graph. And according to the reference relation in the calculation relation in the database, the DCS automatically draws a topological graph to prepare for the calculation of the energy consumption index.
Optionally, in step S204, it is determined whether the energy consumption index in the topological graph is within a preset range according to a preset time period, as shown in the flowchart shown in fig. 4, the method specifically includes the following steps:
step S402, determining the index type of any energy consumption index in the topological graph;
step S404, searching a preset range corresponding to the index type;
step S406, comparing the energy consumption index with a preset range corresponding to the index type, and determining whether the energy consumption index is in the preset range according to the comparison result.
In steps S402 to S406, the DCS has a fixed preset time period, such as hours, shifts, days, months, years, etc., for the acquisition of the energy consuming device display data. When the bit numbers displayed by the energy consumption equipment are collected according to the preset time period, different energy consumption indexes are obtained through calculation according to the incidence relation among the bit numbers, then the incidence relation among the energy consumption indexes is stored in the database, the index types to which the energy consumption indexes belong are determined from the database, and the different index types correspond to different preset ranges. If the index type of the energy consumption index is temperature and the preset range corresponding to the temperature is 60-90 ℃, comparing the temperature value obtained through calculation with the corresponding preset range, and when the temperature value obtained through calculation is within the preset range of 60-90 ℃, the temperature value is a normal value; and when the temperature value obtained by calculation is not in the corresponding preset range of 60-90 ℃, the temperature value is an abnormal value. When the index type of the energy consumption index is energy consumption, and the preset range corresponding to the energy consumption is 5-5.5 tons, comparing the energy consumption obtained through calculation with the corresponding preset range, and when the energy consumption obtained through calculation is 5-5.5 tons in the preset range, the energy consumption is a normal value; and when the calculated energy consumption is not in the corresponding preset range of 5 tons to 5.5 tons, the energy consumption is an abnormal value. The two examples illustrate that different index types correspond to different preset ranges, and whether the energy consumption index is in the corresponding preset range can be determined according to the comparison process.
In steps S202 to S206, the topology graph is drawn using a directed tree, more specifically, an outward tree, where the topology graph is composed of nodes and edges, if there is an association relationship between the nodes, the edges are connected to two nodes of the association relationship, the direction of the directed tree is from an upper node to a lower node, a node at the bottom in the topology graph is used to represent a bit number, and other nodes except the bottom in the topology graph are used to represent an energy consumption index.
Optionally, the energy consumption index includes a first energy consumption index and a second energy consumption index, where the first energy consumption index is a value obtained by calculating a bit number through an association relationship, and the second energy consumption index is a value obtained by calculating the first energy consumption index through an association relationship.
In the embodiment of the present application, the first energy consumption index may refer to a basic index, the second energy consumption index may refer to an upper layer index, and the basic index may be regarded as a value of a direct bit number to be operated; the upper-layer index may be regarded as a value obtained by performing secondary calculation on the basic index.
In the above method, the first energy consumption index and the second energy consumption index are determined in the following manner, as shown in the flowchart of fig. 5, specifically including the following steps:
step S502, determining energy consumption indexes with a correlation relationship from the topological graph, namely the energy consumption indexes connected through directed edges;
step S504, energy consumption indexes with the correlation are calculated, wherein the calculation comprises at least one of the following steps: the above calculation methods are merely examples, and do not represent all calculation methods. Assuming that 7 different energy consumption indexes are represented by numbers 1 to 7, the calculation formula of the energy consumption index 1 is energy consumption index 2+ energy consumption index 3, the calculation formula of the energy consumption index 2 is energy consumption index 4+ energy consumption index 5, and the calculation formula of the energy consumption index 3 is energy consumption index 6+ energy consumption index 7, so that a directed tree as shown in fig. 6b can be drawn.
Optionally, in step S206, the abnormal bit number corresponding to the energy consumption index is searched according to the association relationship, as shown in the flowchart of fig. 6a, the method specifically includes the following steps:
step S602, selecting a first route in the topological graph to search layer by layer until the search of the first route is finished;
step S604, switching a second route in the topological graph, and searching layer by layer until the second route is searched;
step S606, after the search of the first route and the second route is finished, searching other routes in the topological graph until the abnormal bit numbers of all routes in the topological graph are searched, wherein when all nodes in the topological graph are searched once, the searching process is finished.
In steps S602 to S606, a branch route, that is, a first route, is selected first in the process of searching the topology map, and when a leaf node is searched by the first route, the search of the first route is finished, and the leaf node is a node with an out degree of 0, that is, a node without a child node, that is, a lowest node in the topology map; after the search for the first route is finished, another branch route in the topological graph is switched, namely, the second route is searched until all branch routes in the topological graph are searched. Each route searches the next level according to the name of the energy consumption index introduced in the upper-layer index calculation relation, the next level is searched downwards layer by layer along one route until the position number is searched, the other route is switched to search, and each node can only visit once.
As shown in fig. 6b, the directed tree established according to the energy consumption index calculation relationship may obtain 4 paths (1, 2, 4), (1, 2, 5), (1, 3, 6), (1, 3, 7) according to the directed tree, compare the currently obtained energy consumption index with a corresponding preset range by analyzing all the energy consumption indexes on the 4 paths, determine a bit number having a relationship with the current energy consumption index when the current energy consumption index is not within the preset range, and determine the bit number as an abnormal bit number, thereby finding all the abnormal bit numbers in the 4 paths, where the search process is completed, and the calculation order may be quickly determined based on the directed tree.
Alternatively, after the search process of step S602 to step S606 is finished, the following steps need to be executed: and sending the abnormal bit number to the terminal and generating alarm information. After all the abnormal bit numbers are found, the related information of the abnormal bit numbers, such as the positions of the bit numbers, is sent to the terminal, and related post personnel are notified to process in time, so that energy loss is reduced or avoided.
Fig. 7 is a data query apparatus according to an embodiment of the present application, and as shown in fig. 7, the apparatus includes:
the establishing module 70 is configured to establish a topological graph, where the topological graph is used to represent an association relationship between different energy consumption indexes, and the energy consumption indexes are obtained by calculating bit numbers acquired by energy consumption devices in an energy consumption device set;
a determining module 72, configured to determine whether an energy consumption index in the topological graph is within a preset range according to a preset time period;
and the searching module 74 is configured to search for the abnormal bit number corresponding to the energy consumption index according to the association relationship when the energy consumption index is not within the preset range.
Before the building module 70 builds the topology map, the following functions need to be implemented: acquiring the bit number of each energy consumption device in the energy consumption device set, and determining the association relationship among the bit numbers of the energy consumption devices, wherein the bit number is data acquired by the energy consumption devices; calculating the bit number according to the incidence relation to obtain an energy consumption index; establishing an energy consumption index library according to the energy consumption indexes, wherein the energy consumption index library at least stores the association relation among the energy consumption indexes; and establishing a topological graph according to the incidence relation among the energy consumption indexes.
In the determining module 72, it is determined whether the energy consumption index in the topological graph is within a preset range according to a preset time period, and the following process is specifically required to be implemented: determining the index type of any energy consumption index in the topological graph; searching a preset range corresponding to the index type; and comparing the energy consumption index with a preset range corresponding to the index type, and determining whether the energy consumption index is in the preset range according to the comparison result.
In the data query device, a topological graph is drawn by using a directed tree, wherein the topological graph consists of nodes, the node at the bottommost layer in the topological graph is used for representing a bit number, and the nodes except the bottommost layer in the topological graph are used for representing energy consumption indexes.
The energy consumption indexes in the data query device comprise a first energy consumption index and a second energy consumption index, the first energy consumption index is a value obtained by calculating a bit number through an incidence relation, and the second energy consumption index is a value obtained by calculating the first energy consumption index through the incidence relation.
In the data query device, the first energy consumption index and the second energy consumption index are determined in the following manner, specifically including the following processes: determining energy consumption indexes with correlation from the topological graph; calculating the energy consumption index with the relationship, wherein the calculation comprises at least one of the following steps: difference, average, maximum, minimum, initial, final, and real-time values.
In the searching module 74 of the data query apparatus, the method searches for the abnormal bit number corresponding to the energy consumption index according to the association relationship, which specifically includes the following steps: selecting a first route in the topological graph to search layer by layer until the first route is searched; switching a second route in the topological graph, and searching layer by layer until the second route is searched; and after the first route and the second route are searched, searching other routes in the topological graph until the abnormal bit numbers of all the routes in the topological graph are searched, wherein when all the nodes in the topological graph are searched once, the searching process is ended.
After the search process is finished, the data query device also realizes the following functions: and sending the abnormal bit number to the terminal and generating alarm information.
It should be noted that the data query apparatus shown in fig. 7 is used for executing the data query methods shown in fig. 2, fig. 3a, fig. 3b, fig. 4, fig. 5, fig. 6a, and fig. 6b, and therefore the related explanations in the data query methods are also applicable to the data query apparatus, and are not repeated here.
The embodiment of the application also provides a nonvolatile storage medium, which includes a stored program, wherein, when the program runs, the apparatus where the nonvolatile storage medium is located is controlled to execute the following data query method:
establishing a topological graph, wherein the topological graph is used for representing the incidence relation among different energy consumption indexes, and the energy consumption indexes are obtained by calculating the bit numbers acquired by energy consumption equipment in an energy consumption equipment set;
determining whether the energy consumption index in the topological graph is in a preset range according to a preset time period;
and under the condition that the energy consumption index is not in the preset range, searching for an abnormal bit number corresponding to the energy consumption index according to the incidence relation.
In the above process, before the topological graph is established, the following steps need to be performed: acquiring the bit number of each energy consumption device in the energy consumption device set, and determining the association relationship among the bit numbers of the energy consumption devices, wherein the bit number is data acquired by the energy consumption devices; calculating the bit number according to the incidence relation to obtain an energy consumption index; establishing an energy consumption index library according to the energy consumption indexes, wherein the energy consumption index library at least stores the association relation among the energy consumption indexes; and establishing a topological graph according to the incidence relation among the energy consumption indexes.
Determining whether the energy consumption index in the topological graph is in a preset range according to a preset time period, and specifically executing the following steps: determining the index type of any energy consumption index in the topological graph; searching a preset range corresponding to the index type; and comparing the energy consumption index with a preset range corresponding to the index type, and determining whether the energy consumption index is in the preset range according to the comparison result.
In the process, the topological graph is drawn by using a directed tree, wherein the topological graph consists of nodes, the node at the bottommost layer in the topological graph is used for representing a bit number, and the nodes except the bottommost layer in the topological graph are used for representing the energy consumption index.
The energy consumption indexes comprise a first energy consumption index and a second energy consumption index, the first energy consumption index is a value obtained by calculating the position number through the incidence relation, and the second energy consumption index is a value obtained by calculating the first energy consumption index through the incidence relation.
The first energy consumption index and the second energy consumption index are determined in the following manner, and the following process is specifically required to be executed: determining energy consumption indexes with correlation from the topological graph; calculating the energy consumption index with the relationship, wherein the calculation comprises at least one of the following steps: difference, average, maximum, minimum, initial, final, and real-time values.
Searching for an abnormal bit number corresponding to the energy consumption index according to the association relationship, wherein the following steps are specifically required to be executed: selecting a first route in the topological graph to search layer by layer until the first route is searched; switching a second route in the topological graph, and searching layer by layer until the second route is searched; and after the first route and the second route are searched, searching other routes in the topological graph until the abnormal bit numbers of all the routes in the topological graph are searched, wherein when all the nodes in the topological graph are searched once, the searching process is ended.
After the search process is finished, the data query method further needs to execute the following process: and sending the abnormal bit number to the terminal and generating alarm information.
The above-mentioned serial numbers of the embodiments of the present application are merely for description and do not represent the merits of the embodiments.
In the above embodiments of the present application, the descriptions of the respective embodiments have respective emphasis, and for parts that are not described in detail in a certain embodiment, reference may be made to related descriptions of other embodiments.
In the embodiments provided in the present application, it should be understood that the disclosed technology can be implemented in other ways. The above-described embodiments of the apparatus are merely illustrative, and for example, the division of the units may be a logical division, and in actual implementation, there may be another division, for example, multiple units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, units or modules, and may be in an electrical or other form.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present application may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present application may be substantially implemented or contributed to by the prior art, or all or part of the technical solution may be embodied in a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present application. And the aforementioned storage medium includes: a U-disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a removable hard disk, a magnetic or optical disk, and other various media capable of storing program codes.
The foregoing is only a preferred embodiment of the present application and it should be noted that those skilled in the art can make several improvements and modifications without departing from the principle of the present application, and these improvements and modifications should also be considered as the protection scope of the present application.
Claims (10)
1. A method for querying data, comprising:
establishing a topological graph, wherein the topological graph is used for representing the incidence relation among different energy consumption indexes, and the energy consumption indexes are obtained by calculating bit numbers acquired by energy consumption equipment in an energy consumption equipment set;
determining whether the energy consumption index in the topological graph is in a preset range according to a preset time period;
and searching for an abnormal bit number corresponding to the energy consumption index according to the incidence relation under the condition that the energy consumption index is not in the preset range.
2. The method of claim 1, wherein prior to establishing the topology map, the method comprises:
acquiring the bit number of each energy consumption device in the energy consumption device set, and determining the association relationship among the bit numbers of the energy consumption devices, wherein the bit number is data acquired by the energy consumption device;
calculating the bit number according to the incidence relation to obtain the energy consumption index;
establishing an energy consumption index library according to the energy consumption indexes, wherein the energy consumption index library at least stores the incidence relation among the energy consumption indexes;
and establishing the topological graph according to the incidence relation among the energy consumption indexes.
3. The method of claim 1, wherein the determining whether the energy consumption indicator in the topology map is within a predetermined range according to a predetermined time period comprises:
determining the index type of any energy consumption index in the topological graph;
searching the preset range corresponding to the index type;
and comparing the energy consumption index with the preset range corresponding to the index type, and determining whether the energy consumption index is in the preset range according to a comparison result.
4. The method of claim 1, wherein the energy consumption indicators comprise a first energy consumption indicator and a second energy consumption indicator, the first energy consumption indicator being a value calculated from the correlation of the bit numbers, and the second energy consumption indicator being a value calculated from the correlation of the first energy consumption indicator.
5. The method of claim 4, wherein the first energy consumption indicator and the second energy consumption indicator are determined by:
determining energy consumption indexes with correlation from the topological graph;
calculating the associated energy consumption index, wherein the calculating comprises at least one of: difference, average, maximum, minimum, initial, final, and real-time values.
6. The method according to claim 5, wherein the searching for the abnormal bit number corresponding to the energy consumption indicator according to the association relationship comprises:
selecting a first route in the topological graph to search layer by layer until the first route is searched;
switching a second route in the topological graph, and searching layer by layer until the second route is searched;
and searching other routes in the topological graph until the abnormal bit numbers of all the routes in the topological graph are searched after the searching of the first route and the second route is finished, wherein when all the nodes in the topological graph are searched once, the searching process is finished.
7. The method of claim 6, wherein after the search process is completed, the method further comprises: and sending the abnormal bit number to a terminal and generating alarm information.
8. A data query apparatus, comprising:
the energy consumption management system comprises an establishing module, a calculating module and a calculating module, wherein the establishing module is used for establishing a topological graph, the topological graph is used for representing the incidence relation among different energy consumption indexes, and the energy consumption indexes are obtained by calculating bit numbers acquired by energy consumption equipment in an energy consumption equipment set;
the determining module is used for determining whether the energy consumption index in the topological graph is in a preset range according to a preset time period;
and the searching module is used for searching the abnormal bit number corresponding to the energy consumption index according to the incidence relation under the condition that the energy consumption index is not in the preset range.
9. An electronic device, comprising:
a memory for storing program instructions;
a processor coupled to the memory for executing program instructions that implement the functions of: establishing a topological graph, wherein the topological graph is used for representing the incidence relation among different energy consumption indexes, and the energy consumption indexes are obtained by calculating bit numbers acquired by energy consumption equipment in an energy consumption equipment set; determining whether the energy consumption index in the topological graph is in a preset range according to a preset time period; and searching for an abnormal bit number corresponding to the energy consumption index according to the incidence relation under the condition that the energy consumption index is not in the preset range.
10. A non-volatile storage medium, comprising a stored program, wherein when the program runs, a device in which the non-volatile storage medium is located is controlled to execute the data query method according to any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111495312.0A CN113918775B (en) | 2021-12-09 | 2021-12-09 | Data query method and device and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111495312.0A CN113918775B (en) | 2021-12-09 | 2021-12-09 | Data query method and device and electronic equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113918775A true CN113918775A (en) | 2022-01-11 |
| CN113918775B CN113918775B (en) | 2022-06-07 |
Family
ID=79248800
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111495312.0A Active CN113918775B (en) | 2021-12-09 | 2021-12-09 | Data query method and device and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113918775B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117215469A (en) * | 2023-09-15 | 2023-12-12 | 中电金信软件有限公司 | Capital metering data analysis method and data analysis device |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102325335A (en) * | 2011-05-31 | 2012-01-18 | 北京神州泰岳软件股份有限公司 | End-to-end monitoring method for client gathering business |
| CN104484521A (en) * | 2014-11-27 | 2015-04-01 | 国家电网公司 | Rule for positioning VISIO topological graphs for dispatching and monitoring power grids |
| CN111460232A (en) * | 2020-03-17 | 2020-07-28 | 中国平安人寿保险股份有限公司 | Functional module searching method, device, terminal and computer readable storage medium |
| CN112163728A (en) * | 2020-08-24 | 2021-01-01 | 珠海格力电器股份有限公司 | Energy consumption data processing method and device, electronic equipment and storage medium |
| CN113051446A (en) * | 2019-12-26 | 2021-06-29 | 百度国际科技（深圳）有限公司 | Topological relation query method, device, electronic equipment and medium |
| CN113760625A (en) * | 2021-06-30 | 2021-12-07 | 浙江中控技术股份有限公司 | Evaluation method and monitoring system for model prediction controller performance |
-
2021
- 2021-12-09 CN CN202111495312.0A patent/CN113918775B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102325335A (en) * | 2011-05-31 | 2012-01-18 | 北京神州泰岳软件股份有限公司 | End-to-end monitoring method for client gathering business |
| CN104484521A (en) * | 2014-11-27 | 2015-04-01 | 国家电网公司 | Rule for positioning VISIO topological graphs for dispatching and monitoring power grids |
| CN113051446A (en) * | 2019-12-26 | 2021-06-29 | 百度国际科技（深圳）有限公司 | Topological relation query method, device, electronic equipment and medium |
| CN111460232A (en) * | 2020-03-17 | 2020-07-28 | 中国平安人寿保险股份有限公司 | Functional module searching method, device, terminal and computer readable storage medium |
| CN112163728A (en) * | 2020-08-24 | 2021-01-01 | 珠海格力电器股份有限公司 | Energy consumption data processing method and device, electronic equipment and storage medium |
| CN113760625A (en) * | 2021-06-30 | 2021-12-07 | 浙江中控技术股份有限公司 | Evaluation method and monitoring system for model prediction controller performance |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117215469A (en) * | 2023-09-15 | 2023-12-12 | 中电金信软件有限公司 | Capital metering data analysis method and data analysis device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113918775B (en) | 2022-06-07 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108062367A (en) | The method for uploading and its terminal of a kind of data list | |
| CN104572889A (en) | Method, device and system for recommending search terms | |
| CN113918775B (en) | Data query method and device and electronic equipment | |
| CN107689628B (en) | Power grid loop detection method | |
| JP2020507147A (en) | Real-time data processing method and apparatus | |
| CN116827774A (en) | Service analysis method, device, equipment and storage medium | |
| CN112784025A (en) | Method and device for determining target event | |
| CN112860699A (en) | Database management method and device, storage medium and electronic device | |
| CN107153690A (en) | Content delivery method and device | |
| CN110941887A (en) | Base station layout method, device, medium and equipment | |
| CN113986931A (en) | Report paging method and device, storage medium and computing equipment | |
| CN115442799A (en) | Number query method and device, nonvolatile storage medium and processor | |
| CN114915977A (en) | Determination method and device for topological structure of repeater, storage medium and electronic device | |
| CN112052299B (en) | Method, device, equipment and medium for updating interest points | |
| CN110647543A (en) | Data aggregation method, device and storage medium | |
| CN111061878A (en) | Page clustering method, device, medium and equipment | |
| CN111985738A (en) | Project performance management method, system and storage medium | |
| CN111897983A (en) | Network topological graph generation method, device and system based on graph database | |
| CN113316161B (en) | Method for judging discontinuous cell coverage of digital indoor division design scheme | |
| CN113312436B (en) | Spatial index processing method and device | |
| CN113434612B (en) | Data statistics method and device, storage medium and electronic device | |
| CN112863475B (en) | Speech synthesis method, apparatus and medium | |
| CN114422554B (en) | Service area intelligent equipment management method and device based on distributed Internet of things | |
| CN116842031B (en) | Data updating method, device and storage medium | |
| CN112825112B (en) | Data processing method and device and computer terminal |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |