Databases

Mandate

The Database Services Group (IT-DB) is responsible for current and future databases and their platform for accelerators, experiments and administrative services. It is also in charge of hosting Java Web applications as well as critical engineering and administration applications at CERN scale. Moreover, the group provides scale-out analytics services including Hadoop, Spark and Kafka for CERN and the LHC experiments.

For all these services, the group is responsible to work with its users’ community to define the future generation of the services. In a number of cases, the group members also work with the WLCG Tier1 and Tier2 sites to deploy services all across the computing sites.

Sections

Section/unit/leader Description
Relational Database Services

IT-DB-DBR

Leader: Eva Dafonte Perez

The section is responsible for the centralised Oracle relational databases service used by the CERN community and the LHC experiments.
It also offers a database on demand platform designed for everyone who wants to easily deploy and manage its own databases (MySQL, PostgreSQL and InfluxDB).

Streaming and Analytics Services

IT-DB-SAS

Leader: Jose Carlos Luna Duran

The section supports and develops services related to Big Data: Hadoop ecosystem, data processing at scale (Spark), streaming solutions (Kafka) and analytics platforms.
Moreover, the section works with the Experiments, Accelerator sector, IT  and other CERN communities interested in implementing data analysis projects with these technologies.

 

 

Database Applications and Reporting services

IT-DB-DAR

Leader: awiecek

The section provides hosting for critical engineering, administration and IT services. 
It builds and maintains platforms for :

  • CERN developed Java applications based on application servers like Weblogic and Tomcat e.g. EDMS, EDH, Impact, LanDB etc.
  • Commercial software deployments supporting processes in finance, logistics, HR e.g Infor, OracleHR, HRAccess, Qualiac etc.
  • Oracle web hosting e.g. APEX, ORDS

Moreover, it's in charge of the central reporting service. It's currently building a new platform based on Pentaho.

Infrastructure and Automation Services

IT-DB-IA

Leader: Ignacio Coterillo Coz

This section is in charge of managing the common infrastructure elements supporting the services and activities of the CERN IT-DB group. These elements range from hardware elements such as physical servers and low latency storage systems to software services such as inventory systems and several automation tools and API's employed within the group.
The section also consolidates several core activities of the group such as for example, software packaging, infrastructure monitoring or firewall management.