Title :
ETL tool research and implementation based on drilling data warehouse
Author :
Li Jian ; Xu Bihua
Author_Institution :
Sch. of Comput. Sci., Southwest Pet. Univ., Chengdu, China
Abstract :
According to the actual requirements of the drilling data warehouse, this paper analyses the weaknesses of traditional Extract, Transform and Load (ETL) tools´ architecture of its openness and repeatedly development, and proposed a three-layers-architecture based on metadata. That makes ETL process more efficient, multipurpose and flexible. Through intensive studies of ETL theory, the drilling data warehouse ETL tools were designed and implemented.
Keywords :
data mining; data warehouses; meta data; oil drilling; production engineering computing; ETL tool; data warehouse; drilling; metadata; three layers architecture; traditional extract, transform and load; Computer architecture; Data mining; Data models; Data warehouses; Databases; Drilling; Petroleum; ETL; data warehouse; drilling; metadata;
Conference_Titel :
Fuzzy Systems and Knowledge Discovery (FSKD), 2010 Seventh International Conference on
Conference_Location :
Yantai, Shandong
Print_ISBN :
978-1-4244-5931-5
DOI :
10.1109/FSKD.2010.5569836
