Cart (Loading....) | Create Account
Close category search window
 

Log management approach in three-dimensional spatial data management system

Sign In

Cookies must be enabled to login.After enabling cookies , please use refresh or reload or ctrl+f5 on the browser for the login options.

Formats Non-Member Member
$31 $13
Learn how you can qualify for the best price for this item!
Become an IEEE Member or Subscribe to
IEEE Xplore for exclusive pricing!
close button

puzzle piece

IEEE membership options for an individual and IEEE Xplore subscriptions for an organization offer the most affordable access to essential journal articles, conference papers, standards, eBooks, and eLearning courses.

Learn more about:

IEEE membership

IEEE Xplore subscriptions

4 Author(s)
Jing Li ; Sch. of Comput. Sci. & Technol., China Univ. of Geosci. (Wuhan), Wuhan, China ; Xing Li ; Gang Liu ; Zhenwen He

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 th- - e 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.

Published in:

Geoinformatics, 2010 18th International Conference on

Date of Conference:

18-20 June 2010

Need Help?


IEEE Advancing Technology for Humanity About IEEE Xplore | Contact | Help | Terms of Use | Nondiscrimination Policy | Site Map | Privacy & Opting Out of Cookies

A not-for-profit organization, IEEE is the world's largest professional association for the advancement of technology.
© Copyright 2014 IEEE - All rights reserved. Use of this web site signifies your agreement to the terms and conditions.