CN114282618A

CN114282618A - Method, device, equipment and medium for determining user information with abnormal electricity utilization

Info

Publication number: CN114282618A
Application number: CN202111626721.XA
Authority: CN
Inventors: 许庭威; 骆光; 李国君; 陈丽; 韩晓琳; 谢文军; 李秋花
Original assignee: Guangdong Power Grid Co Ltd; Huizhou Power Supply Bureau of Guangdong Power Grid Co Ltd
Current assignee: Guangdong Power Grid Co Ltd; Huizhou Power Supply Bureau of Guangdong Power Grid Co Ltd
Priority date: 2021-12-28
Filing date: 2021-12-28
Publication date: 2022-04-05

Abstract

The embodiment of the invention discloses a method, a device, equipment and a medium for determining user information with abnormal power utilization. The method comprises the following steps: acquiring the power consumption of at least one user to be monitored in a target monitoring time period; determining whether the power consumption comprises abnormal power consumption of rate types except the rate type corresponding to the target monitoring time period; if the electricity consumption comprises the abnormal electricity consumption, determining a user identifier of a user to be monitored corresponding to the abnormal electricity consumption; and determining user information corresponding to the user identification from a pre-constructed user information storage view. According to the technical scheme of the embodiment of the invention, the technical problems of higher troubleshooting difficulty and lower working efficiency in the existing method for determining each user with abnormal electricity utilization data are solved, and the users with abnormal electricity utilization data can be determined more quickly and accurately, so that the technical effects of reducing the troubleshooting difficulty and improving the working efficiency are achieved.

Description

Method, device, equipment and medium for determining user information with abnormal electricity utilization

Technical Field

The embodiment of the invention relates to the technical field of data processing, in particular to a method, a device, equipment and a medium for determining user information with abnormal electricity utilization.

Background

At present, the nation is dedicated to implement a step electricity price and time-sharing charging policy, thereby promoting energy conservation, emission reduction and environmental protection. However, the adoption of the tiered pricing for electricity and time-of-use billing policies results in a large amount of electricity usage data. Because the data volume of the electricity consumption data is large, the work of monitoring and processing the electricity consumption data of the user faces huge challenges.

In the prior art, each user with abnormal electricity consumption data is usually determined in a manual mode, and a worker needs to perform data investigation processing on each piece of electricity consumption data of each user. However, the adoption of the method not only needs more manpower and material resources, but also has the problems of higher troubleshooting difficulty, incapability of quickly positioning users with abnormal electricity utilization and lower working efficiency.

Disclosure of Invention

The embodiment of the invention provides a method, a device, equipment and a medium for determining user information with abnormal power utilization, so as to quickly and accurately determine users with abnormal power utilization data, thereby achieving the technical effects of reducing the difficulty in troubleshooting, quickly positioning the users with abnormal power utilization and improving the working efficiency.

In a first aspect, an embodiment of the present invention provides a method for determining user information of power consumption abnormality, where the method includes:

acquiring the power consumption of at least one user to be monitored in a target monitoring time period;

determining whether the power consumption comprises abnormal power consumption of rate types except the rate type corresponding to the target monitoring time period;

if the electricity consumption comprises the abnormal electricity consumption, determining a user identifier of a user to be monitored corresponding to the abnormal electricity consumption;

and determining user information corresponding to the user identification from a pre-constructed user information storage view.

In a second aspect, an embodiment of the present invention further provides a device for determining user information of abnormal power consumption, where the device includes:

the power consumption acquisition module is used for acquiring the power consumption of at least one user to be monitored in a target monitoring time period;

the abnormal electricity consumption determining module is used for determining whether the electricity consumption comprises abnormal electricity consumption of rate types except the rate type corresponding to the target monitoring time period;

the user identifier determining module is used for determining the user identifier of the user to be monitored corresponding to the abnormal electricity consumption if the electricity consumption comprises the abnormal electricity consumption;

and the user information determining module is used for determining the user information corresponding to the user identification from a pre-constructed user information storage view.

