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

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 of abnormal electricity consumption

technical field

Embodiments of the present invention relate to the technical field of data processing, and in particular, to a method, apparatus, device, and medium for determining user information with abnormal power consumption.

Background technique

At present, the state is committed to implementing tiered electricity prices and time-of-use billing policies to promote energy conservation, emission reduction and environmental protection. However, the adoption of tiered tariffs and time-of-use billing policies generates a large amount of electricity consumption data. Due to the large amount of electricity consumption data, the monitoring and processing of electricity consumption data of users faces enormous challenges.

In the prior art, each user whose electricity consumption data is abnormal is usually determined manually, and a staff member is required to perform data investigation and processing for each piece of electricity consumption data of each user. However, using this method not only requires more manpower and material resources, but also has the problems of high difficulty in troubleshooting, inability to quickly locate users with abnormal power consumption, and low work efficiency.

SUMMARY OF THE INVENTION

Embodiments of the present invention provide a method, device, equipment and medium for determining user information with abnormal power consumption, so as to more quickly and accurately determine users with abnormal power consumption data, thereby reducing the difficulty of investigation and locating abnormal users more quickly. Users of electricity and the technical effect of improving work efficiency.

In a first aspect, an embodiment of the present invention provides a method for determining user information of abnormal electricity consumption, the method comprising:

Obtain the electricity consumption of at least one user to be monitored during the target monitoring time period;

determining whether the electricity consumption includes abnormal electricity consumption of a rate type other than the rate type corresponding to the target monitoring time period;

If the power consumption includes the abnormal power consumption, determining the user identifier of the user to be monitored corresponding to the abnormal power consumption;

User information corresponding to the user identification is determined from a pre-built user information storage view.

In a second aspect, an embodiment of the present invention also provides a device for determining user information with abnormal power consumption, the device comprising:

an electricity consumption acquisition module, used to acquire the electricity consumption of at least one user to be monitored during the target monitoring time period;

an abnormal power consumption determination module, configured to determine whether the power consumption includes abnormal power consumption of a rate type other than the rate type corresponding to the target monitoring time period;

a user identification determination module, configured to determine the user identification of the user to be monitored corresponding to the abnormal power consumption if the power consumption includes the abnormal power consumption;

A user information determination module, configured to determine user information corresponding to the user identification from a pre-built user information storage view.

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

one or more processors;

a storage device for storing one or more programs;

When the program is executed by the processor, the processor implements the method for determining user information of abnormal power consumption provided by 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, and when the program is executed by a processor, implements the user information determination of abnormal power consumption as provided by any embodiment of the present invention method.

The technical solution of the embodiment of the present invention is to obtain the electricity consumption of at least one user to be monitored in the target monitoring time period. Further, it can be determined whether the electricity consumption includes abnormal electricity consumption of a rate type other than the rate type corresponding to the target monitoring time period. If the power consumption includes abnormal power consumption, the user identifier of the user to be monitored corresponding to the abnormal power consumption can be determined. Furthermore, the user information corresponding to the user ID can be determined from the pre-built user information storage view, which solves the problem that the existing method of determining each user with abnormal power consumption data not only requires more human and material resources, but also has problems. The technical problems of high difficulty in troubleshooting abnormal data and low work efficiency have realized a more rapid, effective and accurate determination of each user with abnormal power consumption data, thereby reducing the difficulty of troubleshooting, more quickly locating users with abnormal power consumption, and improving The technical effect of work efficiency.

Description of drawings

In order to illustrate the technical solutions of the exemplary embodiments of the present invention more clearly, the following briefly introduces the accompanying drawings used in describing the embodiments. Obviously, the introduced drawings are only a part of the drawings of the embodiments to be described in the present invention, rather than all drawings. For those of ordinary skill in the art, without creative work, they can also obtain the drawings according to these drawings. Additional drawings.

FIG. 1 is a schematic flowchart of a method for determining user information with abnormal power consumption according to Embodiment 1 of the present invention;

2 is a schematic flowchart of a method for determining user information with abnormal power consumption provided by Embodiment 2 of the present invention;

3 is a schematic structural diagram of an apparatus for determining user information with abnormal power consumption provided by Embodiment 3 of the present invention;

