asset management software

understanding basic concept of asset management software

basic of asset management software Almost all of asset management software uses a database system called RDBMS – relational database management system. People who have access to this software has a specific user profile. the highest user profile is Power User profile which can use all feature and make full data changed. To get deep understanding asset management software, the Power User must learn about RDBMS like Oracle, My SQL or SQL Server. basically, all data are saved in some excellent tables inside the server. there is data communication between these tables. here some example: let say we have asset management software for asset integrity purposes. We have 3 tables on a server: equipment table, inspection table, and employee table. A user can use “client software” to find “how many inspection jobs conducted by Messi in January 2010?” inspection record date inspector method equipment result 1001 1-Jan-10 3001 UTM 2016 good 1002 2-Jan-10 3002 UTM 2017 good 1003 3-Jan-10 3003 ILI 2013 need repair 1004 4-Jan-10 3004 ILI 2014 need repair 1005 5-Jan-10 3005 LRUT 2015 good 1006 6-Jan-10 3001 LRUT 2011 good 1007 7-Jan-10 3002 Vibration 2001 good 1008 8-Jan-10 3003 Vibration 2002 good 1009 9-Jan-10 3004 Vibration 2003[…]

Read more