Log management approach in three-dimensional spatial data management system

Log management is essential to register the three-dimensional spatial data. It plays the role of auditing and monitoring in the system. The traditional method of log management is to set up a management module which records the users' manipulations respectively for each function. Though it's easy to apply such a management system, it consumes more time and energy. Another method is only to use the triggers to record the users' operations. But if this method is adopted, the information would be lost before the triggers were created manually. Thus it's necessary to design an efficient system to improve this situation. This log management designed in this paper introduces the stored procedures and triggers to design a log system to store and manage the three-dimensional spatial data. The stored procedure is used to create triggers and Oracle database tables which are applied for recording information. Triggers would be fired when users do anything to the records stored in the Oracle database tables. It also sets the switches to disable and enable triggers timely to release resources. All the tables and triggers are created dynamically by procedures. Once users created a user account on the Oracle database, the system would create all tables and triggers by calling the procedure which written in the system package. It can save a lot of time for the user and record all the operations in case users damage the data before the tables were created. Oracle database records the concrete operations, including operate-times, operate-types, Ips, usernames, etc. And the log files of this system are designed especially for recording each detail of the operations. The administrator is able to do the recovery operation according to the log management system. So it is essential to use the log management system to insure the safety of the three-dimensional spatial data. This system cuts down the programmers' workload for writing duplicate codes. It is not only an improvement to the Oracle database application performance for the three-dimensional spatial data management and the developer productivity, but also a consolidation to the three-dimensional spatial data management security.