Power grid data management method, device, equipment and medium

Abstract

The embodiment of the present invention discloses a method, device, equipment and medium for managing power grid data. The method includes: obtaining at least two target power grid data from a power grid database; establishing different category data tables corresponding to each regional identifier based on the category and regional identifier of the target power grid data; analyzing and processing each category data table, and storing the obtained processing results; responding to a query request sent by a first user, and returning the query results obtained based on the query request to the first user. The embodiment of the present invention realizes the automated management of power grid data, avoids manual participation in management, and improves the management quality and efficiency of power grid data.

Description

Technical Field

[0001] Embodiments of the present invention relate to the technical field of data management, and in particular to a method, device, equipment and medium for managing power grid data. Background Art

[0002] As the scale of power grid continues to expand, more and more power grid data is stored in the power grid database. In order to ensure the safety and stability of power grid operation, power grid data needs to be managed.

[0003] At present, the management of power grid data is mostly achieved through a large number of manual operations on the power grid data, which makes the management efficiency of the power grid data low and the management quality low. Summary of the invention

[0004] The embodiments of the present invention provide a method, device, equipment and medium for managing power grid data, which realize automatic management of power grid data, avoid manual management, and improve the management quality and efficiency of power grid data.

[0005] In a first aspect, an embodiment of the present invention provides a method for managing power grid data, including:

[0006] Acquire at least two target power grid data from a power grid database;

[0007] Based on the category and regional identification of the target power grid data, establishing a data table of different categories corresponding to each regional identification;

[0008] Analyze and process each category data table, and store the processing results;

[0009] In response to the query request sent by the first user, the query result obtained based on the query request is returned to the first user.

[0010] In a second aspect, an embodiment of the present invention further provides a power grid data management device, including:

[0011] A data acquisition module, used for acquiring at least two target power grid data from a power grid database;

[0012] A data table establishment module, used to establish different category data tables corresponding to each regional identifier based on the category and regional identifier of the target power grid data;

[0013] A processing module is used to analyze and process each category data table and store the obtained processing results;

[0014] The request response module is used to respond to the query request sent by the first user and return the query result obtained based on the query request to the first user.

[0015] In a third aspect, an embodiment of the present invention further provides an electronic device, including:

[0016] one or more processors;

[0017] a storage device for storing one or more programs,

[0018] When the one or more programs are executed by the one or more processors, the one or more processors implement the power grid data management method as described in any one of the embodiments of the present invention.

[0019] In a fourth aspect, an embodiment of the present invention further provides a computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, implements a method for managing power grid data as described in any one of the embodiments of the present invention.

[0020] The technical solution disclosed in the embodiment of the present invention has the following beneficial effects:

[0021] By acquiring target power grid data from a power grid database, and establishing different category data tables corresponding to each regional identifier based on the category and regional identifier of the target power grid data, analyzing and processing each category data table established, and storing the obtained processing results, and then responding to the query request sent by the first user, returning the query results obtained based on the query request to the user. The embodiment of the present invention establishes data tables corresponding to different regions based on the category and region of power grid data in the power grid database, and analyzes and processes the established data tables, thereby realizing automated management of power grid data, avoiding manual participation in management, and improving the management quality and efficiency of power grid data. BRIEF DESCRIPTION OF THE DRAWINGS

[0022] Figure 1 It is a flowchart of a method for managing power grid data provided by Embodiment 1 of the present invention;

[0023] Figure 2 It is a schematic diagram of establishing communication with a power grid database through a pre-agreed communication interface provided by the first embodiment of the present invention;

[0024] Figure 3 It is a flowchart of a method for managing power grid data provided by Embodiment 2 of the present invention;

[0025] Figure 4 It is a flowchart of a method for managing power grid data provided by Embodiment 3 of the present invention;

[0026] Figure 5 It is a structural diagram of a power grid data management device provided by a fourth embodiment of the present invention;

[0027] Figure 6 It is a structural schematic diagram of an electronic device provided in Embodiment 5 of the present invention. DETAILED DESCRIPTION

[0028] The embodiments of the present invention are further described in detail below in conjunction with the accompanying drawings and embodiments. It is to be understood that the specific embodiments described herein are only used to explain the embodiments of the present invention, rather than to limit the embodiments of the present invention. It is also necessary to explain that, for ease of description, only parts related to the embodiments of the present invention are shown in the accompanying drawings, rather than all structures.

[0029] A method, apparatus, device and storage medium for managing power grid data provided by an embodiment of the present invention will be described below with reference to the accompanying drawings.

[0030] Embodiment 1

[0031] Figure 1 This is a flow chart of a method for managing power grid data provided by Embodiment 1 of the present invention. This embodiment is applicable to a scenario in which power grid data in a power grid database is automatically managed. The method can be executed by a power grid data management device, which can be composed of hardware and / or software and can be integrated into an electronic device. The method specifically includes the following:

[0032] S101, obtaining at least two target power grid data from a power grid database.

[0033] Since the power grid database stores various types of power grid data according to different power grid businesses, such as equipment operation data, power supply quality data, and user evaluation data, etc., when managing the power grid data in the power grid database, different target power grid data can be obtained from the power grid database according to management requirements.

[0034] Specifically, a communication connection can be established with the power grid database through a pre-agreed communication interface, and at least two target power grid data can be obtained from the power grid database based on the communication connection. The pre-agreed communication interface can be an application programming interface (Application Programming Interface, referred to as API) or a database driver interface, etc., which is not specifically limited here. For example, the electronic device of this embodiment establishes a communication connection with the power grid database through a pre-agreed communication interface, as shown in FIG. Figure 2 shown.

[0035] In this embodiment, when acquiring at least two target power grid data from the power grid database based on the established communication connection, it can be implemented in different ways, for example, it can be implemented in the following ways:

[0036] Method 1

[0037] At least two target power grid data are acquired from the power grid database in a quasi-real-time acquisition manner.

[0038] Method 2

[0039] At least two target power grid data are acquired from the power grid database in a non-real-time acquisition manner.

[0040] The non-real-time acquisition method is preferably a T+1 acquisition method, that is, when the currently newly stored power grid data is acquired from the power grid database, it can only be acquired tomorrow, that is, delayed acquisition.

[0041] It should be noted that the above two target power grid data acquisition methods are only used as exemplary descriptions of the embodiments of the present invention and are not intended to be specific limitations of the embodiments of the present invention.

[0042] S102: Based on the category and region identifier of the target power grid data, a data table of different categories corresponding to each region identifier is established.

