Presentation Title: A Real-World Comparison of the NoPLSQL & Thick Database Paradigms
Speaker: Mr Toon Koppelaars OakTable
Company: Oracle
Co-presenter: Bryn Llewellyn - Oracle
Presentation abstract: The NoPlsql paradigm starts with an object oriented domain model in the middle tier. This leads naturally to treating the database as a bag of tables, so that primitive SQL statements express the API. The Thick Database paradigm starts with the design of a relational model. This leads naturally to allowing clientside code only to call PL/SQL subprograms, so that all SQL is done from PL/SQL. These two paradigms are mutually incompatible. We explain how the NoPlsql paradigm brings correctness, security, and performance problems and debunk the myth that “moving business logic out of the data tier and into the middle tier” improves scalability. Then we carefully explain the Thick Database paradigm, rehearse the reasons for its superiority, and describe how to adopt it. We formalize a layered code classification scheme which leads to optimal understandability and maintainability of both your PL/SQL and your SQL code – which properties bring the maximum probability of correct behavior.
Presentation begins: 05/12/2016 15:35
Presentation duration: 110
Presentation content level: 3 (1 = indepth, 5 = strategic overview)
Audience experience: Intermediate
Audience function: Product Expert, Product User, Systems Architect
Speaker biography:  Toon has been part of the Oracle eco-system since 1987. He is currently a member of Oracle's Real World Performance team. The RWP-team troubleshoots application performance issues in and around the DBMS. The way applications currently use (or rather, abuse) the DBMS, is often at the root of these performance issues. Prior to joining the RWP team, Toon has been mainly involved in database application development. His special interests are: architecting applications for performance and scalability, database design, and business rules / constraints modelling. He is a long-time champion of the Thick Database paradigm.
Related topics: APEX & Database Development: APEX, APEX & Database Development: Architecture, APEX & Database Development: Database Design, APEX & Database Development: Development Practices/Tips, APEX & Database Development: Development Technologies e.g. REST, JavaScript, APEX & Database Development: Forms, APEX & Database Development: JET, APEX & Database Development: Modelling, APEX & Database Development: Performance, APEX & Database Development: PL/SQL, APEX & Database Development: SQL, APEX & Database Development: Tuning
Hall: Hall 10B

UKOUG_NoPlsql_vs_ThickDB_Part1.pptx8.3 MB08/12/2016 12:31:14
UKOUG_NoPlsql_vs_ThickDB_Part2.pptx6.0 MB08/12/2016 12:31:33