Database Developers' Workshop

Europe/Zurich
IT Auditorium (CERN)

IT Auditorium

CERN

Maria Girone (CERN)
Description
Meeting Access Information:
- Meeting URL
http://evo.caltech.edu/evoGate/koala.jnlp?meeting=292I2iMDMn9l9tDM9aD9
- Phone Bridge
ID: 418227

EVO Phone Bridge Telephone Numbers:

  • USA (Caltech, Pasadena, CA) +1 626 395 2112
  • Switzerland (CERN, Geneva) +41 22 76 71400
  • Slovakia (UPJS, Kosice) +421 55 234 2420
  • Italy (INFN, several cities)
    http://server10.infn.it/video/index.php?page=telephone_numbers
    Enter '4000' to access the EVO bridge
  • Germany (DESY, Hamburg) +49 40 8998 1340
  • USA (BNL, Upton, NY) +1 631 344 6100
Participants
  • Alberto Pace
  • Ali Al-Shabibi
  • Andrea Sciaba'
  • Andrea Valassi
  • Arne Wiebalck
  • Barbara Martelli
  • Benjamin Gaidioz
  • Chevenier Guy
  • David COLLADOS
  • David Front
  • Dawid Wojcik
  • Dennis Waldron
  • Dirk Duellmann
  • Dirk Hufnagel
  • elisa lanciotti
  • Elisabetta Vilucchi
  • Eva Dafonte Perez
  • Florbela Viegas
  • Frank van Lingen
  • Gancho Dimitrov
  • Georgios Papadimitriou
  • Giovanni Polese
  • Giuseppe Lo Presti
  • Imre Pal
  • Jacek Wojcieszuk
  • Jiawei Zhao
  • Joerg Stelzer
  • Josep Serrano
  • Katarzyna Dziedziniewicz
  • Lana Abadie
  • Lisa Williams
  • luca canali
  • Lukas Pribyl
  • Maria Girone
  • michele de gruttola
  • Miguel Anjo
  • Nicolo Magini
  • Paolo Tedesco
  • Pedro Salgado
  • Pradyumna Joshi
  • Raquel Pezoa
  • Robert Frazier
  • Roderick Chris
  • Saroj Kandasamy
  • Sebastien Ponce
  • Silvia Maria Batraneanu
  • Simon Metson
  • Steven Goldfarb
  • Tony Wildish
  • vinod boppanna
  • William Ollivier
  • Zoltan Mathe
    • 09:00 12:30
      DB application design
      • 09:00
        Workshop Goals 5m IT Auditorium

        IT Auditorium

        CERN

        Speaker: Maria Girone (CERN)
        Slides
      • 09:05
        DB design (Tips & tricks) 55m IT Auditorium

        IT Auditorium

        CERN

        schema design, columns and constraints, indexes and partitioning, proper use of PL/SQL (bind variables, static and dynamic SQL), writing robust applications
        Speaker: Eva Dafonte Perez (Unknown)
        Slides
      • 10:00
        DB Monitoring tools (demo) 40m IT Auditorium

        IT Auditorium

        CERN

        session manager OEM 3D DB dashboard
        Speaker: Dawid Wojcik (CERN)
        Slides
      • 10:40
        coffee break 15m IT Auditorium (CERN)

        IT Auditorium

        CERN

      • 10:55
        DB Application security 35m IT Auditorium

        IT Auditorium

        CERN

        Behind Oracle roles and profiles Difference and usage of owner and application accounts
        Speaker: Miguel Anjo (CERN)
      • 11:30
        DB performance/tuning in a RAC environment for developers 1h IT Auditorium

        IT Auditorium

        CERN

        Speaker: Luca Canali (CERN)
        Slides
    • 12:30 14:00
      Lunch break 1h 30m
    • 14:00 18:00
      DB Performance and Tuning