Database Workshop for LHC online/offline developers

24 Jan 2005, 09:00 → 28 Jan 2005, 18:00 Europe/Zurich

IT Auditorium (CERN)

Jamie Shiers (CERN)

Monday, 24 January

09:00 → 12:00 Introduction & DB Design

09:00 Introduction to Workshop and Oracle at CERN

Speaker: Jamie Shiers

more information more information more information

09:30 Policies and Support Levels

Speaker: Maria Girone

transparencies transparencies transparencies

10:00 Coffee

10:30 Database Design

Speaker: Marta Jakubowska-Sobczak

more information more information more information

14:00 → 18:00 Introduction and DB Design

14:00 Data Distribution

Speaker: Dirk Duellmann

transparencies transparencies transparencies

15:00 Tools

Speaker: Jacek Wojcieszuk

transparencies transparencies transparencies

16:00 Coffee

16:30 Oracle Database Architecture

This presentation will explain the architecture of the Oracle Database engine. It will discuss Oracle's ussage of memory, processes and storage, and will cover important aspect of the Oracle database engine such as tablespaces, read consistency, Real Application Clusters, etc.

Speaker: Bjørn Engsig (Oracle Corporation)

transparencies transparencies

Tuesday, 25 January

09:00 → 12:30 SQL

09:00 SQL (1/2)

Speaker: Giacomo Govi

transparencies transparencies transparencies

10:30 Coffee

11:00 SQL (2/2)

Speaker: Miguel Anjo (CERN)

transparencies transparencies transparencies

14:00 → 17:00 Hands-on exercises

more information

• more information
• more information
• more information
• more information

16:00 → 17:00 Lecture

16:00 Case study - HARP

This talk will review the design of the HARP Oracle database, one of the largest presently deployed at CERN. The database contains over 200 GB of HARP event metadata, referring to the 25 TB of raw event records stored on CASTOR tapes. For more information, see the CHEP2004 poster and paper on the HARP Objectivity to Oracle migration. The goal of the talk will be to draw some general guidelines for Oracle developers from this particular case study.

Speaker: Andrea Valassi

more information more information

transparencies transparencies

Wednesday, 26 January

09:00 → 12:00 Optimization and Tuning

09:00 Basic Optimization

Speaker: Dirk Geppert

more information more information

transparencies transparencies

10:00 Coffee

10:30 Oracle session level tuning

This talk will look at Oracle tuning with the perspective of individual applications or sessions. A general overview of tuning concepts will be given, details and examples of using SQL_TRACE and the famous event 10046 will be shown. Additionally, a number of typical problems with application design will be discussed. Tuning of SQL statements will not be covered.

Speaker: Bjørn Engsig (Oracle Corporation)

document document document

transparencies transparencies

14:00 → 16:10 Hands-on exercises

more information

• more information
• more information
• more information
• more information
• more information
• more information
• more information
• more information
• more information
• more information

16:00 Further documentations, tutorials

Speaker: Montse Collados

more information more information more information

Thursday, 27 January

09:00 → 12:15 C++ APIs

09:00 Overview of C/C++ DB APIs

Speaker: Dirk Duellmann

transparencies transparencies transparencies

09:30 LCG Relational Abstract Layer

Speaker: Radovan Chytracek (CERN)

transparencies transparencies transparencies

10:15 Coffee

10:45 Object Storage into RDBMS through the POOL framework

Speaker: Ioannis Papadopoulos (CERN)

transparencies transparencies transparencies

11:30 Conditions DB

Speaker: Andrea Valassi

transparencies transparencies transparencies

14:00 → 16:00 Hands-on exercises

more information

• more information
• more information
• more information

16:00 → 17:05 Lecture

16:00 Case study

Speaker: Anil Kumar

more information more information more information

transparencies transparencies transparencies

17:00 Closing remarks

Speaker: Maria Girone

more information more information more information

Friday, 28 January

09:00 → 12:00 Experiments talks

CMS meets 10h in 40-R-B10

14:00 → 16:00 Experiments Talks