Insert Picture Here Oracle Application Express Architecture Architectural











- Slides: 11

<Insert Picture Here> Oracle Application Express Architecture

Architectural Overview • Integrated within the database 9 i. R 2, 10 g, 11 g, XE • Meta data driven • Uses APEX Listener, Embedded Gateway or Mod. PLSQL © 2009 Oracle Corporation

Page Processing • Each request opens / closes Database session • Doesn’t keep a Database session open for each user • Page Request / Submission processing adds minimal overhead © 2009 Oracle Corporation

Multi-Tenant Saa. S • Single Oracle Database for multiple applications • Provides virtual private databases • Self-service or IT managed provisioning © 2009 Oracle Corporation

Oracle APEX Deployment Options Deployable on any Oracle Database accessed using only a Web browser Cloud / Hosted On Premise – In Datacenter On Premise - Departmental Server Personal Database © 2009 Oracle Corporation

Oracle APEX and Amazon Cloud © 2009 Oracle Corporation

Oracle APEX and Amazon Cloud © 2009 Oracle Corporation

Why APEX makes sense for the Cloud • Very few moving parts – Simple to manage • Browser based development / deployment / runtime • No client-side dependencies • Multi-Tenant Saa. S provides multiple “workspaces” • Applications easy to migrate to other deployments • Database Backups also backup application source • Oracle AMI includes APEX (may require upgrade) • Webservice Support © 2009 Oracle Corporation

Building Integrated Applications © 2009 Oracle Corporation

Integrating APEX & BI Publisher • • Declarative PDF reporting services Create professional “high-fidelity” reports Range of document formats Ability to define multiple queries © 2008 Oracle Corporation – Proprietary

Oracle APEX Listener – Available Soon The Oracle Application Express Listener is a Java based mod_plsql replacement for all Oracle APEX releases. The java based listener will support file system caching, FOP transformations to PDF and improved file upload with Oracle APEX 4. 0. The APEX listener will support popular versions of Apache, Web Logic, Tomcat and OC 4 J. The Java based listener is also extensible. © 2009 Oracle Corporation