FIG. 4 is a schematic structural diagram of an electronic device according to Embodiment 4 of the present invention.

Detailed ways

The present invention will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present invention, but not to limit the present invention. In addition, it should be noted that, for the convenience of description, the drawings only show some but not all structures related to the present invention.

Example 1

FIG. 1 is a schematic flowchart of a method for determining user information of abnormal electricity consumption provided by Embodiment 1 of the present invention. This embodiment is applicable to determining whether the electricity consumption includes a rate type other than the rate type corresponding to the target monitoring time period. The abnormal electricity consumption of the tariff type, and then the situation of each user with abnormal electricity consumption data can be determined. This method can be executed by the user information determination device with abnormal electricity consumption. /Or implemented in hardware, and can be integrated into electronic devices such as computers or servers.

As shown in Figure 1, the method of this embodiment includes:

S110. Acquire the power consumption of at least one user to be monitored in the target monitoring time period.

Among them, the user to be monitored can be understood as a user who needs to monitor the electricity consumption at the current moment. The target monitoring time period may be the time period that needs to be monitored at the current moment. Optionally, the target monitoring time period may be any time period in a peak period, a peak period, a valley period and a normal period divided by the time-of-use electricity price billing.

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

It should be noted that the peak period, peak period, valley period and peace period are divided into several periods of 24 hours a day according to different electricity prices (see Table 1).

Table I

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

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

S120. Determine whether the electricity consumption includes abnormal electricity consumption of a rate type other than the rate type corresponding to the target monitoring time period.

Among them, the tariff type can be understood as the electricity price corresponding to different time periods, that is, the electricity price corresponding to the peak period, the peak period, the valley period and the normal period. The abnormal electricity consumption may be electricity consumption of a rate type other than the rate type corresponding to the target monitoring time period.

Specifically, after the electricity consumption is acquired, the rate type corresponding to the target monitoring time period may be determined based on the corresponding relationship between the preset time period and the rate type. Further, it can be determined whether the electricity consumption includes electricity consumption of a rate type other than the rate type corresponding to the target monitoring time period, that is, it is determined whether there is abnormal electricity consumption in the obtained electricity consumption.

Optionally, determine whether the electricity consumption includes abnormal electricity consumption of a rate type other than the rate type corresponding to the target monitoring time period in the following manner:

If the power consumption exceeds the preset power consumption threshold, it is determined whether the power consumption exceeding the preset power consumption threshold includes abnormal power consumption of a rate type other than the rate type corresponding to the target monitoring time period.

The preset power consumption threshold may be set according to actual needs, and the specific data thereof is not limited here, for example, it may be 0.01, 0.02, or 0.03, and the like.

Specifically, the power consumption threshold is preset. After the power consumption is obtained, the obtained power consumption can 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 abnormal power consumption of a rate type other than the rate type corresponding to the target monitoring time period.

S130. If the power consumption includes abnormal power consumption, determine the user identifier of the user to be monitored corresponding to the abnormal power consumption.

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

Specifically, if there is abnormal power consumption in the acquired power consumption, the user to be monitored corresponding to the abnormal power consumption can be determined. Further, the user identifier of the user to be monitored can be determined.

S140. Determine user information corresponding to the user identifier from a pre-built user information storage view.

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

Specifically, a user information storage view is pre-built. After the user identification of the user to be monitored corresponding to the abnormal power consumption is determined, the user information corresponding to the user identification may be determined from a pre-built user information storage view.

Optionally, construct the user information storage view in the following ways:

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

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

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

Exemplarily, the user information data table to be monitored may be the HZ_TOUCUS table, and the predefined database query statement for querying user information may be: CREATE VIEW INFO_TOUCUS AS (SELECT DISTINCT YHBH account number, MC account name, HTRL capacity, JG county Regional Bureau, SCH Trader Flag FROM HZ_TOUCU); then, the user information storage view can be INFO_TOUCUS.

Optionally, before acquiring the user information data table to be monitored, the method may further include: 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 created quickly and effectively .

