# Quality assurance for CORAL and COOL within the LCG software stack for the LHC experiments

- Institution: CERN
- Department: Conferences
- Speaker: Andrea VALASSI
- Year: 2015
- Language: English
- Subjects: Computer science
- Source: [CERN](https://videos.cern.ch/record/3014260)
- Licence: [CERN](http://copyright.web.cern.ch)
- Who can watch: Tweens profiles and older (sources give no ratings; placed by Invisible Network from the source's own words)

CORAL and COOL are software packages used by the LHC experiments for managing different categories of physics data using a variety of relational database technologies. The core components are written in C++, but Python bindings are also provided. CORAL is a generic relational access layer, while COOL includes the implementation of a specific relational data model and optimization of SQL queries for "conditions data". The software is the result of more than 10 years of development in colaboration between the IT department and the LHC experiments. The packages are built and released within the LCG software stack, for which automatic nightly builds and release installations are provided by PH-SFT (cmake, jenkins, cdash) for many different platforms, compilers and software version configurations. Test-driven development and functional tests of both C++ and Python components (CppUnit, unittest) have been key elements in the success of the projects. Dedicated test suites have also been prepared to commission and maintain the integration of these packages with the LHC experiment framework software. Memory profilers (valgrind, IgProf, gperftools) and static code analyzers (Coverity) are also routinely used for proactive quality assurance. Performance test suites for SQL readback queries also exist for COOL and have been essential for the early detection of issues across Oracle server versions. This talk will give an overview of all these different areas of the CORAL and COOL software quality assurance..

0:00:00 Slide 1

0:00:18 Slide 2

0:00:32 Slide 3

0:02:08 Slide 4

0:02:38 Slide 5

0:02:42 Slide 6

0:02:53 Slide 7

0:02:58 Slide 8

0:03:25 Slide 9

0:03:56 Slide 10

0:04:21 Slide 11

0:06:00 Slide 12

0:07:19 Slide 13

0:09:04 Slide 14

0:10:26 Slide 15

0:11:10 Slide 16

0:11:21 Slide 17

0:14:33 Slide 18

0:15:41 Slide 19

0:16:55 Slide 20

0:18:31 Slide 21

0:19:37 Slide 22

0:21:30 Slide 23

0:22:30 Slide 24

0:23:54 Slide 25

## Lectures

1. [Quality assurance for CORAL and COOL within the LCG software stack for the LHC experiments](https://invisiblenetwork.ai/learn/cern/3014260/24fba8570263), 26 min (CERN's player)