The NoPL/SQL and Thick Database Paradigms, Part 1

We have many years of extensive hands-on experience of building, and tuning, applications that use Oracle Database. We have seen two mutually incompatible architecture paradigms. The thick database paradigm, preferred in the 1990s, starts with the design of the relational model. This leads naturally to the encapsulation of all insert, update, delete, and select statements within PL/SQL subprograms that expose the database interface. The NoPlsql paradigm, which seems now to be the preferred choice, starts with an object oriented domain model in the middle tier, and leads naturally to treating the database as a bag of tables, letting the primitive SQL statements that manipulate these express the API.
In Part 1, we describe the awful problems brought by the NoPlsql paradigm. We discuss its performance implications and debunk the myth that “moving business logic out of the data tier and into the middle tier” improves performance and scalability. We examine the time and effort implications and show that projects that adopt the NoPlsql paradigm use most of their resources on developing “plumbing” code rather than code that implements actual business functionality. These problems are just the tip of the iceberg and we expose several other serious drawbacks.

Thursday, 2016-11-17
3:00 pm - 3:45 pm
St. Petersburg
Distinguished Product Manager, Database Division, Oracle HQ

Toon Koppelaars

Oracle Nederland BV
Oracle OAK-Table
Toon is a member of Oracle's Real-World Performance (RWP) team, which assists in diagnosing application performance issues in and around the DBMS. The way applications currently use—or rather, abuse—the DBMS is often at the root of performance issues. Before joining the RWP team, Toon was involved in database application development. His special interests include architecting applications for performance/scalability and relational database design. He has been part of the Oracle eco-system since 1987, is a member of the Oaktable, and occasionally tweets at @ToonKoppelaars.

Further lectures of Toon Koppelaars

Hash Joins and Bloom Filters
Mittwoch , 16.11.2016 - Seoul
13:00 - 13:45
The NoPL/SQL and Thick Database Paradigms, Part 2
Donnerstag, 17.11.2016 - St. Petersburg
16:00 - 16:45

These lectures could also interest you