Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle's WebDB

Re: Oracle's WebDB

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Wed, 10 Mar 1999 15:10:34 GMT
Message-ID: <36e689d7.8226038@192.86.155.100>


A copy of this was sent to Michael Rothwell <michael_rothwell_at_non-hp-usa-om46.om.hp.com> (if that email address didn't require changing) On Mon, 08 Mar 1999 14:20:42 -0800, you wrote:

>I have been using OWS (or WAS or OAS now) for the last couple years. I
>have only been using the PL/SQL cartridge for this and have developed
>several applications. These applications are very transactional as opposed
>to report based. I am getting a lot of information from the end user and
>inserting/updating many records.
>
>My question is: What is the difference between using the PL/SQL cartridge
>for OAS and using Oracle's new WebDB. I just got the demo disk, it talks
>more about data-driven reporting than for heavy transactions. Is this a
>light weight version of OAS and only for reporting, or can it be used for
>insert/update/delete apps? Will it handle several concurrent connections
>as well as OAS?
>
>I am basically needing to know what the differences are.
>
>Thanks.
>
>Michael

WedDB is predominantly a pl/sql generator. It generates the pl/sql packages to do reports, CRUD screens with lost update detection, simple graphs, etc, etc, etc... It automates the mundane. So thats WebDB the application generator. It does transactions as well as reports.

WebDB is a site builder. It has an application in it that manages content and lets you search/retrieve/upload content into your webserver. It is aimed at sites that want to allow content providers with no HTML/web experience to build, manage, maintain the web site. It is a collaboration tool as well as many people can be 'authors' within the website.

WebDB happens to come with a lightweight listener. This listener supports HTTP only (no https) and is basically the pl/sql cartridge and static file webserver only (no cgi-bin, nothing fancy -- it just does pl/sql and static files). It is based on the owa replacement cartridge you can download from http://govt.us.orcle.com/ (it does file upload, download, database authentication, etc)..

WebDB the pl/sql generator can be used with OAS (since it just generates pl/sql packages that use htp).

WebDB the site builder can be used with OAS with its own cartridge (to do file upload and download in the manner it expects).

The lightweight listener is just that -- designed for small to medium use, very small footprint (about 1meg to start it). Fast for small groups. Your mileage may vary however with it, you would need to see if its 'big' enough (for many groups it will be big enough). It handle concurrent users (tested up to low hundreds) and concurrent connections to the database well.  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
http://govt.us.oracle.com/ -- downloadable utilities  



Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed Mar 10 1999 - 09:10:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US