What this talk is about:

  • How to make life easier for your DBA(s).
  • How to make life easier for your application developer(s) (and everyone else).
  • Taking full advantage of your RDBMS.

Next


 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Quick outline:

 
  • How we got here
  • Where we can go
  • Applying open source principles to your work
  • Using functions, views, triggers, rules, domains, and operators
  • Documentation

Next


 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

What this talk is NOT about:

  • How to use a RDBMS
  • How to unravel office politics
  • How to write SQL
  • How to win friends and influence people
  • Object-orientation

Next


 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

The problem, in a nutshell:

  • Database mostly seen as a support role
  • Application does all the work
  • Database is underutilized
  • Logic and documentation are spread out

Next


 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

The solution, abbreviated

  • Open source your project
  • Involve everyone, early and completely
  • Bind everything close to the data
  • Use the under-utilized: DBAs, databases, OO concepts

Next


 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

What you will get out of this

 
  • Some ideas to apply to your own organization and projects
  • A better understanding of the abilities of a database
  • The idea that everything lives close to the data
  • Different ways to think about your database

      Last             TOC             Next