Specifically, a database table building statement for creating a user information data table to be monitored is pre-defined. After the database table building statement for creating the user information data table to be monitored, the pre-defined database table building statement for creating the user information data table to be detected can be called. The database table creation statement for monitoring the user information data table. After the database table creation statement is executed, the table structure of the user information data table to be monitored can be created in the database.

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

CREATE TABLE HZ_TOUCUS(user number YHBH VARCHAR2(16) not null, user name MCVARCHAR2(256), user type HTRL NUMBER(16,6), contract capacity SCH VARCHAR2(2), management unit DWVARCHAR2(64), primary key PRIMARY KEY( YHBH)); by executing the database table building statement, the table structure of the user information data table (HZ_TOUCUS) to be monitored can be created.

Optionally, obtain the user information data table to be monitored in the following manner:

Obtain the user information of the user to be monitored; add the user information of the user to be monitored to the user information data table of the to-be-monitored user by invoking a predefined database adding statement for adding user information of the to-be-monitored user.

Specifically, a database adding statement for adding user information of the user to be monitored is pre-defined. Obtain the user information of the user to be monitored. After acquiring the user information of the user to be monitored, the user information of the user to be monitored can be added to the user information data table of the user to be monitored by invoking a predefined database adding statement for adding 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 acquisition method is not limited here. For example, the user information of the user to be detected can be obtained from the system for storing user information, or, you can Receive user information input by the user to be monitored.

The technical solution of the embodiment of the present invention is to obtain the electricity consumption of at least one user to be monitored in the target monitoring time period. Further, it can be determined whether the electricity consumption includes abnormal electricity consumption of a rate type other than the rate type corresponding to the target monitoring time period. If the power consumption includes abnormal power consumption, the user identifier of the user to be monitored corresponding to the abnormal power consumption can be determined. Furthermore, the user information corresponding to the user ID can be determined from the pre-built user information storage view, which solves the problem that the existing method of determining each user with abnormal power consumption data not only requires more human and material resources, but also has problems. The technical problems of higher difficulty in troubleshooting abnormal data and low work efficiency can be realized more quickly, effectively and accurately to determine the users with abnormal power consumption data, thus achieving the technical effect of reducing the difficulty of troubleshooting and improving work efficiency.

Embodiment 2

FIG. 2 is a schematic flowchart of a method for determining user information of abnormal power consumption according to Embodiment 2 of the present invention. On the basis of the foregoing embodiment, optionally, the determining whether the power consumption includes the addition of the target Monitoring the abnormal electricity consumption of rate types other than the rate type corresponding to the time period includes: by invoking a predefined database statement for querying electricity consumption, determining whether the electricity consumption includes other than the target monitoring Abnormal electricity consumption of a rate type other than the rate type corresponding to the time period.

Optionally, after determining the user information corresponding to the user identification from the pre-built user information storage view, the method further includes: annotating the user information based on a preset identification style, and labeling the user information. After the user information is displayed. Wherein, the technical terms that are the same as or corresponding to the above embodiments are not repeated here.

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

S210: Acquire the power consumption of at least one user to be monitored in the target monitoring time period.

S220. Determine whether the electricity consumption includes abnormal electricity 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 electricity consumption.

Specifically, a database statement for querying electricity consumption is pre-defined. After the definition of the database statement for querying the electricity consumption is completed, the predefined database statement for querying the electricity consumption can be called, that is, the predefined database statement for querying the electricity consumption can be executed. After the execution of the database statement for querying the electricity consumption is completed, it can be determined whether the electricity consumption includes abnormal electricity consumption of a rate type other than the rate type corresponding to the target monitoring time period.

S230. If the power consumption includes abnormal power consumption, determine the user identifier of the user to be monitored corresponding to the abnormal power consumption.

S240. Determine user information corresponding to the user identifier from a pre-built user information storage view.

S250. Mark the user information based on the preset identification style, and display the marked user information.

The preset logo style can be set according to actual needs, and the specific style is not limited here. For example, the font of the user information can be marked as a font of a preset color (for example, a red font), or the font used for information can be marked as The font of the user information is marked in bold, or, the font of the user information can be underlined.

Specifically, the identification style of the user information is preset. After acquiring the user information corresponding to the user identification, the user information may be marked based on a preset identification 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 marking the user information through the preset identification style is that each user with abnormal power consumption data can be determined more quickly and conveniently.

