Easy HTML DB

1
Easy HTML DB
2
Michael CunninghamDeveloper/Database
Administrator
3
Agenda

• What, Why, How of HTML DB?
• Demo - Building an Application
• Overview of Features Capabilities
• Demo - Existing Application
• Summary
• Q A

4
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

5
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

6
Why use HTML DB?

• Makes web development easy
• Build web applications fast
• Days vs. weeks
• Short one-off applications
• Dont have to be a graphical designer
• Themes Templates

7
Why use HTML DB?

• Dont need to be an expert
• HTML syntax
• CSS
• JavaScript
• DBAs can create their own web applications for
  graphical reporting
• Replace MS-Access

8
HTML DB

• Oracle 10g Companion CD (or 10gR2)
• Download from otn.oracle.com
• HTTP Server
• Apache
• mod_plsql
• Dont need full Application Server
• Supported on 9.2.0.3 or above
• Fully Supported Product
• asktom.oracle.com

9
HTML DB Architecture
HTML DB Database
Oracle HTTP Server with mod_plsql
10
HTML DB Concepts

• HTML DB
• Workspace EASY
• APP DBA Segment Demo
• APP The RV Lot
• APP The RV Lot Admin
• Pages
• Regions
• Components

11
Page Regions
12
Region Components
13
HTML DBD E M O N S T R A T I O NBuilding an
Application
14
Key Features

• Built in Security
• Authentication schemes
• Authorization
• Page
• Region
• Page Level Items (Components)
• Session State management
• Transaction Concurrency

15
Key Features

• Reports
• Forms
• Report with Form Wizard
• Tabular Forms
• Calendar
• Charts (SVG)
• Wizards

16
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

17
Version 2.0 New Features

• Object Browser

18
Version 2.0 New Features

• PL/SQL Editor

19

• Query Builder
• Drag and Drop query building

20
Version 2.0 New Features

• DHTML Pull Down menu navigation

21

• Create Application Wizard (2.0)

22
HTML DBD E M O N S T R A T I O NTheRVLot
Application
23
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

24
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

25
Oracle XE and HTML DB

• XE Administration built with HTML DB

26
Summary

• What, Why, How
• Features Capabilities
• Demo
• Create App Wizard, modify chart, date format, row
  concurrency
• Next Steps
• http//htmldb.oracle.com

27
Q A
Please give me your feedback
http//htmldb.oracle.com http//sumnertech.com htt
p//www.oracle.com/technology/xe