Method, device and medium for determining information of user with power consumption anomaly

Abstract

Embodiments of the present application disclose a kind of user information determination method, device, equipment and medium for abnormal electricity use.The method comprises: obtaining the electricity consumption of at least one user to be monitored in a target monitoring time period;Determine whether the electricity consumption includes the abnormal electricity consumption of the rate type other than the rate type corresponding to the target monitoring time period;If the electricity consumption includes the abnormal electricity consumption, determine the user identification of the user to be monitored corresponding to the abnormal electricity consumption;Determine the user information corresponding to the user identification from the pre-constructed user information storage view.The technical scheme of the embodiments of the present application solves the technical problems of high difficulty and low efficiency in the existing method of determining the users with abnormal electricity data, and realizes faster and more accurate determination of users with abnormal electricity data, thereby reducing the difficulty of investigation and improving the technical effect of work efficiency.

Description

TECHNICAL FIELD

[0001] Embodiments of the present application relate to the technical field of data processing, and particularly relate to a method and device for determining user information of abnormal electricity consumption, and a medium. BACKGROUND

[0002] At present, the country is committed to implementing the policy of ladder electricity price and time-of-use billing, so as to promote energy saving and environmental protection. However, the policy of ladder electricity price and time-of-use billing will generate a large amount of electricity consumption data. Since the amount of electricity consumption data is large, the work of monitoring and processing the electricity consumption data of users faces great challenges.

[0003] In the prior art, the users whose electricity consumption data are abnormal are usually determined by manual means, and the staff needs to perform data investigation and processing on each piece of electricity consumption data of each user. However, this method not only requires a lot of manpower and material resources, but also has the problems of high investigation difficulty, inability to quickly locate the user with abnormal electricity consumption, and low work efficiency. SUMMARY

[0004] Embodiments of the present application provide a method and device for determining user information of abnormal electricity consumption, and a medium, to more quickly and accurately determine the user whose electricity consumption data are abnormal, thereby achieving the technical effects of reducing the investigation difficulty, more quickly locating the user with abnormal electricity consumption, and improving the work efficiency.

[0005] In a first aspect, embodiments of the present application provide a method for determining user information of abnormal electricity consumption, the method comprising:

[0006] obtaining electricity consumption of at least one to-be-monitored user in a target monitoring time period;

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

[0008] if the electricity consumption includes the abnormal electricity consumption, determining a user identifier of a to-be-monitored user corresponding to the abnormal electricity consumption;

[0009] determining user information corresponding to the user identifier from a pre-constructed user information storage view.

[0010] In a second aspect, embodiments of the present application also provide a device for determining user information of abnormal electricity consumption, the device comprising:

[0011] an electricity consumption obtaining module configured to obtain electricity consumption of at least one to-be-monitored user in a target monitoring time period;

[0012] The abnormal electricity consumption determination module is configured to determine whether the electricity consumption contains abnormal electricity consumption of a rate type other than the rate type corresponding to the target monitoring time period.

[0013] The user identification determination module is configured to determine a user identification of a user to be monitored corresponding to the abnormal electricity consumption if the electricity consumption includes the abnormal electricity consumption.

[0014] The user information determination module is configured to determine user information corresponding to the user identification from a pre-constructed user information storage view.

[0015] In a third aspect, an electronic device is provided, and the electronic device includes:

[0016] one or more processors;

[0017] a storage device configured to store one or more programs;

[0018] When the program is executed by the processor, the processor implements the user information determination method for electricity abnormality as provided in any of the embodiments of the present application.

[0019] In a fourth aspect, a computer readable storage medium is provided, and the computer readable storage medium stores a computer program, and the program is executed by a processor to implement the user information determination method for electricity abnormality as provided in any of the embodiments of the present application.

