Transcript Easy HTML DB

Easy HTML DB
Michael Cunningham
Developer/Database Administrator
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
HTML DB Architecture
Browser
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
Page Regions
Region Components
HTML DB
D E M O N STRATI O N
Building an Application
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

Create Application Wizard (2.0)
HTML DB
D E M O N STRATI O N
TheRVLot Application
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