[0043] Among them, the categories of at least two target power grid data obtained from the power grid database may include at least one of the following: power grid overview, power grid cost information, power grid second user information, power grid evaluation information, power grid appeal processing information, power grid complaint resolution information, power grid electricity inspection information, power grid metering and operation and maintenance information, and power grid power supply information. In this embodiment, the power grid second user refers to the power user within the power grid, that is, the user.

[0044] It should be noted that the power grid specifically refers to grid management. Grid management means that the State Power Supply Administration divides different power supply areas into grids of different specifications, and then assigns each grid to the same or different power supply units, or to the same or different persons in charge, so as to achieve the purpose of managing power supply problems of different grids through power supply units and / or persons in charge.

[0045] The regional identification refers to the information that can uniquely identify the region to which the power grid data belongs, such as the region name or region number.

[0046] Optionally, after acquiring the target power grid data, this embodiment can filter all the target power grid data belonging to the same region from the acquired at least two target power grid data according to the regional identifier to obtain the power grid data set of each region. Then, based on the category of each target power grid data in the power grid data set of each region, a data table of different categories corresponding to each regional identifier is established to lay the foundation for the subsequent analysis of various indicators of each region.

[0047] For example, if the regional identification of the target power grid data includes: Chaozhou City, Foshan City and Dongguan City, then all target power grid data belonging to Chaozhou City, all target power grid data belonging to Foshan City and all target power grid data belonging to Dongguan City can be obtained from at least two acquired target power grid data, respectively, to obtain the Chaozhou City power grid data set, the Foshan City power grid data set and the Dongguan City power grid data set.

[0048] In this embodiment, based on the categories of each target power grid data in the power grid data set of each region, different categories of data corresponding to each region identifier are established, including at least one of the following:

[0049] If the category of the target power grid data is the power grid fee information, and the region identifier of the target power grid data is the first identifier and / or the second identifier, then a power grid fee information data table of the first identifier and / or the second identifier is established;

[0050] If the category of the target power grid data is the power grid second user information, and the region identifier of the target power grid data is the first identifier and / or the second identifier, then establishing a power grid second user information data table of the first identifier and / or the second identifier;

[0051] If the category of the target power grid data is the power grid evaluation information, and the region identifier of the target power grid data is the first identifier and / or the second identifier, then establishing a power grid evaluation information data table of the first identifier and / or the second identifier;

[0052] If the category of the target power grid data is the power grid demand processing information, and the region identifier of the target power grid data is the first identifier and / or the second identifier, then a power grid demand processing information data table of the first identifier and / or the second identifier is established;

[0053] If the category of the target power grid data is the power grid complaint resolution information, and the region identifier of the target power grid data is the first identifier and / or the second identifier, then a power grid complaint resolution information data table of the first identifier and / or the second identifier is established;

[0054] If the category of the target power grid data is the power grid electricity consumption inspection information, and the region identifier of the target power grid data is the first identifier and / or the second identifier, then a power grid electricity consumption inspection information data table of the first identifier and / or the second identifier is established;

[0055] If the category of the target power grid data is the power grid metering operation and maintenance information, and the region identifier of the target power grid data is the first identifier and / or the second identifier, then a power grid metering operation and maintenance information data table of the first identifier and / or the second identifier is established;

[0056] If the category of the target power grid data is the power grid power supply information, and the region identifier of the target power grid data is the first identifier and / or the second identifier, a power grid power supply information data table of the first identifier and / or the second identifier is established.

[0057] The first identifier and the second identifier represent the regional identity information to which the target power grid data belongs, such as the region name or region number, etc. For example, the first identifier may be Chaozhou City, and the second identifier may be Dongguan City, etc.

[0058] S103, analyzing and processing each category data table, and storing the obtained processing results.

[0059] Optionally, this embodiment can analyze and process each established category data table according to a preset analysis and processing method to obtain a processing result, and then store the processing result of each category data table to provide conditions for subsequent user data query.

[0060] It should be noted that the specific implementation process of analyzing and processing each category data table and storing the processing results will be described in detail in the following embodiments, and will not be described in detail here.

[0061] S104, responding to the query request sent by the first user, and returning the query result obtained based on the query request to the first user.

[0062] Among them, the first user can be selected as the manager of the power supply headquarters, that is, the leadership user.

[0063] Optionally, after analyzing and processing different power grid data in the power grid database and obtaining the processing results, the manager can query different processing results as needed, and adjust and control the power supply situation of the power grid based on the query results, thereby providing conditions for improving the quality and efficiency of power supply services, and improving users' electricity satisfaction and electricity experience.

[0064] The technical solution provided by the embodiment of the present invention obtains the target power grid data from the power grid database, and establishes different category data tables corresponding to each regional identifier based on the category and regional identifier of the target power grid data, analyzes and processes each established category data table, stores the obtained processing results, and then responds to the query request sent by the first user, and returns the query results obtained based on the query request to the user. The embodiment of the present invention establishes data tables corresponding to different regions based on the power grid data category and the region to which it belongs in the power grid database, analyzes and processes the established data tables, realizes the automated management of power grid data, avoids manual participation in management, and improves the management quality and efficiency of power grid data.

[0065] Embodiment 2

[0066] Figure 3 1 is a flow chart of a method for managing power grid data provided by Embodiment 2 of the present invention. Further optimization and expansion are performed on the basis of the above embodiment. Figure 3 As shown, the method specifically includes:

[0067] S201, obtaining at least two target power grid data from a power grid database.

[0068] S202: Based on the category and region identifier of the target power grid data, a data table of different categories corresponding to each region identifier is established.

[0069] S203, performing analysis and processing of different dimensions on each category data table, and establishing a mapping relationship between the region identifier, the category data table and the processing result.

[0070] Optionally, the analysis and processing of different dimensions is performed on each category data table, and the analysis and processing of different dimensions can be performed according to the data table category and preset rules. For example, the analysis and processing of different dimensions on each category data table in this embodiment may include at least one of the following:

[0071] If the data table is a grid fee information data table, the data table is analyzed and processed for the electricity fee recovery rate and non-cash payment rate of the power supply unit and / or the person in charge;

[0072] If the data table is a power grid second user information data table, the data table is efficiently analyzed and processed for the second user contact information of the power supply unit and / or the person in charge;

[0073] If the data table is a power grid evaluation information data table, the data table is analyzed and processed with respect to the number of complaints and complaints of the power supply unit and / or the person in charge;

[0074] If the data table is a grid demand processing information data table, the data table is analyzed and processed for the timely rate of demand work orders of the power supply unit and / or the person in charge, the timely rate of low-voltage business expansion registration, and the timely notification rate of power outage plans;

