Title :
The Research & Application of ETL Tool in Business Intelligence Project
Author :
Jun, Tang ; Kai, Cui ; Yu, Feng ; Gang, Tong
Author_Institution :
Petrochina Northeast Refining & Chem. Eng. Co. Ltd., Shenyang, China
Abstract :
In modern business, vast amounts of data are accumulated, which makes the decision making process complicated. How to change the existing situation of "mass data, poor knowledge", support better business decision making and help enterprises increase profits and market share become the business and IT sector issues of mutual concern. Business intelligence technologies emerge as the times require. ETL plays an important part role in BI project, which realize the technical service and decision making support. This article sets out an overview of ETL, the main module of ETL, the optimization scheme of ETL, as well as the specific implementation of the ETL process.
Keywords :
DP management; decision support systems; service industries; ETL tool; business intelligence project; decision making process; extract transform load; mass data; poor knowledge; technical service; Bismuth; Business; Cleaning; Data mining; Data warehouses; Database systems; Decision making; Information technology; Manufacturing industries; System performance; BI; ETL; decision-making; optimization scheme; technical service;
Conference_Titel :
Information Technology and Applications, 2009. IFITA '09. International Forum on
Conference_Location :
Chengdu
Print_ISBN :
978-0-7695-3600-2
DOI :
10.1109/IFITA.2009.48