A basic electricity fee processing method, device, electronic equipment and medium

Abstract

The present invention discloses a basic electricity fee processing method, device, electronic device and medium, the method comprising: establishing a database and registering at least one data table; storing the acquired abnormal record data of this period into each of the data tables according to the column name in the data table, the abnormal record data of this period being data related to the basic electricity fee of this period; connecting the abnormal record data of this period in each of the data tables, screening the connected data, and listing the screened data in a key review list; processing the data in the key review list. The method can screen out data with a high probability of abnormality by further screening the abnormal record data of this period in each data table, thereby reducing the workload of subsequent processing, and at the same time processing the data in the key review list, thereby realizing targeted key review of data with a high probability of abnormality, and further improving the accuracy of the processing results.

Description

Technical Field

[0001] The present invention relates to the technical field of databases, and in particular, to a method, device, electronic device and medium for basic electricity charge processing. Background Art

[0002] With the annual growth of various power data, the probability of abnormal electricity charge data inevitably increases. Once the electricity charge data is abnormal, it will cause certain losses to electricity users (especially large industrial users) and power supply units. Therefore, each power supply unit has put forward higher requirements for the review of basic electricity charges to avoid negligence during the review of electricity charges.

[0003] Traditional basic electricity charge review requires checking the data in the abnormal record detail list one by one, that is, first judging the relevant data fields of the electricity charge review form, and then comparing with the data in the previous review form; if some fields are quite different from the previous period, there may be an abnormality, and it is necessary to jump to other pages to query relevant work orders and gradually investigate the reasons.

[0004] It can be seen that the existing review processing steps are relatively cumbersome, with a large workload, and when the number of abnormal electricity charge situations is relatively large, there may be a low review accuracy rate. Summary of the Invention

[0005] The present invention provides a method, device, electronic device and medium for basic electricity charge processing to improve the accuracy of processing results while reducing the workload.

[0006] According to one aspect of the present invention, there is provided a method for basic electricity charge processing, including:

[0007] Establishing a database and registering at least one data table;

[0008] Storing the obtained current abnormal record data into each of the data tables according to the column names in the data tables, where the current abnormal record data is data related to the current basic electricity charge;

[0009] Connecting the current abnormal record data in each of the data tables, screening the connected data, and listing the screened data in a key review list;

[0010] Processing the data in the key review list.

[0011] According to another aspect of the present invention, there is provided a device for basic electricity charge processing, including:

[0012] A registration module for establishing a database and registering at least one data table;

[0013] A data storage module, configured to store the obtained current abnormal record data into each of the data tables according to the column names in the data tables, where the current abnormal record data is data related to the current basic electricity charge;

[0014] A screening module, configured to connect the current abnormal record data in each of the data tables, screen the connected data, and list the screened data in a key review list;

[0015] A processing module, configured to process the data in the key review list.

[0016] According to another aspect of the present invention, there is provided an electronic device, including:

[0017] At least one processor; and

[0018] A memory communicatively connected to the at least one processor; wherein,

[0019] The memory stores a computer program executable by the at least one processor, and the computer program is executed by the at least one processor so that the at least one processor can execute the basic electricity charge processing method according to any embodiment of the present invention.

[0020] According to another aspect of the present invention, there is provided a computer-readable storage medium storing computer instructions for causing a processor to implement the basic electricity charge processing method according to any embodiment of the present invention when executed.

[0021] Embodiments of the present invention provide a basic electricity charge processing method, apparatus, electronic device and medium. The method includes: establishing a database and registering at least one data table; storing the obtained current abnormal record data into each of the data tables according to the column names in the data tables, where the current abnormal record data is data related to the current basic electricity charge; connecting the current abnormal record data in each of the data tables, screening the connected data, and listing the screened data in a key review list; processing the data in the key review list. By using the above technical solution, by further screening the current abnormal record data in each data table, data with a higher abnormal probability can be screened out, reducing the workload of subsequent processing. At the same time, by processing the data in the key review list, targeted key review of data with a higher abnormal probability is achieved, further improving the accuracy of the processing result.

[0022] It should be understood that the content described in this part is not intended to identify the key or important features of the embodiments of the present invention, nor is it used to limit the scope of the present invention. Other features of the present invention will become easily understood through the following description. Description of the Drawings

[0023] To more clearly illustrate the technical solutions in the embodiments of the present invention, the following will briefly introduce the accompanying drawings required for the description of the embodiments. Obviously, the accompanying drawings in the following description are only some embodiments of the present invention. For those of ordinary skill in the art, without creative efforts, other accompanying drawings can be obtained based on these drawings.

[0024] Figure 1 is a flowchart of a basic electricity charge processing method provided according to Embodiment 1 of the present invention;

[0025] Figure 2 is a flowchart of a basic electricity charge processing method provided according to Embodiment 2 of the present invention;

[0026] Figure 3 is a schematic flowchart of a basic electricity charge processing method provided according to Embodiment 2 of the present invention;

[0027] Figure 4 is a schematic structural diagram of a basic electricity charge processing device provided according to Embodiment 3 of the present invention;

[0028] Figure 5 is a schematic structural diagram of an electronic device provided according to Embodiment 4 of the present invention. Detailed implementation manners

[0029] In order to enable those skilled in the art to better understand the solutions of the present invention, the following will clearly and completely describe the technical solutions in the embodiments of the present invention in conjunction with the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only a part of the embodiments of the present invention, rather than all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art without creative efforts shall fall within the protection scope of the present invention.