[0075] If the data table is a grid complaint resolution information data table, the data table is analyzed and processed for the first-time resolution rate of complaints of the power supply unit and / or the person in charge;

[0076] If the data table is a grid electricity inspection information data table, the data table is analyzed for the periodic inspection completion rate, special inspection completion rate and electricity safety hazard rectification rate of the power supply unit and / or the person in charge;

[0077] If the data table is a power grid metering operation and maintenance information data table, the metering fault error rate of the power supply unit and / or the person in charge is analyzed and processed for the data table;

[0078] If the data table is a power grid power supply information data table, the data table is analyzed and processed with respect to the user failure mean time and the D-class voltage qualification rate of the power supply unit and / or the person in charge.

[0079] It should be noted that, in addition to the above dimensions, the analysis and processing methods for each category data table in different dimensions may also include other dimensions, which are not specifically limited here.

[0080] In this embodiment, the implementation process of performing the analysis and processing of different dimensions on each category data table can be specifically as follows:

[0081] S1) Grid fee information data table

[0082] a1. The electricity fee recovery rate of the power supply unit;

[0083] Specifically, the electricity fee recovery rate of the power supply unit is calculated according to the following formula:

[0084]

[0085] Among them, the electricity fee recovery rate i Represents the electricity fee recovery rate of the i-th power supply unit and the actual electricity fee received i Represents the actual electricity fee received by the i-th power supply unit, and the electricity fee receivable in this period i Represents the electricity fee that the i-th power supply unit should collect in this period. This period can be flexibly set according to the power supply needs, such as one month or half a year. i is a positive integer greater than or equal to 1.

[0086] b1. The electricity fee recovery rate of the responsible person;

[0087] Specifically, the electricity fee recovery rate of the responsible person is calculated according to the following formula:

[0088]

[0089] Among them, the electricity fee recovery rate j Represents the electricity fee recovery rate of the jth person in charge, the actual electricity fee received j Represents the electricity fee actually received by the jth person in charge, and the electricity fee receivable in this period j Represents the electricity fee that the jth person in charge should collect in this period. This period can be flexibly set according to the power supply needs, such as one month or half a year. j is a positive integer greater than or equal to 1.

[0090] c1. Count the users in arrears of payment of the power supply unit;

[0091] d1. Count the users who owe fees and are responsible for the statistics;

[0092] e1. Non-cash payment rate of the power supply unit;

[0093] Specifically, the non-cash payment rate of the power supply unit is calculated according to the following formula:

[0094]

[0095] Among them, the non-cash payment rate i represents the non-cash payment rate of the i-th power supply unit and the number of users who pay in non-cash manner i Represents the number of users who pay their bills in non-cash form at the i-th power supply unit, the total number of paying users i Represents the total number of paying users of the i-th power supply unit, where i is a positive integer greater than or equal to 1.

[0096] f1. Non-cash payment rate of the responsible person;

[0097] Specifically, the non-cash payment rate of the responsible person is calculated according to the following formula:

[0098]

[0099] Among them, the non-cash payment rate j The non-cash payment rate of the jth person in charge and the number of users who pay by non-cash method j The number of users who pay by non-cash method on behalf of the jth person in charge, the total number of paying users j Represents the total number of users who are responsible for paying fees. j is a positive integer greater than or equal to 1.

[0100] g1. Cash payment details of the power supply unit;

[0101] h1. Cash payment details of the responsible person.

[0102] S2) Power grid second user information data table

[0103] a2. The contact information of the second user of the power supply unit is effective;

[0104] Specifically, the efficiency of the second user contact information of the power supply unit is calculated according to the following formula:

[0105] Second user contact information is effective i =Completeness rate of user contact information i ×Accuracy of user contact information i

[0106] Among them, the second user contact information is effective iRepresents the efficiency of the second user contact information of the i-th power supply unit and the completeness rate of user contact information i Represents the completeness rate of user contact information of the i-th power supply unit and the accuracy rate of user contact information i Represents the accuracy of the user contact information of the i-th power supply unit, where i is a positive integer greater than or equal to 1.

[0107] b2. The contact information of the second user of the person in charge is effective;

[0108] Specifically, the efficiency of the second user contact information of the person in charge is calculated according to the following formula:

[0109] Second user contact information is effective j =Completeness rate of user contact information j ×Accuracy of user contact information j

[0110] Among them, the second user contact information is effective j Represents the efficiency of the second user contact information of the jth person in charge, and the completeness rate of user contact information j Represents the completeness rate of user contact information of the jth person in charge and the accuracy rate of user contact information j Represents the accuracy rate of the user contact information of the j-th person in charge, where j is a positive integer greater than or equal to 1.

[0111] c2. Count users with abnormal contact information of their power supply units;

[0112] d2. Count the users with abnormal contact information of the responsible persons.

[0113] S3) Power grid evaluation information data table

[0114] a3. Statistics on the number of complaints from second users of the power supply unit;

[0115] Specifically, the number of second user complaints of the power supply unit is counted according to the following formula:

[0116] Second user complaint number i =95598 (including 12398) Total number of complaints by the second user

[0117] Among them, the number of user complaints i Represents the number of complaints from the second users of the i-th power supply unit, where i is a positive integer greater than or equal to 1.

[0118] b3. Statistics on the number of complaints from the second users of the responsible person;

[0119] Specifically, the number of second user complaints of the power supply unit is counted according to the following formula:

[0120] Second user complaint number j =95598 (including 12398) Total number of complaints by the second user

[0121] Among them, the number of user complaints j Represents the number of second user complaints of the j-th person in charge, where j is a positive integer greater than or equal to 1.

[0122] c3. Details of complaints from the second user of the power supply unit;

[0123] d3. Details of the second user's complaint to the responsible person;

[0124] e3. Statistics on the number of complaints from the second users of the power supply unit;

[0125] Specifically, the number of second user complaints of the power supply unit is counted according to the following formula:

[0126] Second user complaint number i =95598 (including 12398) the total number of valid opinions and suggestions from the second user

[0127] Among them, the number of second user complaints i Represents the number of complaints from the second users of the i-th power supply unit, where i is a positive integer greater than or equal to 1.

[0128] f3. Statistics on the number of complaints from the second users to whom the responsible person belongs;

[0129] Specifically, the number of second user complaints of the responsible person is counted according to the following formula:

[0130] Second user complaint number j =95598 (including 12398) the total number of valid opinions and suggestions from the second user

