内存数据库和物理数据库的数据同步设计

Synchronous Design of Main Memory Database and Physical Database Data

随着电信行业的系统对数据库的性能要求越来越高,传统的物理数据库已不能满足系统的运营要求,为了有更高的存取效率,内存数据库就产生了。主要在电信行业系统的基础上研究内存数据库和Oracle数据库之间的数据同步。以ABM余额管理系统为例,阐述了从物理数据库到内存数据库的同步,内存数据库到物理数据库的同步。经过大量测试,达到了物理数据库与内存数据库的数据一致、完整、同步和实时。

With the development of science and technology, especially the requirements of the database performance of telecom industry is more and more high. The traditional physical database system can not satisfy the operational require- ments. In order to have better access efficiency, main memory database is generated. The synchronizaition problem between main memory database and oracle database system is studied based on basic telecommunications industry. With the ABM bal- ance management system as an example, the synchronization from the physical database into main memory database and syn- chronization from the main memory database into physical database are expounded. After extensive testing, the consistency, integrity, synchronization and real - time of the physical database and memory database are achieved.