%0 Journal Article %@ 18675662 %A Kasbon, R. %A Shaharom, S. %A Mazlan, E.M. %A Mahamad, S. %C Shenzhen %D 2012 %F scholars:3024 %J Advances in Intelligent and Soft Computing %K Active database; Electrical equipment; Event condition action rules; Integrated database; Oil and gas; Oil and gas companies; Traffic light; Work process, Electrical engineering; Gas industry; Knowledge engineering; Public utilities; Software engineering, Database systems %N VOL. 2 %P 99-107 %R 10.1007/978-3-642-25349-2₁₄ %T Implementing an active database for maintaining asset data %U https://khub.utp.edu.my/scholars/3024/ %V 115 AI %X This paper presents an approach of using an active database to store asset data. The asset here is referring to motors that are being used for the operation of oil and gas electrical equipments. An Electrical Engineering Department of an Oil and Gas company is now working on a move to restore work process improvement in order to resolve the current problem faced, which is the scattered asset database. With such problem in place, it is important to have an integrated database which allows them to track and record numerous motor histories as well as able to produce constructive information with regards to the overhauling of motors. This project aims to develop an active database whereby it can act as a tool to indicate the progress of work (motor overhaul) by using a traffic light system; e.g. green, yellow and red color-coding based on pre-specified criteria. © 2012 Springer-Verlag GmbH. %Z cited By 1; Conference of 2009 Pacific-Asia Conference on Knowledge Engineering and Software Engineering, KESE 2009 ; Conference Date: 19 December 2009 Through 20 December 2009; Conference Code:89187