Grand Unified Relational Database It all starts with

Grand Unified Relational Database

It all starts with naming…

Gurd’s Complete Hierarchical Device and Signal Naming Convention System: Device: Signal Eg: Linac_Diagnostics: BPM 3: XPosition …but what device is the signal named after?

Gurd’s Complete Accelerator and Control System Drawing … there are (at least) 3 possibilities Controller ADC, DAC etc Signal Transducer Some accelerator device or component eg Quadrupole, BPM, Vacuum Pump Answer: It should be named after the device it is a property device

Devices with no measurable properties (eg the transducer and/or the ADC) can still be named with the same convention: System: Device

The Name makes one set of links – The RDB makes the rest l “Signals” need to be linked to several devices (components): » The device it is a property of (and is named after) » The tranducer » The device it plugs in to (Controller, ADC, etc) l “Devices”/Components need to be linked to: » The device it passes signal information to » The device it is housed in » The device it draws power from » Information about the “equipment” (“hunk of steel”) it was

Gurd’s Complete RDB Schema “Devices” Data about their function in the accelerator “Equipment” Data independent of function – “hunks of steel” Operations Maintenance Physics Property Calibration