464: Database Development Best Practices: Supporting Agile/Extreme Programming
Shyam Varan Nath , Oracle BIWA SIG    Biography

Objectives: Show best practices for database change scripting to support development shops
Develop methodology to support Extreme / Agile development
How to protect large databases from data/scehma corruptions during the change process
Abstract: We will look at the role of the development DBA and the best practices related to the same. Agile or extreme programming is becoming the buzz word and here we will look at how DBA's and Database Developers can follow some processes to improve and add efficiency to the database changes - both schema and data changes.

We will take an approach to club the changes into three logical groups and each group of changes - namely schema changes, data changes and object (procs, functions, triggers) changes, are handled independently. We will show how ot develop the one time framework to support this methodology and track the status of the database changes using this framework. This approach will be useful to salvage large databases when applying a lot of changes to database and prevent prevent refesh of large user schemas. We will show correct order of database changes can be ensured by using this framework that numbers the patches sequentially.

Audiernce Focus: Developers
Expertise: Intermediate
Track: Development
Date: Thursday, April 17, 2008
Time: 11:00 AM - 12:00 PM