| With the popularization and application of Enterprise Production Management System (A2) , two sets of data standard is used .One is "the logic of development database structure and filling regulation " promulgated by Daqing Oilfield Company in 2003,the other is PCEDM pushed out by China National Petroleum Corporation in 2006 . There is great difference in two sets of data standard, data model can not be completely mapped. Data can not be completely migrated. The enterprise has developed a series of software and their databases in years of informatization construction. A2 system can not be popularized smooth if continued using these systems and transplanting data fully to PCEDM model required a large amount of manpower, material, time-consuming. Therefore, the author aimed to establish a universal data interface, heterogeneous databases mapping work is reassigned to lots of data management staff and database administrators' workload is decomposed. Using computer technology to achieve data migration transparency in exploration and development, used many times after customized.The author has carried out amount of technical research to realize this technology. the paper includes three aspects : First, studied heterogeneous databases pattern matching technology, suggested mapping model suitable for exploration and development database, formatted mode of data exchange mechanism; second, studied how to extract unknown database (ORACLE, SQL, DBF, etc.), built data interface customization tools; third, realized of exploration and development data interface system, migrated heterogeneous databases to ORACLE, achieved data loading process transparency.The research achievements solved data exchange problems between A2 and original system, provided exploration and development data migration, avoided consuming resource in the repeated work in software development and data migration. Meanwhile, the system WEB-based providing flexible management tools to data management staff. |
PDF Full Text Request