Project goal

The aim of this project is to test several Oracle technologies and evaluate their potential for use in production systems at CERN. The technologies currently being tested within the framework of this project are Oracle REST Data Services (ORDS), Oracle JavaScript Extension Toolkit (JET), and Oracle Management Cloud (OMC). A key part of our investigation into these technologies is providing Oracle’s engineering teams with important feedback that can be used to further improve them.

R&D topic
R&D Topic 1: Data-centre technologies and infrastructures
Project coordinator(s)
Eric Grancher and Eva Dafonte Perez
Technical team members
Artur Wiecek, Luis Rodríguez Fernández, Antonio Nappi
Collaborator liaison(s)
Artur Wiecek, Luis Rodríguez Fernández, Antonio Nappi

Collaborators

Project background

ORDS is widely used at CERN; we use it to serve more than 450 Oracle APEX applications. Many developers are very interested in exploring its REST capabilities and the potential for dramatically simplifying the implementation of APIs. Initial evaluation of Oracle JET has also been carried out at CERN; it is a promising candidate for potentially replacing some legacy front-end applications used by the CERN IT department’s group for database services. Equally, OMC’s adaptability, in terms of use with both on-premises and cloud resources, makes it a promising monitoring technology.

Recent progress

Thanks to the collaboration of several engineering groups at CERN, three production systems now make use of ORDS’s REST capabilities. These are CERN's access-management and distribution system, CERN’s system for handling digital documents, and the system CERN uses for car sharing). We carried out much work in this area in 2017, particularly in relation to setup automation, configuration, and upgrading the various ORDS installations.

The results of our evaluation of Oracle JET have been summarised in an extended post by one of the CERN openlab summer students on the blog of the CERN IT department’s group for database services. Regarding OMC, CERN engineers primarily focused efforts on extending capabilities related to the monitoring of application performance. Valuable feedback was compiled in a range of reports, with results being discussed with Oracle engineers and product managers at the Oracle Open World 2017 event in October.

Next steps

While ORDS is now fully in production, there are still some aspects we plan to investigate further, particularly related to security. We will also evaluate the promising logging, monitoring, and analytics features offered by OMC. Finally, although other strong competitors exist in terms of JavaScript, it would still be valuable to carry out further investigation into Oracle JET.

Publications

  • R. Alsvaag. My experiences from the CERN openlab Summer Student Programme 2017. Databases at CERN blog. 2017. http://cern.ch/go/l8bV
  • L. Rodríguez Fernández. Oracle JET, ORDS & OAUTH2. Databases at CERN blog. 2017. http://cern.ch/go/G6zS
  • L. Rodríguez Fernández, 1000 Things you always want to know about SSO but you never dare to ask, (8 October), Presented at 16th International Conference on Accelerator and Large Experimental Control Systems, Barcelona, 2017. http://cern.ch/go/8BtF

Presentations

  • R. Alvsvaag, Refactor of Rota application using modern developer techniques: Oracle Restful Data Services & Oracle Jet (11 August), Presented at CERN openlab summer students’ lightning talks, Geneva, 2017. http://cern.ch/go/6sV9
  • L. Rodríguez Fernández, REST services, JavaScript, and JVM performance with Oracle (21 September), Presented at CERN openlab open day, Geneva, 2017. http://cern.ch/go/dNC9
  • L. Rodríguez Fernández, 1000 Things you always want to know about SSO but you never dare to ask (8 October), Presented at 16th International Conference on Accelerator and Large Experimental Control Systems (ICALEPCS 2017), Barcelona, 2017. http://cern.ch/go/8BtF