Learn · CERN

Talk26 min

ATLAS DDM/DQ2 & NoSQL databases: Use cases and experiences

Mario Lassnig · CERN

Watch At CERN

About

The Distributed Data Management System DQ2 is responsible for the global management of petabytes of ATLAS physics data. DQ2 has a critical dependency on Relational Database Management Systems (RDBMS), like Oracle, as RDBMS are well suited to enforce data integrity in online transaction processing application. Despite these advantages, concerns have been raised recently on the scalability of data warehouse-like workload against the relational schema, in particular for the analysis of archived data or the aggregation of data for summary purposes. Therefore, we have considered new approaches of handling very large amount of data. More specifically, we investigated a new class of database technologies commonly referred to as NoSQL databases. This includes distributed file system like HDFS that support parallel execution of computational tasks on distributed data, as well as schema-less approaches via key-value/document stores, like HBase, Cassandra or MongoDB. These databases provide solutions to particular types of problems: for example, NoSQL databases have demonstrated horizontal scalability, high throughput, automatic fail-over mechanisms, and provide easy replication support over LAN and WAN. In this talk, we will describe our use cases in ATLAS, and share our experiences with NoSQL databases in a comparative study with Oracle..

0:00:00 Slide 1

0:01:16 Slide 2

0:02:32 Slide 3

0:05:04 Slide 4

0:07:35 Slide 5

0:10:07 Slide 6

0:12:39 Slide 7

0:15:10 Slide 8

0:17:42 Slide 9

0:20:13 Slide 10

0:22:45 Slide 11

The talk

  1. ATLAS DDM/DQ2 & NoSQL databases: Use cases and experiences 2012-05-21 · 26 min · CERN's player

Credits and licence

Institution
CERN
Department
Conferences
Speaker
Mario Lassnig
Year
2012
Language
English
Subjects
Physics, Computer science, Earth and environment
Source
CERN
Licence
CERN, as CERN states it. CERN's terms
Attribution
© CERN. CERN provides its audiovisual media free of charge for educational and informational use, credited to CERN; this lecture is shown in CERN's own player.
Who can watch
CERN gives no rating. Invisible Network shows it to Tweens profiles and older, judged from what the source says about it. How courses are placed