Transcript Oracle Application Express (Web Application Development)

<Insert Picture Here>
Oracle Application Express
Architecture
Architectural Overview
• Integrated within the database 9iR2, 10g, 11g, XE
• Meta data driven
• Uses APEX Listener, Embedded Gateway or ModPLSQL
© 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 SaaS
• 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 SaaS 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 OC4J. The Java based listener is also extensible.
© 2009 Oracle Corporation