Abstract: 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 filteres the sensitive data. The system is fully functional, practical, and achieves a graphical interface to simplify system operation and maintenance. After implementation, as expected, it effectively alleviates the pressure on the main server load by using the backup database, and expands the use scope of data.

Key words:  materialized view, Oracle, incremental backup, data security, data filtering