Research And Application In SHXepc CMS Based On Oracle Data Replication

As the development of database and network technology, the distributed database system has been developed maturely not only on theory but also on application, for example: Internet application, grid computing, and data warehouse. The data inconsistency problems caused by distribution of the geographical position usually occur. In solving these problems, it has been a key in the database technology research field.The data replication is the commonly used one kind of data duplication technology in the distributional database application procedure. Data replication are saved in many computers. It provides the fast effective method for the information issue of the distributed environment. While it guarantees the data the synchronization and consistency, but also it may enhance the data inquiry deposit and withdrawal the performance, enables the long-distance user in local to quote the duplication the data to complete the distributional operation, reduces the network and the center database server load. This paper mainly analyses the theory of distributed database system and detailed discusses the base concept, system structure, schema structure and transaction management of distributed database system, studies the data replication realization in traditional relation database and the data conflict solution in replication procedure. Based on the foundation of the theory researcher, and combined the practical application of Shxepc CMS(Shanxi electric power corporation Content Management System), we deeply study the modules of data replication and the data conflict solution methods, put forward a data replication method based on modified timestamps of data records and design the data replication solution in an application model on read-only data. and applied to the Shxepc CMS, to solve the practical application of the issue of data replication and achieved a good effect.