[0131] Among them, the number of second user complaints j The number of complaints from the second user representing the j-th person in charge, where j is a positive integer greater than or equal to 1.

[0132] S4) Power grid demand processing information data table

[0133] a4. Timeliness rate of work orders from affiliated power supply units;

[0134] Specifically, the timeliness rate of the request work order of the power supply unit is calculated according to the following formula:

[0135]

[0136] Among them, the timely rate of the request work order i represents the timely rate of the request work order of the i-th power supply unit, and the number of second user request work orders completed within the specified time limit iRepresents the number of work orders for the second user's request completed by the i-th power supply unit within the specified time limit, and the number of work orders delivered by 95598 i Represents the number of work orders transmitted by the i-th power supply unit 95598, where i is a positive integer greater than or equal to 1.

[0137] b4. Timeliness rate of request work orders of the responsible person;

[0138] Specifically, the timely rate of the request work order of the person in charge is calculated according to the following formula:

[0139]

[0140] Among them, the timely rate of the request work order j represents the timely rate of the request work order of the jth person in charge, and the number of second user request work orders completed within the specified time limit j The number of work orders for the second user's request completed by the j-th person in charge within the specified time limit, and the number of work orders delivered by 95598 j Represents the number of work orders delivered by the j-th person in charge 95598, where j is a positive integer greater than or equal to 1.

[0141] c4. Count the overtime request work orders of the power supply units;

[0142] d4. Collect the overtime request work orders of the responsible person;

[0143] e4. Timely rate of low-voltage business expansion reporting and installation by the power supply unit;

[0144] Specifically, the timely rate of low-voltage business expansion reporting of the power supply unit is calculated according to the following formula:

[0145] Timely rate of low voltage business expansion application i =Timeout for low-voltage business expansion registration (new additions and capacity increases): There are no work orders with planned completion time for low-voltage residents that take more than 3 working days, and for non-residents that take more than 7 working days.

[0146] Among them, the timely rate of low-voltage business expansion and installation i Represents the timely rate of low-voltage business expansion reporting of the i-th power supply unit, where i is a positive integer greater than or equal to 1.

[0147] f4. Timely rate of low voltage business expansion reporting by the responsible person;

[0148] Specifically, the timely rate of low-voltage business expansion reporting of the responsible person is calculated according to the following formula:

[0149] Timely rate of low voltage business expansion application j =Timeout for low-voltage business expansion registration (new additions and capacity increases): There are no work orders with planned completion time for low-voltage residents that take more than 3 working days, and for non-residents that take more than 7 working days.

[0150] Among them, the timely rate of low-voltage business expansion and installation j Represents the timely rate of low-voltage business expansion reporting of the j-th person in charge, where j is a positive integer greater than or equal to 1.

[0151] g4. Statistics on overtime of low voltage business expansion orders of affiliated power supply units;

[0152] h4. Statistics on overtime of low voltage business expansion work orders of the responsible persons;

[0153] i4. Timely notification rate of power outage plans of affiliated power supply units;

[0154] Specifically, the timely notification rate of power outage plans of the power supply units is calculated according to the following formula:

[0155]

[0156] Wherein, i represents the i-th power supply unit, and i is a positive integer greater than or equal to 1.

[0157] j4. Timely notification rate of power outage plan by the responsible person;

[0158] Specifically, the timely notification rate of the power outage plan of the responsible person is calculated according to the following formula:

[0159]

[0160] Among them, j represents the jth person in charge, and j is a positive integer greater than or equal to 1.

[0161] k4. Count the number of second users that the power supply unit failed to notify on time;

[0162] l4. The number of second users who were not notified on time by the person in charge of statistics.

[0163] S5) Grid Complaint Resolution Information Data Table

[0164] a5. One-time resolution rate of complaints from second users of the power supply unit;

[0165] Specifically, the one-time resolution rate of the second user complaint of the power supply unit is calculated according to the following formula:

[0166]

[0167] Wherein, i represents the i-th power supply unit, and i is a positive integer greater than or equal to 1.

[0168] b5. The rate of one-time resolution of the second user complaints to which the responsible person belongs;

[0169] Specifically, the one-time resolution rate of the second user complaint of the person in charge is calculated according to the following formula:

[0170]

[0171] Among them, j represents the j-th person in charge, and j is a positive integer greater than or equal to 1.

[0172] c5. To collect statistics on the number of complaints from the second users of the power supply unit that have not been resolved once;

[0173] d5. Collect statistics on the number of second user complaints that have not been resolved by the responsible person.

[0174] S6) Grid power consumption inspection information data table

[0175] a6. Completion rate of periodic inspections of affiliated power supply units;

[0176] Specifically, the periodic inspection completion rate of the power supply unit is calculated according to the following formula:

[0177]

[0178] Wherein, i represents the i-th power supply unit, and i is a positive integer greater than or equal to 1.

[0179] b6. Completion rate of periodic inspections by the responsible persons;

[0180] Specifically, the cycle inspection completion rate of the responsible person is calculated according to the following formula:

[0181]

[0182] Among them, j represents the j-th person in charge, and j is a positive integer greater than or equal to 1.

[0183] c6. Count the unfinished periodic inspection second users of the power supply unit;

[0184] d6. Count the unfinished cycle inspection second user status of the responsible person;

[0185] e6. Completion rate of special inspections of affiliated power supply units;

[0186] Specifically, the special inspection completion rate of the power supply unit is calculated according to the following formula:

[0187]

[0188] Wherein, i represents the i-th power supply unit, and i is a positive integer greater than or equal to 1.

[0189] f6. Completion rate of special inspections by the responsible persons;

[0190] Specifically, the cycle inspection completion rate of the responsible person is calculated according to the following formula:

[0191]

[0192] Among them, j represents the j-th person in charge, and j is a positive integer greater than or equal to 1.

[0193] g6. Count the second users of the power supply unit that have not completed special inspections;

[0194] h6. The second user status of the unfinished special inspection of the person in charge of the statistics;

[0195] i6. The rectification rate of power safety hazards of the affiliated power supply units;

[0196] Specifically, the rectification rate of power safety hazards of the power supply unit is calculated according to the following formula:

[0197]

[0198] Wherein, i represents the i-th power supply unit, and i is a positive integer greater than or equal to 1.

[0199] j6. The rectification rate of power safety hazards of the responsible persons;

[0200] Specifically, the rectification rate of the power safety hazards of the responsible person is calculated according to the following formula:

[0201]

[0202] Among them, j represents the jth person in charge, and j is a positive integer greater than or equal to 1.

[0203] k6. Collect information on rectification of safety hazards that have not been completed by affiliated power supply units;

