A decision support system to manage the maintenance schedule of vehicles

Abstract

This study concentrated on designing, developing, and implementing a decision support system (DSS) to track the maintenance schedules of an organization such as a university’s fleet of vehicles. The schedule takes into account the mobile and immobile vehicles at any point in time, the vehicles due for scheduled maintenance, vehicles due for insurance renewal etc.The database design was done using entity relationship modeling (ERM) technique and subsequently developed a data warehouse (DWH) that contained records of the vehicles such as insurance type, servicing type, make and model etc. The DWH was implemented using MariaDB running through PhpMyAdmin as the administrative GUI interface. The developed DWH was next deployed as a Web application using the Yii PHP component framework just to give the developed software a global reach.With that done, taking decisions as to which vehicle is mobile and which is immobile, which requires insurance renewal, which requires servicing etc. at any point in time, is properly tracked and regulated.

Keywords: data, warehouse, decision, support, system, Yii, Framework, vehicles