Author: Mueller, R.     [Müller, R.]
Paper Title Page
TUPHA041 Conception and Realization of the Versioning of Databases Between Two Research Institutes 478
 
  • S. Mueller, R. Müller
    GSI, Darmstadt, Germany
 
  This paper describes the version control of oracle databases across different environments. The basis of this paper is the collaboration between the GSI Helmholtz Centre for Heavy Ion Research (GSI) and the European Organization for Nuclear Research (CERN). The goal is to provide a sufficient and practical concept to improve database synchronization and version control for a specific database landscape for the two research facilities. First, the relevant requirements for both research facilities were identified and compared, leading to the creation of a shared catalog of requirements. In the process database tools, such as Liquibase and Flyway, were used and integrated as prototypes into the Oracle system landscape. During the implementation of prototypes several issues were identified, which arise out of the established situation of two collaborating departments of the research facilities. Requirements on the prototype were, to be flexible enough to adapt to the given conditions of the database landscape. The creation of a flexible and adjustable system enables the two research facilities to use, synchronize and update the shared database landscape.  
poster icon Poster TUPHA041 [1.991 MB]  
DOI • reference for this paper ※ https://doi.org/10.18429/JACoW-ICALEPCS2017-TUPHA041  
Export • reference for this paper using ※ BibTeX, ※ LaTeX, ※ Text/Word, ※ RIS, ※ EndNote (xml)  
 
THPHA062 First Production Use of the New Settings Management System for FAIR 1512
 
  • J. Fitzek, H.C. Hüther, R. Müller, A. Schaller
    GSI, Darmstadt, Germany
 
  With the successful commissioning of CRYRING, the first accelerator being operated using the new control system for FAIR (Facility for Antiproton and Ion Research), also the new settings management system is now used in a production environment for the first time. Development efforts are ongoing to realize requirements necessary to support accelerator operations at FAIR. At CRYRING, new concepts for scheduling parallel beams are being evaluated. After these successful tests and the first production use, the focus now is to include major parts of the existing facility (synchrotron SIS18, storage ring ESR and transfer lines) into the system in the context of the Controls Retrofit project. First dry runs are planned for Q4 this year. The settings management system is based on the LSA framework, that was introduced at CERN in 2001 and is being developed and enhanced together in a collaboration with GSI. Notwithstanding all successes of LSA at both institutes, a review study was set up with the goal to make the LSA framework fit for the future. Outcomes of this study and impacts on the settings management system for FAIR are being presented.  
poster icon Poster THPHA062 [4.633 MB]  
DOI • reference for this paper ※ https://doi.org/10.18429/JACoW-ICALEPCS2017-THPHA062  
Export • reference for this paper using ※ BibTeX, ※ LaTeX, ※ Text/Word, ※ RIS, ※ EndNote (xml)