1 / 27

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

basil-fry
Download Presentation

Easy HTML DB

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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 • Don’t have to be a graphical designer • Themes & Templates

  7. 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

  8. 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

  9. Browser HTML DB Architecture Oracle HTTP Server with mod_plsql HTML DB Database

  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 http://www.oracle.com/technology/xe

More Related