[0020] The technical solution of the embodiments of the present application acquires the electricity consumption of at least one user to be monitored in a target monitoring time period. Then, it can be determined whether the electricity consumption contains abnormal electricity consumption of a rate type other than the rate type corresponding to the target monitoring time period. If the electricity consumption includes abnormal electricity consumption, the user identification of the user to be monitored corresponding to the abnormal electricity consumption can be determined. Then, the user information corresponding to the user identification can be determined from a pre-constructed user information storage view. The technical solution solves the technical problems that the existing method for determining users whose electricity data are abnormal not only needs to consume more human and material resources, but also has high difficulty in checking abnormal data and low work efficiency. The technical solution realizes more quickly and effectively determining users whose electricity data are abnormal, thereby achieving the technical effects of reducing the difficulty in checking, more quickly positioning the users whose electricity is abnormal, and improving the work efficiency. BRIEF DESCRIPTION OF DRAWINGS

[0021] In order to more clearly illustrate the technical solutions of the exemplary embodiments of the present application, the following briefly introduces the drawings needed in the description of the embodiments. Obviously, the drawings described are only a part of the drawings of the present application, and not all the drawings, and for those skilled in the art, other drawings can be obtained based on these drawings without creative labor.

[0022] Figure 1 is a flowchart of a method for determining user information of abnormal electricity consumption provided by the first embodiment of the present application;

[0023] Figure 2 is a flowchart of a method for determining user information of abnormal electricity consumption provided by the second embodiment of the present application;

[0024] Figure 3 is a structural schematic diagram of a device for determining user information of abnormal electricity consumption provided by the third embodiment of the present application;

[0025] Figure 4 is a structural schematic diagram of an electronic device provided by the fourth embodiment of the present application. DETAILED DESCRIPTION

[0026] The present application will be further described in detail below in combination with the drawings and embodiments. It can be understood that the specific embodiments described herein are only used to explain the present application, and not to limit the present application. In addition, it should be noted that, in order to facilitate the description, only the parts related to the present application are shown in the drawings, and not all the structures.

[0027] Embodiment one

[0028] Figure 1 is a flowchart of a method for determining user information of abnormal electricity consumption provided by the first embodiment of the present application, and the present embodiment can be applicable to determining whether the electricity consumption contains abnormal electricity consumption of a rate type other than the rate type corresponding to the target monitoring time period, and then determining the situation of each user whose electricity data is abnormal. The method can be executed by a device for determining user information of abnormal electricity consumption, and the device for determining user information of abnormal electricity consumption can be realized by software and / or hardware, and can be integrated in an electronic device such as a computer or a server.

[0029] As shown in Figure 1 , the method of the present embodiment includes:

[0030] S110, obtaining the electricity consumption of at least one to-be-monitored user in a target monitoring time period.

[0031] The to-be-monitored user can be understood as a user who needs to be monitored at the current time. The target monitoring time period can be a time period that needs to be monitored at the current time. Alternatively, the target monitoring time period can be any one of a peak time period, a peak time period, a valley time period, and a flat time period divided by time-of-use electricity pricing.

[0032] Specifically, the target monitoring time period is determined. After determining the target monitoring time period, the electricity consumption of one or more to-be-monitored users in the target monitoring time period can be obtained.

[0033] It should be noted that the peak time period, the peak time period, the valley time period, and the flat time period are divided into time periods according to different electricity prices (see Table 1).

[0034] Table 1

[0035]

[0036] Alternatively, the electricity consumption of the to-be-monitored user in the target monitoring time period can be obtained in the following manner:

[0037] The electricity consumption of at least one to-be-monitored user in the target monitoring time period is obtained from a system for storing electricity consumption (such as a power grid metering automation system). It should be noted that there are many ways to obtain the electricity consumption of at least one to-be-monitored user in the target monitoring time period, and the specific obtaining method is not limited here.

[0038] S120, determine whether the electricity consumption contains abnormal electricity consumption of a rate type other than the rate type corresponding to the target monitoring time period.

[0039] The rate type can be understood as the electricity price corresponding to different time periods, i.e., the electricity price corresponding to the peak time period, the peak time period, the valley time period, and the flat time period. The abnormal electricity consumption can be the electricity consumption of the rate type other than the rate type corresponding to the target monitoring time period.

