Research On Interface Technology Of Data Migration And Transform For Comprehensive Logging Instrument

Recently, most comprehensive logging data are stored in their own databases such as Access, SQL Server and so on. The data formats of these logging data are not unified and the data can not be shared with each other, so they are not utilized fully. It is very necessary to design a comprehensive logging Data Migration Interface, which can combine the currently available data migration and conversion technology. By this interface, we can standardize the comprehensive logging data firstly which are discrete in sources and variety in formats, and then transfer these standardization datum into an integrated database. The purpose of interface designing is to provide the standard data for the research department and management, and lay the foundation for data sharing.The interface design is based on middleware technology and XML (eXtensible Markup Language) technology. We use middleware technology to realize data transfer. This technology can not only suppress complexity and heterogeneity of comprehensive logging, but also make interface a good scalability. The use of XML technology to realize data transform have two reasons. The first is because XML has many features such as opening, expansibility, data conversation function by XSLT and so on, which is precisely required by oil complex data. The second reason is more important, because WITSML is an XML-based market information transmission Well Standard markup language, and it is increasingly becoming the standard language on drilling data transmission and preservation.The interface is made up of three both independent and interrelated components. There are data query module, data conversion module and data load module. Data query module will be responsible for the realization that logging instrument databases are visited by users transparently and select database which content need to be transfered. Data conversion module will be responsible for extracting data content from database which are selected, and then transforming them into a unified XML documents which will be presented to the user. Data load modules will be responsible for loading the data which are in XML documents to the target database. In the last section of paper, the feasibility of the interface is proved through an examination that realizing data migration from Access and SQL Server database to Oracle database.