Research Of Data Mapping Method And Application In The Oilfield Data Submitting Management

Information processing has been recognized the key technology to the development of enterprises ,if we grasped it that can have the most advanced production tools, enterprise could economize and improve production efficiency, in addition, enterprise own the self-governed software and operation mode ,shaped isomerism between in-house system and central system, isomerism data transformation became more and more hardly.To the above questions, we researched a kind of the data mapping method that based on XML to the isomerism database,defined the standard of the meta-model for the different data types, described them with XML. Defined some meta-model such as: Data dictionary meta-model, Data mapping dictionary meta-model, Excel report to data form meta-model, Data form to Excel report meta-model and structure database. Data mapping method has been applied in oil field submitting management, specific research include:1.Designed data dictionary meta-model. The standard and unified description. to the data in the processing data change, was the base of data transformation, the data dictionary was in support of data mapping and data integration.,described entity, data and the dependency of entities.2.Data mapping dictionary meta-model could build the dance between the different structures. The system could transform source database to destination database.3.Designed Excel report to data form mapping meta-model. mapped from data form to Excel report ,designed one kind of the report generation, written in report model with the method of annotation, used the module processing conception, to mark,amount,subtotal,merge cells and so on, they have own specific formatting information.4.To structured data mapping,defined specific XML form to describe the mapping between databases.5. The mapping method was applied in the oilfield submitting management, implemented data transformation from structured to semi-structured data.