Learn · CERN

Talk29 min

A new PostgreSQL backend for CERN Tape Archive scheduling for LHC Run 4

Jaroslav Guenther and Konstantina Skovola · CERN

Watch At CERN

About

The CERN Tape Archive (CTA) stores over one exabyte of scientific data. To orchestrate storage operations (archival) and access operations (retrieval), the CTA Scheduler coordinates concurrent data movements across hundreds of tape servers, relying on a Scheduler Database (Scheduler DB) to manage the metadata of the in-flight requests. The existing objectstore-based design of the CTA Scheduler DB is a complex transactional management system. This talk presents the development of a new PostgreSQL-based backend for the CTA Scheduler as an off-the-shelf solution which simplifies implementation and is expected to significantly reduce future development and operational costs. We describe the implementation of all main CTA workflows and explain how PostgreSQL addresses the limitations of the objectstore-based system, providing the foundation for the tenfold increase in data throughput expected during LHC Run 4.

0:00:00 Slide 1

0:00:59 Slide 2

0:01:45 Slide 3

0:03:14 Slide 4

0:04:02 Slide 5

0:05:30 Slide 6

0:06:15 Slide 7

0:07:30 Slide 8

0:08:31 Slide 9

0:09:09 Slide 10

0:09:53 Slide 11

The talk

  1. A new PostgreSQL backend for CERN Tape Archive scheduling for LHC Run 4 2026-02-06 · 29 min · CERN's player

Credits and licence

Institution
CERN
Taught by
Jaroslav Guenther, Konstantina Skovola
Year
2026
Language
English
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 Teens profiles and older, judged from what the source says about it. How courses are placed