Zaharieva, Z.

Paper	Title	Page
TUA004	Automatic Inventory and Configuration Management Tools for the LHC Power Converter Controls	55
	S. T. Page, Q. King, Z. Zaharieva CERN, Geneva
	The LHC has more than 1700 power converters of a variety of different designs, each of which is itself composed of many hardware components. These components must be individually tracked throughout their lifetimes for inventory purposes. Additionally, each component may have associated configuration and calibration values that must follow the component wherever it is installed within the accelerator. The complete history of the inventory and configurations must be retained as well as the calibration values in order to track their evolution. With such a large machine the probability of human error is high, therefore an automated solution is desirable. A system was put in place for the LHC power converter controls that automatically detects the connection of a new device, updates its location and loads its configuration and calibration values from a database within a few seconds. The identification of all key components is remotely readable via the control system. This paper describes the system, detailing its architecture, choices made and results achieved as well as challenges overcome during its implementation.
	Slides
TUB001	Accelerator Data Foundation: How It All Fits Together	61
	R. Billen, P. Le Roux, M. Peryt, C. Roderick, Z. Zaharieva CERN, Geneva
	Since 2003, a coherent data management approach was envisaged for the needs of installing, commissioning, operating and maintaining the LHC. Data repositories in the distinct domains of physical equipment, installed components, controls configuration and operational data have been established to cater for these different aspects. The interdependencies between the domains have been implemented as a distributed database. This approach, based on a very wide data foundation, has been used for the LHC and is being extended to the CERN accelerator complex.
	Slides
THP108	Rapid Development of Database Interfaces with Oracle APEX, Used for the Controls Systems at CERN	883
	Z. Zaharieva, R. Billen CERN, Geneva
	The need to rapidly prototype, build and deploy applications and to be able to react immediately to the changing user requirements is a challenge facing every enterprise. CERN - the largest particle research centre in the world - has tremendous data storage requirements, encompassing many different databases and has to quickly provide interfaces to visualize the data. This article will cover how Oracle APEX has been used to build several different database-centric interfaces related to the accelerator complex. Real-world applications will be discussed and it will be shown how Oracle APEX has met the preliminary requirements of the application developers and the user community at CERN. The article will address the question of when APEX could be a suitable choice of application development technology, and will share a developer's first-hand experience of both the good and bad points.
	Poster
THA005	CERN Proton Synchrotron Complex High-Level Controls Renovation	638
	S. Deghaye, M. Arruat, D. Garcia Quintas, M. Gourber-Pace, G. Kruk, O. Kulikova, V. V. Lezhebokov, S. Pasinelli, M. Peryt, C. Roderick, E. Roux, M. Sobczak, R. R. Steerenberg, J. P. Wozniak, Z. Zaharieva CERN, Geneva
	After a detailed study of the PS complex requirements by experts of the CERN controls & operation groups, a proposal to develop a new system, called Injectors Control Architecture (InCA), was presented to and accepted by the management late 2007. Aiming at the homogenisation of the controls systems across CERN accelerators, InCA is based on components developed for the Large Hadron Collider (LHC) but also new components required to fulfill operation needs. In 2008, the project was in its elaboration phase and we successfully validated its architecture and critical use-cases during several machine development sessions. After a minute description of the architecture put in place and the components used, this paper will describe the planning approach taken combining iterative development phases with deployment in operation for validation sessions.