[0030] It should be noted that the terms "first", "second", etc. in the specification and claims of the present invention and the above accompanying drawings are used to distinguish similar objects, and do not necessarily need to describe a specific order or sequence. It should be understood that such used data can be interchanged under appropriate circumstances so that the embodiments of the present invention described here can be implemented in an order other than those illustrated or described here. In addition, the terms "comprising" and "having" and any variations thereof are intended to cover non-exclusive inclusion. For example, a process, method, system, product, or device including a series of steps or units does not necessarily need to be limited to those clearly listed steps or units, but may include other steps or units not clearly listed or inherent to these processes, methods, products, or devices.

[0031] Embodiment 1

[0032] Figure 1

[0032] and Figure 1 are flowcharts of a basic electricity charge processing method provided by Embodiment 1 of the present invention. This embodiment is applicable to the situation of processing basic electricity charges. The method can be executed by a basic electricity charge processing device, which can be implemented in the form of hardware and / or software, and can be configured in an electronic device. In this embodiment, the electronic device includes, but is not limited to, devices such as computers, laptops, tablets, and mobile phones.

[0033] It can be understood that with the increase in the number of electricity customers and electricity consumption, various electricity data increases year by year, and the probability of abnormal electricity charge data inevitably increases. Especially for large industrial users with a large amount of electricity charges, the incorrect electricity charges in case of abnormal electricity charge data may differ from the normal electricity charges by tens of thousands of yuan, resulting in certain economic losses for both electricity customers and power supply units. Therefore, each power supply unit has higher requirements for the review of the basic electricity charges of large industrial users to avoid unnecessary losses caused by negligence during the electricity charge review.

[0034] Traditional basic electricity charge review requires checking the data in the abnormal record detail list exported from the marketing system one by one. Since this list only reflects the records that may be abnormal and does not represent that the record is truly abnormal, relevant business personnel need to judge the relevant data fields of the electricity charge review form on the "Electricity Quantity and Electricity Charge Details" page of the marketing system and then compare them with previous review forms. If some fields are significantly different from the previous periods, there may be an abnormality, and it is necessary to jump to other pages to query relevant work orders and gradually investigate the reasons. This series of steps is rather cumbersome, and during the period when there are many electricity charge abnormalities, it is inevitable that relevant business personnel will miss the review of certain electricity charge data. Therefore, the traditional basic electricity charge processing method has a large workload and a low accuracy rate for electricity charge data review.

[0035] Based on this, the embodiment of the present invention further screens the monthly abnormal record details related to basic electricity charges based on the SQL programming tool of the data cloud platform. Since the abnormal probability of the screened abnormal records is relatively high, the basic electricity charge processing method of the present invention can focus on reviewing the abnormal records with a relatively high abnormal probability, thereby effectively reducing the error rate of electricity charge review.

[0036] As Figure 1 shown, the basic electricity charge processing method provided by Embodiment 1 of the present invention includes the following steps:

[0037] S110. Establish a database and register at least one data table.

[0038] In this embodiment, a data table can be understood as a grid virtual table for storing data, and the number of data tables is not limited and can be one or more.

[0039] It can be considered that when implementing the basic electricity charge processing method of this embodiment, first, a new database needs to be established, that is, a new database is created. The method of creating the new database is not limited. For example, the new database can be created by clicking a control in the application program, or can be created by using SQL statements, etc.; then, one or more data tables are registered in the established database for storing the data that needs to be processed subsequently. Among them, registering each data table can include setting the table name, column name, etc. of each data table. The specific process of registering each data table is not limited and can be set according to actual needs. In this embodiment, the table name of the data table is used to represent the main content and theme of the data table, and the column name can refer to the name of each column in the data table.

[0040] Exemplarily, in this step, a data table can be registered, its table name is set as the meter reading information table, and the column names in the data table are set (such as YHMC, SCBJDL); another example is that another data table can also be registered, its table name is set as the detailed list of abnormal records, and the column names in this table are set, such as the month and year of the fee, the source of the abnormality, etc. This embodiment does not limit this.

[0041] S120. Store the obtained current-period abnormal record data into each of the above-mentioned data tables respectively according to the column names in the data tables, where the current-period abnormal record data is data related to the current-period basic electricity charge.

[0042] The current-period abnormal record data can refer to data related to the current-period basic electricity charge. For example, the current-period abnormal record data can include data indicating that the current-period electricity charge may be abnormal, such as user number, electricity quantity volatility rate, source of abnormality, etc.; it can also include other data related to the current-period electricity charge, that is, data that can be used to subsequently judge whether the current-period basic electricity charge is abnormal, such as the previous-period and current-period electricity meter data, basic electricity charge information, billing flag, etc. Among them, the acquisition source of the current-period abnormal record data is not limited. Exemplarily, it can be from the abnormal record detail list automatically generated by the marketing system. The abnormal record detail list can refer to the abnormal list automatically exported by the marketing system, which is used to reflect the data that may be abnormal and can include specific data and corresponding column names; it can also be queried and exported from the marketing system. This embodiment does not limit this.

[0043] In this embodiment, after registering each data table, the obtained current-period abnormal record data can be stored into each of the registered data tables respectively according to the column names in the data tables for subsequent processing. The specific means of storage are not elaborated here. For example, query statements can be used for data entry, deletion, and update. Among them, the same current-period abnormal record data can be included in different data tables, and the data included in different data tables can also be completely different. This is not limited here.

[0044] In one embodiment, the data in the detailed list of exception records obtained from the marketing system can be stored in the registered detailed table of exception records, and then the required other data (such as other data related to the current electricity bill) can be stored in the corresponding data tables respectively according to the column names in the data tables for subsequent judgment on whether the current basic electricity bill is abnormal.

[0045] S130. Connect the current exception record data in each of the data tables, screen the connected data, and list the screened data in the key review list.

