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

An effective and agile data warehouse design method

A data warehouse and design method technology, applied in the computer field, can solve problems such as difficult business logic, low conversion efficiency, and hindering the construction efficiency of data warehouse projects

Inactive Publication Date: 2019-02-22
中建材信息技术股份有限公司 +1
View PDF5 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, its ETL converts or checks the quality of the data loaded into the memory one by one, and the conversion efficiency is relatively low. When it is transferred to other fields, it is difficult to deal with new business logic
[0004] However, there are few domestic and foreign studies on how to share the ETL process in similar or similar data warehouse projects, which largely hinders the further improvement of the construction efficiency of data warehouse projects

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
  • An effective and agile data warehouse design method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 2

[0021] An effective and agile data warehouse design method includes: metadata extraction module, reusable component selection and import module, data warehouse architecture automatic maintenance module, ETL process definition module, ETL scheduling module, ETL component generation module; the metadata extraction module mainly Completion: extract business data and dimension data metadata, and define the system more precisely on this basis; the selection and import module of reusable components extracts the packaged full-flow transaction data extraction components and integration conversion components from the component library , KPI conversion components, dimensional data integration conversion components, KPI automatic test components, and import them into the ETL process library;

[0022] The data warehouse architecture automatic maintenance module completes the creation and initialization of the data warehouse for the statistical analysis system based on the information in th...

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 provides an effective and agile data warehouse design method, which comprises four layers: a base layer, an extraction layer, an integrated conversion layer and a special processing layer. The component-based software reuse technology can make full use of the knowledge and experience accumulated in the past work, the identified components with relatively independent functions are applied to the development of the new system, the invention ensures that in the process of the development of the new system, the emphasis can be focused on identifying and realizing the unique components of the application system, and finally shortens the development cycle of the system and improves the quality of the system. The invention has simple structure, convenient use and strong practicability.

Description

technical field [0001] The invention belongs to the field of computers, in particular to an effective and agile data warehouse design method. Background technique [0002] Data warehouse is the inevitable product of computer and database application development to a certain stage, and it is the core technology to support enterprise decision analysis. The purpose of the data warehouse is to establish a structured data storage environment, separate the large amount of data required for analysis and decision-making from the traditional operating environment, and convert scattered and inconsistent operational data into integrated and unified information. However, in the traditional operating environment, the transaction processing systems developed by enterprises in different periods and under different backgrounds are often established for different applications and completed by different developers. The data storage structure and storage platform And the system platform has g...

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/25
Inventor 王洋丁毅孙成国
Owner 中建材信息技术股份有限公司