CN113283772A - Electric power marketing inspection business rule analysis and application method - Google Patents
Electric power marketing inspection business rule analysis and application method Download PDFInfo
- Publication number
- CN113283772A CN113283772A CN202110623669.6A CN202110623669A CN113283772A CN 113283772 A CN113283772 A CN 113283772A CN 202110623669 A CN202110623669 A CN 202110623669A CN 113283772 A CN113283772 A CN 113283772A
- Authority
- CN
- China
- Prior art keywords
- rule
- inspection
- data
- business
- management
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000007689 inspection Methods 0.000 title claims abstract description 145
- 238000000034 method Methods 0.000 title claims abstract description 51
- 238000004458 analytical method Methods 0.000 title claims abstract description 27
- 230000002159 abnormal effect Effects 0.000 claims abstract description 62
- 238000007726 management method Methods 0.000 claims description 55
- 230000010354 integration Effects 0.000 claims description 14
- 238000005259 measurement Methods 0.000 claims description 12
- 238000003860 storage Methods 0.000 claims description 12
- 238000007405 data analysis Methods 0.000 claims description 10
- 238000005457 optimization Methods 0.000 claims description 10
- 238000012550 audit Methods 0.000 claims description 9
- 230000005611 electricity Effects 0.000 claims description 9
- 230000008859 change Effects 0.000 claims description 7
- 238000009826 distribution Methods 0.000 claims description 7
- 238000013523 data management Methods 0.000 claims description 6
- 238000004519 manufacturing process Methods 0.000 claims description 6
- 238000012545 processing Methods 0.000 claims description 6
- 238000005070 sampling Methods 0.000 claims description 6
- 238000012795 verification Methods 0.000 claims description 6
- 238000005192 partition Methods 0.000 claims description 5
- 238000012423 maintenance Methods 0.000 claims description 4
- 238000012163 sequencing technique Methods 0.000 claims description 4
- 238000004140 cleaning Methods 0.000 claims description 3
- 238000000605 extraction Methods 0.000 claims description 3
- 238000012544 monitoring process Methods 0.000 claims description 3
- 230000009466 transformation Effects 0.000 claims description 3
- 238000011161 development Methods 0.000 abstract description 2
- 230000008569 process Effects 0.000 description 4
- 239000000284 extract Substances 0.000 description 3
- 238000012216 screening Methods 0.000 description 3
- 230000009286 beneficial effect Effects 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 239000007787 solid Substances 0.000 description 2
- 235000010627 Phaseolus vulgaris Nutrition 0.000 description 1
- 244000046052 Phaseolus vulgaris Species 0.000 description 1
- 238000013075 data extraction Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000002349 favourable effect Effects 0.000 description 1
- 238000007670 refining Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0639—Performance analysis of employees; Performance analysis of enterprise or organisation operations
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24564—Applying rules; Deductive queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/06—Energy or water supply
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Theoretical Computer Science (AREA)
- Economics (AREA)
- Strategic Management (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Tourism & Hospitality (AREA)
- Health & Medical Sciences (AREA)
- Marketing (AREA)
- Development Economics (AREA)
- Educational Administration (AREA)
- Entrepreneurship & Innovation (AREA)
- General Business, Economics & Management (AREA)
- Game Theory and Decision Science (AREA)
- Quality & Reliability (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Operations Research (AREA)
- Public Health (AREA)
- Water Supply & Treatment (AREA)
- General Health & Medical Sciences (AREA)
- Primary Health Care (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The application discloses a power marketing inspection business rule analysis application method, which comprises the following steps: respectively carrying out online informationized management on the power marketing inspection business rules according to the major; carrying out rule numbering management on the power marketing inspection business rules; managing the rule version number of the power marketing inspection business rule; performing exception type management on the power marketing inspection business rule; performing logic SQL management on the power marketing inspection business rules according to the business needs and the abnormal categories; performing dynamic configuration and display of a business rule abnormal data sample display interface based on logic SQL for inspecting business rules; by adopting a cloud platform timing scheduling mode, abnormal data samples of the inspection business rules are integrated, updated and optimized based on the cloud platform, the inspection business rules are managed in a standardized and precise mode, the working time of online inspectors is greatly reduced, the development cost is reduced, and the online inspection working quality and efficiency are improved.
Description
Technical Field
The application relates to the technical field of electric power marketing inspection, in particular to an electric power marketing inspection business rule analysis application method.
Background
In order to enhance the operation capability of a power grid and expand the service capability and quality of power customers, massive abnormal data from distribution network equipment needs to be efficiently and quickly acquired, the abnormal sample data is effectively identified and filtered by combining business system data such as marketing, production, scheduling and GIS (geographic information system), and the extracted abnormal data is sent to each power supply unit and enterprise for abnormal data rectification. And finally outputting related data which is beneficial to power operation and improves the service quality and service level of customers through an online inspection mode.
The traditional inspection means mainly extracts a certain amount of service samples by a random sampling method, inspectors check related equipment, service forms, service files and the like on site, and accordingly the working condition of an inspected object is evaluated according to inspection results. Although the random sampling method reflects the working level of the inspected object objectively, it is not favorable for the inspection and modification of some main risk points and typical problems in the system service, and meanwhile, because of the traditional way of manual operation, the method has the problems of low efficiency, easy error and the like.
Disclosure of Invention
The application provides an electric power marketing inspection business rule analysis application method, which aims to solve the problems of low efficiency and high error probability in the prior art that an inspection means mainly extracts a certain number of business samples by a manual random sampling method.
The technical scheme adopted by the application is as follows:
a power marketing inspection business rule analysis application method comprises the following steps:
respectively carrying out online informationized management on the power marketing inspection business rules according to the major;
the method comprises the following steps of carrying out rule numbering management on power marketing inspection business rules, and carrying out source tracing, tracking, maintenance, verification and statistics on rule sample data;
the method comprises the following steps of carrying out rule version number management on electric marketing inspection business rules, managing historical configuration information of the inspection business rules, and carrying out backup processing aiming at updating and changing of the inspection business rules;
the power marketing inspection business rules are subjected to exception type management, and the exception type management is used for performing detailed management on exception of the business rules, so that sample data analysis and presentation of the rules are facilitated;
performing logic SQL management on the power marketing inspection business rules according to the business needs and the abnormal categories;
performing dynamic configuration and display of a business rule abnormal data sample display interface based on logic SQL for inspecting business rules;
and a cloud platform timing scheduling mode is adopted, and the integration updating and the integration optimization of abnormal data samples of the inspection business rules are carried out based on the cloud platform.
Preferably, the online information management of the power marketing inspection business rules according to the specialties respectively comprises:
detailed management is carried out on each specific link of business expansion, reading, checking and accepting, metering, customer service, line loss, power failure and inspection professional according to the power marketing inspection business rule;
wherein the business expansion major is at least subdivided into extracorporeal circulation, pause, basic electricity charge, demand verification and business expansion timeout links; the measurement major is at least subdivided into transformer transformation ratio abnormity, measurement asset, measurement configuration and measurement file links; the inspection using major is at least divided into inspection using plan, capacity increasing, user load and user electric quantity links.
Preferably, the performing rule number management on the power marketing inspection business rule includes:
the rule number generation principle of the inspection business rule is that the system is globally unique, and the rule number is composed of five parts, namely a professional part, an affiliated link, a rule creation unit, a rule creation date and a self-defined self-growth number of the system to which the rule belongs.
Preferably, the specialty of the rule in the rule number is 3-bit number, the affiliated link is 3-bit number, the rule creation unit adopts 2-8-bit number, the rule creation date adopts 8-bit number, and the system self-defines 3-bit self-growth number.
Preferably, the performing of rule version number management on the power marketing inspection business rule includes:
the version number of the power marketing check business rule consists of three parts, namely a storage operation identification bit, a submission operation identification bit and a release operation identification bit;
only updating and changing the storage operation identification bit during storage operation, and keeping other operation bits unchanged;
when the operation is submitted, the submitting operation identification bit is upgraded and changed, the saving operation identification bit is set to be 0, and the issuing operation identification bit is not changed;
and carrying out upgrading change on the issuing operation identification bit during issuing operation, wherein the submitting operation identification bit and the storing operation identification bit are both set to be 0.
Preferably, the performing logic SQL management on the electricity marketing inspection business rules according to the business needs and the exception categories includes:
and performing inspection business rule SQL configuration management according to business needs and the exception type through a rule configuration interface user-defined mode, wherein the inspection business rule SQL configuration management comprises exception statistics SQL, exception summary SQL, exception detail SQL and cloud platform market level SQL management.
Preferably, the self-defining of the inspection business rule SQL configuration management through the rule configuration interface according to the business needs includes:
performing data retrieval, extraction, display, partition query or data analysis according to preset logic combination conditions among the data;
the logical combination condition includes: the determination conditions for the data values themselves are "contained", "not contained", "equal to", "greater than", and "less than".
Preferably, the dynamic configuration and display of the service rule abnormal data sample display interface based on the logical SQL for inspecting the service rules includes:
based on logical SQL of the inspection business rule, SQL dynamic configuration of each level of the inspection business rule is carried out;
generating codes representing attribute information of each hierarchy according to the SQL configuration information of each hierarchy of the inspection business rule and the set rule;
dynamically compiling the code based on the set rule;
and dynamically displaying the compiled abnormal data of the inspection business rules through an inspection business rule abnormal sample display interface.
Preferably, the logic SQL based on the audit business rules dynamically configures and displays a business rule abnormal data sample display interface, and then includes:
after the information configuration and dynamic compilation of the inspection business rule SQL are completed, abnormal data information statistics, summaries and details of the inspection business rule are inquired in real time, and inquiry conditions, sequencing fields and dictionary analysis information are displayed;
if the SQL configuration information of the inspection business rule needs to be adjusted, the compiled configuration information change can be inspected in real time after the custom configuration is carried out and the storage is carried out through the rule configuration interface.
Preferably, the integration updating and the integration optimization of the abnormal data samples of the audit service rules are performed based on the cloud platform by adopting a cloud platform timing scheduling mode, and the method comprises the following steps:
the method comprises the steps that a cloud platform timing scheduling mode is adopted, and user data of an electric power marketing system, a production system, a power distribution data acquisition and monitoring system and an electric energy meter related system are subjected to newly increased or abnormal data sampling, quality analysis and data cleaning in sequence;
respectively constructing a local knowledge map and a data index of each system by using the data processed by each system;
transmitting the data processed by each system, the local knowledge graph and the data index to a data management cloud center through a big data connector;
detecting and eliminating conflicts between the local knowledge maps through the data management cloud center;
constructing a global knowledge graph and a data index suitable for all data according to the local knowledge graph and the data index;
and performing integrated updating and integrated optimization on a data source by using the global knowledge graph and the data index.
The technical scheme of the application has the following beneficial effects:
1. the application provides an electric power marketing inspection business rule analysis application method, which can rapidly make and flexibly configure various professional inspection business rules according to the professions of business expansion, reading, checking and accepting, metering, customer service, line loss, power failure, use inspection and the like. Abnormal data samples in other systems are rapidly screened out according to business rules, such as: and abnormal data samples meeting the inspection business rules are quickly screened out in marketing, production, scheduling, GIS systems and the like, and a solid foundation is laid for further carrying out mass abnormal data retrieval and query and large data analysis of the power distribution network.
2. The method and the system combine actual needs, simply and quickly establish the online inspection business rules, realize multi-professional and multi-dimensional integration inspection business rules and standardized and accurate management inspection business rules, carry out real-time retrieval and screening on massive business data information of the electric power marketing system, analyze and display the screened sample data in the system, enter an inspection business process, carry out related business processing, and realize closed-loop management of the sample data.
Drawings
In order to more clearly explain the technical solution of the present application, the drawings needed to be used in the embodiments will be briefly described below, and it is obvious to those skilled in the art that other drawings can be obtained according to the drawings without creative efforts.
Fig. 1 is a flowchart of an electric power marketing inspection business rule analysis application method of the present application.
Detailed Description
Reference will now be made in detail to embodiments, examples of which are illustrated in the accompanying drawings. The embodiments described in the following examples do not represent all embodiments consistent with the present application. But merely as exemplifications of systems and methods consistent with certain aspects of the application, as recited in the claims.
Referring to fig. 1, a flow chart of a power marketing inspection business rule analysis application method is shown.
The application provides an electric power marketing inspection business rule analysis application method, which comprises the following steps:
the method comprises the following steps of performing online informationized management on electric marketing inspection business rules according to the specialties of business expansion, reading, checking, receiving, metering, customer service, line loss, power failure, use inspection and the like;
the method comprises the following steps of carrying out rule numbering management on power marketing inspection business rules, and carrying out source tracing, tracking, maintenance, verification and statistics on rule sample data;
the method comprises the following steps of carrying out rule version number management on electric marketing inspection business rules, managing historical configuration information of the inspection business rules, and carrying out backup processing aiming at updating and changing of the inspection business rules;
the power marketing inspection business rules are subjected to exception type management, and the exception type management is used for performing detailed management on exception of the business rules, so that sample data analysis and presentation of the rules are facilitated;
performing logic SQL management on the power marketing inspection business rules according to the business needs and the abnormal categories;
performing dynamic configuration and display of a business rule abnormal data sample display interface based on logic SQL for inspecting business rules;
and a cloud platform timing scheduling mode is adopted, and the integration updating and the integration optimization of abnormal data samples of the inspection business rules are carried out based on the cloud platform.
The online informatization management of the business rules of the electric power marketing inspection is respectively carried out according to business expansion, reading, checking, receiving, metering, customer service, line loss, power failure and inspection major, and comprises the following steps:
refining to specific links of each specialty according to the power marketing inspection business rules to carry out fine management;
wherein the business expansion major is at least subdivided into extracorporeal circulation, pause, basic electricity charge, demand verification and business expansion timeout links; the measurement major is at least subdivided into transformer transformation ratio abnormity, measurement asset, measurement configuration and measurement file links; the inspection using major is at least divided into inspection using plan, capacity increasing, user load and user electric quantity links.
The inspection business rule number management can better track, maintain, check, count and the like the rule sample data, because the rule sample number does not have a data uniqueness identifier when the data is extracted on the cloud according to the rule information, one user or a metering point repeatedly appears in a plurality of rules, and at this moment, the rule number needs to be judged from which rule, so that the rule number plays a crucial point, the rule sample data can be traced to the source, the uniqueness identification can be carried out on the abnormal sample data in the follow-up process, and basic auxiliary information can be provided for the follow-up sample data analysis.
The management of the rule number of the power marketing inspection business rule comprises the following steps:
the rule number generation principle of the inspection business rule is that the system is globally unique, and the rule number is composed of five parts, namely a professional part, an affiliated link, a rule creation unit, a rule creation date and a self-defined self-growth number of the system to which the rule belongs.
The speciality of the rule in the rule number is 3-bit number, the belonged link is 3-bit number, the rule creation unit adopts 2-8-bit number, the rule creation date adopts 8-bit number, and the system self-defines 3-bit self-growth number.
The historical configuration information of the business rules can be managed by checking the version number management of the business rules, and backup processing is carried out aiming at the upgrading and updating of the rules and the like. The management of the rule version number of the power marketing inspection business rule comprises the following steps:
the version number of the power marketing check business rule consists of three parts, namely a storage operation identification bit, a submission operation identification bit and a release operation identification bit;
only updating and changing the storage operation identification bit during storage operation, and keeping other operation bits unchanged;
when the operation is submitted, the submitting operation identification bit is upgraded and changed, the saving operation identification bit is set to be 0, and the issuing operation identification bit is not changed;
and carrying out upgrading change on the issuing operation identification bit during issuing operation, wherein the submitting operation identification bit and the storing operation identification bit are both set to be 0.
In the electric power marketing system, a large amount of data exists, but not all the data have the significance of auditing, so that in order to improve operability and efficiency, the key data fields with logic judgment significance need to be configured in a personalized manner by combining daily actual auditing experience, and the data fields are displayed in a personalized manner according to configuration information by subsequent rules. According to business needs, interface elements of each function of rule exception statistics, exception summary and exception detail need to be configured. For example: power supply unit, customer name, electricity consumption number, user state, contract capacity, electricity utilization type, metering mode, meter reading period and the like. In order to realize data inspection according to a self-defined rule, the method also has the functions of data retrieval, data extraction, data display, data partition query (the query speed is improved after abnormal configuration with large data quantity), data analysis and the like according to the logic combination conditions among the data set by an inspector. The specific logic conditions mainly comprise: judging conditions of the data values, such as 'containing', 'not containing', 'equal to', 'greater than', 'less' and the like; therefore, the inspection personnel can flexibly search the logic combination condition and quickly screen abnormal data samples which accord with the logic rules, thereby realizing the personalized customization and flexible configuration of the online inspection business rules.
In order to facilitate the auditors to know the abnormal data sample condition of the rule, the logic SQL management is performed on the electricity marketing audit business rule according to the abnormal class according to the business needs, and the logic SQL management comprises the following steps:
and performing inspection business rule SQL configuration management according to business needs and the exception type through a rule configuration interface user-defined mode, wherein the inspection business rule SQL configuration management comprises exception statistics SQL, exception summary SQL, exception detail SQL and cloud platform market level SQL management.
The method for carrying out inspection business rule SQL configuration management through self-defining a rule configuration interface according to business needs and abnormal categories comprises the following steps:
performing data retrieval, extraction, display, partition query or data analysis according to preset logic combination conditions among the data;
the logical combination condition includes: the determination conditions for the data values themselves are "contained", "not contained", "equal to", "greater than", and "less than".
The logic SQL based on the inspection business rule dynamically configures and displays a business rule abnormal data sample display interface, and comprises the following steps:
based on logical SQL of the inspection business rule, SQL dynamic configuration of each level of the inspection business rule is carried out;
generating codes representing attribute information of each hierarchy according to the SQL configuration information of each hierarchy of the inspection business rule and the set rule;
dynamically compiling the code based on the set rule;
and dynamically displaying the compiled abnormal data of the inspection business rules through an inspection business rule abnormal sample display interface.
The logic SQL based on the inspection business rule dynamically configures and displays a business rule abnormal data sample display interface, and then comprises the following steps:
after the information configuration and dynamic compilation of the inspection business rule SQL are completed, abnormal data information statistics, summaries and details of the inspection business rule are inquired in real time, and inquiry conditions, sequencing fields and dictionary analysis information are displayed;
if the SQL configuration information of the inspection business rule needs to be adjusted, the compiled configuration information change can be inspected in real time after the custom configuration is carried out and the storage is carried out through the rule configuration interface.
When the configuration of the inspection business rule SQL is completed, the system developer and the system operation and maintenance personnel configure SQL related information, and the attribute information of the inspection business rule is formatted by one key through the configured SQL of each level of the inspection business rule, including information such as attribute field names, attribute Chinese names, whether to display, whether to analyze dictionaries, partition query identifiers and the like, for example: gddwbm is an attribute field name, a Chinese name is a power supply unit code, then whether the field needs field analysis or not can be configured, if the field is configured to be dictionary analysis, a dictionary table analysis identifier is selected, and finally the field in the interface is displayed as analyzed information which is the power supply unit name. And generating related codes according to the SQL configuration information, and finally generating necessary codes for program operation such as entity, view, controller, service, dao, mybatis and the like by the SQL configuration of each level. And then, carrying out the next operation to realize the dynamic compiling of the codes.
And dynamically compiling the codes according to the rule codes generated by each level of the inspection business rule. The generated code is defaulted to be java or jsp suffix code which can not be operated by a computer and can be operated after being compiled, the compiled file is class suffix, the file can be added into a program operation memory link, the compiled Bean is managed through a spring container, and information such as 'configured and obtained' dynamic display inspection service rule abnormal data is finally realized.
After the configuration and dynamic compilation of the SQL information of the audit service rules are completed, the auditor can query and retrieve the statistics, summary, detail and other information of the abnormal data information of the audit service rules in real time, and the information of query and retrieval conditions, sequencing fields, dictionary analysis and the like is displayed. If the inspector needs to simply adjust the information of display, dictionary analysis and the like of some field attributes, the compiled change can be checked in real time through the interface after the user-defined flexible configuration of the rule configuration interface is stored, so that the inspector can conveniently shield the field which is not needed or adjust the dictionary analysis content, and the efficiency of the inspection service is improved.
And maintaining and updating abnormal data sample exchange of the global inspection business rule in a cloud platform timing scheduling mode. Abnormal data sample analysis and management of cross-system inspection business rules are achieved based on the cloud platform, and therefore abnormal data sample centralized management of the inspection business rules is achieved. When the related data of some inspection business rule entity needs to be inquired, the corresponding inspection business rule and the rule detail are inquired, so that the stage of the abnormal data sample information of the inspection business rule and the modification process of the abnormal data can be inquired, and the abnormal data sample integration of the inspection business rule in each information system is realized.
The method for performing the integration updating and the integration optimization of the abnormal data samples of the inspection business rules based on the cloud platform by adopting the cloud platform timing scheduling mode comprises the following steps:
by adopting a cloud platform timing scheduling mode, unstructured data such as user voice, pictures, texts and the like of an electric power marketing system, a production system, a power distribution data acquisition and monitoring system and an electric energy meter related system are subjected to newly-added or abnormal data sampling, quality analysis and data cleaning treatment in sequence through a data acquisition unit;
respectively constructing a local knowledge map and a data index of each system by using the data processed by each system;
transmitting the data processed by each system, the local knowledge graph and the data index to a data management cloud center through a big data connector;
detecting and eliminating conflicts between the local knowledge maps through the data management cloud center;
constructing a global knowledge graph and a data index suitable for all data according to the local knowledge graph and the data index;
and performing integrated updating and integrated optimization on a data source by using the global knowledge graph and the data index.
The abnormal sample data of the overall inspection business rule come from a plurality of systems, such as a marketing system, a scheduling system, a GIS system and the like, and the method has practical significance. The method has a strong abnormal screening effect on the distribution network data, adopts global and local inspection business rules to make, quickly defines and extracts abnormal data samples of the newly added inspection business rules, improves the speed and accuracy of the integration of the newly added inspection business rules, and realizes the optimization of the integration of the abnormal data samples of the inspection business rules.
The method can rapidly make and flexibly configure various professional audit business rules according to the professions of business expansion, reading, checking and accepting, metering, customer service, line loss, power failure, use inspection and the like. Abnormal data samples in other systems are rapidly screened out according to business rules, such as: and abnormal data samples meeting the inspection business rules are quickly screened out in marketing, production, scheduling, GIS systems and the like, and a solid foundation is laid for further carrying out mass abnormal data retrieval and query and large data analysis of the power distribution network.
The method and the system combine actual needs, simply and quickly establish online inspection business rules, conduct real-time retrieval and screening on massive business data information of the electric power marketing system, analyze and display screened sample data in the system, enter an inspection business process, conduct related business processing, achieve closed-loop management of the sample data, greatly reduce working time of online inspectors and IT technical personnel, reduce development cost, and have very important significance for expanding electric power marketing inspection technical means and improving working quality and efficiency.
The embodiments provided in the present application are only a few examples of the general concept of the present application, and do not limit the scope of the present application. Any other embodiments extended according to the scheme of the present application without inventive efforts will be within the scope of protection of the present application for a person skilled in the art.
Claims (10)
1. A power marketing inspection business rule analysis application method is characterized by comprising the following steps:
respectively carrying out online informationized management on the power marketing inspection business rules according to the major;
the method comprises the following steps of carrying out rule numbering management on power marketing inspection business rules, and carrying out source tracing, tracking, maintenance, verification and statistics on rule sample data;
the method comprises the following steps of carrying out rule version number management on electric marketing inspection business rules, managing historical configuration information of the inspection business rules, and carrying out backup processing aiming at updating and changing of the inspection business rules;
the power marketing inspection business rules are subjected to exception type management, and the exception type management is used for performing detailed management on exception of the business rules, so that sample data analysis and presentation of the rules are facilitated;
performing logic SQL management on the power marketing inspection business rules according to the business needs and the abnormal categories;
performing dynamic configuration and display of a business rule abnormal data sample display interface based on logic SQL for inspecting business rules;
and a cloud platform timing scheduling mode is adopted, and the integration updating and the integration optimization of abnormal data samples of the inspection business rules are carried out based on the cloud platform.
2. The method as claimed in claim 1, wherein the online information management of the power marketing check business rules according to their respective specialities comprises:
detailed management is carried out on each specific link of business expansion, reading, checking and accepting, metering, customer service, line loss, power failure and inspection professional according to the power marketing inspection business rule;
wherein the business expansion major is at least subdivided into extracorporeal circulation, pause, basic electricity charge, demand verification and business expansion timeout links; the measurement major is at least subdivided into transformer transformation ratio abnormity, measurement asset, measurement configuration and measurement file links; the inspection using major is at least divided into inspection using plan, capacity increasing, user load and user electric quantity links.
3. The method as claimed in claim 1, wherein the performing rule number management on the power marketing audit business rules comprises:
the rule number generation principle of the inspection business rule is that the system is globally unique, and the rule number is composed of five parts, namely a professional part, an affiliated link, a rule creation unit, a rule creation date and a self-defined self-growth number of the system to which the rule belongs.
4. The method as claimed in claim 3, wherein the rule in the rule number is 3-bit number, the link is 3-bit number, the rule creation unit is 2-8-bit number, the rule creation date is 8-bit number, and the system self-defined 3-bit self-increment number.
5. The method as claimed in claim 1, wherein the managing of the rule version number of the power marketing audit business rule comprises:
the version number of the power marketing check business rule consists of three parts, namely a storage operation identification bit, a submission operation identification bit and a release operation identification bit;
only updating and changing the storage operation identification bit during storage operation, and keeping other operation bits unchanged;
when the operation is submitted, the submitting operation identification bit is upgraded and changed, the saving operation identification bit is set to be 0, and the issuing operation identification bit is not changed;
and carrying out upgrading change on the issuing operation identification bit during issuing operation, wherein the submitting operation identification bit and the storing operation identification bit are both set to be 0.
6. The method as claimed in claim 1, wherein the performing logic SQL management on the power marketing check business rules according to the abnormal category according to business needs comprises:
and performing inspection business rule SQL configuration management according to business needs and the exception type through a rule configuration interface user-defined mode, wherein the inspection business rule SQL configuration management comprises exception statistics SQL, exception summary SQL, exception detail SQL and cloud platform market level SQL management.
7. The method as claimed in claim 6, wherein the service rule analysis application method for electric marketing inspection is implemented through a rule configuration interface to perform customized inspection service rule SQL configuration management according to the service requirement and the exception category, and includes the following steps:
performing data retrieval, extraction, display, partition query or data analysis according to preset logic combination conditions among the data;
the logical combination condition includes: the determination conditions for the data values themselves are "contained", "not contained", "equal to", "greater than", and "less than".
8. The method as claimed in claim 6, wherein the service rule analysis application method for electricity marketing inspection is characterized in that the service rule abnormal data sample display interface dynamic configuration and display based on the logic SQL for inspecting service rules comprises:
based on logical SQL of the inspection business rule, SQL dynamic configuration of each level of the inspection business rule is carried out;
generating codes representing attribute information of each hierarchy according to the SQL configuration information of each hierarchy of the inspection business rule and the set rule;
dynamically compiling the code based on the set rule;
and dynamically displaying the compiled abnormal data of the inspection business rules through an inspection business rule abnormal sample display interface.
9. The method as claimed in claim 8, wherein the service rule analysis application method for electricity marketing inspection is characterized in that the service rule abnormal data sample display interface is dynamically configured and displayed based on the logic SQL for inspecting service rules, and then the method comprises:
after the information configuration and dynamic compilation of the inspection business rule SQL are completed, abnormal data information statistics, summaries and details of the inspection business rule are inquired in real time, and inquiry conditions, sequencing fields and dictionary analysis information are displayed;
if the SQL configuration information of the inspection business rule needs to be adjusted, the compiled configuration information change can be inspected in real time after the custom configuration is carried out and the storage is carried out through the rule configuration interface.
10. The method as claimed in claim 1, wherein the performing of the integrated updating and the integrated optimization of the abnormal data samples of the audit business rules based on the cloud platform by using the cloud platform timing scheduling manner includes:
the method comprises the steps that a cloud platform timing scheduling mode is adopted, and user data of an electric power marketing system, a production system, a power distribution data acquisition and monitoring system and an electric energy meter related system are subjected to newly increased or abnormal data sampling, quality analysis and data cleaning in sequence;
respectively constructing a local knowledge map and a data index of each system by using the data processed by each system;
transmitting the data processed by each system, the local knowledge graph and the data index to a data management cloud center through a big data connector;
detecting and eliminating conflicts between the local knowledge maps through the data management cloud center;
constructing a global knowledge graph and a data index suitable for all data according to the local knowledge graph and the data index;
and performing integrated updating and integrated optimization on a data source by using the global knowledge graph and the data index.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110623669.6A CN113283772A (en) | 2021-06-04 | 2021-06-04 | Electric power marketing inspection business rule analysis and application method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110623669.6A CN113283772A (en) | 2021-06-04 | 2021-06-04 | Electric power marketing inspection business rule analysis and application method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113283772A true CN113283772A (en) | 2021-08-20 |
Family
ID=77283451
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110623669.6A Pending CN113283772A (en) | 2021-06-04 | 2021-06-04 | Electric power marketing inspection business rule analysis and application method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113283772A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113821540A (en) * | 2021-09-23 | 2021-12-21 | 江苏方天电力技术有限公司 | Method and device for implementing electricity utilization abnormity study and judgment based on rule engine |
| CN114638729A (en) * | 2022-05-18 | 2022-06-17 | 国网浙江省电力有限公司 | Electric power inspection method of double-middlebox architecture based on energy internet marketing service |
| CN114647743A (en) * | 2022-05-20 | 2022-06-21 | 国网浙江省电力有限公司 | Power marketing full-service access control rule map generation and processing method and device |
| CN115081747A (en) * | 2022-07-27 | 2022-09-20 | 国网浙江省电力有限公司 | Data processing method based on knowledge graph technology |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106022617A (en) * | 2016-05-24 | 2016-10-12 | 国网浙江省电力公司 | Inspection control system based on marketing multi-system data center |
| CN110543483A (en) * | 2019-08-30 | 2019-12-06 | 北京百分点信息科技有限公司 | Data auditing method and device and electronic equipment |
| CN112434924A (en) * | 2020-11-18 | 2021-03-02 | 刘凤 | Risk inspection monitoring platform based on cloud platform under full-electric-network multi-source data |
| CN114297334A (en) * | 2021-12-28 | 2022-04-08 | 北京金山数字娱乐科技有限公司 | Index creating method and device based on knowledge graph |
-
2021
- 2021-06-04 CN CN202110623669.6A patent/CN113283772A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106022617A (en) * | 2016-05-24 | 2016-10-12 | 国网浙江省电力公司 | Inspection control system based on marketing multi-system data center |
| CN110543483A (en) * | 2019-08-30 | 2019-12-06 | 北京百分点信息科技有限公司 | Data auditing method and device and electronic equipment |
| CN112434924A (en) * | 2020-11-18 | 2021-03-02 | 刘凤 | Risk inspection monitoring platform based on cloud platform under full-electric-network multi-source data |
| CN114297334A (en) * | 2021-12-28 | 2022-04-08 | 北京金山数字娱乐科技有限公司 | Index creating method and device based on knowledge graph |
Non-Patent Citations (2)
| Title |
|---|
| 张卓: "电力营销管理系统稽查平台的设计与实现", 《中国优秀博硕士学位论文全文数据库(硕士)•信息科技辑》 * |
| 肖传炜: "基于数据融合分析实现在线智能稽查的探讨", 《机电信息》 * |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113821540A (en) * | 2021-09-23 | 2021-12-21 | 江苏方天电力技术有限公司 | Method and device for implementing electricity utilization abnormity study and judgment based on rule engine |
| CN114638729A (en) * | 2022-05-18 | 2022-06-17 | 国网浙江省电力有限公司 | Electric power inspection method of double-middlebox architecture based on energy internet marketing service |
| CN114638729B (en) * | 2022-05-18 | 2022-08-02 | 国网浙江省电力有限公司 | Electric power inspection method of double-middling platform architecture based on energy internet marketing service |
| CN114647743A (en) * | 2022-05-20 | 2022-06-21 | 国网浙江省电力有限公司 | Power marketing full-service access control rule map generation and processing method and device |
| CN114647743B (en) * | 2022-05-20 | 2022-08-26 | 国网浙江省电力有限公司 | Method and device for generating and processing power marketing full-service access control rule map |
| CN115081747A (en) * | 2022-07-27 | 2022-09-20 | 国网浙江省电力有限公司 | Data processing method based on knowledge graph technology |
| CN115081747B (en) * | 2022-07-27 | 2022-11-11 | 国网浙江省电力有限公司 | Data processing method based on knowledge graph technology |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN113283772A (en) | Electric power marketing inspection business rule analysis and application method | |
| US11366829B2 (en) | System and method for analysis and management of data distribution in a distributed database environment | |
| CN111104394A (en) | Energy data warehouse system construction method and device | |
| CN105868373B (en) | Method and device for processing key data of power business information system | |
| CN111159157B (en) | Index processing method and device for enterprise report data | |
| CN109002391A (en) | The method of automatic detection embedded software interface testing data | |
| CN111563103B (en) | Method and system for detecting data blood relationship | |
| CN111259040B (en) | SQL statement auditing method and system | |
| CN111125068A (en) | Metadata management method and system | |
| CN111612294A (en) | City physical examination system based on space-time big data | |
| CN114398669A (en) | Joint credit scoring method and device based on privacy protection calculation and cross-organization | |
| CN111833018A (en) | Patent analysis method and system for science and technology project | |
| CN114880405A (en) | Data lake-based data processing method and system | |
| CN111311173A (en) | National county level unit economic arrangement and spatialization method | |
| CN113590607A (en) | Electric power marketing report realization method and system based on report factor | |
| US11227288B1 (en) | Systems and methods for integration of disparate data feeds for unified data monitoring | |
| CN115599679A (en) | Test rule base updating method and device, electronic equipment and storage medium | |
| Negahban | Network analysis and scientific mapping of the field of e-learning in Iran | |
| CN114860737A (en) | Processing method, device, equipment and medium of teaching and research data | |
| CN112416904A (en) | Electric power data standardization processing method and device | |
| CN112003369A (en) | Cloud platform based power grid automation equipment operation monitoring and statistical analysis method | |
| CN112465364B (en) | Management system for index library | |
| CN117235480B (en) | Screening method and system based on big data under data processing | |
| CN114297729A (en) | Auditing method, system and related device for configuration management database | |
| CN115760012A (en) | Method and device for processing homeland change data |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210820 |
|
| RJ01 | Rejection of invention patent application after publication |