[0046] The key review list can be regarded as a list that needs to be reviewed with emphasis. It can be considered that the data in the key review list has a relatively high probability of being abnormal data, and subsequent processing by relevant business personnel or the system is required for final confirmation.

[0047] Specifically, after obtaining the current exception record data in each data table, the current exception record data can be connected, and then the connected data can be screened to list the screened data in the key review list. This embodiment does not limit the specific method. For example, the required columns can be selected from one or more data tables for data table connection, and then the data can be screened according to the screening conditions. Finally, the screened data can be exported to obtain the key review list. The screened data can be from a certain one or more data tables, or from all data tables, or from specific certain columns. This step will not be further elaborated here.

[0048] Among them, the specific content of the screening conditions is not limited. In one embodiment, screening can be performed by comparing the value of a certain calculated parameter with a set threshold, or the current exception record data can be screened according to the magnitudes of the current basic electricity bill and the previous basic electricity bill. When specifically performing screening, a combination of one or more screening means can also be used, which is not further limited here.

[0049] S140. Process the data in the key review list.

[0050] In this step, the data in the key review list can be processed accordingly to complete the processing of the current exception record data. The processing method can be to judge the relevant data fields in the key review list and then compare them with the previous review list. If certain fields (such as basic electricity bill or power factor adjustment electricity bill) are significantly different from the previous period, it is determined that this record is abnormal; if they are relatively small, it is determined that this record is normal and it will be removed from the key review list. This embodiment does not limit this.

[0051] A basic electricity charge processing method provided in Embodiment 1 of the present invention can screen out data with a relatively high probability of abnormality by further screening the current abnormal record data in each data table, reducing the workload of subsequent processing. At the same time, processing the data in the key review list realizes targeted key review of data with a relatively high probability of abnormality, further improving the accuracy of the processing result.

[0052] In one embodiment, after processing the data in the key review list, it further includes:

[0053] Moving the current abnormal record data to the historical data table.

[0054] It can be understood that after processing the data in the key review list, the obtained current abnormal record data can be moved to the historical data table to obtain and process the next period's abnormal record data. At the same time, moving the current abnormal record data to the historical data table realizes the archiving of abnormal record data for subsequent query and call.

[0055] Embodiment 2

[0056] Figure 2 FIG. is a flowchart of a basic electricity charge processing method provided in Embodiment 2 of the present invention. Embodiment 2 is optimized based on the above embodiments. In this embodiment, further specifying the screening of the connected data is as follows: If the current basic electricity charge volatility is greater than the first set threshold, then screen the connected data according to the billing flag and business category. Further specifying the screening of the connected data is as follows: If the current basic electricity charge volatility is less than or equal to the first set threshold, then screen the connected data according to the current basic electricity charge and the previous period's basic electricity charge.

[0057] For the content not detailed in this embodiment, please refer to Embodiment 1.

[0058] As Figure 2 shown, a basic electricity charge processing method provided in Embodiment 2 of the present disclosure includes the following steps:

[0059] S210. Establish a database and register at least one data table.

[0060] S220. Store the obtained current abnormal record data into each of the data tables according to the column names in the data tables, where the current abnormal record data is data related to the current basic electricity charge.

[0061] S230. Connect the current abnormal record data in each of the data tables, and determine whether the current basic electricity charge volatility is greater than the first set threshold. If so, execute S240; otherwise, execute S250.

[0062] The basic electricity charge volatility in this period can be understood as the fluctuation range of the basic electricity charge in this period compared with that in the previous period. For example, it can be calculated based on the basic electricity charge in this period and the basic electricity charge in the previous period in the data table, or directly obtained from the data table. This step does not make any limitations on this. Among them, the basic electricity charge can refer to the electricity charge calculated according to the user's electricity consumption capacity. The basic electricity charge can be billed according to the transformer capacity or the maximum demand, that is, the billing flag can be by transformer capacity or by maximum demand. The first set threshold can be regarded as the critical value of the basic electricity charge volatility and can be determined by relevant technical personnel according to experience.

[0063] In this embodiment, first, several data tables including the basic electricity charge in this period, the basic electricity charge in the previous period, and / or the basic electricity charge volatility in this period can be selected and connected. The basic electricity charge volatility in this period is compared with the first set threshold, and then the abnormal record data in this period is screened according to the comparison result to obtain a key review list. Specifically, when the basic electricity charge volatility in this period is greater than the first set threshold, it indicates that the basic electricity charge volatility in this period exceeds the critical value of the basic electricity charge volatility. At this time, the abnormal record data in this period can be screened according to the billing flag and the business category, that is, step S240 is executed; when the basic electricity charge volatility in this period is less than the first set threshold, it indicates that the basic electricity charge volatility in this period does not exceed the critical value of the basic electricity charge volatility. At this time, the abnormal record data in this period in each data table can be screened by the basic electricity charge in this period and the basic electricity charge in the previous period, that is, step S250 is executed.

[0064] S240. Screen the connected data according to the billing flag and the business category, and list the screened data in the key review list.

[0065] The billing flag can be regarded as the flag for billing the basic electricity charge, including by transformer capacity or by maximum demand. Among them, billing by transformer capacity can refer to calculating the basic electricity charge according to the capacity of the user's transformer, and billing by maximum demand can refer to calculating the basic electricity charge according to the maximum demand value metered by the user in the current month.

[0066] The business category can refer to the category of the represented business. For example, it can include before change, normal electricity charge, etc. Before change can be understood as a change in the capacity increase or decrease of the user's transformer. For example, it may occur that the transformer capacity increases from 315 kVA to 1200 kVA. It can be understood that in this case, a relatively large basic electricity charge volatility is a normal phenomenon; when the business category is normal electricity charge, it can be considered that there is no situation of data capacity increase or decrease in such data.

