Focus on:  Hide Contributions
Login

Database Workshop for LHC online/offline developers

→ Europe/Zurich
IT Auditorium (CERN)

IT Auditorium

CERN
Jamie Shiers (CERN)
  • Monday, 24 January
    • 09:00 → 12:00
      Introduction & DB Design IT Auditorium

      IT Auditorium

      CERN
      • 09:00
        Introduction to Workshop and Oracle at CERN 30m IT Auditorium

        IT Auditorium

        CERN
        Speaker: Jamie Shiers
        more information
      • 09:30
        Policies and Support Levels 20m IT Auditorium

        IT Auditorium

        CERN
        Speaker: Maria Girone
        transparencies
      • 10:00
        Coffee 30m IT Auditorium

        IT Auditorium

        CERN
      • 10:30
        Database Design 1h 30m IT Auditorium

        IT Auditorium

        CERN
        Speaker: Marta Jakubowska-Sobczak
        more information
    • 14:00 → 18:00
      Introduction and DB Design IT Auditorium--

      IT Auditorium--

      CERN
      • 14:00
        Data Distribution 1h
        Speaker: Dirk Duellmann
        transparencies
      • 15:00
        Tools 1h
        Speaker: Jacek Wojcieszuk
        transparencies
      • 16:00
        Coffee 30m
      • 16:30
        Oracle Database Architecture 1h 30m
        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
  • Tuesday, 25 January
    • 09:00 → 12:30
      SQL IT Auditorium

      IT Auditorium

      CERN
      • 09:00
        SQL (1/2) 1h 30m IT Auditorium

        IT Auditorium

        CERN
        Speaker: Giacomo Govi
        transparencies
      • 10:30
        Coffee 30m IT Auditorium

        IT Auditorium

        CERN
      • 11:00
        SQL (2/2) 1h 30m IT Auditorium

        IT Auditorium

        CERN
        Speaker: Miguel Anjo (CERN)
        transparencies
    • 14:00 → 17:00
      Hands-on exercises 572--23, 24, 25

      572--23, 24, 25

      CERN
      more information
    • 16:00 → 17:00
      Lecture 593--10

      593--10

      CERN
      • 16:00
        Case study - HARP 1h 593--10

        593--10

        CERN
        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
        transparencies
  • Wednesday, 26 January
    • 09:00 → 12:00
      Optimization and Tuning IT Auditorium

      IT Auditorium

      CERN
      • 09:00
        Basic Optimization 1h IT Auditorium

        IT Auditorium

        CERN
        Speaker: Dirk Geppert
        more information
        transparencies
      • 10:00
        Coffee 30m IT Auditorium

        IT Auditorium

        CERN
      • 10:30
        Oracle session level tuning 1h 30m IT Auditorium

        IT Auditorium

        CERN
        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
        transparencies
    • 14:00 → 16:10
      Hands-on exercises 572--23, 24, 25

      572--23, 24, 25

      CERN
      more information
      • 16:00
        Further documentations, tutorials 10m
        Speaker: Montse Collados
        more information
  • Thursday, 27 January
    • 09:00 → 12:15
      C++ APIs IT Auditorium

      IT Auditorium

      CERN
      • 09:00
        Overview of C/C++ DB APIs 30m IT Auditorium

        IT Auditorium

        CERN
        Speaker: Dirk Duellmann
        transparencies
      • 09:30
        LCG Relational Abstract Layer 45m IT Auditorium

        IT Auditorium

        CERN
        Speaker: Radovan Chytracek (CERN)
        transparencies
      • 10:15
        Coffee 30m IT Auditorium

        IT Auditorium

        CERN
      • 10:45
        Object Storage into RDBMS through the POOL framework 45m IT Auditorium

        IT Auditorium

        CERN
        Speaker: Ioannis Papadopoulos (CERN)
        transparencies
      • 11:30
        Conditions DB 45m IT Auditorium

        IT Auditorium

        CERN
        Speaker: Andrea Valassi
        transparencies
    • 14:00 → 16:00
      Hands-on exercises 572--23, 24, 25

      572--23, 24, 25

      CERN
      more information
    • 16:00 → 17:05
      Lecture 593--10

      593--10

      CERN
      • 16:00
        Case study 1h 593--10

        593--10

        CERN
        Speaker: Anil Kumar
        more information
        transparencies
      • 17:00
        Closing remarks 5m 593--10

        593--10

        CERN
        Speaker: Maria Girone
        more information
  • Friday, 28 January
    • 09:00 → 12:00
      Experiments talks IT Auditorium

      IT Auditorium

      CERN

      CMS meets 10h in 40-R-B10

    • 14:00 → 16:00
      Experiments Talks IT Auditorium

      IT Auditorium

      CERN
Powered by Indico v3.3.2-pre