In a third aspect, an embodiment of the present invention further provides an electronic device, where the electronic device includes:

one or more processors;

storage means for storing one or more programs;

when the program is executed by the processor, the processor is caused to implement the user information determination method for power consumption abnormality as provided in any embodiment of the present invention.

In a fourth aspect, an embodiment of the present invention further provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the method for determining user information of power consumption abnormality, as provided in any embodiment of the present invention.

According to the technical scheme of the embodiment of the invention, the power consumption of at least one user to be monitored in the target monitoring time period is obtained. And then it can be determined whether the used electricity amount includes an abnormal used electricity amount of a rate type other than the rate type corresponding to the target monitoring time period. If the electricity consumption comprises abnormal electricity consumption, the user identification of the user to be monitored corresponding to the abnormal electricity consumption can be determined. And then the user information corresponding to the user identification can be determined from the user information storage view which is constructed in advance, so that the technical problems that the conventional method for determining each user with abnormal electricity utilization data needs more manpower and material resources, the abnormal data searching difficulty is higher and the working efficiency is lower are solved, each user with abnormal electricity utilization data can be determined more quickly, effectively and accurately, and the technical effects of reducing the searching difficulty, more quickly positioning the user with abnormal electricity utilization and improving the working efficiency are achieved.

Drawings

In order to more clearly illustrate the technical solutions of the exemplary embodiments of the present invention, a brief description is given below of the drawings used in describing the embodiments. It should be clear that the described figures are only views of some of the embodiments of the invention to be described, not all, and that for a person skilled in the art, other figures can be derived from these figures without inventive effort.

Fig. 1 is a schematic flowchart of a method for determining user information of abnormal power consumption according to an embodiment of the present invention;

fig. 2 is a schematic flowchart of a user information determination method for power consumption abnormality according to a second embodiment of the present invention;

fig. 3 is a schematic structural diagram of a user information determination apparatus for power consumption abnormality according to a third embodiment of the present invention;

fig. 4 is a schematic structural diagram of an electronic device according to a fourth embodiment of the present invention.

Detailed Description

The present invention will be described in further detail with reference to the accompanying drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the invention and are not limiting of the invention. It should be further noted that, for the convenience of description, only some of the structures related to the present invention are shown in the drawings, not all of the structures.

Example one

Fig. 1 is a flowchart illustrating a method for determining user information of abnormal power consumption according to an embodiment of the present invention, where this embodiment is applicable to determining whether the power consumption includes abnormal power consumption of a rate type other than a rate type corresponding to a target monitoring time period, and thus determining a situation of each user with abnormal power consumption data.

As shown in fig. 1, the method of the present embodiment includes:

and S110, acquiring the power consumption of at least one user to be monitored in a target monitoring time period.

The user to be monitored can be understood as the user needing to monitor the electricity consumption at the current moment. The target monitoring period may be a period of time that needs to be monitored at the present moment. Alternatively, the target monitoring time period may be any one of a peak time period, a valley time period, and a flat time period divided by the time-of-use electricity rate billing.

Specifically, a target monitoring time period is determined. After the target monitoring time period is determined, the power consumption of one or more users to be monitored in the target monitoring time period can be obtained.

It should be noted that the peak period, valley period and flat period are periods divided from 24 hours a day according to different electricity prices (see table one).

Watch 1

Optionally, the power consumption of the user to be monitored in the target monitoring time period is obtained by the following method:

the power consumption of at least one user to be monitored in a target monitoring time period is obtained from a system (such as a power grid metering automation system) for storing the power consumption. It should be noted that there are various ways to obtain the power consumption of at least one user to be monitored in the target monitoring time period, and the specific obtaining way is not limited herein.

And S120, determining whether the power consumption comprises abnormal power consumption of rate types except the rate type corresponding to the target monitoring time period.