[0204] l6. Collect information on safety hazard rectification that has not been completed by the responsible person.

[0205] S7) Power grid metering operation and maintenance information data table

[0206] a7. The metering fault error rate of the power supply unit;

[0207] Specifically, the metering fault error rate of the power supply unit is calculated according to the following formula:

[0208]

[0209] Wherein, i represents the i-th power supply unit, and i is a positive integer greater than or equal to 1.

[0210] b7. Measurement failure error rate of the responsible person;

[0211] Specifically, the metering failure error rate of the responsible person is calculated according to the following formula:

[0212]

[0213] Among them, j represents the jth person in charge, and j is a positive integer greater than or equal to 1.

[0214] c7. Collect statistics on metering fault error information of the power supply units;

[0215] d7. Collect the metering failure error information of the responsible person.

[0216] S8) Grid power supply information data table

[0217] a8. The average time between failures of the second user of the power supply unit;

[0218] Specifically, the average time of the second user failure of the power supply unit is calculated according to the following formula:

[0219]

[0220] Wherein, i represents the i-th power supply unit, and i is a positive integer greater than or equal to 1.

[0221] In this embodiment, the second user failure mean time may be the average power outage hours of the power supply system users in the statistical device, recorded as: SAIDI-1 (h / user).

[0222] b8. The average time between failures of the second user of the person in charge;

[0223] Specifically, the average time of the second user failure of the responsible person is calculated according to the following formula:

[0224]

[0225] Among them, j represents the jth person in charge, and j is a positive integer greater than or equal to 1.

[0226] c8. Count the number of second users of power outages in the power supply unit;

[0227] d8. Count the number of second users of power outages under the responsible person;

[0228] e8. Class D voltage qualification rate of the power supply unit;

[0229] Specifically, the Class D voltage qualification rate of the power supply unit is calculated according to the following formula:

[0230]

[0231] Wherein, i represents the i-th power supply unit, and i is a positive integer greater than or equal to 1.

[0232] f8. Class D voltage qualification rate of the responsible person;

[0233] Specifically, the Class D voltage qualification rate of the responsible person is calculated according to the following formula:

[0234]

[0235] Among them, j represents the jth person in charge, and j is a positive integer greater than or equal to 1.

[0236] g8. Collect statistics on the unqualified Class D voltage of the power supply units;

[0237] h8. Collect statistics on Class D voltage failures of responsible persons.

[0238] Then, according to the results of the analysis and processing, a mapping relationship between the region identifier, the category data table and the processing result is established. For example, if the region identifier is Chaozhou City, the category data table includes: the power grid fee information data table, the power grid second user information data table and the power grid evaluation information data table, and the processing result includes: the processing result of the power grid fee information data table, the processing result of the power grid second user information data table and the processing result of the power grid evaluation information data table, then a mapping relationship is established between Chaozhou City, the category data table and the processing results of each category data table, as shown in Table 1 below:

[0239] Table 1

[0240]

[0241] S204, storing the established mapping relationship between the region identification, the category data table and the processing result.

[0242] Optionally, this embodiment may store the established mapping relationship between the region identification, the category data table and the processing result in an analysis database, so that subsequent management users can query the power grid data usage in different regions from the database.

[0243] S205: respond to the query request sent by the first user, and return the query result obtained based on the query request to the first user.

[0244] The technical solution provided by the embodiment of the present invention obtains the target power grid data from the power grid database, and establishes different category data tables corresponding to each regional identifier based on the category and regional identifier of the target power grid data, analyzes and processes each established category data table, stores the obtained processing results, and then responds to the query request sent by the first user, and returns the query results obtained based on the query request to the user. The embodiment of the present invention establishes data tables corresponding to different regions based on the power grid data category and the region to which it belongs in the power grid database, analyzes and processes the established data tables, realizes the automated management of power grid data, avoids manual participation in management, and improves the management quality and efficiency of power grid data.

[0245] Embodiment 3

[0246] Figure 4 1 is a flow chart of a method for managing power grid data provided by Embodiment 3 of the present invention. It is further optimized based on the above embodiment. Figure 4 As shown, the method specifically includes:

[0247] S301, obtaining at least two target power grid data from a power grid database.

[0248] S302: Based on the category and region identifier of the target power grid data, a data table of different categories corresponding to each region identifier is established.

[0249] S303, analyzing and processing each category data table, and storing the obtained processing results.

[0250] S304: In response to the query request sent by the first user, the query result obtained based on the query request is displayed to the first user in a preset display manner.

[0251] Among them, the preset display method includes at least one of the following: a table, a bar chart, a pie chart, a line chart and a bar chart.

[0252] Specifically, when a query request sent by a first user is received, the query request can be parsed to obtain query parameters carried in the query request, and then the corresponding query results can be queried in a database storing processing results based on the query parameters, and the query results can be displayed to the first user in a preset display method to facilitate viewing of the queried query results.

[0253] In this embodiment, displaying the query result obtained based on the query request to the first user in a preset display manner may include but is not limited to at least one of the following situations:

[0254] Displaying the query results to the first user in a tabular format;

[0255] Displaying the query results to the first user in the form of a bar chart;

[0256] Displaying the query results to the first user in the form of a bar chart;

[0257] Displaying the query result to the first user in a form combining a table and a bar chart;

[0258] Displaying the query results to the first user in a form combining a table and a pie chart;

[0259] Displaying the query result to the first user in a form combining a table and a line graph;

[0260] Displaying the query results to the first user in a form combining a table, a line graph, and a pie chart;

[0261] The query results are displayed to the first user in the form of a combination of a table, a line graph and a bar graph.

[0262] It should be noted that, in addition to displaying the query results obtained based on the query request to the first user in a preset display mode in this embodiment, the first user can also personalize the display mode according to actual needs, so that the electronic device can display the query results in the display form that the first user is interested in. In specific implementation, the electronic device provides a free dashboard tool in the display interface, so that the first user can set the display form of interest on the free dashboard tool in advance before performing a query operation, so that the electronic device directly performs the display operation according to the display form set by the first user when displaying the query results; or, the first user can also set the display form of interest on the free dashboard tool after performing a query operation, so that after the electronic device displays the query results in the preset display mode, the first user manually sets a personalized display mode to adjust the display form of the electronic device, etc. Thus, by providing the free dashboard tool, the first user can personalize the display of the query results to meet the needs of the user.