[0040] Specifically, after obtaining the electricity consumption, the rate type corresponding to the target monitoring time period can be determined based on the correspondence between the pre-set time period and the rate type. Further, it can be determined whether the electricity consumption contains electricity consumption of a rate type other than the rate type corresponding to the target monitoring time period, that is, whether there is abnormal electricity consumption in the obtained electricity consumption.

[0041] Alternatively, the electricity consumption can be determined in the following manner whether it contains abnormal electricity consumption of a rate type other than the rate type corresponding to the target monitoring time period:

[0042] If the electricity consumption exceeds the pre-set electricity consumption threshold, it is determined whether the electricity consumption exceeding the pre-set electricity consumption threshold contains abnormal electricity consumption of a rate type other than the rate type corresponding to the target monitoring time period.

[0043] The preset electricity consumption threshold can be set according to actual needs, and specific data is not limited herein, for example, can be 0.01, 0.02 or 0.03, etc.

[0044] Specifically, the electricity consumption threshold is set in advance. After obtaining the electricity consumption, the obtained electricity consumption and the preset electricity consumption threshold are compared. If the electricity consumption exceeds the preset electricity consumption threshold, it can be determined whether the electricity consumption exceeding the preset electricity consumption threshold includes abnormal electricity consumption of a rate type other than the rate type corresponding to the target monitoring time period.

[0045] S130, if the electricity consumption includes abnormal electricity consumption, determining the user identifier of the to-be-monitored user corresponding to the abnormal electricity consumption.

[0046] The user identifier can be used to determine the user information of the to-be-monitored user. The user identifier can include at least one of a user number, a user name, and a user type of the to-be-monitored user.

[0047] Specifically, if the obtained electricity consumption includes abnormal electricity consumption, the to-be-monitored user corresponding to the abnormal electricity consumption can be determined. Further, the user identifier of the to-be-monitored user can be determined.

[0048] S140, determining the user information corresponding to the user identifier from a pre-constructed user information storage view.

[0049] The user information storage view can be a database view for storing user information. The user information can include a user number, a user name, a user type, a contract capacity, a management unit, etc.

[0050] Specifically, the user information storage view is pre-constructed. After determining the user identifier of the to-be-monitored user corresponding to the abnormal electricity consumption, the user information corresponding to the user identifier can be determined from the pre-constructed user information storage view.

[0051] Optionally, the user information storage view is constructed in the following manner:

[0052] Obtaining a to-be-monitored user information data table; based on the to-be-monitored user information data table and a pre-defined database query statement for querying user information, constructing the user information storage view.

[0053] The to-be-monitored user information data table can be understood as a data table for storing to-be-monitored user information. The database query statement can be a pre-defined database statement for querying user information.

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

[0055] For example, the user information data table to be monitored can be the HZ_TOUCUS table, and the predefined database query statement for querying user information can be: CREATE VIEW INFO_TOUCUS AS (SELECT DISTINCT YHBH account number, MC account name, HTRL capacity, JG county / district bureau, SCH transaction account flag FROM HZ_TOUCU); then, the user information storage view can be INFO_TOUCUS.

[0056] Optionally, before obtaining the user information data table to be monitored, the process can also include: creating the 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 creation statement, which allows for a quick and efficient creation of the table structure.

[0057] Specifically, a predefined database creation statement is used to create the user information data table to be monitored. After the database creation statement is executed, the predefined statement can be called to create the user information data table. After executing the database creation statement, the table structure for the user information data table to be monitored is created in the database.

[0058] For example, a predefined database creation statement for creating a table of user information data to be monitored could be:

[0059] The statement `CREATE TABLE HZ_TOUCUS(User ID 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))` creates the table structure for the user information data table (HZ_TOUCUS) to be monitored.

[0060] Optionally, the user information data table to be monitored can be obtained through the following methods:

[0061] Obtain user information of a user to be monitored; add the user information of the user to be monitored to a user information data table of a user to be monitored by calling a pre-defined database addition statement for adding user information of a user to be monitored.

