2012 | OriginalPaper | Buchkapitel
Design and Implementation of an ETL Approach in Business Intelligence Project
verfasst von : Tieniu Wang, Jianhua Hu, Haihe Zhou
Erschienen in: Practical Applications of Intelligent Systems
Verlag: Springer Berlin Heidelberg
Aktivieren Sie unsere intelligente Suche, um passende Fachinhalte oder Patente zu finden.
Wählen Sie Textabschnitte aus um mit Künstlicher Intelligenz passenden Patente zu finden. powered by
Markieren Sie Textabschnitte, um KI-gestützt weitere passende Inhalte zu finden. powered by
In the modern business, a vast amount of data has been accumulated, but mass data has not been fully utilized. Therefore, it is a vital issue for the business and IT sector to explore these data with new technology, which is useful to support better business decision-making and help enterprises to increase profit and market share. BI (Business Intelligence) technologies emerge as the times require, and ETL (Extract, Transform and Load) which realizes the technical service and decision-making support plays an important part role in BI project. In this paper, the main characteristics, advantages and disadvantages in existing ETL methods are analyzed, and some factors affecting the performance of ETL are also summarized. Furthermore, an ETL approach which combines ETL tools and SQL coding was proposed and implemented based on EL-T (Extract, Load and Transform) framework. The practice and experiment results show that the proposed approach has better efficiency and applicability than other existing ETL methods.