<font color="#000000">Recent Changes to the Operational Database Services and Operational Readiness (R. Billen) and Developers' guide to use the Operational Database Services (C. Roderick)

Thursday 8 May 2008, 09:30 → 11:00 Europe/Zurich

864/1-C02

Kris Kostro (CERN)

Minutes https://edms.cern.ch/cedar/plsql/doc.info?cookie=7492085&document_id=916138&version=1

09:30 → 09:50 Recent Changes to the Operational Database Services and Operational Readiness (R. Billen)

On March 18th 2008, all the operational database services (Settings, Controls Configuration, Measurements & Logging, eLogbooks,...) were migrated to new hardware platforms and upgraded to a new Oracle version. This major modification did not go unnoticed, but with an excellent interdepartmental collaboration, the expected performance and stability was rapidly reached. This talk will resume the upgrade process and in particular the resulting availability and performance improvements. The operational readiness for the LHC will be assessed as well with issues such as diagnostics and monitoring, maintenance and security.

09:50 → 10:30 Developers' guide to use the Operational Database Services (C. Roderick)

Most of the operational database services are mission-critical, which puts a huge importance on the methods to access (read/write) the data. This presentation is aimed at application developers so that they get acquainted with the up-to-date, best practices for accessing the Oracle databases. In particular, the following specifics will be covered: How to properly connect to Oracle, pool connections, make your data access as efficient as possible, instrument your application to facilitate problem diagnosis, handle data access exceptions, and recommended application architecture. The presentation will be mainly oriented towards Oracle data access from Java, though many points are applicable to other programming languages.