A data warehouse etl operating system

A data warehouse and operating system technology, applied in the field of data warehouse ETL operating system, can solve the problems of not maximizing the use of data resources, loss, waste of time and funds, etc., to improve real-time response speed, reduce time, and improve effective sexual effect

Active Publication Date: 2021-08-27
武汉光谷联众大数据技术有限责任公司
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Therefore, enterprises still do not maximize the use of existing data resources, so that more time and money are wasted, and the best opportunity to make key business decisions is lost

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
  • A data warehouse etl operating system
  • A data warehouse etl operating system
  • A data warehouse etl operating system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0038] The invention will be described in detail below in conjunction with specific embodiments.

[0039] Such as figure 1 Shown is the structural principle schematic diagram of a kind of data warehouse ETL operating system of the present invention, wherein contains i. user interaction module, comprises:

[0040] 1a. Interaction management components for implementation description data management in data integration and data flow;

[0041] 1b. Data components used to define the mapping relationship between the original data and the target data, the data conversion relationship, the data processing flow, and the interaction process with ETL;

[0042]1c. It is used to display the mapping relationship between the original data and the target data, the data conversion relationship, the data processing flow, and the visualization component of the interaction process with ETL; the visualization component is also used to output the interactive management component to control the win...

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 belongs to the technical field of data processing methods or systems, and in particular relates to a data warehouse ETL operating system. The ETL operating system of the data warehouse of the present invention realizes the implementation of data extraction, greatly reduces the time for obtaining and processing original data, realizes the distributed processing of data conversion and loading through extraction-conversion-release-acquisition, and changes the traditional Periodic job execution steps reduce the delay rate of data and improve the real-time response speed of data.

Description

technical field [0001] The invention belongs to the technical field of data processing methods or systems, and in particular relates to a data warehouse ETL operating system. Background technique [0002] With the rapid development of computer technology and information technology, electronic information data is becoming more and more important in the daily operation of enterprises, and enterprises urgently need to analyze data efficiently, accurately and timely. Traditional data warehouses have a long data loading cycle, and often can only provide analysis and query of historical data, and cannot respond to changes in data information in real time. Information is an important resource of modern enterprises and the basis for enterprises to use scientific management and decision-making analysis. At present, most enterprises spend a lot of money and time to build OLTP business systems and office automation systems to record various related data of transaction processing. Acc...

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 Patents(China)
IPC IPC(8): G06F16/25G06F16/28
Inventor 鲁大军
Owner 武汉光谷联众大数据技术有限责任公司
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