The technical solution of the embodiment of the present invention is to determine whether the electricity consumption includes a rate type other than the rate type corresponding to the target monitoring time period by invoking a predefined database statement for querying electricity consumption. Abnormal power consumption. and after the user information corresponding to the user identification is determined from the pre-built user information storage view, the user information is marked based on a preset identification style, and the marked user information is displayed to further achieve In order to more quickly, effectively and accurately determine the users with abnormal power consumption data, the technical effect of reducing the difficulty of investigation and improving work efficiency is achieved.

Embodiment 3

3 is a schematic structural diagram of an apparatus for determining user information with abnormal power consumption provided by Embodiment 3 of the present invention. The present invention provides an apparatus for determining user information with abnormal power consumption. The apparatus includes: a power consumption acquisition module 310, Abnormal power consumption determination module 320 , user identification determination module 330 and user information determination module 340 .

Among them, the electricity consumption acquisition module 310 is used to acquire the electricity consumption of at least one user to be monitored in the target monitoring time period; the abnormal electricity consumption determination module 320 is used to determine whether the electricity consumption includes the power consumption other than the target Monitoring the abnormal power consumption of rate types other than the rate type corresponding to the time period; the user identification determination module 330 is configured to determine the abnormal power consumption if the power consumption includes the abnormal power consumption The corresponding user identifier of the user to be monitored; the user information determination module 340 is configured to determine the user information corresponding to the user identifier from the pre-built user information storage view.

In the technical solution of the embodiment of the present 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. Further, it can be determined by the abnormal power consumption determination module whether the power consumption includes abnormal power consumption of a rate type other than the rate type corresponding to the target monitoring time period. Through the user identification determining module, if the power consumption includes abnormal power consumption, the user identification of the user to be monitored corresponding to the abnormal power consumption can be determined. Furthermore, the user information corresponding to the user ID can be determined from the pre-built user information storage view through the user information determination module, which solves the problem that the existing method for determining each user with abnormal power consumption data not only requires a lot of manpower and energy. Material resources, and there are technical problems such as high difficulty in troubleshooting abnormal data and low work efficiency, which realizes a more rapid, effective and accurate determination of each user with abnormal power consumption data, thereby reducing the difficulty of troubleshooting and improving work efficiency. technical effect.

Optionally, the abnormal electricity consumption determination module 320 is configured to determine whether the electricity consumption includes any other than the tariff type corresponding to the target monitoring time period by invoking a predefined database statement for querying electricity consumption. Unusual electricity usage for a rate type other than that.

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

Optionally, the device further includes: a user information storage view building module for acquiring a user information data table to be monitored; based on the user information data table to be monitored and a predefined database query statement for querying user information, constructing The user information storage view.

Optionally, before the acquisition of the user information data table to be monitored, the device further includes: a user information data table creation module to be monitored, for creating a table by calling a predefined database for creating the user information data table to be monitored. statement to create the table structure of the user information data table to be monitored.

Optionally, the user information storage view building module is used to obtain the user information of the user to be monitored; the user information of the user to be monitored is added by calling a predefined database adding statement for adding the user information of the user to be monitored. to the user information data table to be monitored.

Optionally, after the user information corresponding to the user identification is determined from the pre-built user information storage view, the device further includes: a user information labeling module, configured to identify the user information based on a preset identification style. Mark and display the marked user information.

The above apparatus can execute the method for determining user information of abnormal power consumption provided by any embodiment of the present invention, and has functional modules and beneficial effects corresponding to executing the method for determining user information of abnormal power consumption.

It is worth noting that the units and modules included in the above-mentioned device for determining user information with abnormal power consumption are only divided according to functional logic, but are not limited to the above-mentioned division, as long as the corresponding functions can be realized; The specific names of the functional units are only for the convenience of distinguishing from each other, and are not used to limit the protection scope of the embodiments of the present invention.

Embodiment 4

FIG. 4 is a schematic structural diagram of an electronic device according to Embodiment 4 of the present invention. Figure 4 shows 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 impose any limitations on the function and scope of use of the embodiments of the present invention. Device 12 is typically an electronic device that undertakes the processing of configuration information.

