Data warehouse based on data fusion and data mining and application method of data warehouse

A data mining and data fusion technology, applied in the field of data warehouses, can solve the problems that data warehouses cannot meet the reliability, consistency and sharing of massive data information storage and extraction, and achieve the effect of convenient storage and extraction

Inactive Publication Date: 2014-02-12
ELECTRIC POWER SCHEDULING CONTROL CENT OF GUIZHOU POWER GRID CO LTD +1
View PDF5 Cites 28 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The purpose of the present invention is to provide a data warehouse based on data fusion and data mining and its application method, which mainly solves the problem that the existing data warehouse in the prior art cannot satisfy users' reliability, consistency and sharing of massive data information storage and extraction. The question of sexual demands

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 based on data fusion and data mining and application method of data warehouse
  • Data warehouse based on data fusion and data mining and application method of data warehouse

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0022] Such as figure 1 As shown, the present invention mainly includes a data extraction layer, a data storage layer and a data access layer.

[0023] Data extraction layer: Import data from online transaction processing systems, external data sources, and offline data storage media into the data warehouse through the extraction process. Data extraction mainly involves interconnection, replication, increment, transformation, scheduling and monitoring technically. The process includes source data analysis and mapping, data extraction, conversion and loading, and data auditing;

[0024] Data storage layer: This layer is the core of the whole system, including ODS, EDW and data mart 3 layers. Among them, ODS stores data that has been lightly cleaned and basically maintains the consistency of data details with the production system, and the data storage period is short; EDW stores organized, customer-centric enterprise data, and the data storage period is long. In the process o...

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 data warehouse based on data fusion and data mining and an application method of the data warehouse. The data warehouse mainly solves the problems that in the prior art, a data warehouse cannot meet requirements of users for reliability, consistency and sharing performance of storage and extraction of large amounts of data information. The data warehouse comprises a data extraction layer, a data storage layer and a data access layer, wherein the data extraction layer is used for extracting data in online transaction processing system, an external data source and off-line data storage media and leading the extracted data into the data storage layer; the data storage layer comprises an ODS used for storing the data which are subject-oriented, integrated and current or close to the current and constantly change, an EDW storing enterprise-level data and a data mart; the data access layer is used for accessing data in the data storage layer in a statement, image or data analysis mode and carrying out analysis prediction. According to the data warehouse based on data fusion and data mining and the application method, the aim of storing and accessing data safely, reliably and conveniently is achieved, and the data warehouse has high practical value and popularization value.

Description

technical field [0001] The invention relates to a data warehouse, in particular to a data warehouse based on data fusion and data mining and an application method thereof. Background technique [0002] With the rapid development of the power industry and the popularization of computer technology in the power system, dispatching automation, energy management system (EMS) and geographic information management system (GIS) have been more and more widely used in the power grid. The continuous expansion of the scale of the power grid makes how to comprehensively process massive, time-varying and mobile data, and how to perform data fusion and data mining on the collected data has become the focus of attention in the power system. Due to the continuous improvement of the functions of the power system automation management system and the application of computer network technology and distributed structure, the amount of data information to be processed has increased greatly, and pe...

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 Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/211
Inventor 姬源陈晓谨沈冠全许良柱吴建国龙家焕何静张韵唐雷刘俊勇吕林沈晓东刘洋魏震波刘继春李成鑫黄媛
Owner ELECTRIC POWER SCHEDULING CONTROL CENT OF GUIZHOU POWER GRID CO LTD
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