Data Integration Technology Applied In Comprehensive Information Platform’s Reconstruction Of Oil Production Plant

Integrated information platform of Linpan Oil Production Plant is a comprehensiveinformation management platform which includes production inquiring, production analysis,production management and other functions. Over the years, the platform has accumulated alarge amount of historical data. With the development of the “digital oilfield” development,these historical data needs to migrate to the source database with uniform standards, in orderto achieve unified management and information sharing purposes.So, the real question is how to migrate mass data which formerly store in differentformat of the database dispersedly, to the source database. The paper uses the technology ofmiddleware and XML to achieve the design of data transfer and conversion interface, itincludes three functional modules, they are data querying model, data export module and dataimport module. And through migrating SQL Server2000database and Access2003databaseto Oracle10g database, we verify the feasibility of the interface.