Abstract
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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Bao, Y., Song, J., Leng, F., Wang, D., Yu, G.: Study and Implementation of a New SQL-Based ETL Approach. Wuhan University Journal of Natural Sciences 12(5), 804–808 (2007)
Tang, J., Cui, K., Feng, Y., Tong, G.: The Research & Application of ETL tool in Business Intelligence Project. In: 2009 International Forum on Information Technology and Applications (2009), doi:10.1109/IFITA.2009.48
Vassiliadis, P., Simitsis, A., Skiadopoulos, S.: Conceptual Modeling for ETL Processes. In: Proceedings of the 5th ACM International Workshop on Data Warehousing and OLAP, doi:10.1145/583890.583893
Liu, Q., Weng, H.: Design and Realization of ETL System for Telecoms Data Warehouse. Computer Engineering 30(supplementary Issue) (2004)
Goswami, S., Ghosh, S., Chakrabarti, A.: Outlier Detection Techniques for SQL and ETL Tuning. International Journal of Computer Applications (0975 – 8887) 23(8) (2011)
Wikipedia: Extract, transform, load, http://en.wikipedia.org/wiki/Extract,_transform,_load
Inmon, W. H.: Building the Data Warehouse, 4th edn. Wiley Publishing, Inc., Indianapolis
Han, J., Kamber, M.: Data Mining Concepts and Techniques, 2nd edn. Elsevier, Inc.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2011 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Wang, T., Hu, J., Zhou, H. (2011). Design and Implementation of an ETL Approach in Business Intelligence Project. In: Wang, Y., Li, T. (eds) Practical Applications of Intelligent Systems. Advances in Intelligent and Soft Computing, vol 124. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-25658-5_35
Download citation
DOI: https://doi.org/10.1007/978-3-642-25658-5_35
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-25657-8
Online ISBN: 978-3-642-25658-5
eBook Packages: EngineeringEngineering (R0)