Object-Oriented Design of Database Stored Procedures
By Michael Blaha, Bill Huth, Peter Cheung
October 22, 2008: Object-oriented (OO) software engineering techniques are often used with programming languages, but they also apply to relational databases. OO techniques are not only helpful for determining database structure, but also for designing stored procedure code. In fact, we were surprised by the magnitude of the stored procedure benefits. OO techniques boost development productivity as well as the quality, clarity, and maintainability of the resulting code.