Skip to Main Content

#SmartDB Office Hours

Free tips and training every month! Subscribe for reminders and more from Office Hours. FAQ

Header container

April 17, 2018

15:00 UTC   Start Times Around the World

Subscribe to be notified of changes to sessions and give us feedback!

Having trouble watching the video on this page? Open the video in your browser.


Code Classification
Toon Koppelaars presents his thoughts on how best to classify the types of code that should reside inside the database. Along the way, he offers recommendations for a sound database design, and much more.

5:44 Recommendations for a sound database design
12:00 Data Integrity Constraints
16:11 Data Logic Code
17:30 Classifications: Query-only Business Logic, Transaction Business Logic, Data Logic
21:21 Avoiding a big pile of PL/SQL code: separate schemas and more
24:32 Vertically materialize APIs per page
25:43 Q&A

Your Experts



    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 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 modeling (see his idea on SQL Assertions here He is a long-time champion of the Smart Database paradigm, i.e. using the database as a processing engine, and not just as a persistence layer.

All Sessions