[0062] Specifically, a pre-defined database addition statement for adding user information of a user to be monitored is defined. The user information of the user to be monitored is obtained. After obtaining the user information of the user to be monitored, the user information of the user to be monitored can be added to a user information data table of a user to be monitored by calling the pre-defined database addition statement for adding user information of a user to be monitored.

[0063] It should be noted that there are many ways to obtain the user information of the user to be monitored, and the specific obtaining method is not limited here, for example, the user information of the user to be monitored can be obtained from a system for storing user information, or the user information input by the user to be monitored can be received.

[0064] The technical scheme of the embodiment of the application obtains the power consumption of at least one user to be monitored in a target monitoring time period. Then it can be determined whether the power consumption includes abnormal power 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. Then the user information corresponding to the user identifier can be determined from a pre-constructed user information storage view, solving the technical problems that the existing method for determining users whose power consumption data is abnormal not only needs to consume more human and material resources, but also has high difficulty in abnormal data investigation and low work efficiency, and achieving more rapid, effective and accurate determination of users whose power consumption data is abnormal, thereby achieving the technical effects of reducing the investigation difficulty and improving the work efficiency.

[0065] Embodiment two

[0066] Figure 2 is a flowchart of a user information determination method for power consumption anomaly provided by the second embodiment of the application. On the basis of the foregoing embodiment, the determination of 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: 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 by calling a pre-defined database statement for querying power consumption.

[0067] Optionally, after determining the user information corresponding to the user identifier from the pre-constructed user information storage view, the method further includes: annotating the user information based on a pre-set identifier style, and displaying the annotated user information. Wherein the same or corresponding technical terms as the above embodiments are not described here.

[0068] As shown in the method of the embodiment can specifically include: Figure 2

[0069] S210, obtaining the power consumption of at least one to-be-monitored user in a target monitoring time period.

[0070] S220, 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 by calling a pre-defined database statement for querying power consumption.

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

[0072] S230, if the power consumption includes abnormal power consumption, determining the user identifier of the to-be-monitored user corresponding to the abnormal power consumption.

[0073] S240, determining the user information corresponding to the user identifier from a pre-constructed user information storage view.

[0074] S250, annotating the user information based on a preset identification style, and displaying the annotated user information.

[0075] The preset identification style can be set according to actual needs, and the specific style is not limited herein, for example, the font of the user information can be annotated as a preset color font (such as a red font), or the font of the user information can be annotated as bold, or the font of the user information can be annotated with an underline.

[0076] Specifically, the identification style of the user information is pre-set. After the user information corresponding to the user identifier is obtained, the user information can be annotated based on the pre-set identification style. After the annotation of the user information is completed, the annotated user information can be displayed. It should be noted that in the embodiment, the user information is annotated based on the pre-set identification style, which can more quickly and conveniently determine the users whose power consumption data are abnormal.

[0077] ​The technical scheme of the embodiment of the present application determines whether the power consumption contains abnormal power consumption of a rate type other than the rate type corresponding to the target monitoring time period by calling a database statement predefined for querying power consumption. After determining the user information corresponding to the user identifier from the pre-constructed user information storage view, the user information is labeled based on a preset identifier style, and the labeled user information is displayed, thereby further realizing more rapid, effective and accurate determination of users whose power consumption data exist abnormities, thereby achieving the technical effects of reducing the difficulty of investigation and improving work efficiency.

[0078] Embodiment three

[0079] Figure 3 is a structural schematic diagram of a user information determination device for power consumption abnormity provided by the third embodiment of the present application. The present application provides a user information determination device for power consumption abnormity, which comprises a power consumption acquisition module 310, an abnormal power consumption determination module 320, a user identifier determination module 330 and a user information determination module 340.

[0080] The power consumption acquisition module 310 is configured to acquire power consumption of at least one user to be monitored in a target monitoring time period. The abnormal power consumption determination module 320 is configured to determine whether the power consumption contains abnormal power consumption of a rate type other than the rate type corresponding to the target monitoring time period. The user identifier determination module 330 is configured to determine a user identifier of the user to be monitored corresponding to the abnormal power consumption if the power consumption includes the abnormal power consumption. The user information determination module 340 is configured to determine user information corresponding to the user identifier from a pre-constructed user information storage view.