[0067] In this embodiment, when the basic electricity charge volatility of this period is greater than the first set threshold, the connected data can be screened according to the billing flag and service category. The specific screening rules are not limited here. Optionally, when the billing flag is based on the transformer capacity and the service category is before change, it can be considered that a relatively large basic electricity charge volatility is normal, so such data can be considered to have no abnormal situation. Optionally, when the billing flag is based on the transformer capacity and the service category is not before change, it can be considered that a relatively large basic electricity charge volatility may be an abnormal phenomenon, and further judgment by relevant business personnel or the system is required for confirmation. Further elaboration on the subsequent judgment is not provided here, as long as the abnormal record data of this period can be screened.

[0068] S250. Screen the connected data based on the basic electricity charge of this period and the basic electricity charge of the previous period, and list the screened data in the key review list.

[0069] Since the basic electricity charge is a part of the electricity charge composition of large industrial users, the basic electricity charge of this period can refer to the electricity charge calculated based on the electricity consumption capacity of the user's transformer in this period, and the basic electricity charge of the previous period can refer to the electricity charge calculated based on the electricity consumption capacity of the user's transformer in the previous period. Among them, the billing flags of the basic electricity charge of this period and the basic electricity charge of the previous period can be the same or different, which is not limited here.

[0070] Specifically, when the basic electricity charge volatility of this period does not exceed the critical value of the basic electricity charge volatility, the abnormal record data of this period can be screened based on the basic electricity charge of this period and the basic electricity charge of the previous period. For example, the screening can be performed according to the specific values of the basic electricity charge of this period and the basic electricity charge of the previous period, and different values can correspond to different screening methods. The abnormal record data of this period can also be screened by comparing the magnitudes of the basic electricity charge of this period and the basic electricity charge of the previous period. This embodiment does not limit this.

[0071] S260. Process the data in the key review list.

[0072] A basic electricity charge processing method provided by the second embodiment of the present invention can perform different screening steps according to the difference between the basic electricity charge volatility of this period and the first set threshold by setting the first set threshold, thereby realizing listing the screened data in the key review list for subsequent processing.

[0073] In one embodiment, the screening of the connected data according to the billing flag and service category includes:

[0074] When the billing flag is the preset flag and the service category is not the preset category, the current abnormal record data with the current electricity consumption days being the set days, or the current abnormal record data with the initial electricity charge volatility greater than the second set threshold, shall be included in the said key review list, and the data included in the said key review list shall be marked as the first abnormal type; wherein, the initial electricity charge volatility is determined according to the previous basic electricity charge, the set days and the current electricity consumption days.

[0075] Among them, the preset flag can be a pre-set billing flag, such as by transformer capacity, etc.; the preset category can be a pre-set service category, such as before change, etc. The current electricity consumption days can be considered as the days of actual electricity consumption in the current period, which can be obtained through the data table; the set days can be understood as the pre-set electricity consumption days, such as the set days can be 30 days.

[0076] The initial electricity charge volatility can refer to the electricity charge volatility determined according to the current actual electricity consumption days. Optionally, it can be determined according to the previous basic electricity charge, the set days and the current electricity consumption days. For example, the initial electricity charge volatility can be equal to the previous basic electricity charge multiplied by the set days and then divided by the current electricity consumption days.

[0077] The second set threshold can be considered as the critical value of the initial electricity charge volatility, which can be determined by relevant technical personnel according to experience. The first set threshold and the second set threshold are only used to distinguish different objects. The first set threshold and the second set threshold can be the same or different. This step does not make any limitation on this. The first abnormal type can be used to characterize the type of data abnormality. For example, the first abnormal type can be that the current basic electricity charge volatility is too large, etc.

[0078] In this embodiment, when the billing flag is the preset flag and the service category is not the preset category, the current abnormal record data can be further screened by the current electricity consumption days. Exemplarily, when the current electricity consumption days are the set days, it can be considered that such data may be abnormal. Therefore, the current abnormal record data with the current electricity consumption days being the set days shall be included in the key review list, and the included data shall be marked as the first abnormal type.

[0079] For another example, when the number of days of electricity consumption in the current period is not the set number of days, further screening can be performed based on the initial electricity bill volatility. If the initial electricity bill volatility is greater than the second set threshold, it indicates that the initial electricity bill volatility exceeds the preset critical value. In this case, the data may be abnormal. Therefore, the abnormal record data of the current period with an initial electricity bill volatility greater than the second set threshold is included in the key review list, and the included data is marked as the first abnormal type. On this basis, by setting a preset flag, a preset category, the set number of days, and the second set threshold, the screening of the abnormal record data of the current period is achieved when the basic electricity bill volatility of the current period is greater than the first set threshold. At the same time, by marking the screened data as the first abnormal type, the type of abnormal data is further clarified, which provides convenience for subsequent processing.

[0080] In one embodiment, the screening of the connected data based on the basic electricity bill of the current period and the basic electricity bill of the previous period includes:

[0081] If the basic electricity bill of the current period is not zero and the basic electricity bill of the previous period is zero, then the abnormal record data of the current period with a billing flag of the preset flag and a service category not being the preset category is included in the key review list, and the data included in the key review list is marked as the second abnormal type;

[0082] If the basic electricity bill of the current period is zero and the basic electricity bill of the previous period is not zero, then the abnormal record data of the current period is screened based on the power factor adjustment electricity bill of the current period and the power factor adjustment electricity bill of the previous period.

