A relational database for magnets and measurement systems at the Fermilab Magnet Test Facility

Author

Sim, J.W. ; Brown, B.C. ; Glass, H.D. ; Harding, D.J. ; Mishra, C.S. ; Russell, A.D. ; Trombly-Freytag, K. ; Walbridge, D.G.C.

Author_Institution

Fermi Nat. Accel. Lab., Batavia, IL, USA

Volume

4

fYear

1995

fDate

1-5 May 1995

Firstpage

2282

Abstract

A magnet measurement system based on relational database technology has been developed for use at the Fermilab Magnet Test Facility (MTF). Results of magnetic field strength and field shape measurements are stored in the database for use in understanding accelerator and beamline operation. In addition to measurement results, the database is used to store measurement history and the commands which prescribe measurement sequences along with supporting parameters that control how each measurement is performed. The system contains more than 200 tables with more than 1500 columns. The design of the tables is documented in the form of diagrams, design documents, as well as through tables which store, within the database itself, descriptions of each table and column

Keywords

accelerator magnets; high energy physics instrumentation computing; magnetic field measurement; relational databases; test facilities; Fermilab Magnet Test Facility; design documents; diagrams; magnetic field shape measurements; magnetic field strength measurement; magnets; measurement systems; relational database; tables; Coils; Current measurement; Magnetic field measurement; Magnets; Performance evaluation; Relational databases; Rotation measurement; Shape measurement; Spatial databases; System testing;

fLanguage

English

Publisher

ieee

Conference_Titel

Particle Accelerator Conference, 1995., Proceedings of the 1995

Conference_Location

Dallas, TX

Print_ISBN

0-7803-2934-1

Type

conf

DOI

10.1109/PAC.1995.505525

Filename

505525