[0081] The technical scheme of the embodiment of the present application acquires power consumption of at least one user to be monitored in a target monitoring time period through the power consumption acquisition module. Then, whether the power consumption contains abnormal power consumption of a rate type other than the rate type corresponding to the target monitoring time period is determined through the abnormal power consumption determination module. If the power consumption includes the abnormal power consumption, the user identifier of the user to be monitored corresponding to the abnormal power consumption is determined through the user identifier determination module. Then, the user information corresponding to the user identifier is determined from a pre-constructed user information storage view through the user information determination module, thereby solving the technical problems that the existing method for determining users whose power consumption data exist abnormities not only needs to consume more human and material resources, but also has high difficulty in investigating abnormal data and low work efficiency, and realizing more rapid, effective and accurate determination of users whose power consumption data exist abnormities, thereby achieving the technical effects of reducing the difficulty of investigation and improving work efficiency.

[0082] Optionally, the abnormal power consumption determining module 320 is configured to determine whether the power consumption contains 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 power consumption.

[0083] Optionally, the abnormal power consumption determining module 320 is configured to determine whether the power consumption exceeding the preset power consumption threshold contains abnormal power consumption of a rate type other than the rate type corresponding to the target monitoring time period if the power consumption exceeds the preset power consumption threshold.

[0084] Optionally, the apparatus further comprises a user information storage view constructing module configured to acquire a to-be-monitored user information data table and construct the user information storage view based on the to-be-monitored user information data table and a predefined database query statement for querying user information.

[0085] Optionally, before the to-be-monitored user information data table is acquired, the apparatus further comprises a to-be-monitored user information data table creating module configured to create a table structure of the to-be-monitored user information data table by invoking a predefined database table creating statement for creating the to-be-monitored user information data table.

[0086] Optionally, the user information storage view constructing module is configured to acquire user information of a to-be-monitored user and add the user information of the to-be-monitored user into 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.

[0087] Optionally, after the user information corresponding to the user identifier is determined from the pre-constructed user information storage view, the apparatus further comprises a user information marking module configured to mark the user information based on a preset identifier style and display the marked user information.

[0088] The apparatus described above can execute the power consumption abnormality user information determining method provided by any of the embodiments of the present application and has the corresponding function modules and beneficial effects of executing the power consumption abnormality user information determining method.

[0089] It is worth noting that each unit and module included in the power consumption abnormality user information determining apparatus described above is only divided according to functional logic, but is not limited to the above division, as long as the corresponding functions can be implemented; in addition, the specific names of each functional unit are only for easy mutual differentiation, and do not serve to limit the protection scope of the embodiments of the present application.

[0090] Embodiment Four

[0091] Figure 4 is a structural schematic diagram of an electronic device provided by Embodiment Four of the present application.Figure 4 A block diagram is shown of an exemplary electronic device 12 suitable for implementing any embodiment of the present invention. Figure 4 The electronic device 12 shown is merely an example and should not be construed as limiting the functionality or scope of the embodiments of the present invention. Device 12 is typically an electronic device that processes configuration information.

[0092] like Figure 4 As shown, the electronic device 12 is represented in the form of a general-purpose computing device. The components of the electronic device 12 may include, but are not limited to: one or more processors or processing units 16, memory 28, and bus 18 connecting different components (including memory 28 and processing unit 16).

[0093] Bus 18 represents one or more of several bus architectures, including a memory bus or memory controller, a peripheral bus, a graphics acceleration port, a processor, or a local bus using any of the various bus architectures. Examples of these architectures include, but are not limited to, the Industry Standard Architecture (ISA) bus, the Micro Channel Architecture (MCA) bus, the Enhanced ISA bus, the Video Electronics Standards Association (VESA) local bus, and the Peripheral Component Interconnect (PCI) bus.

[0094] 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 volatile and non-volatile media, removable and non-removable media.

