Power grid natural-disaster data warehouse model implementation method

Abstract

The invention relates to the technical field of data management, in particular to a power grid natural-disaster data warehouse model implementation method. A power grid natural-disaster device operation and maintenance system is imperfect and is simple in data storage mode, a traditional data window changes deserved natural-disaster data into information isolated islands. The power grid natural-disaster data warehouse model implementation method comprises the steps that a natural-disaster classification system is established according to a natural-disaster monitoring device; a monitoring device standing book entity model is established; the monitoring device entity model is converted to generate one or more theme example models; according to theme examples, theme type standards are subdivided for the natural-disaster classification system; according to specific items of natural-disaster monitoring, a theme attribute basic-standard library is established; a relation model is established; a big data technology is applied to establish a non-relational database natural-disaster data storage model. The power grid natural-disaster data warehouse model implementation method facilitates information calling and use and meanwhile provides a reliable unified data warehouse for future natural-disaster information data mining and analysis.

Description

technical field [0001] The application relates to the technical field of data management, in particular to a method for realizing a model of a power grid natural disaster data warehouse. Background technique [0002] Data warehouse, the English name is Data Warehouse, which can be abbreviated as DW or DWH. A data warehouse is a strategic collection that provides support for all types of data for decision-making processes at all levels of an enterprise. It is a single data store created for analytical reporting and decision support purposes. Provides guidance on business process improvement, monitoring time, cost, quality, and control for businesses that need business intelligence. With the advent of the big data era, the data warehouse has slowly transformed into a distributed architecture, and the storage method has also changed from a single relational storage to a hybrid storage, relational database plus non-relational database, to meet the explosive growth of analysis,...

AI Technical Summary

Problems solved by technology

[0004] The purpose of the present invention is to solve the problem of accessing a large number of online power grid natural disaster monitoring data. The sudden increase in data volume leads to poor system performance and cannot meet application requirements; the operation and maintenance system of power grid natural disaster devices is not perfect, and the data storage method is single. The window cannot efficiently store and process it; at the same time, the current natural disaster data of the power grid is poorly correlated with the ledger information of the power grid, and a unified traceability context cannot be formed. The correlation query is very difficult, making the natural disaster data that should be an information island. question

Images