基于物化视图的Oracle增量备份方法的实现

Implementation of Incremental Backup Based on Oracle Materialized View

为缓解HIS主服务器压力,提高数据安全性和保密性,本文研究使用Oracle物化视图实现数据库的实时增量备份,同时对敏感数据进行过滤。该系统功能完整,实用性强,辅以图形界面以简化系统操作和维护。系统实施后,通过访问备份数据库,有效缓解了主服务器的负载压力,扩大了数据使用范围,达到了预期的设计要求。

To ease the pressure on the main server of HIS, increase data security and privacy, this paper researches the real-time incremental backup of database with Oracle materialized view, and fiheres the sensitive data. The system is fully functional, prac- tical, and achieves a graphical interface to simplify system operation and maintenance. After implementation, as expected, it ef- fectively alleviates the pressure on the main server load by using the backup database, and expands the use scope of data.