WP3: Infrastructure Web- Based Database

WP3:

Infrastructure

Web-Based Database

Peter McIntosh

(STFC, Daresbury Laboratory)

TIARA Mid-Term Review Meeting,

Madrid, 12 - 14th _{June 2012.}

TIARA Objectives

• The main objective of TIARA is the integration of national and international accelerator R&D

infrastructures into a single distributed European

accelerator R&D facility with the goal of

developing and strengthening state-of-the-art research, competitiveness and innovation in a

sustainable way in the field of accelerator Science and Technologies in Europe.

• Besides maximizing the benefits for the owners of the infrastructures and their users, TIARA aims at

establishing a framework for developing and supporting strong joint European programmes:

– for accelerator Research and Development, – for Education and Training,

WP3 Infrastructure Survey

– Is the infrastructure available for TIARA access? – How to access

– Support available – Contact details – Keywords

• Key Accelerator Research Area

• Key Technical Issues

• Costing Model:

– Operations staffing level (FTE’s) – Annual operating costs

– Costing model employed – Investment cost

Infrastructure Data Collected

• 140 infrastructures surveyed and listed in the D3.1 Infrastructure Survey Report, Annex 2:

– https://cdsweb.cern.ch/record/1426607

• In the process of uploading infrastructures:

– Austria 1 – Denmark 1 – Finland 1 – France 19 – Germany 13 – Italy 13 – Poland 6 – Slovenia 1 – Spain 8 – Sweden 3 – Switzerland 61 – UK 13

• 85% of ISR survey data currently available in database (13/6/12).

• More infrastructures continually identified, which are being added as appropriate.

WP3 Survey Collection

Loïc Bordais (CNRS) France, Belgium

Antoine Daël (CEA) France

Peter McIntosh (STFC) UK

Hans Mueller (GSI) Germany

Diego Obradors (CIEMAT) Spain

Paolo Pierini (INFN) Italy

Roger Ruber (UU) Nordic countries &

Netherlands

Thomas Schietinger (PSI) Switzerland

Anders Unnervik (CERN) Switzerland

Hans Weise (DESY) Germany

Slawomir Wronka (IFJ PAN) Poland & former East

Infrastructure Number Ion Beam facility 14 Magnet testing 13 Linac Accelerators 11 Vacuum coating & preparation 8 Proton source 6 SRF system testing 6 Irradiation facility 6 Cryogenic testing 6 SRF cavity preparation 5 Stabilisation and alignment 5 SR Accelerators 5 Medical Therapy 4

Ion source 4

Material analysis 4 Instrumentation 4 Component vacuum brazing 3

Infrastructure Number Photo-injectors 2 ERL Accelerators 2 Collider Accelerator 2 Neutron generation 2 Power converter test facility 2 Plasma wakefield generator/accelerator 2 Electro static Storage Ring 1 Positron source 1 Coordinate measurement 1 Ion implanter 1 Radiation reactor 1 Anti-proton Accelerator 1 Neutroino facility 1 Chemistry laboratory 1 Polymer Laboratory 1 FFAG Accelerator 1 Ionisation Cooling 1

Infrastructure Spectrum

• Austria – Medaustron • Denmark – Aarhus University • Finland – University of Jyväskylä • France – CEA Saclay – CNRS/IN2P3 – Ganil • Germany – DESY

– Karlsruhe Institute of Technology – Helmholtz Zentrum Berlin

– TU Dortmund – HZD‐Rossendorf

– Research Instruments – GSI

• Italy

– INFN Genova, Catania, Frascati, Legnaro, Segrate

– SINCROTRONE TRIESTE

• Poland

– National Centre for Nuclear Research – Warsaw University of Technology • Slovenia

– Jozef Stefan Institut • Spain

– CIEMAT – CELLS

– Insituto de Fisica Corpuscular – Universidad Autonoma de Madrid – National Center of Accelerators – ESS BILBAO CONSORTIUM

• Sweden – Lund University – Uppsala University • Switzerland – CERN – PSI • UK – Strathclyde University – STFC Daresbury Laboratory – STFC Rutherford Laboratory – Diamond Light Source

Database Development Platform

• STFC database development team:

– Stephen Buckley (STFC, ASTeC)

– Joan Berry (STFC, CSE)

– Stephen McGill (STFC, ROE)

• Database – MS SQL server 2005 database.

• Server platforms for both web application and database are Windows 2003 R2 Standard Edition.

• Web front end - Internet Information Services 6 (IIS 6 SP2), written in ASP, Javascript and VBScript technologies.

• Both packages running on a Windows 2003 server.

• Cookies are used throughout the web application and must be enabled on the clients computer.

• SSL encryption provision included:

Web-based Database Requirements

• Allow TIARA participants to register new test infrastructures for TIARA purposes.

• Allow any potential user to interface and interrogate the database to obtain all required information relating to a infrastructure

availability.

• Processes comprise 4 main functionalities. 1. Data entry portal:

– Prescriptive unambiguous question entry system.

2. Data storage and manipulation:

– Standard SQL processes employed.

3. Data post processing and interrogation:

– Appropriate categorisation, filtering, data export and display.

4. Data security provision:

– Restricted data entry and data encryption.

WP3: Infrastructure Database

Geographical Searching

Search Field - FRANCE

Organisational Searching

Facility Searching

Infrastructure Searching

Additional Features to be Included

• Multiple KARA/KTI input selection:

– Demo developed, but needs further testing.

• As infrastructure survey initiated before the database

development, need to remove remaining data

ambiguity:

– Introduce additional selection options rather than free text input.

– Assimilate infrastructure descriptions to a smaller, more concise set of categories, refinement underway.

• Provide a normalised operational & investment cost:

review.

• Provide infrastructure plotting capability:

– Infrastructure type per Country.

– Infrastructures open for access and location. – Infrastructure investment with variety of filters.

Summary

• 140 accelerator infrastructure profiles/descriptions obtained from 37 Laboratories, Institutes and/or Universities across Europe:

– Details presented in D3.1 Infrastructure Survey Report.

– More infrastructures being continually identified and included.

• Key Accelerator Research Areas (KARA) and Technical Issues (KTI) defined by WP4.

• Web-based database developed via WP3 coordination:

– Undergoing testing and final stages of iteration.

• Accelerator infrastructures being categorised against KARA/KTIs.

• Improvements ongoing to refine survey data collected and provide ease of interrogation.

• TIARA will use this information to identify infrastructure priorities and deficiencies: