Unlock instant, AI-driven research and patent intelligence for your innovation.

A data mart layer table establishment method based on power grid energy data

A technology for data marts and establishment methods, which is applied in the field of data processing, can solve problems such as low data processing efficiency, and achieve the effect of improving data processing efficiency

Active Publication Date: 2021-12-07
STATE GRID ZHEJIANG ELECTRIC POWER +1
View PDF7 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] Aiming at the problem of low data processing efficiency caused by repeated processing of similar information in the prior art, the present invention provides a method for establishing a data mart layer table based on power grid energy data. By judging the entity repetition degree and the relationship repetition degree in the early stage of the task, And summarize it into a comprehensive repetition degree to identify and delete requests with similar content, avoid creating data mart layer tables with high repetition, prevent waste of computing resources, and improve data processing efficiency

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
  • A data mart layer table establishment method based on power grid energy data
  • A data mart layer table establishment method based on power grid energy data

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0029] A method for establishing a data mart layer table based on power grid energy data, such as figure 1 shown, including the following steps:

[0030] S01: Establish a logic estimation model for the received data mart layer table generation request, and conduct a comprehensive repeatability check on the logic estimation model between different requests. If the logic estimation model repeatability between several requests is higher than the setting threshold, one of the requests is retained and the rest are deleted. Among them, the data mart layer table generation request is sent by the user terminal or user module of each department, and the server in the data center receives the corresponding request and performs comprehensive repetition check and follow-up work.

[0031] The establishment process of the logical estimation model includes: randomly dividing the logical entities involved in the data mart layer table generation request into two groups, traversing and recordi...

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 discloses a method for establishing a data mart layer table based on power grid energy data, comprising the following steps: S01 : establishing a logic prediction model for a received data mart layer table generation request, and predicting the logic between different requests The evaluation model is used to comprehensively check the repetition degree. If the repetition degree of the logical prediction model between several requests is higher than the set threshold, one of the requests will be retained, and the other requests will be deleted; S02: For the requests that have not been deleted, according to the request A final logical model is established and constructed as a corresponding physical model; S03: extract data from the database according to the physical model; S04: generate a data mart layer table according to the extracted data. The present invention identifies and deletes requests with similar content by judging the entity duplication degree and the relation duplication degree in the early stage of the task, and summarizing them into a comprehensive duplication degree, thereby avoiding the creation of a data mart layer table with excessive repetition, and preventing the waste of computing resources. Improve data processing efficiency.

Description

technical field [0001] The invention relates to the field of data processing, in particular to a method for establishing a data mart layer table based on power grid energy data. Background technique [0002] During the construction of the energy big data center, a large number of public energy data models have been accumulated. According to the standard architecture of the energy big data center, the data mart layer table needs to be constructed based on the public energy data model. At present, there are still some problems in the standardized use of the public energy data model, which leads to the inability to standardize the construction of the upper data mart layer table. It is urgent to explore and develop the visual design method of the public energy data model, and then improve the construction specification of the data mart layer table sex. [0003] In the prior art, for example, the invention with publication number CN108959356A discloses a method for establishing ...

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 Patents(China)
IPC IPC(8): G06F16/22G06F16/28G06F16/215G06Q10/10G06Q50/06
CPCG06F16/2282G06F16/288G06F16/215G06Q10/10G06Q50/06
Inventor 黄宇腾王红凯夏洪涛倪阳旦孔晓昀应张驰潘司晨
Owner STATE GRID ZHEJIANG ELECTRIC POWER