基于ORACLE数据库的数据管理措施

Method of Data Management Based on Oracle Database

基于 Oracle 数据库的系统数据库管理旨在数据操作和双机热备的安全。以某政府市区乡三级综合信息数据库管理为例,设计上中下三层数据库管理模块。用数据管道实现数据的合并与分离;用嵌入式 SQL 语句实现数据删除;用 ORACLE 逻辑备份实现系统的备份与恢复;双机热备实现数据库的连续性和安全性。

The system database management based on Oracle database management system aims at data operating and the security of online backup of double computer. Taking third class management of integrated information database for a city, district and town of a government as an example, three layers module of database management was designed. The amalgamation and separation of the data was realized with the data pipeline, and the deletion of the data was completed with embedded SQL sentence. The backup and recovery of system was accomplished with Oracle logic backup. The continuity and security of the database was achieved with the online backup of double computer.