The rate type may be understood as the electricity prices corresponding to different time periods, that is, the electricity prices corresponding to the peak time period, the valley time period, and the flat time period. The abnormal electricity usage may be a rate type of electricity usage other than a rate type corresponding to the target monitoring period.

Specifically, after the power consumption is obtained, the rate type corresponding to the target monitoring time period may be determined based on a correspondence between a preset time period and the rate type. And then, whether the electricity consumption comprises electricity consumption of rate types except the rate type corresponding to the target monitoring time period can be determined, namely whether abnormal electricity consumption exists in the obtained electricity consumption is determined.

Optionally, it is determined whether the power consumption includes an abnormal power consumption of a rate type other than the rate type corresponding to the target monitoring time period by:

and if the power consumption exceeds the preset power consumption threshold, determining whether the power consumption exceeding the preset power consumption threshold contains abnormal power consumption of rate types except the rate type corresponding to the target monitoring time period.

The preset power utilization threshold may be set according to actual requirements, and specific data thereof is not limited herein, and may be, for example, 0.01, 0.02, or 0.03.

Specifically, the electricity utilization threshold is set in advance. After the power consumption is acquired, the acquired power consumption may be compared with a preset power consumption threshold. If the power consumption exceeds the preset power consumption threshold, it may be determined whether the power consumption exceeding the preset power consumption threshold includes an abnormal power consumption of a rate type other than the rate type corresponding to the target monitoring time period.

And S130, if the electricity consumption comprises abnormal electricity consumption, determining the user identification of the user to be monitored corresponding to the abnormal electricity consumption.

The user identifier may be used to determine user information of the user to be monitored. The user identification may comprise at least one of a user number, a user name and a user type of the user to be monitored.

Specifically, if the obtained power consumption has abnormal power consumption, the user to be monitored corresponding to the abnormal power consumption can be determined. And the user identification of the user to be monitored can be determined.

And S140, determining user information corresponding to the user identification from the pre-constructed user information storage view.

Wherein the user information storage view may be a database view for storing user information. The user information may include a user number, a user name, a user type, a contract capacity, a management unit, and the like.

Specifically, a user information storage view is constructed in advance. After the user identifier of the user to be monitored corresponding to the abnormal electricity consumption is determined, the user information corresponding to the user identifier can be determined from the user information storage view which is constructed in advance.

Optionally, the user information storage view is constructed by the following method:

acquiring a user information data table to be monitored; and constructing a user information storage view based on the user information data table to be monitored and a predefined database query statement for querying the user information.

The user information data table to be monitored can be understood as a data table for storing the user information to be monitored. The database query statement may be a predefined database statement for querying the user information.

Specifically, a user information data table to be monitored is obtained. After the user information data table to be monitored is obtained, a database query statement for querying user information can be defined based on the user information data table to be monitored. And then the user information storage view can be constructed by executing a predefined database query statement for querying the user information.

For example, the user information data table to be monitored may be an HZ _ touch table, and the predefined database query statement for querying the user information may be: CREATE VIEW INFO _ TOUCUS AS (SELECT DISTINCT YHBH house number, MC house name, HTRL volume, JG county and district office, SCH trading user flag FROM HZ _ TOUCU); then, the user information storage view may be INFO _ touch.

Optionally, before obtaining the user information data table to be monitored, the method may further include: and creating a table structure of the user information data table to be monitored. Specifically, the table structure of the user information data table to be monitored can be created by calling a predefined database table building statement for creating the user information data table to be monitored, so that the table structure of the user information data table to be monitored can be quickly and effectively created.

Specifically, a database table building statement for creating a user information data table to be monitored is predefined. After the database table building statement used for creating the user information data table to be monitored, the predefined database table building statement used for creating the user information data table to be monitored can be called, that is, the predefined database table building statement used for creating the user information data table to be monitored can be executed. After executing the database table building statement, a table structure of the user information data table to be monitored can be created in the database.

For example, the predefined database table building statement for creating the user information data table to be monitored may be:

CREATE TABLE HZ _ touch (user NUMBER YHBH VARCHAR2(16) not null, user name MC VARCHAR2(256), user type HTRL NUMBER (16,6), contract capacity SCH VARCHAR2(2), administrative unit DW VARCHAR2(64), primary key PRIMARY KEY (YHBH)); by executing the database table building statement, a table structure of a user information data table (HZ _ TOUCUS) to be monitored can be created.

Optionally, the user information data table to be monitored is obtained by the following method:

acquiring user information of a user to be monitored; and adding the user information of the user to be monitored into the user information data table to be monitored by calling a predefined database adding statement for adding the user information of the user to be monitored.

Specifically, a database addition statement for adding user information of a user to be monitored is predefined. And acquiring user information of a user to be monitored. After the user information of the user to be monitored is acquired, the user information of the user to be monitored can be added into the user information data table to be monitored by calling a predefined database adding statement for adding the user information of the user to be monitored.

It should be noted that there are many ways to obtain the user information of the user to be monitored, and the specific obtaining way is not limited herein, for example, the user information of the user to be monitored may be obtained from a system for storing the user information, or the user information input by the user to be monitored may be received.

According to the technical scheme of the embodiment of the invention, the power consumption of at least one user to be monitored in the target monitoring time period is obtained. And then it can be determined whether the used electricity amount includes an abnormal used electricity amount of a rate type other than the rate type corresponding to the target monitoring time period. If the electricity consumption comprises abnormal electricity consumption, the user identification of the user to be monitored corresponding to the abnormal electricity consumption can be determined. And then the user information corresponding to the user identification can be determined from the user information storage view which is constructed in advance, so that the technical problems that the conventional method for determining each user with abnormal electricity utilization data needs more manpower and material resources, the abnormal data searching difficulty is higher and the working efficiency is lower are solved, each user with abnormal electricity utilization data can be determined more quickly, effectively and accurately, and the technical effects of reducing the searching difficulty and improving the working efficiency are achieved.

Example two

Fig. 2 is a schematic flow chart of a method for determining user information of abnormal power consumption according to a second embodiment of the present invention, where on the basis of the foregoing embodiment, optionally, the determining whether the power consumption includes abnormal power consumption of a rate type other than the rate type corresponding to the target monitoring time period includes: and determining whether the electricity consumption comprises abnormal electricity consumption of rate types except the rate type corresponding to the target monitoring time period by calling a predefined database statement for inquiring the electricity consumption.

Optionally, after determining the user information corresponding to the user identifier from the pre-constructed user information storage view, the method further includes: and marking the user information based on a preset identification style, and displaying the marked user information. The technical terms that are the same as or corresponding to the above embodiments are not repeated herein.

As shown in fig. 2, the method of the embodiment may specifically include:

s210, obtaining the electricity consumption of at least one user to be monitored in the target monitoring time period.

And S220, determining whether the electricity consumption comprises abnormal electricity consumption of rate types except the rate type corresponding to the target monitoring time period by calling a predefined database statement for inquiring the electricity consumption.

Specifically, a database statement for querying the power consumption amount is predefined. After the definition of the database statement for inquiring the electricity consumption amount is completed, a predefined database statement for inquiring the electricity consumption amount may be called, that is, the predefined database statement for inquiring the electricity consumption amount may be executed. After the database statement for inquiring the electricity consumption is executed, it may be determined whether the electricity consumption includes an abnormal electricity consumption of a rate type other than the rate type corresponding to the target monitoring period.

And S230, if the electricity consumption comprises abnormal electricity consumption, determining the user identification of the user to be monitored corresponding to the abnormal electricity consumption.

And S240, determining user information corresponding to the user identification from the pre-constructed user information storage view.

And S250, marking the user information based on the preset identification style, and displaying the marked user information.

The preset identification style may be set according to actual requirements, and the specific style is not limited herein, for example, the font of the user information may be marked as a font with a preset color (e.g., a red font), or the font used for the information may be marked as a bold font, or the font of the user information may be marked as an underline.