[0263] In one embodiment of the present invention, the query request sent by the first user may carry multiple query parameters, so that the electronic device can obtain multiple query results according to the multiple query parameters. In order to better display the query results, this embodiment can sort the multiple query results according to the total score of each query result, and return the sorted results to the first user, that is, the sorted results can be displayed to the first user in a preset display method or a custom display method, so that the first user can more intuitively view the query results based on the sorted results.

[0264] The total score of each query result can be determined by the following steps: specifically, when analyzing and processing each type of data table, the score of each processing result is calculated respectively, and then the score of each processing result is multiplied by the preset weight to obtain the total score of each processing result. In this embodiment, the preset weight can be adaptively set according to the percentage of each type of data table, and it is not specifically limited here.

[0265] That is, in this embodiment, returning the query result obtained based on the query request to the first user includes: if multiple query results are obtained based on the query request, sorting the multiple query results, and returning the sorted result to the user.

[0266] The technical solution provided by the embodiment of the present invention obtains the target power grid data from the power grid database, and establishes different category data tables corresponding to each regional identifier based on the category and regional identifier of the target power grid data, analyzes and processes each established category data table, stores the obtained processing results, and then responds to the query request sent by the first user, and returns the query results obtained based on the query request to the user. The embodiment of the present invention establishes data tables corresponding to different regions based on the power grid data category and the region to which it belongs in the power grid database, analyzes and processes the established data tables, thereby realizing automated management of power grid data, avoiding manual participation in management, and improving the management quality and efficiency of power grid data. In addition, the embodiment of the present invention provides a free dashboard tool to enable users to personalize the display of query results to meet user needs.

[0267] Embodiment 4

[0268] Figure 5 Schematic diagram of the structure of a power grid data management device provided by the fourth embodiment of the present invention. The power grid data management device of this embodiment can be composed of hardware and / or software, and can be integrated into an electronic device. Figure 5 As shown, the power grid data management device 400 provided in the embodiment of the present invention includes: a data acquisition module 410 , a data table establishment module 420 , a processing module 430 and a request response module 440 .

[0269] The data acquisition module 410 is used to acquire at least two target power grid data from the power grid database;

[0270] A data table establishment module 420, for establishing a data table of different categories corresponding to each regional identifier based on the category and regional identifier of the target power grid data;

[0271] The processing module 430 is used to analyze and process each category data table and store the obtained processing results;

[0272] The request response module 440 is used to respond to the query request sent by the first user and return the query result obtained based on the query request to the first user.

[0273] As an optional implementation method of an embodiment of the present invention, the category of target power grid data includes at least one of the following: power grid overview, the power grid cost information, the power grid second user information, the power grid evaluation information, the power grid appeal processing information, the power grid complaint resolution information, the power grid electricity consumption inspection information, the power grid metering and operation and maintenance information and the power grid power supply information.

[0274] As an optional implementation of the embodiment of the present invention, the data table creation module 420 specifically performs at least one of the following:

[0275] If the category of the target power grid data is the power grid fee information, and the region identifier of the target power grid data is the first identifier and / or the second identifier, then a power grid fee information data table of the first identifier and / or the second identifier is established;

[0276] If the category of the target power grid data is the power grid second user information, and the region identifier of the target power grid data is the first identifier and / or the second identifier, then establishing a power grid second user information data table of the first identifier and / or the second identifier;

[0277] If the category of the target power grid data is the power grid evaluation information, and the region identifier of the target power grid data is the first identifier and / or the second identifier, then establishing a power grid evaluation information data table of the first identifier and / or the second identifier;

[0278] If the category of the target power grid data is the power grid demand processing information, and the region identifier of the target power grid data is the first identifier and / or the second identifier, then a power grid demand processing information data table of the first identifier and / or the second identifier is established;

[0279] If the category of the target power grid data is the power grid complaint resolution information, and the region identifier of the target power grid data is the first identifier and / or the second identifier, then a power grid complaint resolution information data table of the first identifier and / or the second identifier is established;

[0280] If the category of the target power grid data is the power grid electricity consumption inspection information, and the region identifier of the target power grid data is the first identifier and / or the second identifier, then a power grid electricity consumption inspection information data table of the first identifier and / or the second identifier is established;

[0281] If the category of the target power grid data is the power grid metering operation and maintenance information, and the region identifier of the target power grid data is the first identifier and / or the second identifier, then a power grid metering operation and maintenance information data table of the first identifier and / or the second identifier is established;

[0282] If the category of the target power grid data is the power grid power supply information, and the region identifier of the target power grid data is the first identifier and / or the second identifier, a power grid power supply information data table of the first identifier and / or the second identifier is established.

[0283] As an optional implementation of the embodiment of the present invention, the processing module 430 includes:

[0284] A processing unit, used to perform analysis and processing on each category data table in different dimensions, and establish a mapping relationship between the region identifier, the category data table and the processing result;

[0285] The storage unit is used to store the mapping relationship between the established region identification, category data table and processing result.

[0286] As an optional implementation of the embodiment of the present invention, the processing unit is specifically configured to perform at least one of the following:

[0287] If the data table is a grid fee information data table, the data table is analyzed and processed for the electricity fee recovery rate and non-cash payment rate of the power supply unit and / or the person in charge;

[0288] If the data table is a power grid second user information data table, the data table is efficiently analyzed and processed for the second user contact information of the power supply unit and / or the person in charge;

[0289] If the data table is a power grid evaluation information data table, the data table is analyzed and processed for the amount of complaint data and the amount of complaint data of the power supply unit and / or the person in charge;

[0290] If the data table is a grid demand processing information data table, the data table is analyzed and processed for the timely rate of demand work orders of the power supply unit and / or the person in charge, the timely rate of low-voltage business expansion registration, and the timely notification rate of power outage plans;

[0291] If the data table is a grid complaint resolution information data table, the data table is analyzed and processed for the first-time resolution rate of complaints of the power supply unit and / or the person in charge;

[0292] If the data table is a grid electricity inspection information data table, the data table is analyzed for the periodic inspection completion rate, special inspection completion rate and electricity safety hazard rectification rate of the power supply unit and / or the person in charge;

[0293] If the data table is a power grid metering operation and maintenance information data table, the metering fault error rate of the power supply unit and / or the person in charge is analyzed and processed for the data table;

[0294] If the data table is a power grid power supply information data table, the data table is analyzed and processed with respect to the user failure mean time and the D-class voltage qualification rate of the power supply unit and / or the person in charge.

[0295] As an optional implementation of the embodiment of the present invention, the request response module 440 is specifically configured to:

[0296] Displaying the query result obtained based on the query request to the first user in a preset display manner;

