FAULTS: An Equipment Maintenance and Repair Tracking System Using a Relational Database

D.C. Mudie

EECS Department
University of California, Berkeley
Technical Report No. UCB/ERL M91/44
May 1991

http://www2.eecs.berkeley.edu/Pubs/TechRpts/1991/ERL-91-44.pdf

FAULTS combines a forms-based user interface with a facility-wide relational database to record equipment maintenance and repair events as they occur. The semantics of preventive maintenance and repair events are formalized to create clear and unambiguous maintenance reports. Storing preventive maintenance and equipment failure information in a structured database has several benefits. Accumulated information is automatically indexed to aid diagnosis of failures as they occur. Equipment failure information is available to utility programs for display and statistical analysis to produce summaries such as preventive maintenance intervals, mean time between failures, predicted downtimes, performance trends, etc. FAULTS is installed in the U. C. Berkeley Microfabrication Facility where it is used to manage more than a hundred pieces of equipment. The FAULTS system has provided a significant improvement in the management of preventive maintenance and equipment repair information.

BibTeX citation:

@techreport{Mudie:M91/44,
    Author = {Mudie, D.C.},
    Title = {FAULTS: An Equipment Maintenance and Repair Tracking System Using a Relational Database},
    Institution = {EECS Department, University of California, Berkeley},
    Year = {1991},
    Month = {May},
    URL = {http://www2.eecs.berkeley.edu/Pubs/TechRpts/1991/1757.html},
    Number = {UCB/ERL M91/44},
    Abstract = {FAULTS combines a forms-based user interface with a facility-wide relational database to record equipment maintenance and repair events as they occur. The semantics of preventive maintenance and repair events are formalized to create clear and unambiguous maintenance reports. Storing preventive maintenance and equipment failure information in a structured database has several benefits. Accumulated information is automatically indexed to aid diagnosis of failures as they occur. Equipment failure information is available to utility programs for display and statistical analysis to produce summaries such as preventive maintenance intervals, mean time between failures, predicted downtimes, performance trends, etc. FAULTS is installed in the U. C. Berkeley Microfabrication Facility where it is used to manage more than a hundred pieces of equipment. The FAULTS system has provided a significant improvement in the management of preventive maintenance and equipment repair information.}
}

EndNote citation:

%0 Report
%A Mudie, D.C.
%T FAULTS: An Equipment Maintenance and Repair Tracking System Using a Relational Database
%I EECS Department, University of California, Berkeley
%D 1991
%@ UCB/ERL M91/44
%U http://www2.eecs.berkeley.edu/Pubs/TechRpts/1991/1757.html
%F Mudie:M91/44