[0095] Memory 28 can include computer-readable media in the form of volatile memory, such as random access memory (RAM) 30 and / or cache memory 32. Electronic device 12 can further include other removable / non-removable, volatile / non-volatile computer storage media. By way of example only, storage system 34 can be provided for reading from and writing to a non-removable, non-volatile magnetic media (not shown and typically called a "hard drive"). Although not shown, a magnetic disk drive can also be used for reading from and writing to a removable, non-volatile magnetic disk (e.g., a "floppy disk"), and an optical disk drive can be used for reading from or writing to a removable, non-volatile optical disk (e.g., a CD-ROM, DVD-ROM, etc.). In such instances, each can be connected to bus 18 by one or more data media interfaces. Memory 28 can include at least one program product 40 having a set (e.g., at least one) of program modules 42 configured to carry out the functions of embodiments of the application. Program product 40, can be stored in memory 28 by way of example, and can include an operating system, one or more application programs, other program modules, and program data, each of which or a combination thereof, can include implementation of a networking environment. Program modules 42 generally carry out the functions and / or methodologies of embodiments of the application described herein.

[0096] Electronic device 12 can also communicate with one or more external devices 14 such as a keyboard, a mouse, a camera, etc. and a display, one or more devices that enable a user to interact with electronic device 12, and / or one or more devices that enable electronic device 12 to communicate with one or more other computing devices. Such communication can be facilitated by an input / output (I / O) interface 22. Still yet, electronic device 12 can communicate with one or more networks, such as a local area network (LAN), a wide area network (WAN), and / or the Internet, through a network adapter 20. As depicted, network adapter 20 communicates with the other components of electronic device 12 via bus 18. It should be appreciated that although not shown, other hardware and / or software modules could be used in conjunction with electronic device 12. Such as, but not limited to, microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data archival storage systems, etc.

[0097] The processing unit 16 executes various function applications and data processing by running programs stored in the memory 28, such as the user information determination method for power consumption anomaly provided by the above-mentioned embodiments of the present application, which comprises:

[0098] obtaining power consumption of at least one to-be-monitored user in a target monitoring time period; determining whether the power consumption contains abnormal power 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 a user identity of the to-be-monitored user corresponding to the abnormal power consumption; and determining user information corresponding to the user identity from a pre-constructed user information storage view.

[0099] Of course, those skilled in the art can understand that the processor can also implement the technical solutions of the user information determination method for power consumption anomaly provided by any of the embodiments of the present application.

[0100] Embodiment five

[0101] The embodiment five of the present application also provides a computer readable storage medium, which stores a computer program, characterized in that, when the program is executed by a processor, such as the user information determination method for power consumption anomaly provided by the above-mentioned embodiments of the present application, which comprises:

[0102] obtaining power consumption of at least one to-be-monitored user in a target monitoring time period; determining whether the power consumption contains abnormal power 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 a user identity of the to-be-monitored user corresponding to the abnormal power consumption; and determining user information corresponding to the user identity from a pre-constructed user information storage view.

[0103] The computer storage medium of the embodiments of the present application can adopt any combination of one or more computer readable media. The computer readable medium can be a computer readable signal medium or a computer readable storage medium. The computer readable storage medium may, for example, but is not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, device or apparatus, or any combination thereof. More specific examples (non-exhaustive list) of the computer readable storage medium include 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 above. In this document, the computer readable storage medium can be any tangible medium that contains or stores a program that can be used by or in connection with an instruction execution system, apparatus or device.

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

[0105] The program code contained on the computer readable medium can be transmitted using any suitable medium, including but not limited to wireless, wire line, optical fiber cable, RF, etc., or any suitable combination thereof.

[0106] The computer program code for carrying out operations of the embodiments of the present application can be written in one or more programming languages or combinations of languages including an object oriented programming language such as Java, Smalltalk, C++ or the like and conventional procedural programming languages such as "C" or similar programming languages. The program code can 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 latter scenario, the remote computer can 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 can be made to an external computer (for example, through the Internet using an Internet Service Provider).

