Oracle Database Application Development
Michael Hichwa VP Database Tools Oracle Corporation Midwest Oracle User Group September 7, 2007
Application Express
• Is a unique Mass Market Web Application Development tool for the Oracle Database • Fills void between Access and Java • Declarative • Leverage SQL and PL/SQL Skills • No DB Cost Feature (requires 9iR2 or better) • New Release, APEX 3.0
• • • • • PDF Printing MS Access Application Migration Tool Flash Charting Improved Web Services (Complements BPEL & Jdev) Distributed with 11g
Application Express – Browser Based
• Browser Based Application Development • No Client Software to Develop, Deploy, or Run Applications • Full Service: Application Building, SQL Workshop, Utilities
http://www.apex.oracle.com
Application Express – Architecture
Databases: 9iR2, 10g; XE, SE, EE Features: Analytics, Text , Spatial, XML, RAC, VPD / RLS, Intermedia, AQ, Jobs, Distributed DB, Replication Fully database encapsulated
Application Express – Framework
• • • • • • • • • • • • Automatic Session State Management Session State referenced in SQL using bind variable syntax Automatic Table DML 60 Built in Item Display Types (text, checkbox, shuttle, date, file upload...) Abstracted from Complex & Fluid AJAX, JS, XML, CSS Technologies Granular UI Control via Templates (aggregated into Themes) Authentication and Authorization Controls Fully Exploits both SQL and PL/SQL Database Encapuslated (everything is in the database) Declarative, no 3GL code, no code generation, no scripting Hacker Hardened: URL Tampering, CSS, SQL Injection Integrated Reporting and Charting Services
Application Express – New With 11g Embedded PL/SQL Gateway
• With XE and 11g
• With Apache and mod_plsql
Application Express - Multi Tenant Hosting
Application Express - Packaged Apps
• Project Tracking
• People Search • Discussion Forum • Bug Tracker
• Online Store
• Ask the Expert • Issue Tracker • Document Management
Application Express 3.0 – Flash Charting
• • • • Flash Charting Define charts using SQL Granular Control Single and multiple series
Application Express 3.0 – PDF Printing via BI Publisher or Apache FOP
• y
Application Express – Relevant 11g Features
• • • • • • • Pivot Embedded PL/SQL (EPG) Installed via Seed Result Cache (function & SQL) Database Authentication Observe privileges from roles from PL/SQL Secure Files (improved LOBs)
Application Express-Access Replacement
• Microsoft Access
• Application Express
• • • •
Insecure Client / Server Poor Performance Jet Engine
• • • •
Secure Web Outstanding Performance Oracle Database
Application Express
"Oracle has come a long way in understanding what customers really want when it comes to accessing data quickly and easily, and APEX delivers such an environment."
-- Noel Yuhanna, Forrester Research
SQL Developer
• Database development tool for all frameworks • Improves DBA Developer Productivity • Browse database objects • Run SQL and SQL scripts • Edit and debug PL/SQL • Popular download • Extensible framework • Included in JDeveloper 11g
http://www.oracle.com/technology/products/database/sql_developer/index.html
SQL Developer 1.2
• Reporting • Master Detail & Linked Reports • Charting • Native Excel Import & Export • SQL Worksheet enhancements • Duplicate Record • View CLOB data • Single record view • SQL and PL/SQL Parsing Updates • Enhanced SQL Script File Handling • Rewritten Object Navigator • Search Engines: Metalink, OTN Forum… • External Tools Support • Third Party Database support: MySQL, MS Access and SQL Server • Migration Services • Application Express Objects
PHP & Database Resident Connection Pooling
• Enhanced PHP OCI8 Driver with easy APIs, improved performance • 11g OCI Connection Pooling to improve scalability, most notably PHP applications • Support Larger PHP user loads with fewer database connections