Design and realization of the National Petroleum Resource Database ETL System based on SOA
Ying Li, Li-zhou Feng, Chen Ya-fu, Yang Wang · 2010
Considering the current situation of the data on oil and gas resources in China, which is relatively multi-sourced, heterogeneous and decentralized, as well as the actual demand of OLAP, MVC model is employed as the system constructing model. Besides, ODBC and XML technology are combined to achieve dynamic mapping on database connection. Thus the National Petroleum Resource Database ETL System which is based on SOA comes into being. Meanwhile, the technical difficulties encountered in the integrated developing process as well as the corresponding solutions adopted are also provided.