NCOAUG

1
NCOAUG

• 8th March, 2004
• HTML DB Develop Deploy Database-centric Web
  Applications
• Presented By Karthikeyan Chakkarapani
• Senior Consultant, Keane Inc

2
What is HTML DB ?

• Web Application Development Tool
• Browser based development
• Declarative development framework
• Oracle Database Centric
• Meta tables
• HTML DB is part of Oracle 10G database

3
Benefits of HTML DB

• Productivity - With HTML DB you can build
  applications faster with fewer developers.
• Manageability HTML DB allows IT departments to
  centrally manage development of web applications
  by hosting a browser based declarative
  development environment. No more rogue
  departmental databases. HTML DBs architecture
  is refreshingly simple, making deployment and
  management light work.
• HTML DB allows organizations to capitalize on
  their existing investment in SQL and PL/SQL
  skills. If the developers are comfortable with
  the Oracle Database, very little training, if
  any, will be required to build applications.

4
Major Features of HTML DB

• Wizards based development (with navigation paths)
• Export/Import of files (ASCII, Spreadsheet, XML)
• Export/Import of metadata
• Data Browser
• Manage Users
• Monitor workspace utilization
• Manage logs
• Session state management
• Administrative reports
• Debugging tool
• On-line Help

5
HTML DB in City of Chicago
6
HTML DB - Architecture

7
HTML DB Environment

• Application Builder
• SQL Workshop
• Data Workshop
• Administration

8
HTML DB - Components

Application BuilderThe Flow Builder allows you
to build database-centric interactive web
applications.
SQL WorkshopThe SQL Workshop allows you to run
SQL statements and SQL scripts.
Data WorkshopThe Data Workshop helps you load
data into and extract data from the database.
9
Application Builder Components
Applications

Pages
Regions
Items
10
Application Builder

• What is a Application?
• Collection of pages that share a definition of
  session state and authentication.
• Application Builder where you build applications

• Show and Accept Model
• showing a page generates the HTML
• accepting a page is the processing after the
  form is submitted

11
Application Builder (continued)

• Session State Management
• One of the primary functions of HTML DB
• Session state is maintained in database tables
• Application item values are linked to session IDs
  that are created when a user logs in to the
  application
• Allows you to reference application item values
  from page to page using ITEM_NAME, ITEM_NAME

12
Application Builder (continued)
13
Application Builder User Interface(UI)
HTML DB provides precise control over UI using
templates. The template architecture allows a UI
specialist to define how pages and regions within
pages are rendered. These templates can then be
applied to flows at any time.
                                                  
                           

14
Application Syntax
Applications uses a syntax to allow for pages to
be referenced as URLs. For example to run page 1
within flow 100 you could use the following
f?p1001 To maintain the current session use
the built in substitution string SESSION, for
example f?p1001SESSION The f?p syntax is
very powerful -- you can set session state, clear
session state, define the "request" and turn on
debugging using the following syntax f?pFlow
Page Session Request Debug ClearCache
itemNames itemValues For example
f?p60006003SESSIONNO6003MY_ITEM1234

15
SQL Workshop

• Enter run SQL commands and SQL scripts
• Upload and run script files
• Browse database objects
• Export DDL
• Query By Example

16
Data Workshop

• Enables to import into and export data from the
  hosted Oracle database
• File Formats ASCII, XML, Spreadsheets

17
Administration

• Manage Users within the workspace
• Monitor workspace utilization
• Manage logs session state
• Various Administrative reports

18
HTML DB - Security

• INTERNAL HTML DB specific cookie-based
  implementation
• SCHEME Use pre-defined session management
  behaviors or define your own. Single sign-on
  environments and LDAP authentication can also be
  implemented.
• Authorization schemes can then be defined to
  secure different pages, allowing access to those
  pages to DAB users only. You can also attach
  authorization schemes to tabs, buttons, regions,
  items etc.

19
HTML DB Extensibility

• Web Services -- Requests encapsulates in a SOAP
  envelope. Once requests are received they can be
  displayed using a XSL style sheet an XPATH, or
  processed by using PL/SQL. Web Services are only
  available on 9i or better databases.
• URL Region Sources -- Base a regions source on a
  URL and then "scrape" the result. For example
  scrape a Yahoo! page for the ORCL stock price and
  make this a URL region source.
• Use Oracle database links to access information
  in other databases. Transparent gateways also
  extend your capabilities.
• Use Oracle database links to access information
  in other databases. Transparent gateways also
  extend your capabilities.

20
HTML DB - Demo

• Application Builder
• SQL Workshop
• Data Workshop
• Administration
• Sample application

21

More Information

• For more information on HTML DB check out
• http//marvel.oracle.com
• http//askTom.oracle.com
• http//tahiti.oracle.com
• http//osi.oracle.com
• OTN Discussion Forums

22

Q A