Re: PL/SQL or SQL in the middle tier?

I also wonder where the PLSQL would exist outside of the database. Or is it rewritten in java? BL directly placed in screens or EJBs? That sounds scary.

It sounds like the DBA is swayed by the sirens call of the SOA and Oracle Fusion middle tier.
There are basically two camps of thought, Application server centric or database-centric (and some hybrids in between). The java programmers typically focus on using the application server to basically do what a db like Oracle already does. Then the db to them is just a place to finally store the data. Database-centric moves more of the BL logic closer to the data in the database where all processes can access it (or can be forced to use it to ensure data integrity).

Toon Koppelars and Paul Dorsey are advocates of the db-centric approach, and I agree with that line of thought until someone can convince me otherwise. IMO, the Oracle Fusion Middle tier looks like a technology stack, not to make systems easier to create, but to make more money for Oracle.

I would be interested in knowing what the DBA thinks the benefit will be for doing this.

Andrew Received on Wed Feb 20 2008 - 15:09:31 CST