|
|
|
|
 |
| A CMMS is nothing more than a sophisticated relational database... |
|
| As with any database, it needs to be properly managed to ensure data integrity. It all starts with a good backup and recovery process. Should something go wrong your only as good as your last backup. |
|
| In order to keep your CMMS database current, there needs to be a policy for archiving of ‘old’ information. Ensuring that the archiving is performed on a timely basis usually keeps the database at a manageable size based upon allocated disk capacity and provides for improved system performance. Often the display and reporting times are improved. In addition to properly securing the archived data, a trial recovery of this information is a prudent test. There is no point to archiving data if it will not or cannot be retrieved. |
|
|
|
|
|
| Effective database management produces accurate and meaningful reports that help you identify problems and trends. With this information, you can deploy those limited resources to where they will make the biggest impact. This will reduce downtime and scrap costs which in turn will hit the bottom line on the financial statements. When people see the system working and know it can be trusted, they will feel better about putting the effort into maintaining the database. This means that all the hard work to build and maintain that pristine database was not wasted. |
|
|
|
|
|