[0297] Among them, the preset display method includes at least one of the following: a table, a bar chart, a pie chart, a line chart and a bar chart.

[0298] As an optional implementation of the embodiment of the present invention, the request response module 440 is specifically configured to:

[0299] If multiple query results are obtained based on the query request, the multiple query results are sorted and the sorted results are returned to the first user.

[0300] It should be noted that the above explanation of the embodiment of the power grid data management method is also applicable to the power grid data management device of this embodiment, and the implementation principle is similar, which will not be repeated here.

[0301] The technical solution provided by the embodiment of the present invention establishes data tables corresponding to different regions based on the power grid data categories and the regions to which they belong in the power grid database, and analyzes and processes the established data tables, thereby realizing automated management of power grid data, avoiding manual participation in management, and improving the management quality and efficiency of power grid data.

[0302] Embodiment 5

[0303] Figure 6 It is a structural schematic diagram of an electronic device provided in Embodiment 5 of the present invention. Figure 6 A block diagram of an exemplary electronic device 500 suitable for implementing embodiments of the present invention is shown. Figure 6 The electronic device 500 shown is only an example and should not bring any limitation to the functions and scope of use of the embodiments of the present invention.

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

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

[0306] The electronic device 500 typically includes a variety of computer system readable media. These media can be any available media that can be accessed by the electronic device 500, including volatile and non-volatile media, removable and non-removable media.

[0307] The system memory 28 may include computer system readable media in the form of volatile memory, such as random access memory (RAM) 30 and / or cache memory 32. The electronic device 500 may further include other removable / non-removable, volatile / non-volatile computer system storage media. By way of example only, the storage system 34 may be used to read and write non-removable, non-volatile magnetic media ( Figure 6 not shown, usually called a "hard drive"). Although Figure 6 Not shown in the figure, a disk drive for reading and writing to a removable non-volatile disk (e.g., a "floppy disk"), and an optical disk drive for reading and writing to a removable non-volatile optical disk (e.g., a CD-ROM, a DVD-ROM, or other optical media) may be provided. In these cases, each drive may be connected to the bus 18 via one or more data medium interfaces. The system memory 28 may include at least one program product having a set (e.g., at least one) of program modules that are configured to perform the functions of the various embodiments of the present invention.

[0308] A program / utility 40 having a set (at least one) of program modules 42 may be stored, for example, in system memory 28, such program modules 42 including, but not limited to, an operating system, one or more application programs, other program modules, and program data, each of which or some combination may include an implementation of a network environment. Program modules 42 generally perform the functions and / or methods of the embodiments described herein.

[0309] The electronic device 500 may also communicate with one or more external devices 14 (e.g., keyboards, pointing devices, displays 24, etc.), may also communicate with one or more devices that enable a user to interact with the electronic device 500, and / or communicate with any device that enables the electronic device 500 to communicate with one or more other computing devices (e.g., network cards, modems, etc.). Such communication may be performed via an input / output (I / O) interface 22. Furthermore, the electronic device 500 may also communicate with one or more networks (e.g., local area networks (LANs), wide area networks (WANs), and / or public networks, such as the Internet) via a network adapter 20. As shown, the network adapter 20 communicates with other modules of the electronic device 500 via a bus 18. It should be understood that, although not shown in the figure, other hardware and / or software modules may be used in conjunction with the electronic device 500, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup storage systems.

[0310] The processing unit 16 executes various functional applications and data processing by running the program stored in the system memory 28, for example, implementing the power grid data management method provided in the embodiment of the present invention, which includes:

[0311] Acquire at least two target power grid data from a power grid database;

[0312] Based on the category and regional identification of the target power grid data, establishing a data table of different categories corresponding to each regional identification;

[0313] Analyze and process each category data table, and store the processing results;

[0314] In response to the query request sent by the first user, the query result obtained based on the query request is returned to the first user.

[0315] It should be noted that the above explanation of the embodiment of the method for managing power grid data is also applicable to the electronic device of this embodiment, and the implementation principle is similar, which will not be repeated here.

[0316] Embodiment 6

[0317] In order to achieve the above objective, embodiment 6 of the present invention further proposes a computer-readable storage medium.

[0318] The computer-readable storage medium provided in the embodiment of the present invention stores a computer program, and when the program is executed by a processor, the method for managing power grid data according to the embodiment of the present invention is implemented, including:

[0319] Acquire at least two target power grid data from a power grid database;

[0320] Based on the category and regional identification of the target power grid data, establishing a data table of different categories corresponding to each regional identification;

[0321] Analyze and process each category data table, and store the processing results;

[0322] In response to the query request sent by the first user, the query result obtained based on the query request is returned to the first user.

[0323] The computer storage medium of the embodiment of the present invention 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 can be, for example, but not limited to, a system, device or device of electricity, magnetism, light, electromagnetic, infrared, or semiconductor, or any combination of the above. More specific examples (non-exhaustive list) of computer-readable storage media include: an electrical connection with one or more wires, a portable computer disk, 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 disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In this document, a computer-readable storage medium can be any tangible medium containing or storing a program, which can be used by an instruction execution system, a device or a device or used in combination with it.

[0324] Computer-readable signal media may include data signals propagated in baseband or as part of a carrier wave, which carry computer-readable program code. 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 above. Computer-readable signal media may also be any computer-readable medium other than a computer-readable storage medium, which may send, propagate, or transmit a program for use by or in conjunction with an instruction execution system, apparatus, or device.

[0325] The program code embodied on the 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.

[0326] Computer program code for performing the operation of the present invention may be written in one or more programming languages ​​or a combination thereof, including object-oriented programming languages ​​such as Java, Smalltalk, C++, and conventional procedural programming languages ​​such as "C" or similar programming languages. The program code may be executed entirely on the user's computer, partially on the user's computer, as a separate software package, partially on the user's computer and partially on a remote computer, or entirely on a 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 may be connected to an external computer (e.g., via the Internet using an Internet service provider).

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

Claims

