Font Size: a A A

The Data Synchronization And Switch Of Main Memory Database

Posted on:2007-10-10Degree:MasterType:Thesis
Country:ChinaCandidate:Q B RuanFull Text:PDF
GTID:2178360182993720Subject:Computer application technology
Abstract/Summary:PDF Full Text Request
As the economy developing, modern Application requires the database more and more quickly. Traditional database can't satisfy those requirements at some field, so the memory resident database (MMDB) comes true. Data synchronization technology can ensure the data consistency that on different node in distributed system. Many commercial databases have provided their own solution like Oracle and SQL Server. At the other side, as to MMDB, the important thing is how to synchronize the data more efficiently and how to keep the data consistency.The background of this paper is a futures transaction system named JinCheng . It is also a distributed system. The features that transaction area is independent of the system make the data synchronization necessary. On the basis of research of the technology and the project that we are working on, considering the requirement and efficiency of the system, we propose a data synchronization solution based on transaction log. And the advantage is that it can decrease the data quantity transported and lighten the backup database's burden. In another way, asynchronous mode can improve the whole system's performance. The problem about delay between Primary database and backup database is analyzed and solved.Following the design, we show how to implement the system that divided into two parts: Primary database and backup database. At last, we introduce the database switch which can recover the system from failure and make the system more usable and strong.
Keywords/Search Tags:futures transaction system, memory resident database, transaction log, data synchronization, data Consistency, database switch
PDF Full Text Request
Related items