280 likes | 407 Views
Rich Web Applications for the Enterprise... Creating RWA from Your Oracle Database. Presented By: John Krahulec Biz whazee. SEOUC Charlotte February 2009. Learn how PL/SQL Developers can deliver Rich Web Applications (RWA) directly from the Oracle database.
E N D
Rich Web Applications for the Enterprise... Creating RWA from Your Oracle Database Presented By: John Krahulec Bizwhazee SEOUC Charlotte February 2009
Learn how PL/SQL Developers can deliver Rich Web Applications (RWA) directly from the Oracle database • Build apps far more sophisticated than previously thought possible using the PL/SQL web toolkit as a foundation • No complex middle-tier setup • Achieve technology efficiency by serving AJAX features directly from PL/SQL APIs
Target Audience • Managers • AJAX developers • Non-AJAX developers & Oracle PL/SQL developers • End-Users… waiting impatiently for the benefits of Web 2.0 @ Work
Our Philosophy It’s All About the End User
Rich Web Applications Yahoo Mail Zimbra App generated from Oracle DB Google Docs
What makes a Web Application “Rich”? FLASH FLEX AIR AJAX All provide amazing interactivity
Asynchronous JavaScript and XML AJAX A popular technique for providing rich application features AJAX is a group of inter-related Web development scripting languages (including JavaScript, PHP, etc) used for creating interactive Web applications
More Philosophy Software development should be getting easier Combine AJAX with PL/SQL for the ultimate application development environment for the Enterprise. AJAX is a game changer
Enterprise Application Evolution C/C++/C# .Net ColdFusion Python PowerBuilder HTML 4.0/XHTML JAVA HTML3.0 AJAX JavaScript Delphi HTML 1.0 XML VisualBasic PERL PHP Ruby Flash HTML 2.0 JSON Database Military Government ORACLE Payroll Medical Corporate Inventory Finance Any Data Accounting The Sales
Build it in the database? Doesn’t that fly in the face of conventional system architecture? Distribute the application Database Independence Model View Control (MVC) And so on…
The Flip Side… Middle-tier developers spend enormous amounts of time recreating functionality already provided by the database Methods Objects Classes Constructors Connection Pooling
Think about this… • What is the probability that your database will be the same next year? What is the probability that UI languages will be the same next year? “So why not leverage the database as the foundation of our Rich Web App development approach?”
What is Thick Database? Oracle Apache mod_plsql ORACLE GUI DATA OPS LOGIN
Getting Thick GUI Rendering C/C++/C# .Net ColdFusion Python PowerBuilder HTML 4.0/XHTML JAVA HTML3.0 AJAX JavaScript Delphi HTML 10 XML VisualBasic Ruby PERL PHP Flash HTML 2.0 JSON ORACLE Database
Getting Thick GUI Rendering ORACLE LOGIN DATA
Harness power and performance of Oracle Why Thick Database? • Eliminate the “middle-tier” tax • network congestion and latency between App and Database servers • slow ODBC/JDBC calls • Multiple steps handling the data • unparsed and un-tuned SQL statements • Utilize Oracle features for scalability • Lower cost of ownership by leveraging existing Oracle investment and staff skills • Use PL/SQL to serve up AJAX and FLASH features
Why Thick Database? (cont.) • One backup and recovery process for both application and data Application code is stored in compiled packages in the database for fastest performance • Rapid deployment and enhancements • Smaller development team Get more value out of your Oracle DB investment
The Database Movement ORACLE APEX “Using only a web browser and limited programming experience” Dulcian Business Rules Information Manager “Business Rules Based Systems Development Environment” “The Rich Internet Framework for PL/SQL Developers”
SlowEnterprise Adoption Developer Beware
SlowEnterprise Adoption Developer Beware Complexity of AJAX code
SlowEnterprise Adoption Developer Beware Complexity of AJAX code AJAX opens numerous “back-doors”
SlowEnterprise Adoption Developer Beware Complexity of AJAX code AJAX opens numerous “back-doors” Most RWA offerings are focused only on the front-end
SlowEnterprise Adoption Developer Beware Complexity of AJAX code AJAX opens numerous “back-doors” Most RIA offerings are focused only on the front-end Legacy languages need additional add-ons for RWA
SlowEnterprise Adoption Developer Beware Complexity of AJAX code AJAX opens numerous “back-doors” Most RIA offerings are focused only on the front-end Legacy languages need additional add-ons for RWA Need to retrain enterprise developers
Live Demo for Developing RIA applications from the ORACLE database
Leverage Oracle features for scalability and performance Benefits of combining AJAX & Database • 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
John Krahulec 703-889-8499 John.Krahulec@TURBO-enterprise.com Visit TURBO-enterprise.com for more information.