270 likes | 390 Vues
Join Michael Cunningham, Developer and Database Administrator, as he explores HTML DB—a rapid web application development tool that operates entirely in your browser. Learn what HTML DB is, why it can streamline your development process, and how it features a wizard-driven interface that simplifies application building. We'll showcase a live demo, overview its capabilities, and discuss how you can start creating your own applications without needing to be a graphics expert. Dive into the world of easy web development with us!
E N D
Agenda • What, Why, How of HTML DB? • Demo - Building an Application • Overview of Features & Capabilities • Demo - Existing Application • Summary • Q & A
Goal for Presentation • Determine if HTML DB is right for you • Return to your home, or office, and have the information to know - • How to start using HTML DB immediately • Where to get more information on HTML DB
What is HTML DB? • Rapid Web Application development and deployment tool. • Web-based • All development can be done inside a browser • Airport, home, office, Starbucks, motorhome, lake-front • Wizard Driven • Metadata stored in HTML DB Repository
Why use HTML DB? • Makes web development easy • Build web applications fast • Days vs. weeks • Short one-off applications • Don’t have to be a graphical designer • Themes & Templates
Why use HTML DB? • Don’t need to be an expert • HTML syntax • CSS • JavaScript • DBA’s can create their own web applications for graphical reporting • Replace MS-Access
HTML DB • Oracle 10g Companion CD (or 10gR2) • Download from otn.oracle.com • HTTP Server • Apache • mod_plsql • Don’t need full Application Server • Supported on 9.2.0.3 or above • Fully Supported Product • asktom.oracle.com
Browser HTML DB Architecture Oracle HTTP Server with mod_plsql HTML DB Database
HTML DB Concepts • HTML DB • Workspace: EASY • APP: DBA Segment Demo • APP: The RV Lot • APP: The RV Lot Admin • Pages • Regions • Components
Key Features • Built in Security • Authentication schemes • Authorization • Page • Region • Page Level Items (Components) • Session State management • Transaction Concurrency
Key Features • Reports • Forms • Report with Form Wizard • Tabular Forms • Calendar • Charts (SVG) • Wizards
Version 2.0 New Features • SQL Workshop redesigned • Object Browser • Add, Rename, Drop columns, indexes etc. • Graphical Query Builder • SQL Command Processor • PL/SQL Editor • SQL scripts
Version 2.0 New Features • Object Browser
Version 2.0 New Features • PL/SQL Editor
Query Builder • Drag and Drop query building
Version 2.0 New Features • DHTML “Pull Down” menu navigation
Getting Started – More Information • http://htmldb.oracle.com • http://sumnertech.com • Forum – help from community and developers • Studio – download sample applications • Resources – The HTML DB Home page on OTN • References – success stories • Sample Applications
New and Exciting from Oracle • Oracle 10g Express Edition • Interface to XE is written in HTML DB • Oracle 10g Release 2 • Completely Free of Charge • Free to download, develop, and deploy • Up to 4GB of user data • 1GB RAM • Single CPU • 32-bit Linux and Windows http://www.oracle.com/technology/xe
Oracle XE and HTML DB • XE Administration built with HTML DB
Summary • What, Why, How • Features & Capabilities • Demo • Create App Wizard, modify chart, date format, row concurrency • Next Steps • http://htmldb.oracle.com
Q & A Please give me your feedback http://htmldb.oracle.com http://sumnertech.com http://www.oracle.com/technology/xe