Transcript Th_5_McIntosh_-_TIARA_WP3_Database_v3

WP3: Infrastructure WebBased Database
Peter McIntosh
(STFC, Daresbury Laboratory)
TIARA Mid-Term Review Meeting,
Madrid, 12 - 14th June 2012.
WP3 Infrastructure Database: https://tiara.astec.ac.uk
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,
– for Enhancing Innovation in collaboration with industry.
WP3 Infrastructure Survey
• Organisation
• Facility
• Infrastructure:
–
–
–
–
–
–
–
–
Description
Status
Unique features
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
Defined by WP4 (see P Pierini Talk)
WP4: KARA and Applications
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
Denmark
Finland
France
Germany
Italy
Poland
Slovenia
Spain
Sweden
Switzerland
UK
1
1
1
19
13
13
6
1
8
3
61
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)
Antoine Daël (CEA)
Peter McIntosh (STFC)
Hans Mueller (GSI)
Diego Obradors (CIEMAT)
Paolo Pierini (INFN)
Roger Ruber (UU)
Thomas Schietinger (PSI)
Anders Unnervik (CERN)
Hans Weise (DESY)
Slawomir Wronka (IFJ PAN)
France, Belgium
France
UK
Germany
Spain
Italy
Nordic countries &
Netherlands
Switzerland
Switzerland
Germany
Poland & former East
European countries
Infrastructure Spectrum
Infrastructure
Ion Beam facility
Magnet testing
Linac Accelerators
Vacuum coating & preparation
Proton source
SRF system testing
Irradiation facility
Cryogenic testing
SRF cavity preparation
Stabilisation and alignment
SR Accelerators
Medical Therapy
Ion source
Material analysis
Instrumentation
Component vacuum brazing
Number
14
13
11
8
6
6
6
6
5
5
5
4
4
4
4
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
Contributing Labs & Institutes
•
Austria
–
•
•
•
•
DESY
Karlsruhe Institute of Technology
Helmholtz Zentrum Berlin
TU Dortmund
HZD‐Rossendorf
Research Instruments
GSI
Italy
–
–
INFN Genova, Catania, Frascati,
Legnaro, Segrate
SINCROTRONE TRIESTE
•
Lund University
Uppsala University
Switzerland
–
–
•
CIEMAT
CELLS
Insituto de Fisica Corpuscular
Universidad Autonoma de Madrid
National Center of Accelerators
ESS BILBAO CONSORTIUM
Sweden
–
–
•
Jozef Stefan Institut
Spain
–
–
–
–
–
–
CEA Saclay
CNRS/IN2P3
Ganil
National Centre for Nuclear Research
Warsaw University of Technology
Slovenia
–
Germany
–
–
–
–
–
–
–
•
University of Jyväskylä
Poland
–
–
France
–
–
–
•
Aarhus University
Finland
–
•
Medaustron
Denmark
–
•
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:
–
https://tiara.astec.ac.uk
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:
–
2.
Data storage and manipulation:
–
3.
Standard SQL processes employed.
Data post processing and interrogation:
–
4.
Prescriptive unambiguous question entry system.
Appropriate categorisation, filtering, data export and display.
Data security provision:
–
–
Restricted data entry and data encryption.
UID/password for Public and Administrative access.
WP3: Infrastructure Database
WP3 Infrastructure Database: https://tiara.astec.ac.uk
Infrastructure Inclusion
Infrastructure Details
Costing Information
Save and Submit
Searching Options
Geographical Searching
Search Field - FRANCE
Data export capability to: Text, CSV and Excel formats
Organisational Searching
Search Field – Science & Technology Facility Council
Facility Searching
Search Field – SACM
Infrastructure Searching
Search Field – Ion Beam Source
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:
– Currency, exchange rate, date to be understood, under
review.
• Provide infrastructure plotting capability:
–
–
–
–
Number of infrastructures per Country.
Infrastructure type per Country.
Infrastructures open for access and location.
Infrastructure investment with variety of filters.
Multiple KARA/KTI Input Selection
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:
– Prioritisation for future FP8 R&D funding.