Specifically, the identification style of the user information is preset. After the user information corresponding to the user identifier is acquired, the user information may be labeled based on a preset identifier style. After the user information is marked, the marked user information can be displayed. It should be noted that, in this embodiment, the advantage of labeling the user information through the preset identification style is that it is possible to determine each user with abnormal electricity consumption data more quickly and conveniently.

According to the technical scheme of the embodiment of the invention, whether the electricity consumption comprises abnormal electricity consumption of rate types except the rate type corresponding to the target monitoring time period is determined by calling a predefined database statement for inquiring the electricity consumption. And after the user information corresponding to the user identification is determined from the pre-constructed user information storage view, marking the user information based on a preset identification pattern, and displaying the marked user information, so that each user with abnormal electricity utilization data can be determined more quickly, effectively and accurately, and the technical effects of reducing the troubleshooting difficulty and improving the working efficiency are achieved.

EXAMPLE III

Fig. 3 is a schematic structural diagram of a user information determination device with abnormal power consumption according to a third embodiment of the present invention, and the present invention provides a user information determination device with abnormal power consumption, including: a power consumption obtaining module 310, an abnormal power consumption determining module 320, a user identification determining module 330, and a user information determining module 340.

The power consumption obtaining module 310 is configured to obtain power consumption of at least one user to be monitored in a target monitoring time period; an abnormal power consumption determining module 320, configured to determine whether the power consumption includes an abnormal power consumption of a rate type other than the rate type corresponding to the target monitoring time period; a user identifier determining module 330, configured to determine, if the power consumption includes the abnormal power consumption, a user identifier of a user to be monitored, where the user identifier corresponds to the abnormal power consumption; and the user information determining module 340 is configured to determine user information corresponding to the user identifier from a pre-constructed user information storage view.

According to the technical scheme of the embodiment of the invention, the power consumption of at least one user to be monitored in the target monitoring time period is acquired through the power consumption acquisition module. And then, whether the power consumption comprises abnormal power consumption of rate types except the rate type corresponding to the target monitoring time period can be determined through the abnormal power consumption determination module. Through the user identification determining module, if the electricity consumption comprises abnormal electricity consumption, the user identification of the user to be monitored corresponding to the abnormal electricity consumption can be determined. And then the user information corresponding to the user identification is determined from the user information storage view which is constructed in advance through the user information determining module, so that the technical problems that the conventional method for determining each user with abnormal electricity utilization data not only needs to spend more manpower and material resources, but also has higher difficulty in abnormal data investigation and lower working efficiency are solved, each user with abnormal electricity utilization data can be determined more quickly, effectively and accurately, and the technical effects of reducing the difficulty in investigation and improving the working efficiency are achieved.

Optionally, the abnormal power consumption determining module 320 is configured to determine whether the power consumption includes an abnormal power consumption of a rate type other than the rate type corresponding to the target monitoring time period by invoking a predefined database statement for querying the power consumption.

Optionally, the abnormal electricity consumption determining module 320 is configured to determine whether the electricity consumption exceeding the preset electricity consumption threshold includes an abnormal electricity consumption of a rate type other than the rate type corresponding to the target monitoring time period, if the electricity consumption exceeds the preset electricity consumption threshold.

Optionally, the apparatus further comprises: the user information storage view construction module is used for acquiring a user information data table to be monitored; and constructing the user information storage view based on the user information data table to be monitored and a predefined database query statement for querying the user information.

Optionally, before the obtaining of the user information data table to be monitored, the apparatus further includes: and the to-be-monitored user information data table creating module is used for creating a table structure of the to-be-monitored user information data table by calling a pre-defined database table creating statement used for creating the to-be-monitored user information data table.

Optionally, the user information storage view construction module is configured to obtain user information of a user to be monitored; and adding the user information of the user to be monitored into a user information data table to be monitored by calling a predefined database adding statement for adding the user information of the user to be monitored.

