1 / 23

WP3: Infrastructure Web-Based Database

WP3: Infrastructure Web-Based Database. Peter McIntosh (STFC, Daresbury Laboratory) TIARA Mid-Term Review Meeting, Madrid, 12 - 14 th June 2012. WP3 Infrastructure Database: https://tiara.astec.ac.uk. TIARA Objectives.

olaf
Download Presentation

WP3: Infrastructure Web-Based Database

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. WP3: Infrastructure Web-Based Database Peter McIntosh (STFC, Daresbury Laboratory) TIARA Mid-Term Review Meeting, Madrid, 12 - 14th June 2012. WP3 Infrastructure Database: https://tiara.astec.ac.uk

  2. 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 andDevelopment, • for Education and Training, • for Enhancing Innovation in collaboration with industry.

  3. 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)

  4. WP4: KARA and Applications

  5. 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.

  6. 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 European countries

  7. Infrastructure Spectrum

  8. Contributing Labs & Institutes • 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 • 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

  9. 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

  10. 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. • Data entry portal: • Prescriptive unambiguous question entry system. • Data storage and manipulation: • Standard SQL processes employed. • Data post processing and interrogation: • Appropriate categorisation, filtering, data export and display. • Data security provision: • Restricted data entry and data encryption. • UID/password for Public and Administrative access.

  11. WP3: Infrastructure Database WP3 Infrastructure Database: https://tiara.astec.ac.uk

  12. Infrastructure Inclusion

  13. Infrastructure Details

  14. Costing Information

  15. Save and Submit

  16. Searching Options

  17. Geographical Searching Search Field - FRANCE Data export capability to: Text, CSV and Excel formats

  18. Organisational Searching Search Field – Science & Technology Facility Council

  19. Facility Searching Search Field – SACM

  20. Infrastructure Searching Search Field – Ion Beam Source

  21. 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.

  22. Multiple KARA/KTI Input Selection

  23. 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.

More Related