[0083] The power factor adjustment electricity bill can be considered as the electricity bill generated based on the power factor of a user over a period of time. The power factor can be obtained through the calculation of the reactive power consumption and the active power consumption of the user. The power factor adjustment electricity bill of the current period is the electricity bill adjustment generated based on the power factor of the user in the current period, and the power factor adjustment electricity bill of the previous period is the electricity bill adjustment generated based on the power factor of the user in the previous period. In this embodiment, the power factor adjustment electricity bill can be determined by the magnitude of the power factor and the power factor adjustment standard. The power factor adjustment standard can be a standard value set in the art for calculating the power factor adjustment electricity bill.

[0084] In this step, the abnormal record data of this period can be screened according to the specific values of the basic electricity charge of this period and the basic electricity charge of the previous period. If the basic electricity charge of this period is not zero and the basic electricity charge of the previous period is zero, further screening can be carried out through the billing flag and business category at this time. That is, when the billing flag is based on transformer capacity and the business category is before change, it can be considered that the basic electricity charge of this period is not zero and the basic electricity charge of the previous period is zero is a normal phenomenon. Therefore, such data can be considered to have no abnormal situation; when the billing flag is based on transformer capacity and the business category is not before change, it can be considered that the basic electricity charge of this period is not zero and the basic electricity charge of the previous period is zero is an abnormal phenomenon. Therefore, such data can be included in the key review list, and the included data is marked as the second abnormal type. The second abnormal type is similar to the first abnormal type and can be used to characterize the type of data abnormality. For example, the second abnormal type can be that the basic electricity charge of the previous period is zero and the basic electricity charge of this period is not zero.

[0085] Similarly, if the basic electricity charge of this period is zero and the basic electricity charge of the previous period is not zero, further screening can be carried out through the power factor adjustment electricity charge of this period and the power factor adjustment electricity charge of the previous period at this time. For example, screening can be carried out according to the specific values of the power factor adjustment electricity charge of this period and the power factor adjustment electricity charge of the previous period. Different values can correspond to different screening methods; it is also possible to screen the abnormal record data of this period by comparing the magnitudes of the power factor adjustment electricity charge of this period and the power factor adjustment electricity charge of the previous period. This embodiment does not limit this. On this basis, different screening of the abnormal record data of this period is realized according to the different specific values of the basic electricity charge of this period and the basic electricity charge of the previous period, further improving the accuracy of the basic electricity charge processing method.

[0086] In one embodiment, the screening of the abnormal record data of this period according to the power factor adjustment electricity charge of this period and the power factor adjustment electricity charge of the previous period includes:

[0087] The abnormal record data of this period where the power factor adjustment electricity charge of this period is not zero, the power factor adjustment electricity charge of the previous period is zero, and the power factor adjustment standard is not equal to the previous power factor is included in the key review list, and the data included in the key review list is marked as the third abnormal type.

[0088] In this embodiment, the abnormal record data of this period can be screened according to the specific values of the power factor adjustment electricity charge of this period and the previous period. If the power factor adjustment electricity charge of this period is zero and the power factor adjustment electricity charge of the previous period is not zero, it indicates that such data is normal; if the basic electricity charge of this period is not zero and the basic electricity charge of the previous period is zero, it indicates that such data may be abnormal. At this time, further screening is required through the power factor adjustment standard and the power factor of the previous period. That is, when the power factor adjustment standard is equal to the power factor of the previous period, it indicates that the basic electricity charge of the previous period is zero, which is consistent with the prerequisite condition, indicating that such data is normal; when the power factor adjustment standard is not equal to the power factor of the previous period, it indicates that the basic electricity charge of the previous period is not zero, which is not consistent with the prerequisite condition that the basic electricity charge of the previous period is zero, indicating that such data is abnormal. Then, such data is included in the key review list, and the included data is marked as the third abnormal type. The third abnormal type is similar to the first abnormal type and can be used to represent the type of data abnormality. For example, the third abnormal type can be that the power factor adjustment electricity charge of the previous period is zero and that of this period is not zero. On this basis, the screening of the data of the third abnormal type is realized by comparing the power factor adjustment standard with the power factor of the previous period.

[0089] The basic electricity charge processing method provided by the embodiment of the present invention is described exemplarily below. First, the database can be initialized (i.e., the database is established) to store tables such as abnormal record details, meter reading information, and metering point information. The abnormal record detail table can be a table for storing data related to electricity charge abnormalities, such as electricity charge year and month, abnormal source, etc.; the meter reading information table can be a table for storing data related to the electric meter, such as meter reading date, etc.; the metering point information table can be a table for storing metering point data, such as metering point serial number, metering point number, etc.

[0090] Then, the tables (i.e., data tables) to be used subsequently are registered, and data is exported from the marketing system and synchronized accordingly (i.e., the obtained abnormal record data of this period is respectively stored in each of the data tables according to the column names in the data tables).

[0091] Secondly, when the data related to the marketing system changes, the change records can be written into the corresponding data tables.

[0092] Subsequently, a process is started (i.e., the abnormal record data of this period in each of the data tables is connected, and the connected data is screened) and a key review detail list is obtained (i.e., the screened data is included in the key review list). After the abnormal processing of this part is completed, the data in the corresponding table is moved to the corresponding historical table (i.e., the abnormal record data of this period is moved to the historical data table).

[0093] Finally, after the electricity charge data of the next month is updated, the tables and statements related to the date in the code are updated to extract the abnormal data of the next month (i.e., the abnormal record data of the next period).

[0094] Figure 3It is a schematic flowchart of a basic electricity charge processing method provided by Embodiment 2 of the present invention. As Figure 3 shown, first, a basic electricity charge volatility threshold (i.e., the first set threshold) is defined, a database is established, a response table is initialized, and marketing system data is synchronized (i.e., a database is established and at least one data table is registered; the obtained current period abnormal record data is respectively stored in each of the data tables according to the column names in the data tables).

