PAC09 - List of Authors (Chan, A.)

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Chan, A.

Paper	Title	Page
FR5REP025	Device and Accelerator Modelling Relational Database	4820
	G.R. White, A. Chan, P. Chu, E. Grunhaus, P. Krejcik, K. Luchini, M. Woodley SLAC, Menlo Park, California
	Funding: Department of Energy contract DE-ACO3-76SF00515 We describe an integrated relational database for beamline element configuration and online accelerator modelling for LCLS. It is hosted in Oracle, from which online controls software, optimization applications and feedback, use a programming interface to acquire the element data and model. Database population is by an automated process starting with a MAD deck, which is processed in Matlab to derive text files that describe the beamline elements whose data are uploaded using Oracle Loader, and the resulting Oracle APEX applications and reports are used for survey, cabling, metrology and other facilities. An automated facility for online model generation creates an XAL online model beamline description file using a database query; the resulting model is then tracked, and results can be loaded back into the database. As such, both the design or extant machine model, of the present and all previous model runs are available, and linked to the relevant element configuration. We present the process flow from the MAD design to the database, the database schema, the database applications, the process of generating a machine model, and some scientific software which uses the database.

Paper

Title

Page

FR5REP025

Device and Accelerator Modelling Relational Database

4820

G.R. White, A. Chan, P. Chu, E. Grunhaus, P. Krejcik, K. Luchini, M. Woodley
SLAC, Menlo Park, California

Funding: Department of Energy contract DE-ACO3-76SF00515

We describe an integrated relational database for beamline element configuration and online accelerator modelling for LCLS. It is hosted in Oracle, from which online controls software, optimization applications and feedback, use a programming interface to acquire the element data and model. Database population is by an automated process starting with a MAD deck, which is processed in Matlab to derive text files that describe the beamline elements whose data are uploaded using Oracle Loader, and the resulting Oracle APEX applications and reports are used for survey, cabling, metrology and other facilities. An automated facility for online model generation creates an XAL online model beamline description file using a database query; the resulting model is then tracked, and results can be loaded back into the database. As such, both the design or extant machine model, of the present and all previous model runs are available, and linked to the relevant element configuration. We present the process flow from the MAD design to the database, the database schema, the database applications, the process of generating a machine model, and some scientific software which uses the database.