Category Archives: Architecture

OOW16 – Are we failing or will performance rise?

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 […]

How PL/SQL can help improve your application design, and a lot more

As an Oracle resource taking part in development projects I’ve had the change to see how PL/SQL can actually increase the quality of both the application development and in application maintenance. In this article I’ll try to share this experience, and show how using PL/SQL will increase the quality of your application and your Oracle […]

11gR2: “Unlucky” combination of a new feature, a fix, application design and code

Sometimes a new feature (and/or a fix) could give some very unexpected results. In this article I’ll show how a mix between a 11g new feature (Adaptive Cursor Sharing), a fix (in 11.2, the obsolete threshold), application design (a separate schema for every customer), and code issues (not prefixing objects with schemaname, and bind datatype […]

So many DBAs; yet so many performance problems

There are many applications and databases around, performing and scaling just as supposed to. We very seldom hear about these project. Of course, this could be small applications with small loads; or, on the other hand, this could be well design application with well written code, and well maintained databases. Yet there are so many […]

Architecture: “Don’t put the technology cart before the business horse”

Reading the article in the last Oracle Magazine I found this quote from Philip Wik: “Don’t put the technology cart before the business horse” I’ve seen too many projects using a ”company decided architecture”, choosing an architecture without weighting the real need of the system being built. Standardization might be good, but not when the […]