基于SOA的国家级油气资源数据库ETL系统设计与实现

Design and Realization of the National Petroleum Resource Database ETL System Based on SOA

针对我国油气资源数据相对多源、异构、分散的现状,根据OLAP的实际需求,采用MVC模式作为系统架构模式,实现了国家油气资源数据库数据提取、转换和加载(ETL)系统。阐述了系统所采用的基于面向对象体系结构(SOA)的5层结构模型,使用ODBC和XML技术实现数据库连接的动态映射,应用Oracle DB解决了多媒体数据处理等关键问题。

For the petroleum resource data in China being relatively multi-source,heterogeneous and decentralized,we use MVC model as an architecture model of the system to design and realize the national petroleum resource database extraction,transformation and loading system based on the actual requirement of OLAP.We introduce the designed 5-layer structure model based on SOA(object-oriented architecture),which joints ODBC with XML technology to achieve a dynamic mapping database connection and resolves the problem of processing multimedia data by Oracle DB,and so on.