14-16 September 2015
University "La Sapienza", Physics Department
Europe/Rome timezone

The Relational Database System of KM3NeT

15 Sep 2015, 16:30
20m
Aula Rasetti, 2nd floor (University "La Sapienza", Physics Department)

Aula Rasetti, 2nd floor

University "La Sapienza", Physics Department

Piazzale Aldo Moro, 2 - 00185 Roma - Italy

Speaker

Cristiano Bozza (University of Salerno)

Description

KM3NeT is a new generation neutrino telescope in the Mediterranean Sea. For the operation of the telescope a relational database is designed and implemented for several purposes, like the centralised management of accounts, the storage of all documentation on components and on the status of the detector, of the slow control and calibration data. It also contains information useful during the construction and the data acquisition phases. It means that the database is not conceived as a simple container but it plays an active role during the whole life of the experiment. Highlights in the database schema and management are discussed along with design choices that have impact on performances. In most cases, the database is not accessed directly by applications, but they go via a custom designed Web application server. It provides connection pooling and can be used to cache responses to frequently accessed information. It also allows serving and receiving data in several formats. For large data streams, binary encoding and columnar storage are used to boost performance in data access. Other issues like database connection reliability over wide area networks and fault tolerance will be discussed.

Primary author

Cristiano Bozza (University of Salerno)

Co-author

Mr Arnauld Albert (GRPHE)

Presentation Materials