Database security protection, database backup and disaster recovery are important tasks for all colleges and universities to ensure the safe and stable operation of information systems. Based on the operating environm...Database security protection, database backup and disaster recovery are important tasks for all colleges and universities to ensure the safe and stable operation of information systems. Based on the operating environment of the Oracle production database in China University of Geosciences (Beijing), combined with the practical operation and maintenance experience, this paper provides a design and implementation case of Oracle database security protection system and disaster recovery architecture. The network security protection architecture of the three-layer firewall and fortress machine, the detection and repair of security vulnerabilities, the management of system accounts and permissions, data encryption and database audit constitute the security protection system of the database. Oracle RAC (Real Application Clusters), Oracle DataGuard, redundant backup management and backup recovery constitute the disaster recovery architecture of the database. The case has practical significance for database operation and maintenance management in other colleges and universities.展开更多
An Oracle8i-based approach is proposed to manage the integrated databases oflarge CyberCity. This approach consists of three schemes: ① a special R+-tree index is designed toaccelerate spatial retrieving, in which th...An Oracle8i-based approach is proposed to manage the integrated databases oflarge CyberCity. This approach consists of three schemes: ① a special R+-tree index is designed toaccelerate spatial retrieving, in which the bounding boxes of local regions have no intersection andall leaf nodes of the R+-tree (geometry records ) have no repetition; ② different data compressionalgorithms are adopted to compress the digital elevation models, 3D vector models and images, suchas LZ77 lossless compression algorithm for compression of vector data and JPEG compressionalgorithms for texture images; ③ in order to communicate with Oracle8i database, a CyberCity GIS.spatial database engine (SDE) is designed. On the basis of this SDE prototype a case study is done.展开更多
文摘Database security protection, database backup and disaster recovery are important tasks for all colleges and universities to ensure the safe and stable operation of information systems. Based on the operating environment of the Oracle production database in China University of Geosciences (Beijing), combined with the practical operation and maintenance experience, this paper provides a design and implementation case of Oracle database security protection system and disaster recovery architecture. The network security protection architecture of the three-layer firewall and fortress machine, the detection and repair of security vulnerabilities, the management of system accounts and permissions, data encryption and database audit constitute the security protection system of the database. Oracle RAC (Real Application Clusters), Oracle DataGuard, redundant backup management and backup recovery constitute the disaster recovery architecture of the database. The case has practical significance for database operation and maintenance management in other colleges and universities.
基金Project supported by the National Key Basic Research and Development Program (No. 2002CB312101) the National Natural Science Foundation of China (No.40001017).
文摘An Oracle8i-based approach is proposed to manage the integrated databases oflarge CyberCity. This approach consists of three schemes: ① a special R+-tree index is designed toaccelerate spatial retrieving, in which the bounding boxes of local regions have no intersection andall leaf nodes of the R+-tree (geometry records ) have no repetition; ② different data compressionalgorithms are adopted to compress the digital elevation models, 3D vector models and images, suchas LZ77 lossless compression algorithm for compression of vector data and JPEG compressionalgorithms for texture images; ③ in order to communicate with Oracle8i database, a CyberCity GIS.spatial database engine (SDE) is designed. On the basis of this SDE prototype a case study is done.
