基于地震资料处理的数据库迁移方法研究  

Research on database migration method based on seismic data processing

作　　者：金弟 邵萌珠 何嘉诚 叶月明 王宗仁 JIN Di;SHAO Mengzhu;HE Jiacheng;YE Yueming;WANG Zongren(Research Institute of Computer Application,Petro China Hangzhou Research Institute of Geology,Hangzhou 310023,China)

机构地区：[1]中国石油杭州地质研究院计算机应用研究所,浙江杭州310023

出　　处：《电子设计工程》2023年第19期30-35,共6页Electronic Design Engineering

基　　金：国家自然科学基金(41874164);国家科技重大专项(2017ZX05026-006)。

摘　　要：为构建高性价比数据库系统,解决油气勘探领域地震资料处理系统更新中数据库迁移问题,提出将Oracle数据库迁移到PostgreSQL数据库的数据迁移解决方案。对地震资料处理数据库数据组织结构进行分析,针对迁移难点提出以地震项目工区为迁移单位和基于模板机制的数据迁移方法。通过设计SQL模板、Perl转换程序及SQL脚本等实现了基于Linux平台的数据库迁移工具。以一个时间偏移地震项目工区为案例进行验证,结果表明,数据迁移完整性与正确性为100%,为油气勘探领域数据库迁移提供了参考。In order to build a cost-effective database system in the field of oil and gas exploration,and solve the problem of database data migration during the upgrading of seismic data processing system.A data migration solution is proposed to migrate Oracle database to PostgreSQL database.The data organization structure of seismic data processing database is analyzed,aiming at the migration difficulties,a data migration method based on the template mechanism and taking the seismic project work area as the migration unit are proposed.The database migration tool based on Linux platform is realized by designing SQL template,Perl conversion program and SQL script.A time migration seismic project is carried out.The results show that the integrity and correctness of data migration is 100%,which provides a reference for database migration in the field of oil and gas exploration.

关 键 词：油气勘探 地震资料处理 数据库迁移 POSTGRESQL 模板机制 

分 类 号：TN915.05[电子电信—通信与信息系统]