[0095] Then, the current period abnormal record data in each of the data tables is joined, the joined data is filtered, and the filtered data is listed in a key review list. The specific filtering steps can be: judging whether the current period basic electricity charge volatility is greater than the volatility threshold. When the current period basic electricity charge volatility is greater than the volatility threshold (i.e., the first set threshold), it can be judged whether the billing flag is by transformer capacity (i.e., the preset flag) and the service type is before change (i.e., the preset category). If so, the record can be discarded; if not, it continues to judge whether the electricity consumption date (i.e., the current period electricity consumption days) in the current period review form is 30 days (i.e., the set days), that is, the current period abnormal record data with the electricity consumption date of 30 days, or the current period abnormal record data with the initial electricity charge volatility (i.e., the previous period basic electricity charge * 30 / electricity consumption date) greater than the volatility threshold is written into the key review detail list form (i.e., the key review list), and is marked as "the current period basic electricity charge volatility is too large", that is, the first abnormal type; those that do not meet the conditions are discarded.

[0096] When the current period basic electricity charge volatility is less than the volatility threshold, it can be judged whether the current period basic electricity charge is not 0 and the previous period (i.e., the previous period basic electricity charge) is 0, and then subsequent filtering is carried out respectively according to the different values of the basic electricity charge: when the current period basic electricity charge is not 0 and the previous period is 0, filtering is carried out according to the billing flag and the service type, that is, when the billing flag is by transformer capacity and the service type is not before change, the record is written into the key review detail list form and is marked as "the previous period basic electricity charge is zero, the current period is not zero", that is, the second abnormal type; those that do not meet the conditions are discarded. When the current period basic electricity charge is 0 and the previous period is not 0, it is judged whether the current period power factor adjustment charge is not 0 and the previous period (i.e., the previous period power factor adjustment charge) is 0. If not, the record can be discarded; if so, further filtering is carried out according to whether the power factor adjustment standard is equal to the actual interest rate of the previous month (i.e., the previous period power factor). The records with the power factor adjustment standard equal to the actual interest rate of the previous month are considered normal records, and the records with the power factor adjustment standard not equal to the actual interest rate of the previous month are written into the key review detail list form and are marked as "the previous period power factor adjustment charge is zero, the current period is not zero", that is, the third abnormal type.

[0097] As can be seen from the above description, the basic electricity charge processing method of this embodiment can query the detailed list of abnormal records for this month from the marketing system database, extract the records with the warning information keyword of "basic electricity charge", and then according to the specific warning information text of the record, the specific abnormal types (i.e., the first abnormal type, the second abnormal type, and the third abnormal type) can be identified, and corresponding screening strategies are adopted for extraction and processing, so as to realize the abnormal extraction of records of different basic electricity charge abnormal types.

[0098] Embodiment III

[0099] Figure 4 is a structural schematic diagram of a basic electricity charge processing device provided according to Embodiment III of the present invention, as Figure 4 shown, the device includes:

[0100] A registration module 310, configured to establish a database and register at least one data table;

[0101] A data storage module 320, configured to store the obtained current period abnormal record data into each of the data tables according to the column names in the data tables, where the current period abnormal record data is data related to the current period basic electricity charge;

[0102] A screening module 330, configured to connect the current period abnormal record data in each of the data tables, screen the connected data, and list the screened data in a key review list;

[0103] A processing module 340, configured to process the data in the key review list.

[0104] A basic electricity charge processing device provided by Embodiment III of the present invention establishes a database and registers at least one data table through a registration module 310; stores the obtained current period abnormal record data into each of the data tables according to the column names in the data tables through a data storage module 320, where the current period abnormal record data is data related to the current period basic electricity charge; connects the current period abnormal record data in each of the data tables through a screening module 330, screens the connected data, and lists the screened data in a key review list; processes the data in the key review list through a processing module 340. By using this device, by further screening the current period abnormal record data in each data table, data with a higher abnormal probability can be screened out, reducing the workload of subsequent processing. At the same time, by processing the data in the key review list, targeted key review of data with a higher abnormal probability is realized, further improving the accuracy of the processing result.

[0105] Optionally, the screening module 330 includes:

[0106] The first screening unit is configured to, if the basic electricity charge volatility in the current period is greater than the first set threshold, screen the connected data according to the billing flag and service category.

[0107] Optionally, the screening module 330 includes:

[0108] The first screening unit is configured to, if the basic electricity charge volatility in the current period is less than or equal to the first set threshold, screen the connected data according to the basic electricity charge in the current period and the basic electricity charge in the previous period.

[0109] Optionally, the first screening unit is specifically configured to:

[0110] When the billing flag is the preset flag and the service category is not the preset category, include the current abnormal record data with the number of days of electricity consumption in the current period being the set number of days, or the current abnormal record data with the initial electricity charge volatility greater than the second set threshold, in the key review list, and label the data included in the key review list as the first abnormal type; wherein, the initial electricity charge volatility is determined according to the basic electricity charge in the previous period, the set number of days, and the number of days of electricity consumption in the current period.

[0111] Optionally, the second screening unit includes:

[0112] The first screening subunit is configured to, if the basic electricity charge in the current period is not zero and the basic electricity charge in the previous period is zero, include the current abnormal record data with the billing flag being the preset flag and the service category not being the preset category in the key review list, and label the data included in the key review list as the second abnormal type;

[0113] The second screening subunit is configured to, if the basic electricity charge in the current period is zero and the basic electricity charge in the previous period is not zero, screen the current abnormal record data according to the power factor adjustment charge in the current period and the power factor adjustment charge in the previous period.

