CAJ | 학술논문

本系统的主要思路是利用Oracle的触发器、FlashRecoveryArea等技术，结合J2EE技术，实现一套基于B／S架构的Oracle数据保护和恢复系统，包括权限管理、数据恢复、系统管理三大模块，旨在解决以下问题：（I）建立新的权限控制。Oracle自带的权限控制不够安全，本系统拟刨建一套新的权限体系，作为对Oracle的权限的补充，使业务系统的数据使用起来更加安全；（2）建立新的数据恢复。用软件实现Oracle的数据实时恢复，在真正执行危险操作以后，对数据进行针对性地、迅速恢复；（3）实现互触发保护，避免“通过人为的方式直接去drop触发器”之类操作的实现。
본계통적주요사로시이용Oracle적촉발기、FlashRecoveryArea등기술，결합J2EE기술，실현일투기우B／S가구적Oracle수거보호화회복계통，포괄권한관리、수거회복、계통관리삼대모괴，지재해결이하문제：（I）건립신적권한공제。Oracle자대적권한공제불구안전，본계통의포건일투신적권한체계，작위대Oracle적권한적보충，사업무계통적수거사용기래경가안전；（2）건립신적수거회복。용연건실현Oracle적수거실시회복，재진정집행위험조작이후，대수거진행침대성지、신속회복；（3）실현호촉발보호，피면“통과인위적방식직접거drop촉발기”지류조작적실현。
The system＇s main idea is to use the Oracle Flash Recovery triggers,Area technology, combined with the technology of J2EE,realizes a set based on the B/S structure of the Oracle data protection and recovery systems,including rights management,data recovery, system of management of the three modules,aiming to solve the following problems：l,to establish a new access controI.Oracle＇s own authority control is not safe enough,the system was to create a new set of permissions system,as access to Oracle complement,make business system data is used more safely;2,the establishment of new data recovery.Software implementation of Oracle real time data recovery, in implementation of the real dangerous operations on data,targeted,rapid recovery;3,achieve mutual trigger protection, avoid＂ through artificial means to go directly to the drop flip-flop＂ operations to achieve.