Optionally, after determining the user information corresponding to the user identifier from the pre-constructed user information storage view, the apparatus further includes: and the user information marking module is used for marking the user information based on a preset identification style and displaying the marked user information.

The device can execute the user information determining method for power utilization abnormity provided by any embodiment of the invention, and has the corresponding functional modules and beneficial effects of the user information determining method for power utilization abnormity.

It should be noted that, the units and modules included in the user information determination apparatus with abnormal power consumption are merely divided according to functional logic, but are not limited to the above division, as long as the corresponding functions can be realized; in addition, specific names of the functional units are only for convenience of distinguishing from each other, and are not used for limiting the protection scope of the embodiment of the invention.

Example four

Fig. 4 is a schematic structural diagram of an electronic device according to a fourth embodiment of the present invention. FIG. 4 illustrates a block diagram of an exemplary electronic device 12 suitable for use in implementing any of the embodiments of the present invention. The electronic device 12 shown in fig. 4 is only an example and should not bring any limitation to the function and the scope of use of the embodiment of the present invention. The device 12 is typically an electronic device that undertakes the processing of configuration information.

As shown in FIG. 4, electronic device 12 is embodied in the form of a general purpose computing device. The components of electronic device 12 may include, but are not limited to: one or more processors or processing units 16, a memory 28, and a bus 18 that couples the various components (including the memory 28 and the processing unit 16).

Bus 18 represents one or more of any of several types of bus structures, including a memory bus or memory controller, a peripheral bus, an accelerated graphics port, and a processor or local bus using any of a variety of bus architectures. By way of example, such architectures include, but are not limited to, an Industry Standard Architecture (ISA) bus, a Micro Channel Architecture (MCA) bus, an enhanced ISA bus, a Video Electronics Standards Association (VESA) local bus, and a Peripheral Component Interconnect (PCI) bus.

Electronic device 12 typically includes a variety of computer-readable media. Such media may be any available media that is accessible by electronic device 12 and includes both volatile and nonvolatile media, removable and non-removable media.

Memory 28 may include computer device readable media in the form of volatile Memory, such as Random Access Memory (RAM) 30 and/or cache Memory 32. The electronic device 12 may further include other removable/non-removable, volatile/nonvolatile computer storage media. By way of example only, storage system 34 may be used to read from and write to non-removable, nonvolatile magnetic media (not shown, but commonly referred to as a "hard drive"). Although not shown, a magnetic disk drive for reading from and writing to a removable, nonvolatile magnetic disk (e.g., a "floppy disk") and an optical disk drive for reading from or writing to a removable, nonvolatile optical disk (e.g., a Compact disk-Read Only Memory (CD-ROM), Digital Video disk (DVD-ROM), or other optical media) may be provided. In these cases, each drive may be connected to bus 18 by one or more data media interfaces. Memory 28 may include at least one program product 40, with program product 40 having a set of program modules 42 configured to carry out the functions of embodiments of the invention. Program product 40 may be stored, for example, in memory 28, and such program modules 42 include, but are not limited to, one or more application programs, other program modules, and program data, each of which examples or some combination may comprise an implementation of a network environment. Program modules 42 generally carry out the functions and/or methodologies of the described embodiments of the invention.

Electronic device 12 may also communicate with one or more external devices 14 (e.g., keyboard, mouse, camera, etc., and display), one or more devices that enable a user to interact with electronic device 12, and/or any devices (e.g., network card, modem, etc.) that enable electronic device 12 to communicate with one or more other computing devices. Such communication may be through an input/output (I/O) interface 22. Also, the electronic device 12 may communicate with one or more networks (e.g., a Local Area Network (LAN), Wide Area Network (WAN), and/or a public Network such as the internet) via the Network adapter 20. As shown, the network adapter 20 communicates with other modules of the electronic device 12 via the bus 18. It should be understood that although not shown in the figures, other hardware and/or software modules may be used in conjunction with electronic device 12, including but not limited to: microcode, device drivers, Redundant processing units, external disk drive Arrays, disk array (RAID) devices, tape drives, and data backup storage devices, to name a few.

