A software system for measurement of accelerator magnets using a relational database
- and others
Two major upgrades to the Fermilab accelerator complex required the measurement of magnetic field strength and shape for a large number of electromagnets and permanent magnets. This paper describes the software system developed at Fermilab to measure these magnets. The data produced by this system was used to feed back information to the magnet design and fabrication process, as well as to help in determining magnet placement within the accelerator. The central framework of the measurement software is a relational database management system (RDBMS). Tables within the RDBMS are designed to store magnet design and identification information, measurement prescriptions, magnetic field strength and shape data, comment text entered by measurement technicians, lists of instrumentation used during measurements, calibration constants used to convert data to appropriate engineering units, and quality control limits for measurement data. The system employs a client-server architecture in which measurement computers, distributed at each of the magnet test stands, retrieved measurement prescriptions from the RDBMS server, controlled the data acquisition hardware used to run the measurement, and communicated measurement data back to the RDBMS. Additional client software was developed to apply analysis algorithms to the measurement data. These clients run either at the test stand, or from analysts' workstations. Standard tools provided by the RDBMS vendor facilitated report generation, ad-hoc queries, and manual data entry.
- Research Organization:
- Fermi National Accelerator Lab. (FNAL), Batavia, IL (United States)
- Sponsoring Organization:
- USDOE Office of Energy Research (ER) (US)
- DOE Contract Number:
- AC02-76CH03000
- OSTI ID:
- 12605
- Report Number(s):
- FERMILAB-Conf-99-275; TRN: US0102566
- Resource Relation:
- Conference: 16th International Conference on Magnet Technology, Tallahassee, FL (US), Conference dates not supplied; Other Information: PBD: 8 Oct 1999
- Country of Publication:
- United States
- Language:
- English
Similar Records
MDI: Mathematica database interface for the MFEDB
Maintenance of Maywood Laboratory Operations Support During Contractor Transition and Replacement of the Project Databases - 16329