Transcript ORACLE WebDB 2.2 - CERN EDMS Service

ORACLE WebDB 2.2
Montse Collados Polidura SL/CO - April 2000
WebDB
What for?
Oracle Server
To build dynamic Web database
WebDB
PL/SQL
applicationsHTML
& content-driven Web sites
What do I need?
Just a browser
How does it work?
Uses the standard three-tier architecture
[email protected]
April 2000
2
WebDB : Functionality

Browse : scan the database components by

Build : construct user interface components

Administer : manage privileges and establish

Monitor : view end-user and database

Sites : construct and monitor a Web site
schema, object_type or name.
and database objects.
listener settings.
activity.
wholly contained within the database.
[email protected]
April 2000
3
WebDB - Browse
 Query and update rows in tables and
views. The results can be displayed in an
HTML table, as plain text, or downloaded
for displaying in Microsoft Excel.
 Execute procedures and functions.
 View the contents of packages.
 View information about indexes,
sequences, synonyms, and triggers.
 View object dependencies.
[email protected]
April 2000
4
WebDB - Build
Database Objects
tables, views, indexes, functions, etc.
User Interface Components
reports, charts, forms, calendars, etc.
Shared Components
fonts, colors, images, templates, LOV, Javascripts
Utilities
Find WebDB Components
[email protected]
April 2000
5
WebDB -
Building WebDB ComponentsI
Forms
Menus
Frame Drivers
Dynamic Pages
[email protected]
April 2000
6
WebDB -
Building WebDB ComponentsII
Reports
Charts
Calendars
Hierarchies
[email protected]
April 2000
7
WebDB - Administer
 User Manager
 Grant Manager
 Role Manager
 Change your Password
 Report WebDB Privileges
 Configure WebDB Activity Logs
 Listener Settings
[email protected]
April 2000
8
WebDB - Monitor
Objects that can be monitored:
 User Interface Components
Monitor end-user requests for components
 Activity Log. Browse it using a QBE form
 Database Objects
Monitor storage, sessions, jobs, memory
utilization, and the various parameters of your
Oracle database
 Batch Jobs (DBMS_JOB)
[email protected]
April 2000
9
WebDB - Sites
 The database administrator creates
Secure URL
Public URL
the site in the database, and assigns one
or more site administrators.
 Site administrators design the site,
and assign folder owners.
 Folder owners assign content
contributors for their folders.
 Content contributors add content
to the site.
 WebDB site users view the contents
of the site.
[email protected]
April 2000
10
WebDB 3.0 - Overview
More control and flexibility building Forms,
Reports and Charts
 New development object : the Module
 New services :

 Session Storage
 Event Handling

New tools:
 Application Explorer
 Database Explorer
[email protected]
April 2000
11
WebDB - Demonstration
 Form to raise the salary of people
working in a department… :0)
 Chart to display how many people
are working in every department.
 Menu to join both components
together
 Add menu to the alarm team web
site
[email protected]
April 2000
12
WebDB - Conclusions
The fastest and easiest way to
“Web-enable” Oracle databases





No PL/SQL knowledge
Basic HTML/HTTP knowledge
WebDB Sites need improvement
Forms need more flexibility and ‘speed’
Good user interface components
[email protected]
April 2000
13
Interesting Links to Visit



http://technet.oracle.com/products/webdb/
http://www.oracle.com/tools/webdb/
http://oradoc/816doc/
WebDB Sites !!




http://www.labour.org.uk/
http://www.radissonsas.com/
http://www.voug.org/
http://bauarena.bau-data.co.at/
[email protected]
April 2000
14
WEBDB...
[email protected]
April 2000
15