[0107] Note that the above merely describes preferred embodiments of the present application and the principles of the technology applied. Those skilled in the art will understand that the present application is not limited to the specific embodiments described herein, and that various obvious changes, modifications and substitutions can be made without departing from the scope of the present application. Therefore, although the present application has been described in detail through the above embodiments, the present application is not limited to the above embodiments, and can include more other equivalent embodiments without departing from the concept of the present application, and the scope of the present application is determined by the scope of the claims.

Claims

1. A method of determining information of a user with an abnormality in power consumption, characterized by, The method comprises the following steps: obtaining the power consumption of at least one to-be-monitored user in a target monitoring time period; determining whether the power consumption contains abnormal power consumption of a rate type other than the rate type corresponding to the target monitoring time period; if the power consumption contains the abnormal power consumption, determining the user identification of the to-be-monitored user corresponding to the abnormal power consumption; determining the user information corresponding to the user identification from a pre-constructed user information storage view; wherein the user information comprises user number, user name, user type, contract capacity, and management unit; the step of determining whether the power consumption contains abnormal power consumption of a rate type other than the rate type corresponding to the target monitoring time period comprises: if the power consumption exceeds a preset power consumption threshold, determining whether the power consumption exceeding the preset power consumption threshold contains abnormal power consumption of a rate type other than the rate type corresponding to the target monitoring time period; the method further comprises: obtaining a to-be-monitored user information data table; constructing the user information storage view based on the to-be-monitored user information data table and a pre-defined database query statement for querying user information; the step of determining whether the power consumption contains abnormal power consumption of a rate type other than the rate type corresponding to the target monitoring time period comprises: determining whether the power consumption contains abnormal power consumption of a rate type other than the rate type corresponding to the target monitoring time period by calling a pre-defined database statement for querying power consumption; the step of obtaining the to-be-monitored user information data table comprises: obtaining user information of the to-be-monitored user; adding the user information of the to-be-monitored user to the to-be-monitored user information data table by calling a pre-defined database addition statement for adding user information of the to-be-monitored user; the step of obtaining the user information of the to-be-monitored user comprises: obtaining the user information of the to-be-monitored user from a system for storing user information.

2. The method of claim 1, wherein, Before the step of obtaining the to-be-monitored user information data table, the method further comprises: creating a table structure of the to-be-monitored user information data table.

3. The method of claim 1, wherein, After the step of determining the user information corresponding to the user identification from the pre-constructed user information storage view, the method further comprises: annotating the user information based on a preset identification style, and displaying the annotated user information.

4. A device for determining user information regarding abnormal electricity consumption, characterized in that, The method comprises the following steps: a power consumption obtaining module, configured to obtain the power consumption of at least one to-be-monitored user in a target monitoring time period; an abnormal power consumption determining module, configured to determine whether the power consumption contains abnormal power consumption of a rate type other than the rate type corresponding to the target monitoring time period; a user identification determining module, configured to, if the power consumption contains the abnormal power consumption, determine the user identification of the to-be-monitored user corresponding to the abnormal power consumption; a user information determining module, configured to determine the user information corresponding to the user identification from a pre-constructed user information storage view; wherein the user information comprises user number, user name, user type, contract capacity, and management unit; The abnormal power consumption determining module is configured to determine whether the power consumption exceeding the preset power consumption threshold comprises abnormal power consumption of a rate type other than the rate type corresponding to the target monitoring time period, if the power consumption exceeds the preset power consumption threshold. The abnormal power consumption determining module is specifically configured to determine whether the power consumption comprises 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 power consumption. The device further comprises: A user information storage view constructing module configured to acquire a user information data table to be monitored, and construct the 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 storage view constructing module is specifically configured to acquire user information of a user to be monitored, and add the user information of the user to be monitored to a user information data table to be monitored by invoking a predefined database addition statement for adding user information of a user to be monitored.

5. An electronic device, comprising: The electronic device comprises: One or more processors; A storage device configured to store one or more programs; When the program is executed by the processor, the processor implements the user information determination method for power consumption anomaly as claimed in any one of claims 1-3.

6. A computer-readable storage medium having stored thereon a computer program, characterized in that, The program is executed by the processor to implement the user information determination method for power consumption anomaly as claimed in any one of claims 1-3.

Images