| 基于SOA的国家级油气资源数据库ETL系统设计与实现 |
| |
| 引用本文： | 李颖,凤丽洲,贾字田,姜悦,公维学.基于SOA的国家级油气资源数据库ETL系统设计与实现[J].吉林大学学报(地球科学版),2011(Z1):414-418. |
| |
| 作者姓名： | 李颖 凤丽洲 贾字田 姜悦 公维学 |
| |
| 作者单位： | 吉林大学计算机科学与技术学院;中国石油辽阳石化分公司; |
| |
| 基金项目： | 国土资源大调查项目(1211010750107) |
| |
| 摘 要： | 针对我国油气资源数据相对多源、异构、分散的现状,根据OLAP的实际需求,采用MVC模式作为系统架构模式,实现了国家油气资源数据库数据提取、转换和加载(ETL)系统。阐述了系统所采用的基于面向对象体系结构(SOA)的5层结构模型,使用ODBC和XML技术实现数据库连接的动态映射,应用Oracle DB解决了多媒体数据处理等关键问题。
|
| 关 键 词： | 国家级油气资源数据库 面向服务的体系结构 联机分析处理 数据提取、转换和加载 |
Design and Realization of the National Petroleum Resource Database ETL System Based on SOA |
| |
| LI Ying,FENG Li-zhou,JIA Zi-tian,JIANG Yue,GONG Wei-xue .College of Computer Science , Technology,Jilin University,Changchun ,China .Liaoyang Petrochemical Company,PetroChina,Liaoyang ,Liaoning,China.Design and Realization of the National Petroleum Resource Database ETL System Based on SOA[J].Journal of Jilin Unviersity:Earth Science Edition,2011(Z1):414-418. |
| |
| Authors: | LI Ying FENG Li-zhou JIA Zi-tian JIANG Yue GONG Wei-xue College of Computer Science Technology Jilin University Changchun China Liaoyang Petrochemical Company PetroChina Liaoyang Liaoning China |
| |
| Institution: | LI Ying1,FENG Li-zhou1,JIA Zi-tian2,JIANG Yue1,GONG Wei-xue1 1.College of Computer Science and Technology,Jilin University,Changchun 130012,China 2.Liaoyang Petrochemical Company,PetroChina,Liaoyang 111003,Liaoning,China |
| |
| Abstract: | 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 ... |
| |
| Keywords: | national petroleum resources database service-oriented architecture(SOA) on-line analytical(OLAP) extraction-transformation-loading(ETL) |
| 本文献已被 CNKI 等数据库收录！ |
|
