Database Developers' Workshop

Contribution List

8. Workshop Goals

Maria Girone (CERN)

08/07/2008, 09:00

DB application design

0. DB design (Tips & tricks)

Eva Dafonte Perez (Unknown)

08/07/2008, 09:05

DB application design

schema design, columns and constraints, indexes and partitioning, proper use of PL/SQL (bind variables, static and dynamic SQL), writing robust applications

2. DB Monitoring tools (demo)

Dawid Wojcik (CERN)

08/07/2008, 10:00

DB application design

session manager OEM 3D DB dashboard

3. DB Application security

Miguel Anjo (CERN)

08/07/2008, 10:55

DB application design

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

11. DB performance/tuning in a RAC environment for developers

Luca Canali (CERN)

08/07/2008, 11:30

DB application design

10. DB development tools (with demo)

Jacek Wojcieszuk (CERN)

08/07/2008, 14:00

DB Performance and Tuning

5. DB Tuning Best Practices from a developer's perspective

Giuseppe Lo Presti (CERN/INFN)

08/07/2008, 14:45

DB Performance and Tuning

7. Case Studies

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

08/07/2008, 16:00

DB Performance and Tuning

ATLAS PVSS CMS Dashboard LCG Gridview / LCG SAM CASTOR COOL

9. Wrap-up

Maria Girone (CERN)

08/07/2008, 17:40

DB Performance and Tuning

6. COOL performance optimization using Oracle hints

Andrea Valassi (CERN)

1. DB development tools (with demo)

Jacek Wojcieszuk (CERN)