Designation Of Data Migration Middleware On Heterogeneous Database

With the rapid development of computer technology, most of mines, enterprisesand institutions have realized the businessrelatedmanagement information system,but many systems have kinds of problems, such as: the interoperability betweendifferent hardware platform, different network environment and different databases, aswell as the coexistence of multiple application modes etc. Data migration middlewareand data access middleware could manage all kinds of data resources, support thesenior integration of data and provide a unified access interface to the data set.Therefore, as long as the various types of data resources environment exist, the dataaccess middleware will always play an important role.In the oil and gas production management services of the "digital oil field",various production management units have many types of heterogeneous databasesand data resources, and these units usually apply all data comprehensive integrated inorder to support different business. Collecting and processing of structured data andunstructured data is very complicated. The process of Collection and treatment ofstructured data and unstructured data is very complicated,and the transmission andprocessing of these data are also usually troublesome. Therefore, in order to solve theproblem of data migration and data transformation between these heterogeneousdatabases, it is necessary to design data migration middleware. The Migration of thecollected data from realtime database to relational database by the data migrationmiddleware is more easily, so that data resources collection and integrated applicationare more convenient.In this paper, our research is based on the project of"network interconnectionsystem of oil and gas production"of China Petroleum, and our goal is to solve theproblem of data migration and data transformation between heterogeneous databases.A program of a set of data migration middleware based on heterogeneous database isproposed by requirements analysis, coding and testing methods. JDBCspecificdatabase connection technology, JSP technology and data migration technicalprinciple are used in this paper, and data migration method and architecturedevelopment tools for JAVA are also used in this paper too. The scheme is mainlyaimed at studying many kinds of databases in network interconnection system of oiland gas production, which is responsible for the storage of data realtimeand storing historical data. After verification of major code, the middleware of data migration canshield the complex environment between heterogeneous databases? through using thestandard interfaces and agreement, the data of realtime database can be migrated torelational database. The migration method of the data could achieve automaticmigration of data in heterogeneous database, promote efficiency of migration andachieve effect of saving system development charges.