The Research And Application Of Web Database Migration Technology Based On Hibernate

With the development of computer software technology and modern enterprise information, content management has been widespread and in-depth application in enterprises. Nowadays, with people's growing demand for web content management system, the enterprise content management system is getting continuously upgrading. , the historical data kept in the old content management system must be migrated to new system, and a lot of tedious work of the data migration becomes a key element of the new system on-line. Yet heterogeneity of old and new database platform makes data migration a hard work. So the emergence of common and cross-platform content management system data migration tools become urgent .The main difficulty of data migration is data heterogeneity. To achieve Implementation of data migration between old and new systems, data description is firstly to be required to be based on a unified format to achieve data conversion, processing and other functions. The thesis maps the data in the source database and target database to Java program class, using Hibernate Reverse Engineering. We can only operate Java classes to implement the conversion between the object.When operating Data migration, which eliminates the heterogeneity of the database layer and facilitates the implementation of data migration of enterprise's old and new content management systems. Hibernate, as an object for Java environment / relational mapping (ORM) tool, is an integration bridge between object-oriented Java applications and relational database, which can map the Java objects and relational database. It holds the most important advantages in the mapping of data to the object.This thesis points out the consistency of content management system in the object model, which offers the theoretical basis for developing a variety of generic tools of data transfer between different content management systems, on the basis of generalizing common business processes, background management, and content organization of Content management system. It also discusses the problem of heterogeneous data migration, analyzes data migration strategies, and makes an analysis and comparison of the advantages and disadvantages of the current data migration tools, directing to the shortages of the present data migration tools. Then it introduces a general data migration model based on Hibernate layer to exchange data between heterogeneous database content management systems and discusses the advantages and key technologies of the model.In the end, in the title of instance of upgrading the content management system of Shanxi Electric Power Company, this article focuses on the implementation of the theory, thus the combination of theory and practice fully proves the guide of the theory in practical application.