Using a Pl/SQL Table API to Implement Thick Database Principles by Peter Koletzke
Applications developed using APEX, ADF, MAF, JET, MAX, VBCS/VB Studio, Java, JavaScript, or any other development framework can benefit from using the development approach known as "Thick Database" (SmartDB). Thick Database uses the power of Oracle PL/SQL and SQL to centralize business logic in database code. One key technique that can be used to implement these principles is the Table Application Programming Interface (Table API).
This session provides an overview of the Thick Database approach and explains its benefits such as reduced cloud database costs, simplification of user interface code, and more efficient and secure applications.
The session then focuses on the code components and strategies in the Table API technique used to isolate code that accesses data. The presentation explains a number of methods for generating a large part of the Table API code and shows examples of generated code as well as code that calls the Table API code.