oracle htmldb introduction n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Oracle HTMLDB introduction PowerPoint Presentation
Download Presentation
Oracle HTMLDB introduction

Loading in 2 Seconds...

play fullscreen
1 / 15

Oracle HTMLDB introduction - PowerPoint PPT Presentation


  • 95 Views
  • Uploaded on

Oracle HTMLDB introduction. IT-AIS Developers Pizza Forum: 28 April 2005. What is HTMLDB. A rapid web application development tool for the Oracle database. 100% web based development PL/SQL driven. Architecture. Everything is in the Database!. Oracle. WebServer. Client. RDBMS. HTMLDB.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Oracle HTMLDB introduction' - trevelian


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
oracle htmldb introduction

Oracle HTMLDB introduction

IT-AIS Developers Pizza Forum: 28 April 2005

1/15

what is htmldb
What is HTMLDB
  • A rapid web application development tool for the Oracle database.
  • 100% web based development
  • PL/SQL driven

2/15

architecture
Architecture

Everything is in the Database!

Oracle

WebServer

Client

RDBMS

HTMLDB

3/15

pros cons
Pros & Cons

Pros

  • Fast development
  • 100% web based
  • No code required
  • Ready to use components
  • Professional looking
  • Easy to create mock-ups
  • Easy to deploy
  • Easy to understand
  • Fast (no overhead)

Cons

  • Platform lock
  • Difficult to debug
  • Tricky to customize
  • Scaling problems
  • Difficult version control

4/15

trade off comparison
Trade Off Comparison

Effort

Good for small/simple projects

J2EE

HTMLDB

?

Results

5/15

real world examples
Real World Examples
  • HTMLDB Itself!
  • AskTom
  • CERN: Pre Registration Tool
  • CERN: Safety Information Registration
  • http://htmldb.oracle.com/references

6/15

development cycle
Development Cycle

RDBMS

HTMLDB

Web Interface

Developer

HTMLDB Engine

Application

Metadata

Web

Application

User

7/15

htmldb interface
HTMLDB Interface

Application Builder

  • Create pages
  • Manage shared components (Items, Templates, Translations, …)
  • Import & Export application

SQL Workshop

  • Browse DB Objects (Tables, Packages, DBLinks, Java Classes, …)
  • Create DB Objects
  • Run arbitrary SQL

Data Workshop

  • Import/Export Data from/to XML/Spreadsheet

8/15

page creation overview
Page Creation: Overview

Request

Page

Pre-processing

Client

Rendering

Order can be finely

tuned mixing processing

and rendering.

Post-processing

Branching

Same or other Page

9/15

page creation rendering
Page Creation: Rendering

User Interface Items

Data Loading PL/SQL

Repository

Input Text

Checkbox

Report

Every Item corresponds to a “global” variable

10/15

processing branching
Processing & Branching
  • Processes
  • execute PL/SQL
  • manage sessions state
  • Reports pagination
  • Many others …
  • Computations
  • Set “item” values
  • SQL or PL/SQL driven
  • Static values
  • Other item values
  • Branches
  • Application Page
  • External URL
  • Functions returning URL/page
  • Others …

11/15

example room booking
Example: Room Booking

Use Cases

  • Search for first available time slot
  • Book desired time slot
  • Show room availability

12/15

conclusions
Conclusions
  • Fast implementation
  • Good looking results
  • Good for small to medium applications
  • It takes some time to get used to it

13/15

resources
Resources
  • Official Oracle Page http://www.oracle.com/technology/products/database/htmldb/index.html
  • Good support forumhttp://forums.oracle.com/forums/forum.jsp?forum=137
  • AskTom http://asktom.oracle.com/
  • Newsgroups comp.databases.oracle.tools

14/15