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