DATABASE APPLICATION FOR CONTROL SYSTEM HARDWARE MANAGEMENT

The Paul Scherrer Institute (PSI) is operating at present two accelerator facilities, and a third one is under construction. The control system hardware for these facilities is managed by a single group. To be able to keep track of the hardware (more than 300 VME and CAMAC systems), database applications are being developed. The set of applications provide features to track the stock status as well as the life cycle of components. It will also optimise the spare parts stock and improve the overall quality of service. The paper presents the conceptual design and implementation, using object relational methods, of the Oracle RDBMS and web application server.