As shown in FIG. 4, the electronic device 12 takes the form of a general-purpose computing device. Components of the 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 connecting the various components including the memory 28 and the processing unit 16 .

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

Electronic device 12 typically includes a variety of computer-readable media. These media can be any available media that can be accessed by electronic device 12, including both volatile and non-volatile 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 . Electronic device 12 may further include other removable/non-removable, volatile/non-volatile computer storage media. For example only, storage system 34 may be used to read and write to non-removable, non-volatile magnetic media (not shown, commonly referred to as "hard disk drives"). Although not shown in the figures, magnetic disk drives for reading and writing to removable non-volatile magnetic disks (eg "floppy disks") and removable non-volatile optical disks (eg Compact Disc-Read) may be provided Only Memory, CD-ROM), Digital Video Disc (Digital Video Disc-Read Only Memory, DVD-ROM) or other optical media) read and write optical disc drives. In these cases, each drive may be connected to bus 18 through one or more data media interfaces. The memory 28 may include at least one program product 40 having a set of program modules 42 configured to perform the functions of various embodiments of the present invention. Program product 40, which may be stored, for example, in memory 28, such program modules 42 including, but not limited to, one or more application programs, other program modules, and program data, each or some combination of these examples may include a network environment realization. Program modules 42 generally perform the functions and/or methods of the described embodiments of the present invention.

The electronic device 12 may also communicate with one or more external devices 14 (eg, keyboard, mouse, camera, etc., and display), with one or more devices that enable a user to interact with the electronic device 12, and/or with Any device (eg, network card, modem, etc.) that enables the electronic device 12 to communicate with one or more other computing devices. Such communication may take place through input/output (I/O) interface 22 . Also, the electronic device 12 may communicate with one or more networks (eg, Local Area Network (LAN), Wide Area Network, WAN) and/or public networks such as the Internet through the network adapter 20 . As shown, network adapter 20 communicates with other modules of electronic device 12 via bus 18 . It should be understood that, although not shown, 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, Redundant Arrays of Independent Disks, RAID) devices, tape drives, and data backup storage devices.

The processing unit 16 executes various functional applications and data processing by running the programs stored in the memory 28, for example, to realize the method for determining user information of abnormal power consumption provided by the above-mentioned embodiments of the present invention, and the method includes:

Obtain the electricity consumption of at least one user to be monitored during the target monitoring period; determine whether the electricity consumption includes abnormal electricity consumption of a rate type other than the rate type corresponding to the target monitoring period; if If the power consumption includes the abnormal power consumption, the user ID of the user to be monitored corresponding to the abnormal power consumption is determined; the user information corresponding to the user ID is determined from a pre-built user information storage view .

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

Embodiment 5

Embodiment 5 of the present invention further provides a computer-readable storage medium on which a computer program is stored, characterized in that, when the program is executed by a processor, for example, the method for determining user information of abnormal power consumption provided by the above-mentioned embodiments of the present invention , the method includes:

Obtain the electricity consumption of at least one user to be monitored during the target monitoring period; determine whether the electricity consumption includes abnormal electricity consumption of a rate type other than the rate type corresponding to the target monitoring period; if If the power consumption includes the abnormal power consumption, the user ID of the user to be monitored corresponding to the abnormal power consumption is determined; the user information corresponding to the user ID is determined from a pre-built user information storage view .

