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.

asset management software
asset management software

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?”

integrity database management system trending
integrity database management system trending
inspection recorddateinspectormethodequipmentresult
10011-Jan-103001UTM2016good
10022-Jan-103002UTM2017good
10033-Jan-103003ILI2013need repair
10044-Jan-103004ILI2014need repair
10055-Jan-103005LRUT2015good
10066-Jan-103001LRUT2011good
10077-Jan-103002Vibration2001good
10088-Jan-103003Vibration2002good
10099-Jan-103004Vibration2003good
101010-Jan-103005UTM2018good
10111-Feb-103001UTM2019good
10122-Feb-103002Vibration2008good
10133-Feb-103003Vibration2009good
10144-Feb-103004Vibration2010good
10155-Feb-103005Vibration2007good
10164-Mar-103001UTM2020good
10175-Mar-103002UTM2021good
10186-Mar-103003UTM2022need repair
10197-Mar-103004UTM2023good
10208-Mar-103005LRUT2024good
Asset NumberEquipment NumberEquipment typeequipment name
2001P-001Pumpwater pump A
2002P-002Pumpwater pump B
2003P-003Pumpwater pump C
2004P-004Pumpcrude oil pump A
2005P-005Pumpcrude oil pump B
2006P-006Pumpcrude oil pump C
2007P-007Pumpcrude oil pump D
2008C-001compressorgas compressor A
2009C-002compressorgas compressor B
2010C-003compressorgas compressor C
2011PI-001pipewater pipe
2012PI-002pipeoil pipe
2013PI-003pipegas pipe
2014PI-004pipechemical pipe
2015PI-005pipeshipping pipe
2016V-001vesselseparator
2017V-002vesselKO drum
2018V-003vesselgas scrubber
2019V-004vesselgas boot
2020V-005vesselstripper
2021T-001Tankwater tank
2022T-002Tankoil tank
2023T-003Tanksurge tank
2024T-004Tankchemical tank
employee numbername
3001Sane
3002Barry
3003Salah
3004Messi
3005Ronaldo

how the asset management software work?

  1. go to the employee table, find employee name “Messi” and its employee number –> 3004.
  2. go to the inspection table, find inspector = 3004. calculate the quantity of inspection record in January 2010. result = 1

this is a simple example of how asset management software work by using correlation of 2 tables.

in actual application, the asset management software consists many tables which related each other. if you interested to learn more about asset management software, then you can start with some subject below

Microsoft excel functionsum, count, vlook up, pivot table
if function,
script or syntaxget, add date, julian date, gregorian date, joint table
data typefloat, integer, double, date
VBA – Visual basic application or Macro Excel
database connection

Leave a Reply