Transcript Presentation

Rich Web App Development
using Oracle & AJAX
Presented By:
John Krahulec
WebEx Demonstration
September 9, 2009
Agenda
Company Overview
Features Overview
Install & Configure
Demo Application
Company Overview
Who we are
Headquartered in Reston, Virginia
Spun off from a consulting services practice in 2008
Oracle Database Experts
Oracle DBAs
PL/SQL Developers
Web UI Specialists
Featured in IOUG SELECT Magazine
Presented at local, regional & national conferences
Company Overview
Who we are
How it started
Problems We Noticed
Constantly changing UI and middle-tier languages
Increased complexity of architectures
Decreased use of Oracle database features
Solution We Chose
Disruptive Approach using Stable Technology
Company Overview
Who we are
How it started
Implementations
Campaign Management, Marketing
Intelligence and Data Warehouse
SMB ERP, Sales Pipeline, Intranet
Cyber Security Management System
FAA/DHS/SecretService/NORAD - SkyWatch
FAA/DoD - Military Operations
Special Use Airspace Scheduling
Features
PL/SQL based APIs for HTML, AJAX and FLASH
Apps work in Firefox, IE, Safari, etc
Development Toolkit & Framework
Application Platform
Social Enterprise features
View TURBOKit to “see” individual components
Benefits
Begin developing immediately
No need to build complex architectures, add expensive
hardware or recruit hard-to-find, expensive talent
With shrinking and overworked IT staff, businesses can't
expect to have experts in every technology. Do more with
less
TURBOKit Demo
Architecture Overview
ORACLE
OPS
DATA
GUI
LOGIN
Oracle HTTP
Server or OAS
with mod_plsql
Install
1) Install Oracle Database
2) Install Oracle HTTP Server (with
mod_plsql)
3) Install TURBO Enterprise
Virtual n-Tier Architecture
(Patent
Pending)
TURBO
Purpose: Contains noncustomizable core TURBO objects.
TURBO_GUI
TURBO_DATA
TURBO_OPS
APP_WEB
APP_DATA
APP_ETL
TURBO source code is encrypted
to protect the intellectual property
Application
Purpose: Contains applications
built using TURBO
APP_USER
Build all apps in this layer or
create additional layers for
functional areas (i.e. HR, Sales,
etc)
xxxx
Database schemas
Layers:
Vertical – virtual tier
Horizontal –
core/custom/app
Login
GUI
Data
Operational
Purpose: Database
login via Oracle Apache.
Purpose: Rendering
packages for creating
the graphical user
interface in the web
browser.
Purpose: Database
tables and the packages
to handle DML actions
against the tables.
Purpose: Specialized
data processing.
TURBO Install Demo
Configure Oracle HTTP Server
1) Copy HTDOCS folder to your Apache server
2) Modify httpd.conf for security
# Override default error documents
ErrorDocument 400 /turbo/te_pages.p_error?i_code=400
ErrorDocument 401 /turbo/te_pages.p_error?i_code=401
ErrorDocument 402 /turbo/te_pages.p_error?i_code=402
ErrorDocument 403 /turbo/te_pages.p_error?i_code=403
ErrorDocument 404 /turbo/te_pages.p_error?i_code=404
ErrorDocument 405 /turbo/te_pages.p_error?i_code=405
ErrorDocument 406 /turbo/te_pages.p_error?i_code=406
ErrorDocument 407 /turbo/te_pages.p_error?i_code=407
ErrorDocument 408 /turbo/te_pages.p_error?i_code=408
ErrorDocument 409 /turbo/te_pages.p_error?i_code=409
ErrorDocument 410 /turbo/te_pages.p_error?i_code=410
ErrorDocument 411 /turbo/te_pages.p_error?i_code=411
ErrorDocument 412 /turbo/te_pages.p_error?i_code=412
ErrorDocument 413 /turbo/te_pages.p_error?i_code=413
ErrorDocument 414 /turbo/te_pages.p_error?i_code=414
ErrorDocument 415 /turbo/te_pages.p_error?i_code=415
# Security Lockdown
ServerTokens Prod
ServerSignature Off
Configure Oracle HTTP Server
1) Copy HTDOCS folder to your Apache server
2) Modify httpd.conf for security
3) Modify dads.conf
<Location /turbo>
SetHandler pls_handler
Order deny,allow
Allow from all
AllowOverride None
PlsqlDatabaseUsername
app_user
PlsqlDatabasePassword
app_user_password
PlsqlDatabaseConnectString HOST:PORT:SERVICE_NAME
PlsqlAuthenticationMode
CustomOwa
PlsqlSessionStateManagement StatelessWithFastResetPackageState
PlsqlExclusionList
sys.*, dbms_.*, utl_.*,owa_.*, owa.*, htp.*, htf.*
PlsqlDefaultPage
te_pages.p_home
PlsqlDocumentTablename turbo_data.global_documents
PlsqlDocumentProcedure
turbo_data.te_docload.process_download
PlsqlDocumentPath
docs
PlsqlNLSLanguage
American_America.WE8ISO8859P1
PlsqlErrorStyle
ApacheStyle
</Location>
Configure Oracle HTTP Server
1) Copy HTDOCS folder to your Apache server
2) Modify httpd.conf for security
3) Modify dads.conf
4) Restart Apache HTTP listener
Verify TURBO Install
Install
1) Install Oracle Database
2) Install Oracle HTTP Server (with
mod_plsql)
3) Install TURBO Enterprise
Configure TURBO
Company Name, Address, Logo
Password Policies
Setup Users
Logo
Name & Address
Demo Rich Web Apps
from the ORACLE database
Technical Benefits
Leverage Oracle features for scalability and performance
Build Enterprise-class Rich Web Apps right out of the
database using existing skills and infrastructure
AJAX and Flash stored in the database
Just use PL/SQL to call the APIs to build RWA components
Authenticated AJAX calls from browser to database
Flexible and open standard for customization and third
party tool integration
Value Proposition
For Developers…
TURBO Enterprise offers an environment in which
you can quickly create Rich Web Applications using
the Oracle PL/SQL skills you already have.
Value Proposition
For Managers…
TURBO Enterprise allows you to provide more for your
customers with your existing resources. TURBO
Enterprise runs inside your existing Oracle database, so
you already have all the hardware, OS, and database
ready to go.
Value Proposition
For End Users…
TURBO Enterprise gives you what you've come to
expect from other consumer web sites, but for the
Enterprise…Web 2.0 functionality, great looks, intuitive
design, minimal training, etc.
You get all those features when you surf the web.
Now you can have it at work too.
We can provide personalized sessions
We can help get you started
Questions and Answers
Contact Information
John Krahulec
Executive VP & COO
703-889-8430
Mark Eddy
Account Executive
703-889-8452
[email protected]
[email protected]