21-25 May 2012
New York City, NY, USA
US/Eastern timezone

The ATLAS database application enhancements using Oracle 11g

24 May 2012, 13:30
4h 45m
Rosenthal Pavilion (10th floor) (Kimmel Center)

Rosenthal Pavilion (10th floor)

Kimmel Center

Poster Software Engineering, Data Stores and Databases (track 5) Poster Session

Speaker

Gancho Dimitrov (Brookhaven National Laboratory (US))

Description

The ATLAS experiment at LHC relies on databases for detector online data-taking, storage and retrieval of configurations, calibrations and alignments, post data-taking analysis, file management over the grid, job submission and management, data replications to other computing centers, etc. The Oracle Relational Database Management System has been addressing the ATLAS database requirements to a great extent for many years. Several database clusters were deployed for the needs of the different applications. The data volume, complexity and demands from the users are increasing steadily with time. Nowadays about 20 TB of data are stored in the ATLAS Oracle databases at CERN (not including the index overhead), but the most impressive number is the hosted 260 database schemas (in the common case each schema is related to a dedicated client application with its own requirements). At the beginning of 2012 all ATLAS databases at CERN are upgraded to the newest Oracle version 11g Release 2. In order to make the ATLAS DB applications more reliable and performant we explored and evaluated the new 11g database features. In this work we present some of the Oracle 11g enhancements and typical ATLAS application use cases which suit best and the gain from the implemented changes.

Primary author

Gancho Dimitrov (Brookhaven National Laboratory (US))

Co-authors

Luca Canali (CERN) Marcin Blaszczyk (CERN) Roman Sorokoletov (University of Texas at Arlington (US))

Presentation Materials