1. A method for managing power grid data, characterized in that: include: Acquire at least two target power grid data from a power grid database; Based on the category and regional identification of the target power grid data, establishing a data table of different categories corresponding to each regional identification; Analyze and process each category data table, and store the processing results; In response to the query request sent by the first user, the query result obtained based on the query request is returned to the first user; Wherein, the acquiring at least two target power grid data from the power grid database includes: Establishing a communication connection with a power grid database through a pre-agreed communication interface, and acquiring at least two target power grid data from the power grid database based on the communication connection; The analyzing and processing each category data table and storing the obtained processing results include: Perform analysis and processing on each category data table in different dimensions, and establish a mapping relationship between the region identifier, category data table and processing results; The mapping relationship between the established region identification, category data table and processing results is stored; The analyzing and processing each category data table in different dimensions includes at least one of the following: If the data table is a grid fee information data table, the data table is analyzed and processed for the electricity fee recovery rate and non-cash payment rate of the power supply unit and / or the person in charge; If the data table is a power grid second user information data table, the data table is efficiently analyzed and processed for the second user contact information of the power supply unit and / or the person in charge; If the data table is a power grid evaluation information data table, the data table is analyzed and processed for the amount of complaint data and the amount of complaint data of the power supply unit and / or the person in charge; If the data table is a grid demand processing information data table, the data table is analyzed and processed for the timely rate of demand work orders of the power supply unit and / or the person in charge, the timely rate of low-voltage business expansion registration, and the timely notification rate of power outage plans; If the data table is a grid complaint resolution information data table, the data table is analyzed and processed for the first-time resolution rate of complaints of the power supply unit and / or the person in charge; If the data table is a grid electricity inspection information data table, the data table is analyzed for the periodic inspection completion rate, special inspection completion rate and electricity safety hazard rectification rate of the power supply unit and / or the person in charge; If the data table is a power grid metering operation and maintenance information data table, the metering fault error rate of the power supply unit and / or the person in charge is analyzed and processed for the data table; If the data table is a power grid power supply information data table, the data table is analyzed and processed with respect to the user failure mean time and the D-class voltage qualification rate of the power supply unit and / or the person in charge.

2. The method according to claim 1, characterized in that The categories of target power grid data include at least one of the following: power grid overview, power grid cost information, power grid second user information, power grid evaluation information, power grid appeal processing information, power grid complaint resolution information, power grid electricity inspection information, power grid metering and operation and maintenance information, and power grid power supply information.

3. The method according to claim 2, characterized in that Based on the category and region identifier of the target power grid data, establishing a different category data table corresponding to each region identifier includes at least one of the following: If the category of the target power grid data is the power grid fee information, and the region identifier of the target power grid data is the first identifier and / or the second identifier, then establishing a power grid fee information data table of the first identifier and / or the second identifier; If the category of the target power grid data is the power grid second user information, and the region identifier of the target power grid data is the first identifier and / or the second identifier, then establishing a power grid second user information data table of the first identifier and / or the second identifier; If the category of the target power grid data is the power grid evaluation information, and the region identifier of the target power grid data is the first identifier and / or the second identifier, then establishing a power grid evaluation information data table of the first identifier and / or the second identifier; If the category of the target power grid data is the power grid demand processing information, and the region identifier of the target power grid data is the first identifier and / or the second identifier, then a power grid demand processing information data table of the first identifier and / or the second identifier is established; If the category of the target power grid data is the power grid complaint resolution information, and the region identifier of the target power grid data is the first identifier and / or the second identifier, then a power grid complaint resolution information data table of the first identifier and / or the second identifier is established; If the category of the target power grid data is the power grid electricity consumption inspection information, and the region identifier of the target power grid data is the first identifier and / or the second identifier, then a power grid electricity consumption inspection information data table of the first identifier and / or the second identifier is established; If the category of the target power grid data is the power grid metering operation and maintenance information, and the region identifier of the target power grid data is the first identifier and / or the second identifier, then a power grid metering operation and maintenance information data table of the first identifier and / or the second identifier is established; If the category of the target power grid data is the power grid power supply information, and the region identifier of the target power grid data is the first identifier and / or the second identifier, a power grid power supply information data table of the first identifier and / or the second identifier is established.

4. The method according to claim 1, characterized in that: Returning the query result obtained based on the query request to the first user includes: Displaying the query result obtained based on the query request to the first user in a preset display manner; Among them, the preset display method includes at least one of the following: a table, a bar chart, a pie chart, a line chart and a bar chart.

5. The method according to claim 1, characterized in that Returning the query result obtained based on the query request to the first user includes: If multiple query results are obtained based on the query request, the multiple query results are sorted and the sorted results are returned to the first user.

6. A power grid data management device, characterized in that: include: A data acquisition module, used for acquiring at least two target power grid data from a power grid database; A data table establishment module, used to establish different category data tables corresponding to each regional identifier based on the category and regional identifier of the target power grid data; A processing module is used to analyze and process each category data table and store the obtained processing results; A request response module, used to respond to the query request sent by the first user, and return the query result obtained based on the query request to the first user; Wherein, the acquiring at least two target power grid data from the power grid database includes: Establishing a communication connection with a power grid database through a pre-agreed communication interface, and acquiring at least two target power grid data from the power grid database based on the communication connection; The processing module comprises: A processing unit, used to perform analysis and processing on each category data table in different dimensions, and establish a mapping relationship between the region identifier, the category data table and the processing result; A storage unit, used for storing the mapping relationship between the established region identification, category data table and processing result; The processing unit is specifically configured to perform at least one of the following: If the data table is a grid fee information data table, the data table is analyzed and processed for the electricity fee recovery rate and non-cash payment rate of the power supply unit and / or the person in charge; If the data table is a power grid second user information data table, the data table is efficiently analyzed and processed for the second user contact information of the power supply unit and / or the person in charge; If the data table is a power grid evaluation information data table, the data table is analyzed and processed for the amount of complaint data and the amount of complaint data of the power supply unit and / or the person in charge; If the data table is a grid demand processing information data table, the data table is analyzed and processed for the timely rate of demand work orders of the power supply unit and / or the person in charge, the timely rate of low-voltage business expansion registration, and the timely notification rate of power outage plans; If the data table is a grid complaint resolution information data table, the data table is analyzed and processed for the first-time resolution rate of complaints of the power supply unit and / or the person in charge; If the data table is a grid electricity inspection information data table, the data table is analyzed for the periodic inspection completion rate, special inspection completion rate and electricity safety hazard rectification rate of the power supply unit and / or the person in charge; If the data table is a power grid metering operation and maintenance information data table, the metering fault error rate of the power supply unit and / or the person in charge is analyzed and processed for the data table; If the data table is a power grid power supply information data table, the data table is analyzed and processed with respect to the user failure mean time and the D-class voltage qualification rate of the power supply unit and / or the person in charge.

7. An electronic device, characterized in that: include: one or more processors; a storage device for storing one or more programs, When the one or more programs are executed by the one or more processors, the one or more processors implement the method for managing power grid data as described in any one of claims 1-5.

8. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the program is executed by a processor, the method for managing power grid data as described in any one of claims 1 to 5 is implemented.

Images