Quality management and control method for electricity transaction data warehouses and management and control system thereof

A data warehouse and power transaction technology, applied in the fields of electrical digital data processing, data processing applications, special data processing applications, etc., can solve the control, verification rules and verification that cannot meet the free customization of business personnel and do not consider quality issues Logic solidification and other problems to achieve the effect of promoting subjective initiative, shortening processing time, and realizing tracking and assessment

Inactive Publication Date: 2015-07-08
STATE GRID CORP OF CHINA +4
View PDF6 Cites 31 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The quality control tools of existing information systems are generally tailored for a certain application, and it is difficult to exist independently without business data
Its verification rules and verification logic are also relatively fixed, which cannot meet the needs of free customization by business personnel
In addition, the results of data verification lack the function of active release and notification, and there is no feedback and tracking of problem solving links. The quality monitoring of data is partially realized, and the control of quality problems is hardly considered.

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Quality management and control method for electricity transaction data warehouses and management and control system thereof
  • Quality management and control method for electricity transaction data warehouses and management and control system thereof
  • Quality management and control method for electricity transaction data warehouses and management and control system thereof

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0050] 1. Define the metadata information of the data item for the rationality verification of the data. Metadata information includes the settings of parameters such as "whether to allow null", "whether to allow zero", "maximum value", "minimum value", and "menu range". Define the metadata of the dataset, including parameters such as "data frequency" and "time format" for timeliness verification, and parameters for "dataset maintainer" for message release.

[0051] Table 1 Extended metadata definition of data item

[0052]

[0053] 2. Define the verification rules. Link dynamic query statements through operators. Provide a data warehouse model selector, based on the database table domain name technology, to realize the selection of data sets and data items. Provide operators and function selectors, operators include conventional mathematical operators, and functions provide common database syntax keywords, such as "summation (", "grouping (", etc. After the expression e...

example 1

[0054] Example 1: On-grid electricity of power plants. One piece of data every 15 minutes, one power plant should have 96 pieces of data in one day. The validation rules are expressed as:

[0055] HAVING(D.v1)=96

[0056] GROUP BY(to_char(D.t,'yyyymmdd'),D.p,D.a)

example 2

[0057] Example 2: The total amount of online electricity in each period is equal to the sum of the online electricity in each period.

[0058] D.v1=D.v2+D.v3+D.v4+D.v5

[0059] where D.t=:param and D.a='Gateway port power'

[0060] Explanation: D represents the data set, v1 represents the total power of the data item, v2 represents the peak power of the data item, v3 represents the peak power of the data item, v4 represents the average power of the data item, and v5 represents the valley power of the data item. The time primary key of the data set in the condition is passed in when the verification task is executed, and the application dimension primary key of the data set is "gateway port power".

[0061] 3. Define the timeliness time expression. Set the timeliness check time expression according to the fixed format. The format specification of the expression is as follows:

[0062] Table 2 Explanation of timeliness time format

[0063]

[0064] Examples of timeliness...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention relates to a quality management and control method for electricity transaction data warehouses and a management and control system thereof. The method comprises the following steps: defining checking metadata and checking rules; setting checking tasks; performing checking service; releasing a data checking result; and handling and tracking quality problems. According to the technical scheme of the invention, the rationality, consistency, integrality and timeliness of data are judged by aiming at a data set and through flexible definition of the checking rules, statistical and historical trend analysis is made on four management and control indicators, and a problem handling and tracking feedback mechanism is designed to facilitate quality control measure formulation by management personnel. After implementation, the system, as an important part of an electricity market data warehouse, provides a data quality guarantee for advanced analysis and mining application of the market.

Description

technical field [0001] The invention relates to a data quality control method and a system thereof in the field of electric power automation, in particular to a quality control method and a control system for a power trading data warehouse. Background technique [0002] With the construction of the smart grid and the development of the electricity market, the positioning of the transaction operation system has evolved from the original information management to transaction control and business decision-making. The system has been in operation for many years, and the accumulated massive data has become an important resource for the company to conduct market strategy analysis. Based on data warehouse technology, build an electricity market analysis system to support advanced applications such as transaction management and control, market auxiliary decision-making, and market situation analysis. Among them, high-quality data is a prerequisite for supporting applications such a...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06Q10/06G06Q10/10G06Q50/06G06F17/30
Inventor 郭艳敏耿建龙苏岩邵平郑亚先薛必克程海花王高琴吕建虎赵彤张显张文哲徐骏黄春波史述红叶飞
Owner STATE GRID CORP OF CHINA
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap