ATLAS database application enhancements using Oracle 11g
ATLAS database application enhancements using Oracle 11g
复制标题
使用 Oracle 11g 增强 ATLAS 数据库应用程序
DOI：
--
复制
发表时间：
2012
期刊：
影响因子：
--
通讯作者：
R. Sorokoletov
中科院分区：
文献类型：
--
作者：
G. Dimitrov;L. Canali;M. Błaszczyk;R. Sorokoletov
大型强子对撞机的ATLAS实验依赖于数据库进行探测器在线数据采集，存储和检索配置，校准和校准，数据采集后分析，网格文件管理，作业提交和管理，条件数据复制到远程站点。Oracle关系数据库管理系统（RDBMS）多年来在很大程度上解决了ATLAS数据库的需求。目前为满足不同应用程序的需要部署了10个数据库集群，分为生产、集成和备用数据库。随着时间的推移，数据量、复杂性和用户需求都在稳步增长。如今，超过20 TB的数据存储在CERN的ATLAS生产Oracle数据库中（不包括索引开销），但最令人印象深刻的数字是托管的260个数据库模式（对于最常见的情况，每个模式都与具有自己要求的专用客户端应用程序相关）。2012年初，CERN的所有ATLAS数据库都升级到了最新的Oracle版本：Oracle 11g Release 2。与以前的数据库引擎版本相比，Oracle 11g有几个关键的改进。在这项工作中，我们提出了我们的评估最相关的新功能的Oracle 11g的兴趣的ATLAS应用程序和用例。值得注意的是，我们报告了自2012年第一季度部署Oracle 11 g以来生产中获得的性能和可扩展性增强，并概述了该领域未来工作的计划。
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, condition data replication to remote sites. Oracle Relational Database Management System (RDBMS) has been addressing the ATLAS database requirements to a great extent for many years. Ten database clusters are currently deployed for the needs of the different applications, divided in production, integration and standby databases. The data volume, complexity and demands from the users are increasing steadily with time. Nowadays more than 20 TB of data are stored in the ATLAS production Oracle databases at CERN (not including the index overhead), but the most impressive number is the hosted 260 database schemes (for the most 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 have been upgraded to the newest Oracle version at the time: Oracle 11g Release 2. Oracle 11g come with several key improvements compared to previous database engine versions. In this work we present our evaluation of the most relevant new features of Oracle 11g of interest for ATLAS applications and use cases. Notably we report on the performance and scalability enhancements obtained in production since the Oracle 11g deployment during Q1 2012 and we outline plans for future work in this area.