Database Developers' Workshop

Tuesday 8 Jul 2008, 09:00 → 18:00 Europe/Zurich

IT Auditorium (CERN)

Maria Girone (CERN)

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

09:00 → 12:30 DB application design

09:00 Workshop Goals

Speaker: Maria Girone (CERN)

Slides maria-workshop-goals.pdf maria-workshop-goals.ppt

09:05 DB design (Tips & tricks)

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 Workshop_DB_Design_Eva.pdf Workshop_DB_Design_Eva.ppt

10:00 DB Monitoring tools (demo)

session manager OEM 3D DB dashboard

Speaker: Dawid Wojcik (CERN)

Slides Workshop_Mon_Tools.pdf Workshop_Mon_Tools.ppt

10:40 coffee break

10:55 DB Application security

Behind Oracle roles and profiles Difference and usage of owner and application accounts

Speaker: Miguel Anjo (CERN)

Slides

• Roles_Profiles.pdf
• Roles_Profiles_PPT.pdf
• Roles_Profiles_PPT.ppt
• Roles_Profiles.pptx

11:30 DB performance/tuning in a RAC environment for developers

Speaker: Luca Canali (CERN)

Slides Workhops_8_Jul_perf_for_developers_LC.pdf Workhops_8_Jul_perf_for_developers_LC.ppt

12:30 → 14:00 Lunch break

14:00 → 18:00 DB Performance and Tuning

14:00 DB development tools (with demo)

Speaker: Jacek Wojcieszuk (CERN)

Slides Workhops_8_Jul_DB_development_tools_JW.pdf Workhops_8_Jul_DB_development_tools_JW.ppt

14:45 DB Tuning Best Practices from a developer's perspective

Speaker: Giuseppe Lo Presti (CERN/INFN)

Slides dbworkshop-tuning.pdf dbworkshop-tuning.ppt

15:45 coffee break

16:00 Case Studies

ATLAS PVSS CMS Dashboard LCG Gridview / LCG SAM CASTOR COOL

Speakers: Andrea Valassi (CERN), Luca Canali (CERN), Miguel Anjo (CERN), Sebastien Ponce (CERN), jacek wojcieszuk (CERN)

Slides

• 20080708_COOL_hints.pdf
• 20080708_COOL_hints.pptx
• gridview_use-case.pdf
• gridview_use-case.pptx
• slides
• slides
• Workhops_8_Jul_case_CMS_Dashboard_JW.pdf
• Workhops_8_Jul_case_CMS_Dashboard_JW.ppt
• Workhops_8_Jul_case_PVSS_LC.pdf
• Workhops_8_Jul_case_PVSS_LC.ppt

17:40 Wrap-up

Speaker: Maria Girone (CERN)