Author: Johansson, L.J.G.
Paper Title Page
WEPHA047 Cable Database at ESS 1199
  • R.N. Fernandes, S.R. Gysin, J.A. Persson, S. Regnell
    ESS, Lund, Sweden
  • L.J.G. Johansson
    OTIF, Malmö, Sweden
  • S. Sah
    Cosylab, Ljubljana, Slovenia
  • M. Salmič
    COSYLAB, Control System Laboratory, Ljubljana, Slovenia
  When completed, the European Spallation Source (ESS) will have around half a million of installed cables to power and control both the machine and end-stations instruments. To keep track of all these cables throughout the different phases of ESS, an application called Cable Database was developed at the Integrated Control System (ICS) Division. It provides a web-based graphical interface where authorized users may perform CRUD operations in cables, as well as batch imports (through well-defined EXCEL files) to substantially shortened the time needed to deal with massive amounts of cables at once. Besides cables, the Cable Database manages cable types, connectors, manufacturers and routing points, thus fully handling the information that surrounds cables. Additionally, it provides a programmatic interface through RESTful services that other ICS applications (e.g. CCDB) may consume to successfully perform their domain specific businesses. The present paper introduces the Cable Database and describes its features, architecture and technology stack, data concepts and interfaces. Finally, it enumerates development directions that could be pursued to further improve this application.  
DOI • reference for this paper ※  
About • paper received ※ 30 September 2019       paper accepted ※ 09 October 2019       issue date ※ 30 August 2020  
Export • reference for this paper using ※ BibTeX, ※ LaTeX, ※ Text/Word, ※ RIS, ※ EndNote (xml)