160 likes | 276 Views
ORNL/BNL Discussion on Database. ACCELERATOR PHYSICS VIEW ON RING DATABASE. Jie Wei SNS Ring/Transport Lines. March 13, 2002. Database functions. Ring databases classified in three categories Optics Database Generic Device Database (GDDB) Magnet, Alignment and Survey Database
E N D
ORNL/BNL Discussion on Database ACCELERATOR PHYSICS VIEW ON RING DATABASE Jie Wei SNS Ring/Transport Lines March 13, 2002
Database functions • Ring databases classified in three categories • Optics Database • Generic Device Database (GDDB) • Magnet, Alignment and Survey Database • From design, to generic devices, to actual elements • Similar database structure as for RHIC (SYBASE) • Magnet, alignment, survey database similarly developed for LHC during US-LHC collaboration • Similar magnet & survey database structure developed for SNS (S. Sathe)
Optics Database • Generate input files to existing codes • Standard Input File (MAD, TEAPOT); TRACE3D; TRANSPORT • DBSF developed for RHIC SYBASE (S. Tepikian) • Magnet strength tables • Aperture • … • Support on-line applications • Transfer matrices; optics editor; … • Support off-line analysis
Generic Device Database • Correlates names (name look-up) • Site-wide name or survey slot names • Assembly name • Serial name for devices • Magnet families • Power supply wire-up • Half-cell type and component • … • Reflects status of the machine device (spares replacement, hook-up) • Record hierarchical structure of the machine
Magnet Database • Record measurement data • Serial name, measurement date, run number, type, ... • Transfer function (integral, body, ends) • Field angle, field angle deviation • Multipole error data • Local field map • Quality assurance • Record repair history • Record assembly assignment • Record spare and replacement history • Sorting and installation support
Survey Database • Need to re-define magnetic center • Correct magnet center offset and rolls (offset between magnetic and mechanical center, due to e.g. residual ITF variation) • Record magnet fiducial positions? • BPM center not measured – beam based correction • Re-center & correct magnet misalignment
Magnet analysis & survey support • Database for magnet measurement & survey data • Field quality analysis • Corrector strength setting • Magnet sorting • Fiducialization & placement in global coordinate system • Survey & misalignment evaluation • Beam-based correction
Summary • Three steps: design, generic device, actual measurement • We are already behind (e.g. magnet & survey database) • Fill-up magnet database • Define and record center; be ready for sorting & survey correction • Record repair/rework history; record half-cell assignment • How do we use optics database? • A software to extract lattice file from the database?