Data management system and method for electric power information system based on unified dimension modeling

A power information and dimensional modeling technology, applied in the field of data modeling, can solve problems such as difficult data expansion and complex data structure, and achieve the effect of easy development

Active Publication Date: 2019-03-26
STATE GRID CORP OF CHINA +2
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Therefore, this method often makes it difficult to expand the data later
In power operation management, especially in transaction management, the data structure is relatively complex, and due to business expansion and changes, new data structures often appear. The above-mentioned modeling method often brings a lot of later maintenance and expansion in actual use. Work

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
  • Data management system and method for electric power information system based on unified dimension modeling

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0065] The following takes the definition of the data structure of the monthly settlement electricity of power generation rights trading in the power trading operation as an example to illustrate the use of the data management method based on unified dimension modeling.

[0066] 1. Divide the data into the smallest granularity dimension. The dimensions of the data include four categories: subject, application, time, and value. The subject dimension includes the purchaser, seller, and power transmission party. The sub-system (settlement) and power metering caliber (online), time includes two start time and end time, and the numerical dimension has three dimensions: electricity quantity, electricity price, and transmission price, totaling 11.

[0067] 2. Traversing the existing dimension categories and dimension attributes, if the above-mentioned dimension attributes are not included, add the definition of corresponding dimension categories and dimension attributes in the dimensi...

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 an electric power information system data management system based on unified dimensional modeling and a method thereof. The system comprises a data dimension attribute pool management module used for managing and maintaining a usable data dimension attribute pool, a data dimension model definition module used for achieving definition of data and description of a data dimension model, and a data management interface service module used for providing a unified data management interface for retrieval, storage and statistic analysis of data to prevent data usage change along with structure change. Due to the fact that data description is achieved by means of a unified data dimension attribute definition table and standardized operation including data retrieval and storage is designed, unified management of complex structure data in an electric power information system is achieved, data retrieval and storage and data interaction between different service systems are facilitated, and a unified data basis is provided for designing and developing a data management tool.

Description

technical field [0001] The invention relates to a data modeling method in the technical field of data processing, in particular to a data management system and method for an electric power information system based on unified dimension modeling. Background technique [0002] Dimensional modeling proposed by Kimball is a data modeling method in data warehouse construction. This law introduces the construction of data warehouses and data marts based on fact tables and dimension tables. The popular name of this method is Star-schema. Entity-relationship (E-R) modeling is often used to create a complex model of all processes in an organization. This approach has been proven effective in creating efficient online transaction processing (OLTP) systems. In contrast, dimensional modeling creates individual models for discrete business processes. For example, create sales information as one model, inventory as another, and customer accounts as another. Each model that is created ...

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/21G06Q50/06
CPCG06F16/22G06F16/2282G06Q50/06
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