Re: any multidatabases?

As mentioned before we have successfully used Oracle on a 50 Gig database
to return 'virtual' HTML documents through Mosaic that are generated via
OraPERL (Oracle Program Extraction and Reporting Language, Public Domain
software by Larry Wall) on the database server.  The only tricky part is
getting a graceful abort through all processes generated by the server
when a user cancels a request (such as hitting the spinning globe in
Mosaic in mid-query).  The latest httpd server handles this but we wrote 
custom code to do it in httpd 1.1.  

I can post the generic 'virtual' PERL pre-amble that we use to generate
the virtual documents if there is any interest...its pretty short...
OraPERL handles multiple Oracle instances pretty easily.

	Frank Dreano  Logisitics Management Decision Support System


On Tue, 11 Apr 1995, Rich Oesterling wrote:

> Hello Roel -
> 
> Could you expand on your needs?  
> 
> If you are running Oracle, it looks like a relatively straightforward 
> query to any or all of the Oracle instances you might be running would do 
> the trick.  If you want to query all databases simultaneously, then maybe 
> a query against a view in one instances that looks at all the instances 
> would work.
> 
> Good luck
> 
> Rich Oesterling
> 
> 
> On Thu, 30 Mar 1995 Bennink@vsnu.nl wrote:
> > 
> > Hallo,
> > 
> > As a new subscriber to this list, I have a burning question.
> > 
> > In Holland we are exploring new ways of making university research 
> > information (project-titles, names of institutes, titles of publications, of 
> > up to 14 universities) accessible through WWW/Gopher.
> > 
> > It seems there are two ways of doing that (apart from creating one central 
> > database, ofcourse):
> > - creating WAIS-databases with indexed text-files, and 
> > - creating WWW-gateways to relational databases with research information.
> > 
> > We are searching for examples of these two options. So far I have found only 
> > examples of WAIS-text-searches. Do you know any existing examples of 
> > multidatabases (preferably under Oracle) accessible by WWW?
> > 
> > Roel.
> > 
> > ------------------------------------------------------------------------------
> > drs. Roel D. Bennink   Vereniging van Samenwerkende Nederlandse Universiteiten
> > Informatiebeleid VSNU  Association of Universities in the Netherlands
> > Leidseveer 35          tel.: 030 - 363834
> > Postbus 19270          fax : 030 - 333540
> > 3501 DG  UTRECHT  NL   e-mail: bennink@vsnu.nl
> > http:/www.surfnet.nl/vsnu
> > ------------------------------------------------------------------------------
> > 
> > 
>

Received on Tuesday, 11 April 1995 05:13:03 UTC