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

Data warehouse visual modeling system and method based on power grid big data

A modeling method and big data technology, applied in the field of big data, can solve problems that do not involve data warehouse visualization modeling efficiency, data modeling standardization, etc., and achieve the effect of improving design efficiency and reducing complexity

Active Publication Date: 2021-03-30
FOSHAN POWER SUPPLY BUREAU GUANGDONG POWER GRID
View PDF17 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This method is mainly aimed at the management of big data warehouses, and does not involve the improvement of the efficiency of data warehouse visualization modeling and the standardization of data modeling

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 warehouse visual modeling system and method based on power grid big data
  • Data warehouse visual modeling system and method based on power grid big data

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0054] Such as figure 1 As shown, a data warehouse visualization modeling system based on power grid big data includes a data source configuration module, a hierarchy / subject domain management module, a logical model design management module, a physical model management module, and a table management module; the data configuration module All connect logical model design management module with described level / subject field management module, described logical model design management module connects physical model management module, and described physical model management module connects table management module; Described data source configuration module carries out specified data Source configuration; the hierarchical / subject domain management module establishes the hierarchical relationship of the database; the specified data source and the hierarchical relationship of the database are input into the logical model design management module; the logical model design management mo...

Embodiment 2

[0058] Such as figure 2 As shown, a data warehouse visualization modeling method based on power grid big data, the specific process is:

[0059] Step 1: The data warehouse engineer formulates data warehouse layering rules according to business requirements and metadata conditions, and transmits the formulated data warehouse layering rules to the logical model design management module;

[0060] Step 2: Connect the big data platform data to the data source configuration module to obtain metadata, and transfer the metadata to the logic model design management module;

[0061] Step 3: The logical model design management module utilizes the warehouse design in step S1 and the metadata in step S2 to generate data warehouse layering rules and metadata to generate a logical model, and transmits the logical model to the hierarchical / subject domain management module;

[0062] Step 4: The hierarchical / subject domain management module uses the logical model in step S3 to generate a comp...

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 the technical field of big data, in particular to a data warehouse visual modeling system based on power grid big data. The system comprises a data source configuration module, a hierarchy / theme domain management module, a logic model design management module, a physical model management module and a table management module, wherein the data source configuration module performs the configuration of a specified data source; the hierarchy / theme domain management module is used for establishing a hierarchy relationship of a database, the logic model design management module is used for forming a logic model, the physical model management module is used for forming a physical model, and the table management module is used for forming the physical model into an actual table to realize maintenance of a database table. According to the data warehouse visual modeling system and method based on the power grid big data, a database modeling platform meeting requirements can be rapidly and efficiently constructed, and the database modeling efficiency of a power grid big data center and the standardization of data modeling are improved.

Description

technical field [0001] The invention relates to the field of big data technology, in particular to a data warehouse visualization modeling system and method based on power grid big data. Background technique [0002] A data warehouse is a warehouse that uses computer storage devices to organize, store and manage data according to the characteristics of data types and structures. In essence, it can be regarded as a file cabinet for data. Management operations such as adding, intercepting, updating, and deleting data. With the rapid development of social economy and the advent of the era of big data, the power industry has higher and higher requirements for the storage, management and analysis of power big data, and different data warehouses need to be established according to different types of power big data. Therefore, The construction of electric power big data warehouse has become an inevitable problem for electric power enterprises. [0003] At present, the business vo...

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/22
CPCG06F16/212G06F16/21G06F16/2282Y02D10/00
Inventor 宋才华关兆雄布力吴丽贤王永才杜家兵
Owner FOSHAN POWER SUPPLY BUREAU GUANGDONG POWER GRID