The computer storage medium in the embodiments of the present invention may adopt any combination of one or more computer-readable mediums. The computer-readable medium may be a computer-readable signal medium or a computer-readable storage medium. The computer-readable storage medium can be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus or device, or a combination of any of the above. More specific examples (a non-exhaustive list) of computer readable storage media include: electrical connections having one or more wires, portable computer disks, hard disks, random access memory (RAM), read only memory (ROM), Erasable programmable read only memory (EPROM or flash memory), optical fiber, portable compact disk read only memory (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination of the foregoing. In this document, a computer-readable storage medium can be any tangible medium that contains or stores a program that can be used by or in conjunction with an instruction execution system, apparatus, or device.

A computer-readable signal medium may include a propagated data signal in baseband or as part of a carrier wave, with computer-readable program code embodied thereon. Such propagated data signals may take a variety of forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination of the foregoing. A computer-readable signal medium can also be any computer-readable medium other than a computer-readable storage medium that can transmit, propagate, or transport the program for use by or in connection with the instruction execution system, apparatus, or device .

Program code embodied on a computer readable medium may be transmitted using any suitable 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 the operations of embodiments of the present invention may be written in one or more programming languages, including object-oriented programming languages—such as Java, Smalltalk, C++, and A conventional procedural programming language - such as the "C" language or similar programming language. 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 kind of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computer (eg, using an Internet service provider through Internet connection).

Note that the above are only preferred embodiments of the present invention and applied technical principles. Those skilled in the art will understand that the present invention is not limited to the specific embodiments described herein, and various obvious changes, readjustments and substitutions can be made by those skilled in the art without departing from the protection scope of the present invention. Therefore, although the present invention has been described in detail through the above embodiments, the present invention is not limited to the above embodiments, and can also include more other equivalent embodiments without departing from the concept of the present invention. The scope is determined by the scope of the appended claims.

Claims (10)

1. a method for determining user information of abnormal electricity consumption, characterized in that, comprising: Obtain the electricity consumption of at least one user to be monitored during the target monitoring time period; determining whether the electricity consumption includes abnormal electricity consumption of a rate type other than the rate type corresponding to the target monitoring time period; If the power consumption includes the abnormal power consumption, determining the user identifier of the user to be monitored corresponding to the abnormal power consumption; User information corresponding to the user identification is determined from a pre-built user information storage view. 2 . The method according to claim 1 , wherein the determining whether the electricity consumption includes abnormal electricity consumption of a rate type other than the rate type corresponding to the target monitoring time period, comprising: 2 . : By invoking a predefined database statement for querying electricity consumption, it is determined whether the electricity consumption includes abnormal electricity consumption of a rate type other than the rate type corresponding to the target monitoring time period. 3 . The method according to claim 1 , wherein the determining whether the electricity consumption includes abnormal electricity consumption of a rate type other than the rate type corresponding to the target monitoring time period, comprising: 3 . : If the electricity consumption exceeds a preset electricity consumption threshold, determine whether the electricity consumption exceeding the preset electricity consumption threshold includes abnormal usage of a rate type other than the rate type corresponding to the target monitoring time period power. 4. The method according to claim 1, wherein the method further comprises: Obtain the user information data sheet to be monitored; The user information storage view is constructed based on the to-be-monitored user information data table and a predefined database query statement for querying user information. 5. The method according to claim 4, wherein, before the acquiring the user information data table to be monitored, the method further comprises: Create the table structure of the user information data table to be monitored. 6. The method according to claim 4, wherein the acquiring the user information data table to be monitored comprises: Obtain the user information of the user to be monitored; The user information of the to-be-monitored user is added to the to-be-monitored user information data table by invoking a predefined database adding statement for adding the user information of the to-be-monitored user. 7. The method according to claim 1, wherein after the user information corresponding to the user identification is determined from a pre-built user information storage view, the method further comprises: The user information is marked based on a preset identification style, and the marked user information is displayed. 8. A user information determination device for abnormal electricity consumption, characterized in that, comprising: a power consumption acquisition module, used to acquire the power consumption of at least one user to be monitored during the target monitoring time period; an abnormal power consumption determination module, configured to determine whether the power consumption includes abnormal power consumption of a rate type other than the rate type corresponding to the target monitoring time period; a user identification determination module, configured to determine the user identification of the user to be monitored corresponding to the abnormal power consumption if the power consumption includes the abnormal power consumption; A user information determination module, configured to determine user information corresponding to the user identification from a pre-built user information storage view. 9. An electronic device, characterized in that the electronic device comprises: one or more processors; a storage device for storing one or more programs; When the program is executed by the processor, the processor implements the method for determining user information of abnormal power consumption according to any one of claims 1-7. 10 . A computer-readable storage medium on which a computer program is stored, characterized in that, when the program is executed by a processor, the method for determining user information of abnormal power consumption according to any one of claims 1-7 is implemented.

Images