Research of Data Mapping Method and Application in the Oilfield Data Submitting Management
|School||Northeast University of Petroleum|
|Keywords||Data mapping XML Metadata|
Information processing technology has been considered a key technology to support business development , to master the information processing technology means mastered the most advanced production tools , saving the cost of the enterprise , improve the efficiency of production , due to the original business relatively independent of system software and the mode of operation , so formed between the local system and the central system of the heterogeneous nature of the data , make conversion between heterogeneous data is difficult to be carried out smoothly . In response to these problems , the paper proposes an XML-based heterogeneous database data mapping method for different types of data , define the corresponding meta - model standard XML markup language to describe them . The defined element model include : data dictionary element model , data mapping dictionary metamodel mapping meta-model to the data table , Excel statements , the data table to Excel report data meta-model and structured database mapping between the meta-model . This method has been applied in the management of oilfield data collected and submitted . Specific research topics include: (1 ) design a data dictionary element model . Given specifications and a unified description of the data involved in the data exchange process , is the basis of the data migration , the data mapping and the data set definition need the support of the data dictionary describes the existing entity , data item and inter-entity dependency ; (2 ) the establishment of a data mapping dictionary element model . Used to create entities and data items corresponding relationship between the two different data model structure , the system based on such a corresponding relationship , can be a source database to the target database . ( 3 ) design Excel report mapping meta-model to the data table . In the data table to Excel report mapping process , the development of a report generation system , the system needs to write statements with database mapping relationship endorsement report template , the introduction of the concept of block processing by this the technology can not only achieve the columns together, the the subtotal can achieve merged cell operation , for each operation are defined in a specific format . (4 ) For structured data mapping , define a dedicated XML format to describe the mapping between databases . (5 ) data mapping method for oilfield data Remit management , structured data exchange between the semi-structured data .