Design and realization of the National Petroleum Resource Database ETL System based on SOA

Author

Li Ying ; Feng Li-zhou ; Chen Ya-fu ; Yang, Wang

Author_Institution

Coll. of Comput. Sci. & Technol., Jilin Univ., Changchun, China

Volume

2

fYear

2010

fDate

9-11 July 2010

Firstpage

325

Lastpage

327

Abstract

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.

Keywords

XML; data mining; natural gas technology; petroleum; software architecture; China; MVC model; ODBC; OLAP; SOA; XML; dynamic mapping; gas resource; national petroleum resource database ETL system; oil resource; system constructing model; Analytical models; Data models; Multimedia communication; Multimedia databases; Service oriented architecture; XML; Extraction-transformation-loading (ETL); National Petroleum and Gas Resources Database; OLAP (On-Line Analytical); service-oriented architecture (SOA);

fLanguage

English

Publisher

ieee

Conference_Titel

Computer Science and Information Technology (ICCSIT), 2010 3rd IEEE International Conference on

Conference_Location

Chengdu

Print_ISBN

978-1-4244-5537-9

Type

conf

DOI

10.1109/ICCSIT.2010.5564584

Filename

5564584