How many application developers truly understand what a database can do for them? Many times I have seen code written by developers for business or presentation logic placed outside the database when it did not need to be. The load on the database, on the client and across the network increase unnecessarily, since more calls to the database are made, more data is transferred between the database and the application has to process more data.
It would be nice if all developers would learn more about the power of the database they are using. There is a nice picture over at the ORA-00001 blog that shows this. I'll delve into some of these capabilities in future posts.
As a developer, it does not matter which database you use: Oracle, MS SQL Server, or DB2, take the time to learn what it can do for you. You may be surprised at how much more effective you become!
