ISOLDE Yield Database Jochen Ballof ENSTIRBS Components User

ISOLDE Yield Database Jochen Ballof EN-STI-RBS

Components User interface SQL data Set of table base definitions Website „Yield database“ Set of Rules Data rows (Business) Logic Yields 2

Technical Aspects After an update of the ISOLDE webpage, the graphical layout and some functionally has been lost. Interface was successfully recovered by Tania Next Step: Bring the new interface and the database together SQL data base User interface

Technical Aspects Development roadmap Evaluation of technologies to use with respect to requirements Enter production state! Set-up of development environment Data consolidation and migration Test of Technologies (Proof-of-concept) Test the new system Review requirements in detail SQL Website Implement data model SQL Implement User Interface Object – RDMS mapping 4

Technical Aspects Status Evaluation of technologies to use with respect to requirements Suggested Change Current situation Website is generated by the Oracle database server using the Oracle SQL dialect (PL/SQL) Leave the data in Oracle, but use ASP. NET as webserver technology to gain better maintainability, flexibility and ability to implement complex requirements. SQL Oracle Server SQL GUI Oracle Services Logic 5 GUI Logic Microsoft IIS

Technical Aspects Development roadmap Evaluation of technologies to use with respect to requirements Set-up of development environment - Requested new oracle database for testing Cloned the production to the new testing database Installed development tools Visual Studio / SQL Developer Created Source control repository 6

Technical Aspects Development roadmap Evaluation of technologies to use with respect to requirements Set-up of development environment Test of Technologies (Proof-of-Concept) Test-Website with new technologies is working and online! Demonstration https: //test-jochen. web. cern. ch/ Cs, Mg, C 7

Technical Aspects Yield Graph is generated by the server and transferred as picture to the client -> No Java or similar necessary Mg: 8 Authentication with CERN Single-Sign On (SSO), which is e. g. also used by EDH.

Technical Aspects The. aspx – File: …. Having a quick look under the hood: The. aspx. cs – File (Code behind): The output in the browser: 9

Technical Aspects Development roadmap Evaluation of technologies to use with respect to requirements Set-up of development environment Test of Technologies (Proof-of-concept) Review requirements in detail Ticketing for yield database containing all requests: https: //its. cern. ch/jira/projects/ISOYIELDDB 10

Data and requirements - To implement the requested yield extrapolation feature, production cross sections must be known. - A number of ARBLABLA and FLUKA simulations have been performed mostly by Joao Pedro Ramos and Jozef Klimo (Slovak Acad. Sci) J. Klimo et. al, Simulations of production cross section of isotopes produced in spallation reaction using ABRABLA 07 code 11

Data and requirements 1. Major Modifications - Extrapolation of yields for cases in which the release is understood well Yields for target in sub-optimal operation conditions („contaminations“) 2. Other new features - Link to the logbook entry in which the yield was documented Add fields: Target number, Measurement details, Rilis Information, Molecular sideband, Freshness of a Target, Target temperature Show release information Link to Rilis PSE from Yield database PSE Produced isotopes from a given target Thank you! 3. Cosmetic changes - Optimize Legend in ISOLDE nuclide chart Is there anything else? 12