oracle webdb
TRANSCRIPT
![Page 1: Oracle Webdb](https://reader034.vdocuments.us/reader034/viewer/2022052506/5571f91e49795991698ed590/html5/thumbnails/1.jpg)
ORACLE WebDB 2.2
Montse Collados Polidura SL/CO - April 2000
![Page 2: Oracle Webdb](https://reader034.vdocuments.us/reader034/viewer/2022052506/5571f91e49795991698ed590/html5/thumbnails/2.jpg)
April [email protected] 2
WebDB
What for? To build dynamic Web database
applications & content-driven Web sites What do I need?
Just a browser How does it work?
Uses the standard three-tier architecture
WebDBOracle Server
HTMLPL/SQL
![Page 3: Oracle Webdb](https://reader034.vdocuments.us/reader034/viewer/2022052506/5571f91e49795991698ed590/html5/thumbnails/3.jpg)
April [email protected] 3
WebDB : Functionality
Browse : scan the database components by schema, object_type or name.
Build : construct user interface components and database objects.
Administer : manage privileges and establish listener settings.
Monitor : view end-user and database activity.
Sites : construct and monitor a Web site wholly contained within the database.
![Page 4: Oracle Webdb](https://reader034.vdocuments.us/reader034/viewer/2022052506/5571f91e49795991698ed590/html5/thumbnails/4.jpg)
April [email protected] 4
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.
![Page 5: Oracle Webdb](https://reader034.vdocuments.us/reader034/viewer/2022052506/5571f91e49795991698ed590/html5/thumbnails/5.jpg)
April [email protected] 5
WebDB - Build
Database Objects
tables, views, indexes, functions, etc.
User Interface Componentsreports, charts, forms, calendars, etc.
Shared Componentsfonts, colors, images, templates, LOV, Javascripts
Utilities
Find WebDB Components
![Page 6: Oracle Webdb](https://reader034.vdocuments.us/reader034/viewer/2022052506/5571f91e49795991698ed590/html5/thumbnails/6.jpg)
April [email protected] 6
WebDB - Building WebDB ComponentsI
Forms
Menus
Frame Drivers
Dynamic
Pages
![Page 8: Oracle Webdb](https://reader034.vdocuments.us/reader034/viewer/2022052506/5571f91e49795991698ed590/html5/thumbnails/8.jpg)
April [email protected] 8
WebDB - Administer
User Manager
Grant Manager
Role Manager
Change your Password
Report WebDB Privileges
Configure WebDB Activity Logs
Listener Settings
![Page 9: Oracle Webdb](https://reader034.vdocuments.us/reader034/viewer/2022052506/5571f91e49795991698ed590/html5/thumbnails/9.jpg)
April [email protected] 9
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)
![Page 10: Oracle Webdb](https://reader034.vdocuments.us/reader034/viewer/2022052506/5571f91e49795991698ed590/html5/thumbnails/10.jpg)
[email protected] April 2000
WebDB - Sites
The database administrator creates 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.Public URLSecure URL
![Page 11: Oracle Webdb](https://reader034.vdocuments.us/reader034/viewer/2022052506/5571f91e49795991698ed590/html5/thumbnails/11.jpg)
April [email protected] 11
WebDB 3.0 - Overview
More control and flexibility building Forms, Reports and Charts
New development object : the Module New services :
Session StorageEvent Handling
New tools:Application ExplorerDatabase Explorer
![Page 12: Oracle Webdb](https://reader034.vdocuments.us/reader034/viewer/2022052506/5571f91e49795991698ed590/html5/thumbnails/12.jpg)
April [email protected] 12
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
![Page 13: Oracle Webdb](https://reader034.vdocuments.us/reader034/viewer/2022052506/5571f91e49795991698ed590/html5/thumbnails/13.jpg)
April [email protected] 13
WebDB - Conclusions
No PL/SQL knowledge Basic HTML/HTTP knowledge WebDB Sites need improvement Forms need more flexibility and
‘speed’ Good user interface components
The fastest and easiest way to “Web-enable” Oracle databases
![Page 14: Oracle Webdb](https://reader034.vdocuments.us/reader034/viewer/2022052506/5571f91e49795991698ed590/html5/thumbnails/14.jpg)
April [email protected] 14
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/