Power grid multi-dimensional data modeling method based on XML

A technology of multi-dimensional data and modeling methods, applied in multi-dimensional databases, database models, database indexes, etc., can solve problems such as standard dilemmas, data barriers, data islands, etc., to improve management level, great competitiveness, and improve management level Effect

Pending Publication Date: 2022-01-11
CHINA REALTIME DATABASE +1
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, there is a lack of unified workflow management and data standards among various systems, and problems such as data islands, standard dilemmas, and sharing problems have emerged, resulting in data barriers and hindering data empowerment

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
  • Power grid multi-dimensional data modeling method based on XML
  • Power grid multi-dimensional data modeling method based on XML
  • Power grid multi-dimensional data modeling method based on XML

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0031] An XML-based grid multi-dimensional data modeling method, comprising the following steps:

[0032] (1) Abstract the multidimensional data model of OLAP into a cube containing multidimensional space;

[0033] In the multi-dimensional space inside the cube, there are axes of multiple dimensions, and the axes of each dimension are perpendicular to each other (the vertical concept of multi-dimensional space has surpassed the general three-dimensional vertical). The data that users care about is distributed in a multi-dimensional coordinate system composed of all dimensions.

[0034] Subject: the name of a certain aspect of data to be analyzed, it can have multiple cubes; cube: a multidimensional data set, consisting of a fact table and multiple dimensions, and a dimension can be a dimension table; index: or called For the fact, it corresponds to a specific fact table, corresponds to the decision support center, and is the center of the star schema, which contains all the m...

Embodiment 2

[0053] A computer storage medium, on which a computer program is stored, and when the computer program is executed by a processor, the above XML-based grid multi-dimensional data modeling method is realized.

Embodiment 3

[0055] A computer device, comprising a memory, a processor, and a computer program stored in the memory and operable on the processor, when the processor executes the computer program, the above-mentioned XML-based grid multi-dimensional data modeling is realized method. The attribute is used to define the dimension table for the dimension mapping; the foreignKey attribute of the Dimension tag defines the foreign key of the indicator table associated with the dimension table.

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 power grid multi-dimensional data modeling method based on XML, which is characterized in that power grid dimension modeling is divided into two stages, namely storage layer modeling and application layer modeling, so that a power grid dimension model is constructed quickly, accurately and flexibly; in a storage layer, by using a relational database, and a relational data model with multi-dimensional characteristics is established according to a 'star graph' method; in an application layer, an XML Schema is designed, and a multi-dimensional data cube and physical mapping are described. Based on OLAP of XML, the invention provides an effective modeling method for multi-dimensional data modeling of the storage layer and the application layer for problems existing in data in power grid service, and has the characteristics of high efficiency, accuracy and flexibility. Various multi-dimensional data models are established according to different data requirements, and the problems of non-uniform data standards, data islands and the like are solved. Data fusion and sharing are quickly realized, the management level of a power grid company is further improved and perfected, and greater competitiveness is brought to the power grid company.

Description

technical field [0001] The invention relates to grid dimension modeling, in particular to an XML-based grid multi-dimensional data modeling method. Background technique [0002] With the rapid development of informatization in the power grid industry, various data resources continue to accumulate, and there is an urgent need for data sharing between different business systems. However, there is a lack of unified workflow management and data standards among various systems, and problems such as data islands, standard dilemmas, and sharing problems have emerged, resulting in data barriers and hindering data empowerment. Data warehouse technology can solve the above problems very well. One of the most important tasks in the construction of data warehouse is to establish a data model suitable for decision analysis. The dimensional model is suitable for data processing of large-scale data volume, and better supports data warehouse mining and OLAP (OnLine Analytical Processing, O...

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
IPC IPC(8): G06F16/21G06F16/22G06F16/28G06F16/81G06F16/84G06Q50/06
CPCG06F16/212G06F16/2282G06F16/283G06F16/81G06F16/86G06Q50/06Y04S10/50
Inventor 李钢胡健陆玮崔正大孙浩原
Owner CHINA REALTIME DATABASE
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