The processing unit 16 executes various functional applications and data processing by running the program stored in the memory 28, for example, implementing the user information determination method for power consumption abnormality provided by the above-described embodiment of the present invention, the method including:

acquiring the power consumption of at least one user to be monitored in a target monitoring time period; determining whether the power consumption comprises abnormal power consumption of rate types except the rate type corresponding to the target monitoring time period; if the electricity consumption comprises the abnormal electricity consumption, determining a user identifier of a user to be monitored corresponding to the abnormal electricity consumption; and determining user information corresponding to the user identification from a pre-constructed user information storage view.

Of course, those skilled in the art can understand that the processor may also implement the technical solution of the method for determining the user information of the power utilization abnormality provided in any embodiment of the present invention.

EXAMPLE five

An embodiment of the present invention further provides a computer-readable storage medium, on which a computer program is stored, where when the program is executed by a processor, for example, the method for determining user information of power consumption abnormality provided in the foregoing embodiment of the present invention includes:

Computer storage media for embodiments of the invention may employ any combination of one or more computer-readable media. The computer readable medium may be a computer readable signal medium or a computer readable storage medium. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples (a non-exhaustive list) of the computer readable storage medium would include the following: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the context of this document, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.

A computer readable signal medium may include a propagated data signal with computer readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device.

Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.

Computer program code for carrying out operations for embodiments of the present invention may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, Smalltalk, C + + or the like and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any type of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or the connection may be made to an external computer (for example, through the Internet using an Internet service provider).

It is to be noted that the foregoing is only illustrative of the preferred embodiments of the present invention and the technical principles employed. It will be understood by those skilled in the art that the present invention is not limited to the particular embodiments described herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the invention. Therefore, although the present invention has been described in greater detail by the above embodiments, the present invention is not limited to the above embodiments, and may include other equivalent embodiments without departing from the spirit of the present invention, and the scope of the present invention is determined by the scope of the appended claims.

Claims

1. A user information determination method for power utilization abnormality is characterized by comprising the following steps:

2. The method of claim 1, wherein the determining whether the power usage includes abnormal power usage of a rate type other than the rate type corresponding to the target monitoring time period comprises:

and determining whether the electricity consumption comprises abnormal electricity consumption of rate types except the rate type corresponding to the target monitoring time period by calling a predefined database statement for inquiring the electricity consumption.

3. The method of claim 1, wherein the determining whether the power usage includes abnormal power usage of a rate type other than the rate type corresponding to the target monitoring time period comprises:

and if the electricity consumption exceeds a preset electricity utilization threshold, determining whether the electricity consumption exceeding the preset electricity utilization threshold contains abnormal electricity consumption of rate types except the rate type corresponding to the target monitoring time period.

4. The method of claim 1, further comprising:

acquiring a user information data table to be monitored;

and constructing the user information storage view based on the user information data table to be monitored and a predefined database query statement for querying the user information.

5. The method of claim 4, wherein before the obtaining the user information data table to be monitored, the method further comprises:

and creating a table structure of the user information data table to be monitored.

6. The method according to claim 4, wherein the obtaining the user information data table to be monitored comprises:

acquiring user information of a user to be monitored;

and adding the user information of the user to be monitored into a user information data table to be monitored by calling a predefined database adding statement for adding the user information of the user to be monitored.

7. The method of claim 1, wherein after determining the user information corresponding to the user identifier from the pre-constructed user information storage view, the method further comprises:

and marking the user information based on a preset identification style, and displaying the marked user information.

8. A user information determination device for power abnormality, comprising:

9. An electronic device, characterized in that the electronic device comprises:

one or more processors;

storage means for storing one or more programs;

when the program is executed by the processor, the processor is caused to implement the power abnormality user information determination method according to any one of claims 1 to 7.

10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, implements the method for determining user information of a power usage abnormality according to any one of claims 1 to 7.