WebDB

1
WebDB

• Presented by Violeta Marachenska, FN
• Course
• Modern Software Technologies

2
Contents

• WebDB Overview

• WebDB Architecture

• PL/SQL Gateway

• Database Access Descriptor (DAD)

• Example of Gateway Configuration File

• HTTP Listener

• WebDBs categories

• Database Administration

• Application Development

• Content-Driven Web Site Management

3
WebDB Overview
1. WebDB is user-friendly tool for developing
database-driven web applications and sites
2. 100 in the browser, 100 in the database
concept
3. WebDBs wizards are just PL/SQL code
generators that act on normal database objects
4. Every WebDB component, from development tools
to the database administrator toolkit, has an
HTML user interface
5. WebDB is a standalone product that contains
everything you need to create a complete
application
4
WebDB Architecture
WebDB Components
5
PL/SQL Gateway

• Users call a procedure using a URL

• The gateway uses DADs (Database Access
  Descriptor) to authenticate web users
• http//WebDB_serverport/dad_name/package.proc
  edure?parm1fooparm2bogus

• DAD parameters
• - Database Access Descriptor Name
• - Oracle User Name/Password/Connect String
• - Keep Database Connection Open between
  Requests?
• - Default (Home) Page
• - Document Table/Access Path/Access Procedure

• The configuration information for the PL/SQL
  gateway is stored in the file ORACLE_HOME/listen
  er/wdbsvr.app

6
DAD Administration In WebDB
7
Example of Gateway Configuration File
DAD_WebDB connect_string password
username default_page WEBDB.home document_t
able WEBDB.wwv_document document_path
docs document_proc WEBDB.wwv_testdoc.process_dow
nload name_prefix always_describe
after_proc reuse Yes connmax 4
8
HTTP Listener

• The HTTP Listener is a miniature web server with
  following characteristics

- Supports HTTP 1.1
- Able to serve static files residing in mapped
directories
- Supports application-specific MIME type mapping
- Uses multithreading to provide increased
performance
- Specifically designed to integrate with the
Oracle database via PL/SQL applications

• The configuration information for the HTTP
  Listener is stored in the file ORACLE_HOME/liste
  ner/wdbsvr.cfg

9
WebDBs categories

• Database Administration

• Browse database objects

• Administer WebDB and database security

• Users

• Privileges

• Roles

• Monitor database and application performance

10
Browsing database objects with WebDB
11
WebDBs categories

• Application Development

• Building database objects

• Building user interface components

• Building shared components

• Building custom components

12
Creating a list of values in WebDB
13
WebDBs categories

• Content-Driven Web Site Management

• User-uploaded content

• File

• Folderlink

• WebDB component

• Imagemap

• PL/SQL call

• Text item

• URL

• Managing content

• Folders

• Categories

• Perspectives

• Controlling access to content

• Group

• Privilege

14
A list of all folders in WebDB