The last session I attended at OpenWorld 2016 was “Thinking Clearly About Database Application Architecture”. A panel discussion with Toon Koppelaars, Cary Millsap, Gerald Venzl, Bryn Llewellyn and Connor Mcdonald. The panelists promotes that the business logic should be moved into the database, and implemented using PL/SQL. And yes – I do get the message, but I just don’t really agree with the rapping. I don’t think this is a one way street, and I think the message fades away because of the way this is presented. It’s a matter of expediency! Sometimes using ORM API’s like Hibernate, and running your business logic outside the database, can be a good solution. Nobody argues whether Ferrari is a very fast car, but this doesn’t mean that everybody have to ride a Ferrari. Sometimes a Fiat or Lada is more than good enough. My advice is: “Don’t let this become a silver bullet!”
Name: Lasse Jenssen
Mobile: +47 92233948
- OOW16 – Are we failing or will performance rise?
- An Oracle DBA at JavaZone – a fish on land?
- Books to read: “Mastering Oracle Trace Data, Second Edition” with Cary Millsap
- One of the things you just need to know about Oracle …
- Sometimes it’s alright to be LAZY – Part 2
- Paginating over parent table (in one-to-many join)
- Sometimes it’s alright to be LAZY – Part 1
- SQL Developer Extension: Keep Alive
- Template for creating data owners and application users
- Ora-600 when setting OCSID.DBOP tag with JDBC to a value larger than 29 byte
DisclaimerFor the avoidance of any doubt, all views expressed here are my own and not those of past or current employers, clients, friends, Oracle Corporation, EVRY, my Mum or, indeed, my mother in law. If you want to sue someone, I suggest you pick on Tigger, but I hope you have a good lawyer. Frankly, I doubt any of the former agree with my views or would want to be associated with them in any way.