[0114] Optionally, the second screening subunit is specifically configured to:

[0115] Include the current abnormal record data with the power factor adjustment charge in the current period not being zero, the power factor adjustment charge in the previous period being zero, and the power factor standard not being equal to the previous period's power factor in the key review list, and label the data included in the key review list as the third abnormal type.

[0116] Optionally, the processing module 340 includes:

[0117] After processing the data in the key review list, it further includes:

[0118] Move the current abnormal record data to the historical data table.

[0119] The basic electricity charge processing device provided by the embodiments of the present invention can execute the basic electricity charge processing method provided by any embodiment of the present invention, and has the corresponding functional modules and beneficial effects for executing the method.

[0120] Embodiment 4

[0121] Figure 5 FIG. 7 is a schematic structural diagram of an electronic device according to Embodiment 4 of the present invention. The electronic device is intended to represent various forms of digital computers, such as, for example, a laptop computer, a desktop computer, a workbench, a personal digital assistant, a server, a blade server, a mainframe computer, and other suitable computers. The electronic device may also represent various forms of mobile devices, such as, for example, a personal digital processor, a cellular phone, a smart phone, a wearable device (such as a helmet, glasses, a watch, etc.) and other similar computing devices. The components shown herein, their connections and relationships, and their functions are merely exemplary and are not intended to limit the implementation of the present invention described and / or claimed herein.

[0122] As Figure 5 shown, the electronic device 10 includes at least one processor 11, and a memory communicatively connected to the at least one processor 11, such as a read-only memory (ROM) 12, a random access memory (RAM) 13, etc. The memory stores a computer program executable by the at least one processor. The processor 11 can perform various appropriate actions and processes according to the computer program stored in the read-only memory (ROM) 12 or the computer program loaded from the storage unit 18 into the random access memory (RAM) 13. In the RAM 13, various programs and data required for the operation of the electronic device 10 can also be stored. The processor 11, the ROM 12, and the RAM 13 are connected to each other through a bus 14. The input / output (I / O) interface 15 is also connected to the bus 14.

[0123] Multiple components in the electronic device 10 are connected to the I / O interface 15, including: an input unit 16, such as a keyboard, a mouse, etc.; an output unit 17, such as various types of displays, speakers, etc.; a storage unit 18, such as a magnetic disk, an optical disk, etc.; and a communication unit 19, such as a network card, a modem, a wireless communication transceiver, etc. The communication unit 19 allows the electronic device 10 to exchange information / data with other devices through a computer network such as the Internet and / or various telecommunication networks.

[0124] The processor 11 may be various general-purpose and / or special-purpose processing components with processing and computing capabilities. Some examples of the processor 11 include, but are not limited to, a central processing unit (CPU), a graphics processing unit (GPU), various dedicated artificial intelligence (AI) computing chips, various processors running machine learning model algorithms, a digital signal processor (DSP), and any suitable processor, controller, microcontroller, etc. The processor 11 executes the various methods and processes described above, such as the basic electricity charge processing method.

[0125] In some embodiments, the basic electricity charge processing method may be implemented as a computer program tangibly embodied in a computer-readable storage medium, such as the storage unit 18. In some embodiments, part or all of the computer program may be loaded and / or installed onto the electronic device 10 via the ROM 12 and / or the communication unit 19. When the computer program is loaded into the RAM 13 and executed by the processor 11, one or more steps of the basic electricity charge processing method described above may be executed. Alternatively, in other embodiments, the processor 11 may be configured to execute the basic electricity charge processing method by any other suitable means (e.g., by means of firmware).

[0126] Various embodiments of the systems and techniques described above herein can be implemented in digital electronic circuitry, integrated circuit systems, field programmable gate arrays (FPGA), application specific integrated circuits (ASIC), application specific standard products (ASSP), systems on a chip (SOC), complex programmable logic devices (CPLD), computer hardware, firmware, software, and / or combinations thereof. These various embodiments can include: implemented in one or more computer programs that can be executed and / or interpreted on a programmable system including at least one programmable processor, which can be a special-purpose or general-purpose programmable processor that can receive data and instructions from a storage system, at least one input device, and at least one output device, and transmit the data and instructions to the storage system, the at least one input device, and the at least one output device.

[0127] The computer program for implementing the method of the present invention can be written in any combination of one or more programming languages. These computer programs can be provided to the processor of a general-purpose computer, a special-purpose computer, or other programmable data processing device, such that when the computer program is executed by the processor, the functions / operations specified in the flowchart and / or block diagram are implemented. The computer program can be executed entirely on the machine, partially on the machine, as a stand-alone software package partially on the machine and partially on a remote machine, or entirely on a remote machine or server.

[0128] In the context of the present invention, a computer-readable storage medium can be a tangible medium that can contain or store a computer program for use by or in connection with an instruction execution system, apparatus, or device. The computer-readable storage medium can include, but is not limited to, electronic, magnetic, optical, electromagnetic, infrared, or semiconductor systems, apparatus, or devices, or any suitable combination of the foregoing. Alternatively, the computer-readable storage medium can be a machine-readable signal medium. More specific examples of the machine-readable storage medium would include an electrical connection based on 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 disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

[0129] To provide for interaction with a user, the systems and techniques described herein can be implemented on an electronic device having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to the user; and a keyboard and a pointing device (e.g., a mouse or a trackball) by which the user can provide input to the electronic device. Other kinds of devices can also be used to provide for interaction with the user; for example, feedback provided to the user can be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user can be received in any form (including acoustic, speech, or tactile input).

