Software design for a database driven system for accelerator magnet measurements

Brown, Bruce; Bleadon, M.; Glass, H.; Glosson, R.; Hanft, R.; Harding, David J.; Mazur, Péter; Pachnik, J.E.; Sim, J.W.; Trombly-Freytag, K.; Walbridge, D.G.C.

doi:10.1109/pac.1991.164890

Cited by 4 publications

(3 citation statements)

References 2 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…In previous years, the main dipole magnets were designed, prototyped, produced, measured, and installed. These efforts were supported by magnet measurements with existing [2] and newly commissioned [3][4] [5] systems at the Fermilab Magnet Test Facility (MTF) 1 . A summary of these efforts with complete references was recently presented [6] which covers most magnet production and accelerator operation issues.…”

Section: Introductionmentioning

confidence: 99%

Magnetic field measurements of Fermilab main injector dipoles

Brown

DiMarco²,

Glass³

et al. 2000

IEEE Trans. Appl. Supercond.

Self Cite

View full text Add to dashboard Cite

show abstract

Section: Introductionmentioning

confidence: 99%

Magnetic field measurements of Fermilab main injector dipoles

Brown

DiMarco²,

Glass³

et al. 2000

IEEE Trans. Appl. Supercond.

Self Cite

View full text Add to dashboard Cite

show abstract

“…Software for a magnet measurement system[1], [2] has been created at Fermilab. This paper describes the database design and implementation which supports that system and provides access to the measurement results as well as the complete description of the measurement environment.…”

Section: Software Environmentmentioning

confidence: 99%

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

Sim

Brown

Glass

et al.

Proceedings Particle Accelerator Conference

Self Cite

View full text Add to dashboard Cite

A magnet measurement system based on relational database technology has been developed for use at the Fermilab Magnet Test Facility (MTF). Results of magnetic ®eld strength and ®eld 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. I. SOFTWARE ENVIRONMENTSoftware for a magnet measurement system[1], [2] has been created at Fermilab. This paper describes the database design and implementation which supports that system and provides access to the measurement results as well as the complete description of the measurement environment. We use the Sybase 1 relational database system, employing features of the standard relational model plus additional vendor speci®c features which have reduced implementation effort. The measurement system was developed primarily to support testing of magnets for the Fermilab Main Injector Project[3], but it also has been used to measure magnets for other applications. II. DATABASE DESIGN OVERVIEWThere are several distinguishing features in the MTF database design including:Tables with closely related functionality are grouped together into ªvirtual databases.º For example, measurement data obtained by rotating a coil in the ®eld are stored in the ªharmonicsºvirtual database, while measurement data obtained by scanning and measuring the the ®eld at various points are stored in ªpointscan.º Data are grouped into related tables based on natural hierarchies derived from data collection (points, runs, sequences) and data processing (raw, reduced, analyzed) relationships. Special procedures called triggers are executed to enforce the integrity of the relationships between data entered into the various database tables.

show abstract

“…[7,8,9,10,11,12], produced [13,14], measured [15,16,17,18,19,20,21], installed [22], and commissioned [23,24].…”

Section: Measurementsmentioning

confidence: 99%

Strength and shape of the magnetic field of the Fermilab Main Injector dipoles

Harding

Brown²,

DiMarco³

et al.

Proceedings of the 1999 Particle Accelerator Conference (Cat. No.99CH36366)

Self Cite

View full text Add to dashboard Cite

MAGNET STRENGTHMeasurements of 230 6-meter and 136 4-meter dipoles constructed for the Fermilab Main Injector were carried out as part of the magnet production effort. An automated measurement system provided data on magnetic field strength and shape using several partially redundant systems. Results of these measurements are available for each individual magnet for use in accelerator modelling. In this report we will summarise the results on all of the magnets to characterise the properties which will govern accelerator operation.Groups 4 and 5 define our nominal magnet strength at each current.The mean strength, including me 4-m magnets weighted at 2/3 of the 6-m magnets, was calculated for each current. Deviations from that strength (for the 6-m magnets) or from 2/3 of that strength (for the 4-m magnets) are normalized to the nominal strength of the 6-m magnets.These deviations are quoted here in "units" of parts in 104.

show abstract

Software design for a database driven system for accelerator magnet measurements

Cited by 4 publications

References 2 publications

Magnetic field measurements of Fermilab main injector dipoles

Magnetic field measurements of Fermilab main injector dipoles

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

Strength and shape of the magnetic field of the Fermilab Main Injector dipoles

Contact Info

Product

Resources

About