| With the development of distributed database, the database system is paid more and more attention. There are two kinds of database replication architecture:one is embedded architecture that is based on database system and another is middleware architecture which is independent of database system. The former is more efficient and the latter has better generality but low efficiency. The major database vendors abroad have developed replication system embedded in their database system. While the domestic research in this aspect mainly focuses on the middleware architecture. Therefore, it’s necessary to do some research about replication system based on database system. The main work of this thesis is summarized as follows:(1) The research status and major technology of database replication system is introduced, including distributed database system, database replication technology and database replication architecture.(2) The requirement of database replication system based on BeyonDB is analyzed and the architecture of system and the key technology are presented. The whole system is composed of data capture component and data transmission component. In data capture component, the method of control table is improved that each replicated table has a set of control tables. The data transmission adopt mixed-transmission model and each transmission path has one replication server. In order to guarantee the data consistency, the strategy of data conflict has designed——based on timestamp or priority.(3) The replication prototype system is implemented in BeyonDB which is the domestic spatial database management system. The replication system is tested and verified, including function verification and performance verification.The results of this study show that the embedded database architecture of replication system is more efficient than middleware architecture, and it has higher reliability to maintain the consistency of the data in the distributed environment. |
PDF Full Text Request