[0130] The systems and techniques described herein can be implemented in a computing system that includes backend components (e.g., as a data server), or a computing system that includes middleware components (e.g., an application server), or a computing system that includes frontend components (e.g., a user computer having a graphical user interface or a web browser through which the user can interact with an implementation of the systems and techniques described herein), or a computing system that includes any combination of such backend components, middleware components, or frontend components. The components of the system can be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: a local area network (LAN), a wide area network (WAN), a blockchain network, and the Internet.

[0131] A computing system may include a client and a server. The client and the server are generally far from each other and usually interact via a communication network. The relationship between the client and the server is created by computer programs that run on respective computers and have a client-server relationship with each other. The server can be a cloud server, also known as a cloud computing server or a cloud host, which is a host product in the cloud computing service system, solving the defects of difficult management and weak business scalability existing in traditional physical hosts and VPS services.

[0132] It should be understood that various forms of the processes shown above can be used, with steps reordered, added, or deleted. For example, the steps recited in the present invention can be executed in parallel, sequentially, or in a different order, as long as the desired results of the technical solution of the present invention can be achieved, and no limitation is made herein.

[0133] The above specific embodiments do not constitute a limitation on the protection scope of the present invention. Those skilled in the art should understand that various modifications, combinations, sub-combinations, and substitutions can be made according to design requirements and other factors. Any modifications, equivalent substitutions, and improvements made within the spirit and principles of the present invention shall be included within the protection scope of the present invention.

Claims

1. A basic electricity fee processing method, characterized in that: include: Create a database and register at least one data table; The acquired abnormal record data of this period are stored in each of the data tables according to the column names in the data table, wherein the abnormal record data of this period is data related to the basic electricity fee of this period; Connect the abnormal record data of the current period in each of the data tables, screen the connected data, and include the screened data in the key review list; Processing the data in the key review list; The filtering of the connected data includes: If the basic electricity fee fluctuation rate for this period is greater than the first set threshold, the connected data is screened according to the billing mark and the service category, wherein the billing mark refers to the transformer capacity or the maximum demand, and the service category refers to the category of the represented service; The screening of the connected data according to the charging mark and the service category includes: When the billing mark is a preset mark and the business category is not a preset category, the abnormal record data of the current period in which the number of electricity consumption days in the current period is the set number of days, or the abnormal record data of the current period in which the initial electricity price fluctuation rate is greater than the second set threshold value is included in the key review list, and the data included in the key review list is marked as the first abnormal type, wherein the initial electricity price fluctuation rate is determined based on the basic electricity price of the previous period, the set number of days and the number of electricity consumption days in the current period.

2. The method according to claim 1, characterized in that The filtering of the connected data includes: If the fluctuation rate of the basic electricity charge for this period is less than or equal to the first set threshold, the connected data is screened according to the basic electricity charge for this period and the basic electricity charge for the previous period.

3. The method according to claim 2, characterized in that The screening of the connected data according to the basic electricity fee of the current period and the basic electricity fee of the previous period includes: If the basic electricity fee for the current period is not zero and the basic electricity fee for the previous period is zero, the abnormal record data for the current period whose billing mark is a preset mark and whose business category is not a preset category is included in the key review list, and the data included in the key review list is marked as the second abnormal type, wherein the billing mark refers to the transformer capacity or the maximum demand, and the business category refers to the category of the represented business; If the basic electricity fee for this period is zero and the basic electricity fee for the previous period is not zero, the abnormal record data for this period will be screened based on the power-adjusting electricity fee for this period and the power-adjusting electricity fee for the previous period.

4. The method according to claim 3, characterized in that The screening of abnormal record data of this period according to the power regulation electricity fee of this period and the power regulation electricity fee of the previous period includes: The abnormal record data of this period in which the power regulation electricity fee of this period is not zero, the power regulation electricity fee of the previous period is zero, and the power regulation standard is not equal to the power factor of the previous period is included in the key review list, and the data included in the key review list is marked as the third abnormal type.

5. The method according to claim 1, characterized in that After processing the data in the key review list, it also includes: Move the abnormal record data of this period to the historical data table.

6. A basic electricity fee processing device, characterized in that: include: A registration module, used to establish a database and register at least one data table; A data storage module, used to store the acquired abnormal record data of this period into each of the data tables according to the column names in the data table, wherein the abnormal record data of this period is data related to the basic electricity fee of this period; A screening module is used to connect the abnormal record data of the current period in each of the data tables, screen the connected data, and include the screened data in the key review list; A processing module, used for processing the data in the key review list; The screening module comprises: A first screening unit is used to screen the connected data according to a billing mark and a service category if the fluctuation rate of the basic electricity charge for this period is greater than a first set threshold, wherein the billing mark refers to transformer capacity or maximum demand, and the service category refers to the category of the represented service; The first screening unit is specifically used for: When the billing mark is a preset mark and the business category is not a preset category, the abnormal record data of the current period in which the number of electricity consumption days in the current period is the set number of days, or the abnormal record data of the current period in which the initial electricity price fluctuation rate is greater than the second set threshold value is included in the key review list, and the data included in the key review list is marked as the first abnormal type, wherein the initial electricity price fluctuation rate is determined based on the basic electricity price of the previous period, the set number of days and the number of electricity consumption days in the current period.

7. An electronic device, characterized in that: The electronic device comprises: at least one processor; and a memory communicatively connected to the at least one processor; wherein, The memory stores a computer program executable by the at least one processor, and the computer program is executed by the at least one processor so that the at least one processor can perform the basic electricity fee processing method according to any one of claims 1 to 5.

8. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores computer instructions, and the computer instructions are used to enable a processor to implement the basic electricity fee processing method according to any one of claims 1 to 5 when executed.

Images